SAP ABAP Table IOMAMO (Database structure for documentation goods movements)

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	IOMAMO	Table Relationship Diagram
Short Description	Database structure for documentation goods movements

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	Goods movements for order
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
4	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
5	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
6	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
7	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
8	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
12	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
16	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
17	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
18	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
21	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
22	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
23	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
24	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
25	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
26	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
27	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
28	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
29	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
30	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
31	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
32	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
33	RSART	☐	RSART	RSART	CHAR	1	0	Record type
34	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
35	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
36	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
37	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
38	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
39	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
40	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
41	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
42	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
43	MAKTX	☐	CO_MATXT	TEXT40	CHAR	40	0	Material description
44	WBKNZ	☐	WBKNZ	WBKNZ	CHAR	1	0	Goods movement indicator
45	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
46	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
47	MENGE_VZ	☐	MENGEV	MENGV13	QUAN	13	3	Quantity with Sign
48	ERFMG_VZ	☐	ERFMGV	MENGV13	QUAN	13	3	Quantity in unit of entry with leading sign
49	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOMAMO	AUFNR	AUFK	AUFNR	REF	C	CN
2	IOMAMO	BWART	T156	BWART	REF	1	CN
3	IOMAMO	BWTAR	T149D	BWTAR	REF	C	CN
4	IOMAMO	CHARG	MCH1	CHARG	REF	C	CN
5	IOMAMO	EBELN	EKKO	EBELN	REF	C	CN
6	IOMAMO	EBELP	EKPO	EBELP	REF	C	CN
7	IOMAMO	ERFME	T006	MSEHI	REF	1	N
8	IOMAMO	KDAUF	VBUK	VBELN	REF	C	CN
9	IOMAMO	KOKRS	TKA01	KOKRS	REF	C	CN
10	IOMAMO	LGORT	T001L	LGORT	REF	C	CN
11	IOMAMO	LIFNR	LFA1	LIFNR	REF	C	CN
12	IOMAMO	MANDT	T000	MANDT	KEY	1	CN
13	IOMAMO	MATNR	MARA	MATNR	REF	C	CN
14	IOMAMO	MEINS	T006	MSEHI	REF	C	CN
15	IOMAMO	NPLNR	AUFK	AUFNR	REF	1	CN
16	IOMAMO	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
17	IOMAMO	RSNUM	RESB	RSNUM	REF	C	CN
18	IOMAMO	SAKTO	SKA1	SAKNR	REF	C	CN
19	IOMAMO	SOBKZ	T148	SOBKZ	REF	C	CN
20	IOMAMO	WAERS	TCURC	WAERS	REF	1	CN
21	IOMAMO	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in