| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | C_AUFNR | Child order of a split hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | BYPRODUCT | Material Number By-Product Order Split | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | BYPRODUCT_BATCH | Batch Number By-Product Order Split | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | SPLCNT | Counter for the Parent-Child Order Relationships | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | P_AUFNR | Parent order of a split hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | L_AUFNR | Leading order of a split hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | SPLQ | Split Quantity in Order Split | decimal | 13 | 3 | | | | |
| 9 | QUNIT | Unit of Measure for Activity/Operation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | SDATE | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | STIME | Time created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | SUSER | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | BYPROD_MAT_DOC | Material Document for Goods Receipt By-Product Order Split | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | BYPROD_MAT_ITEM | Material Document Item GR By-Product Order Split | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | BYPROD_MAT_YEAR | Material Document Year Goods Receipt By-Product Order Split | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | COMPONENT_BATCH | Component Batch Used for Order Split | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | WIP_BATCH | WIP Batch Used for Order Split | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | CANCELED | Order Split Cancelled | char | 1 | 0 | | | | Allow NULL? |
| 19 | CANCEL_USER | User Who Carried Out Order Split Cancellation | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | CANCEL_DATE | Cancellation Date Order Split | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | CANCEL_TIME | Time of Cancellation | nvarchar | 6 | 0 | | | | Allow NULL? |