SAP Table AFSPREL - Relation Between Orders in an Order Split

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
C_AUFNR X SPLIT_CAUFNR CHAR 3 12 0 AUFK Child order of a split hierarchy
BYPRODUCT X COOS_BYPRODUCT CHAR 15 18 0 MARA Material Number By-Product Order Split
BYPRODUCT_BATCH X COOS_BYPRODUCT_BATCH CHAR 33 10 0 MCH1 Batch Number By-Product Order Split
SPLCNT SPLCNT NUMC 43 4 0 Counter for the Parent-Child Order Relationships
P_AUFNR SPLIT_PAUFNR CHAR 47 12 0 AUFK Parent order of a split hierarchy
L_AUFNR SPLIT_LAUFNR CHAR 59 12 0 AUFK Leading order of a split hierarchy
SPLQ SPLIT_QTY QUAN 71 13 3 Split Quantity in Order Split
QUNIT VORME UNIT 78 3 0 T006 Unit of Measure for Activity/Operation
SDATE CATS_ERSDA DATS 81 8 0 Created on
STIME C_TIME TIMS 89 6 0 Time created
SUSER UNAME CHAR 95 12 0 User Name
BYPROD_MAT_DOC COOS_MATERIAL_DOC_NO_BYPRODUCT CHAR 107 10 0 Material Document for Goods Receipt By-Product Order Split
BYPROD_MAT_ITEM COOS_MATERIAL_DOC_PO_BYPRODUCT NUMC 117 4 0 Material Document Item GR By-Product Order Split
BYPROD_MAT_YEAR COOS_MATERIAL_DOC_YY_BYPRODUCT NUMC 121 4 0 Material Document Year Goods Receipt By-Product Order Split
COMPONENT_BATCH COOS_COMPONENT_BATCH CHAR 125 10 0 MCH1 Component Batch Used for Order Split
WIP_BATCH COOS_WIPBATCH CHAR 135 10 0 MCH1 WIP Batch Used for Order Split
CANCELED COOS_CANCELED CHAR 145 1 0 Order Split Cancelled
CANCEL_USER COOS_CANCELLATION_USER CHAR 146 12 0 User Who Carried Out Order Split Cancellation
CANCEL_DATE COOS_CANCELLATION_DATE DATS 158 8 0 Cancellation Date Order Split
CANCEL_TIME COOS_CANCELLATION_TIME TIMS 166 6 0 Time of Cancellation