SAP ABAP Table AFSPRELB (Buffer Table Structure for Relation Betw. Parent/Child Order)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COOS (Package) Production Order Split

Basic Data

Table Category	INTTAB	Structure
Structure	AFSPRELB	Table Relationship Diagram
Short Description	Buffer Table Structure for Relation Betw. Parent/Child Order

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Relation Between Orders in an Order Split
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	C_AUFNR	☐	SPLIT_CAUFNR	AUFNR	CHAR	12	0	Child order of a split hierarchy	*
4	BYPRODUCT	☐	COOS_BYPRODUCT	MATNR	CHAR	18	0	Material Number By-Product Order Split	*
5	BYPRODUCT_BATCH	☐	COOS_BYPRODUCT_BATCH	CHARG	CHAR	10	0	Batch Number By-Product Order Split	*
6	SPLCNT	☐	SPLCNT	NUMC4	NUMC	4	0	Counter for the Parent-Child Order Relationships
7	P_AUFNR	☐	SPLIT_PAUFNR	AUFNR	CHAR	12	0	Parent order of a split hierarchy	*
8	L_AUFNR	☐	SPLIT_LAUFNR	AUFNR	CHAR	12	0	Leading order of a split hierarchy	*
9	SPLQ	☐	SPLIT_QTY	MENG13	QUAN	13	3	Split Quantity in Order Split
10	QUNIT	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	*
11	SDATE	☐	CATS_ERSDA	DATUM	DATS	8	0	Created on
12	STIME	☐	C_TIME	UZEIT	TIMS	6	0	Time created
13	SUSER	☐	UNAME	UNAME	CHAR	12	0	User Name
14	BYPROD_MAT_DOC	☐	COOS_MATERIAL_DOC_NO_BYPRODUCT	BELNR	CHAR	10	0	Material Document for Goods Receipt By-Product Order Split
15	BYPROD_MAT_ITEM	☐	COOS_MATERIAL_DOC_PO_BYPRODUCT	MBLPO	NUMC	4	0	Material Document Item GR By-Product Order Split
16	BYPROD_MAT_YEAR	☐	COOS_MATERIAL_DOC_YY_BYPRODUCT	GJAHR	NUMC	4	0	Material Document Year Goods Receipt By-Product Order Split
17	COMPONENT_BATCH	☐	COOS_COMPONENT_BATCH	CHARG	CHAR	10	0	Component Batch Used for Order Split	*
18	WIP_BATCH	☐	COOS_WIPBATCH	CHARG	CHAR	10	0	WIP Batch Used for Order Split	*
19	CANCELED	☐	COOS_CANCELED	FLAG	CHAR	1	0	Order Split Cancelled
20	CANCEL_USER	☐	COOS_CANCELLATION_USER	UNAME	CHAR	12	0	User Who Carried Out Order Split Cancellation
21	CANCEL_DATE	☐	COOS_CANCELLATION_DATE	DATUM	DATS	8	0	Cancellation Date Order Split
22	CANCEL_TIME	☐	COOS_CANCELLATION_TIME	UZEIT	TIMS	6	0	Time of Cancellation
23	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
24	VORNR	☐	SPLIT_OPER	VORNR	CHAR	4	0	Split operation of an order split
25	TREE_MOD	☐	TREE_MOD	CHAR1	CHAR	1	0	Indicator: Type of change to the split hierarchy
26	VBKZ	☐	VBKZ	VERBUCHER	CHAR	1	0	Update indicator
27	CANCEL_AT_SAVE	☐	COOS_CANCEL_AT_SAVE	FLAG	CHAR	1	0	Cancellation of Order Split Upon Saving
28	BMENGE	☐	BASMN	MENG13	QUAN	13	3	Base quantity
29	BMEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*

History

Last changed by/on	SAP	20130529
SAP Release Created in