SAP ABAP Table AFFLB (Order: Document table structure for AFFL)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	INTTAB	Structure
Structure	AFFLB	Table Relationship Diagram
Short Description	Order: Document table structure for AFFL

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	Work order sequence
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
4	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	.INCLUDE	☐				0	0	Work order sequence (Include structure)
6	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
7	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
8	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
9	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
10	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
11	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
12	FLGAT	☐	FOLGENART	FLGAT	CHAR	1	0	Sequence category	TCA07
13	BEZFL	☐	BEZFL	PLNFOLGE	CHAR	6	0	Reference sequence for a sequence
14	BKNT1	☐	BEZKNTANF	KNTNR	NUMC	8	0	Reference node for start of a sequence
15	BKNT2	☐	BEZKNTEND	KNTNR	NUMC	8	0	Finish reference node of a sequence
16	LTXA1	☐	FLGTEXT	TEXT40	CHAR	40	0	Sequence description
17	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
18	LOSVN	☐	CP_FLGLOSV	MENG13	QUAN	13	3	From lot size
19	LOSBS	☐	CP_FLGLOSB	MENG13	QUAN	13	3	To lot size
20	BSCHL1	☐	CP_BSCHL1	CP_TSCHL	CHAR	1	0	Relationship key for branch operation of parallel sequences	TCA50
21	BSCHL2	☐	CP_BSCHL2	CP_TSCHL	CHAR	1	0	Relationship key for return operation of parallel sequences	TCA50
22	AUSCHL	☐	CP_AUSCHL	CP_AUSSCHL	CHAR	1	0	Alignment key for scheduling	TCA52
23	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
24	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
25	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
26	.INCLUDE	☐				0	0	Buffer tables - additional fields in order
27	VBKZ	☐	VBKZ	VERBUCHER	CHAR	1	0	Update indicator
28	FLG_SEL	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
29	AUFNR_T	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
30	FLG_CALCUL	☐	FLG_CALC	KREUZ	CHAR	1	0	Indicator: Order (network etc.) still to be calculated
31	.INCLUDE	☐				0	0	Temporary field for document table for sequences
32	COMP_RES	☐	OCM_COMP_RES	OCM_COMP_RES	CHAR	1	0	OCM: Result of comparison of two order objects
33	.INCLUDE	☐				0	0	Version-include for AFFL
34	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFFLB	AENNR	AENR	AENNR	REF	1	CN
2	AFFLB	AUSCHL	TCA52	AUSCHL	REF	C	CN
3	AFFLB	BSCHL1	TCA50	TSCHL	REF	C	CN
4	AFFLB	BSCHL2	TCA50	TSCHL	REF	C	CN
5	AFFLB	FLGAT	TCA07	FLGAT
6	AFFLB	MANDT	T000	MANDT	KEY	1	CN
7	AFFLB	OBJNR	ONR00	OBJNR	REF	C	1
8	AFFLB	PLNTY	TCA01	PLNTY	REF	1	CN
9	AFFLB	TXTSP	T002	SPRAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in