SAP Table AFSPREL
Relation Between Orders in an Order Split
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table AFSPREL (Relation Between Orders in an Order Split) is a standard table in SAP ERP. It belongs to the package CO.
Technical Information
| Table | AFSPREL |
| Short Text | Relation Between Orders in an Order Split |
| Package | CO |
| Table Type | Transparent Table |
Fields for Table AFSPREL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| C_AUFNR | ✔ | Child order of a split hierarchy | SPLIT_CAUFNR | CHAR | 12 | * |
| BYPRODUCT | ✔ | Material Number By-Product Order Split | COOS_BYPRODUCT | CHAR | 18 | * |
| BYPRODUCT_BATCH | ✔ | Batch Number By-Product Order Split | COOS_BYPRODUCT_BATCH | CHAR | 10 | * |
| SPLCNT | Counter for the Parent-Child Order Relationships | SPLCNT | NUMC | 4 | ||
| P_AUFNR | Parent order of a split hierarchy | SPLIT_PAUFNR | CHAR | 12 | * | |
| L_AUFNR | Leading order of a split hierarchy | SPLIT_LAUFNR | CHAR | 12 | * | |
| SPLQ | Split Quantity in Order Split | SPLIT_QTY | QUAN | 13 | ||
| QUNIT | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | * | |
| SDATE | Created on | CATS_ERSDA | DATS | 8 | ||
| STIME | Time created | C_TIME | TIMS | 6 | ||
| SUSER | User Name | UNAME | CHAR | 12 | ||
| BYPROD_MAT_DOC | Material Document for Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_NO_BYPRODUCT | CHAR | 10 | ||
| BYPROD_MAT_ITEM | Material Document Item GR By-Product Order Split | COOS_MATERIAL_DOC_PO_BYPRODUCT | NUMC | 4 | ||
| BYPROD_MAT_YEAR | Material Document Year Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_YY_BYPRODUCT | NUMC | 4 | ||
| COMPONENT_BATCH | Component Batch Used for Order Split | COOS_COMPONENT_BATCH | CHAR | 10 | * | |
| WIP_BATCH | WIP Batch Used for Order Split | COOS_WIPBATCH | CHAR | 10 | * | |
| CANCELED | Order Split Cancelled | COOS_CANCELED | CHAR | 1 | ||
| CANCEL_USER | User Who Carried Out Order Split Cancellation | COOS_CANCELLATION_USER | CHAR | 12 | ||
| CANCEL_DATE | Cancellation Date Order Split | COOS_CANCELLATION_DATE | DATS | 8 | ||
| CANCEL_TIME | Time of Cancellation | COOS_CANCELLATION_TIME | TIMS | 6 |