SAP ABAP Table AFFLD (Order: Dialog table for order sequences (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	AFFLD	Table Relationship Diagram
Short Description	Order: Dialog table for order sequences (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	Order: Additional fields for dialog table AFFLD
27	VORNR1	☐	VORNR1	VORNR	CHAR	4	0	Number of the branch operation
28	VORNR2	☐	VORNR2	VORNR	CHAR	4	0	Number of the return operation
29	TXTKZ	☐	TXTKZ	FLAG	CHAR	1	0	Indicator: long text exists
30	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
31	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
32	FLG_LOE	☐	FLG_SEQLOE	KREUZ	CHAR	1	0	Indicator: Sequence is deleted (printing)
33	COMP_RES	☐	OCM_COMP_RES	OCM_COMP_RES	CHAR	1	0	OCM: Result of comparison of two order objects
34	.INCLUDE	☐				0	0	Version-include for AFFL
35	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	AFFLD	AENNR	AENR	AENNR
2	AFFLD	AUFNR	AUFK	AUFNR
3	AFFLD	AUSCHL	TCA52	AUSCHL
4	AFFLD	BSCHL1	TCA50	TSCHL
5	AFFLD	BSCHL2	TCA50	TSCHL
6	AFFLD	FLGAT	TCA07	FLGAT
7	AFFLD	MANDT	T000	MANDT
8	AFFLD	OBJNR	ONR00	OBJNR
9	AFFLD	PLNTY	TCA01	PLNTY
10	AFFLD	TXTSP	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in