SAP ABAP Table IOSEQUEN (Database structure for order sequences)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COIS (Package) Order Information System

Basic Data

Table Category	INTTAB	Structure
Structure	IOSEQUEN	Table Relationship Diagram
Short Description	Database structure for order sequences

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	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
35	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
36	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
37	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOSEQUEN	AENNR	AENR	AENNR
2	IOSEQUEN	AUFNR	AUFK	AUFNR
3	IOSEQUEN	AUSCHL	TCA52	AUSCHL
4	IOSEQUEN	BSCHL1	TCA50	TSCHL
5	IOSEQUEN	BSCHL2	TCA50	TSCHL
6	IOSEQUEN	FLGAT	TCA07	FLGAT
7	IOSEQUEN	MANDT	T000	MANDT
8	IOSEQUEN	OBJNR	ONR00	OBJNR
9	IOSEQUEN	PLNME	T006	MSEHI
10	IOSEQUEN	PLNTY	TCA01	PLNTY
11	IOSEQUEN	TXTSP	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in