AFSPREL - Relation Between Orders in an Order Split

Relation Between Orders in an Order Split information is stored in SAP table AFSPREL.
It is part of development package CO in software component PP-SFC. This development package consists of objects that can be grouped under "Application Development ERP PP Production Orders".

Fields for table AFSPREL

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
C_AUFNR	Child Order of a Split Hierarchy	X	SPLIT_CAUFNR	CHAR	24
BYPRODUCT	Material Number By-Product Order Split	X	COOS_BYPRODUCT	CHAR	80
BYPRODUCT_BATCH	Batch Number By-Product Order Split	X	COOS_BYPRODUCT_BATCH	CHAR	20
SPLCNT	Counter for the Parent-Child Order Relationships		SPLCNT	NUMC	8
P_AUFNR	Parent Order of a Split Hierarchy		SPLIT_PAUFNR	CHAR	24
L_AUFNR	Leading Order of a Split Hierarchy		SPLIT_LAUFNR	CHAR	24
SPLQ	Split Quantity in Order Split		SPLIT_QTY	QUAN	7
QUNIT	Unit of measure for activity		VORME	UNIT	6
SDATE	Created On		CATS_ERSDA	DATS	16
STIME	Created At		C_TIME	TIMS	12
SUSER	User Name		UNAME	CHAR	24
BYPROD_MAT_DOC	Material Document for Goods Receipt By-Product Order Split		COOS_MATERIAL_DOC_NO_BYPRODUCT	CHAR	20
BYPROD_MAT_ITEM	Material Document Item GR By-Product Order Split		COOS_MATERIAL_DOC_PO_BYPRODUCT	NUMC	8
BYPROD_MAT_YEAR	Material Document Year Goods Receipt By-Product Order Split		COOS_MATERIAL_DOC_YY_BYPRODUCT	NUMC	8
COMPONENT_BATCH	Component Batch Used for Order Split		COOS_COMPONENT_BATCH	CHAR	20
WIP_BATCH	WIP Batch Used for Order Split		COOS_WIPBATCH	CHAR	20
CANCELED	Order Split Cancelled		COOS_CANCELED	CHAR	2
CANCEL_USER	User Who Carried Out Order Split Cancellation		COOS_CANCELLATION_USER	CHAR	24
CANCEL_DATE	Cancellation Date Order Split		COOS_CANCELLATION_DATE	DATS	16
CANCEL_TIME	Time of Cancellation		COOS_CANCELLATION_TIME	TIMS	12
WEBLNR	Number of a document from a goods movement with errors		WEBLNR	CHAR	20