SAP ABAP Table IOITEM (Database structure for order items)

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	IOITEM	Table Relationship Diagram
Short Description	Database structure for order items

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	Order item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
4	POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
5	.INCLUDE	☐				0	0	Order item (Include structure)
6	PSOBS	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
7	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
8	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
9	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
10	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
11	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
12	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
13	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
14	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
15	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
16	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
17	PSAMG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
18	PSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
19	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
20	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
21	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
22	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
23	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
24	PAMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
25	PGMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
26	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
27	TPAUF	☐	TPAUF	CHAR1	CHAR	1	0	Indicator: Partial conversion
28	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
29	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
30	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	CKHS
31	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
32	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
33	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
34	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
35	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
36	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
37	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
38	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
39	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
40	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
41	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
42	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
43	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
44	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
45	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
46	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
47	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
48	DWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
49	DAUTY	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
50	DAUAT	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
51	DGLTP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
52	DGLTS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
53	DFREI	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
54	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
55	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
56	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
57	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
58	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
59	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
60	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
61	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
62	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
63	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
64	WEAED	☐	CO_WEAE	XFELD	CHAR	1	0	Indicator: Goods receipt indicator can be changed
65	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
66	KBNKZ	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
67	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
68	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
69	KRSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
70	KRSPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
71	KCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key	*
72	RTP01	☐	RTP01	XFELD	CHAR	1	0	Cost collector for repetitive manufacturing
73	RTP02	☐	RTP02	XFELD	CHAR	1	0	Cost collector for KANBAN
74	RTP03	☐	RTP03	XFELD	CHAR	1	0	Cost collector for valuated sales order stock
75	RTP04	☐	RTP04	XFELD	CHAR	1	0	Cost collector for external PPC
76	KSVON	☐	KSVON	DATUM	DATS	8	0	Cost collector valid from
77	KSBIS	☐	KSBIS	DATUM	DATS	8	0	Cost collector valid to
78	OBJNP	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
79	NDISR	☐	CO_NDISR	CHAR1	CHAR	1	0	Ind.: Material in order item is not relevant for MRP
80	VFMNG	☐	CO_VFMNG	MENG13	QUAN	13	3	Committed quantity for order acc. to ATP check components
81	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
82	KZAVC	☐	KZAVC	KZAVC	CHAR	1	0	Indicator for type of availability check
83	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
84	XLOEK	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
85	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
86	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
87	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
88	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
89	FXPRU	☐	CK_FIXPRKU	XFELD	CHAR	1	0	Fixed-Price Co-Product
90	CUOBJ_ROOT	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
91	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
92	TECHS_COPY	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
93	MATXT	☐	CO_MATXT	TEXT40	CHAR	40	0	Material description
94	FHWTX	☐	CO_FHWTEXT	CO_FHWTEXT	CHAR	1	0	Indicator: Production memo exists
95	SOPNR	☐	SAFNR	SAFNR	CHAR	10	0	SOP order number
96	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
97	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
98	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
99	BMENG	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
100	VSMNG	☐	VSMNG	MENG13	QUAN	13	3	Delivered quantity in sales units
101	KETDAT	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
102	BDATU	☐	DAT05	DATUM	DATS	8	0	Committed date
103	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
104	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
105	WEWERT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
106	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	*
107	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
108	PSPEX	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
109	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
110	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOITEM	AMEIN	T006	MSEHI
2	IOITEM	AUFNR	AUFK	AUFNR
3	IOITEM	BWTAR	T149D	BWTAR
4	IOITEM	BWTTY	T149C	BWTTY
5	IOITEM	CHARG	MCHA	CHARG
6	IOITEM	DAUAT	T003O	AUART
7	IOITEM	DWERK	T001W	WERKS
8	IOITEM	GSBER	TGSB	GSBER
9	IOITEM	KALNR	CKHS	KALNR
10	IOITEM	KDAUF	VBUK	VBELN
11	IOITEM	KDPOS	VBUP	POSNR
12	IOITEM	KNTTP	T163K	KNTTP
13	IOITEM	LGORT	T001L	LGORT
14	IOITEM	MANDT	T000	MANDT
15	IOITEM	MATNR	MARA	MATNR
16	IOITEM	MEINS	T006	MSEHI
17	IOITEM	OBJNP	ONR00	OBJNR	REF	C	C
18	IOITEM	PROJN	PRPS	PSPNR
19	IOITEM	PWERK	T001W	WERKS
20	IOITEM	SERNP	T377P	SERAIL
21	IOITEM	SERNR	SNUM	SERNR
22	IOITEM	SOBKZ	T148	SOBKZ
23	IOITEM	VERTO	T437V	VERTL

History

Last changed by/on	SAP	20110901
SAP Release Created in