SAP Table AFSPREL
Relation Between Orders in an Order Split
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 |