SAP ABAP View AFSPLIT (View of Split Relationships and Split Operations)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	AFSPLIT
Short Description	View of Split Relationships and Split Operations
Root table	AFSPREL	Relation Between Orders in an Order Split

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFSPREL	AFSPREL
2	AFSPOPR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFSPREL	MANDT	JL	EQ				0	0
2	AFSPOPR	MANDT	JR	EQ			AND	0	0
3	AFSPREL	C_AUFNR	JL	EQ				0	0
4	AFSPOPR	C_AUFNR	JR	EQ			AND	0	0
5	AFSPREL	BYPRODUCT	JL	EQ				0	0
6	AFSPOPR	BYPRODUCT	JR	EQ			AND	0	0
7	AFSPREL	BYPRODUCT_BATCH	JL	EQ				0	0
8	AFSPOPR	BYPRODUCT_BATCH	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	AFSPREL	*		☐		☐
2	MANDT	AFSPREL	MANDT		☐	MANDT	☐	Client
3	C_AUFNR	AFSPREL	C_AUFNR		☐	SPLIT_CAUFNR	☐	Child order of a split hierarchy
4	BYPRODUCT	AFSPREL	BYPRODUCT		☐	COOS_BYPRODUCT	☐	Material Number By-Product Order Split
5	BYPRODUCT_BATCH	AFSPREL	BYPRODUCT_BATCH		☐	COOS_BYPRODUCT_BATCH	☐	Batch Number By-Product Order Split
6	SPLCNT	AFSPREL	SPLCNT		☐	SPLCNT	☐	Counter for the Parent-Child Order Relationships
7	P_AUFNR	AFSPREL	P_AUFNR		☐	SPLIT_PAUFNR	☐	Parent order of a split hierarchy
8	L_AUFNR	AFSPREL	L_AUFNR		☐	SPLIT_LAUFNR	☐	Leading order of a split hierarchy
9	SPLQ	AFSPREL	SPLQ		☐	SPLIT_QTY	☐	Split Quantity in Order Split
10	QUNIT	AFSPREL	QUNIT		☐	VORME	☐	Unit of measure for activity
11	SDATE	AFSPREL	SDATE		☐	CATS_ERSDA	☐	Created on
12	STIME	AFSPREL	STIME		☐	C_TIME	☐	Time created
13	SUSER	AFSPREL	SUSER		☐	UNAME	☐	User Name
14	BYPROD_MAT_DOC	AFSPREL	BYPROD_MAT_DOC		☐	COOS_MATERIAL_DOC_NO_BYPRODUCT	☐	Material Document for Goods Receipt By-Product Order Split
15	BYPROD_MAT_ITEM	AFSPREL	BYPROD_MAT_ITEM		☐	COOS_MATERIAL_DOC_PO_BYPRODUCT	☐	Material Document Item GR By-Product Order Split
16	BYPROD_MAT_YEAR	AFSPREL	BYPROD_MAT_YEAR		☐	COOS_MATERIAL_DOC_YY_BYPRODUCT	☐	Material Document Year Goods Receipt By-Product Order Split
17	COMPONENT_BATCH	AFSPREL	COMPONENT_BATCH		☐	COOS_COMPONENT_BATCH	☐	Component Batch Used for Order Split
18	WIP_BATCH	AFSPREL	WIP_BATCH		☐	COOS_WIPBATCH	☐	WIP Batch Used for Order Split
19	CANCELED	AFSPREL	CANCELED		☐	COOS_CANCELED	☐	Order Split Cancelled
20	CANCEL_USER	AFSPREL	CANCEL_USER		☐	COOS_CANCELLATION_USER	☐	User Who Carried Out Order Split Cancellation
21	CANCEL_DATE	AFSPREL	CANCEL_DATE		☐	COOS_CANCELLATION_DATE	☐	Cancellation Date Order Split
22	CANCEL_TIME	AFSPREL	CANCEL_TIME		☐	COOS_CANCELLATION_TIME	☐	Time of Cancellation
23	APLZL	AFSPOPR	APLZL		☐	CO_APLZL	☐	General counter for order
24	APLFL	AFSPOPR	APLFL		☐	PLNFOLGE	☐	Sequence

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in