SAP Table AFSPREL
Relation Between Orders in an Order Split
AFSPREL (Relation Between Orders in an Order Split) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AFSPREL to other SAP tables.
AFSPREL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||
| C_AUFNR | Child order of a split hierarchy | SPLIT_CAUFNR | CHAR | 12 | 0 | |||||||
| BYPRODUCT | Material Number By-Product Order Split | COOS_BYPRODUCT | CHAR | 18 | 0 | |||||||
| BYPRODUCT_BATCH | Batch Number By-Product Order Split | COOS_BYPRODUCT_BATCH | CHAR | 10 | 0 | |||||||
| SPLCNT | Counter for the Parent-Child Order Relationships | SPLCNT | NUMC | 4 | 0 | |||||||
| P_AUFNR | Parent order of a split hierarchy | SPLIT_PAUFNR | CHAR | 12 | 0 | |||||||
| L_AUFNR | Leading order of a split hierarchy | SPLIT_LAUFNR | CHAR | 12 | 0 | |||||||
| SPLQ | Split Quantity in Order Split | SPLIT_QTY | QUAN | 13 | 3 | |||||||
| QUNIT | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | 0 | |||||||
| SDATE | Created on | CATS_ERSDA | DATS | 8 | 0 | |||||||
| STIME | Time created | C_TIME | TIMS | 6 | 0 | |||||||
| SUSER | User Name | UNAME | CHAR | 12 | 0 | |||||||
| BYPROD_MAT_DOC | Material Document for Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_NO_BYPRODUCT | CHAR | 10 | 0 | |||||||
| BYPROD_MAT_ITEM | Material Document Item GR By-Product Order Split | COOS_MATERIAL_DOC_PO_BYPRODUCT | NUMC | 4 | 0 | |||||||
| BYPROD_MAT_YEAR | Material Document Year Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_YY_BYPRODUCT | NUMC | 4 | 0 | |||||||
| COMPONENT_BATCH | Component Batch Used for Order Split | COOS_COMPONENT_BATCH | CHAR | 10 | 0 | |||||||
| WIP_BATCH | WIP Batch Used for Order Split | COOS_WIPBATCH | CHAR | 10 | 0 | |||||||
| CANCELED | Order Split Cancelled | COOS_CANCELED | CHAR | 1 | 0 |
Possible values
|
||||||
| CANCEL_USER | User Who Carried Out Order Split Cancellation | COOS_CANCELLATION_USER | CHAR | 12 | 0 | |||||||
| CANCEL_DATE | Cancellation Date Order Split | COOS_CANCELLATION_DATE | DATS | 8 | 0 | |||||||
| CANCEL_TIME | Time of Cancellation | COOS_CANCELLATION_TIME | TIMS | 6 | 0 | |||||||
