SAP ABAP Table BAPIOIL2017_GM_ITM_SHOW (BAPI Communic. Struct.: Display Material Document Item (OIL))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL (Application Component) Industry Solution Oil
     ⤷ OI0_IF (Package) Common objects new Interfaces/BAPI

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIOIL2017_GM_ITM_SHOW	Table Relationship Diagram
Short Description	BAPI Communic. Struct.: Display Material Document Item (OIL)

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	MAT_DOC	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
2	DOC_YEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
3	MATDOC_ITM	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
4	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
5	PARENT_ID	☐	MB_PARENT_ID	MB_LINE_ID	NUMC	6	0	Identifier of immediately superior line
6	LINE_DEPTH	☐	MB_LINE_DEPTH	MB_LINE_DEPTH	NUMC	2	0	Hierarchy level of line in document
7	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
11	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
12	STCK_TYPE	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
13	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	CUSTOMER	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
16	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
17	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
18	SCHED_LINE	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
19	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
20	ENTRY_QNT	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
21	ENTRY_UOM	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
22	ENTRY_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
23	PO_PR_QNT	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
24	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
25	ORDERPR_UN_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
26	PO_NUMBER	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
27	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
28	SHIPPING	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
29	COMP_SHIP	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
30	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
31	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
32	GR_RCPT	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
33	UNLOAD_PT	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
34	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
35	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
36	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
37	CALC_MOTIVE	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
38	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
39	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
40	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
41	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
42	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
43	WITHDRAWN	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
44	MOVE_MAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
45	MOVE_PLANT	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
46	MOVE_STLOC	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
47	MOVE_BATCH	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	MCHA
48	MOVE_VAL_TYPE	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch	T149D
49	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
50	MOVE_REAS	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
51	RL_EST_KEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
52	REF_DATE	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
53	COST_OBJ	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
54	PROFIT_SEGM_NO	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
55	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
56	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
57	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
58	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
59	PART_ACCT	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
60	AMOUNT_LC	☐	BAPI_EXBWR	BAPICURR	DEC	23	4	Externally entered posting amount in local currency (BAPI)
61	AMOUNT_SV	☐	BAPI_EXVKW	BAPICURR	DEC	23	4	Externally entered sales value in local currency (for Bapi)
62	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
63	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
64	REF_DOC_YR	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
65	REF_DOC	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
66	REF_DOC_IT	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
67	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
68	PROD_DATE	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
69	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
70	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
71	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
72	VAL_SALES_ORD	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	VBUK
73	VAL_S_ORD_ITEM	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
74	VAL_WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
75	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
76	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
77	SUPPL_VEND	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
78	X_AUTO_CRE	☐	MB_XAUTO	MB_XAUTO	CHAR	1	0	Item automatically created
79	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
80	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
81	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
82	MOVE_MAT_EXTERNAL	☐	MGV_MOVE_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MOVE_MAT Field
83	MOVE_MAT_GUID	☐	MGV_MOVE_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MOVE_MAT Field
84	MOVE_MAT_VERSION	☐	MGV_MOVE_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MOVE_MAT Field
85	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
86	CMMT_ITEM_LONG	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
87	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
88	ORIGINCITY	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	*
89	ORIGINCOUNTY	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	*
90	ORIGINREGION	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	*
91	ORIGINCOUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
92	DESTINATIONCITY	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	*
93	DESTINATIONCOUNTY	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	*
94	DESTINATIONREGION	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	*
95	DESTINATIONCOUTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
96	TAXORIGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
97	TAXDESTINATION	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
98	PIPELINETRIPNUMBER	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
99	PIPELINEBATCHNUMBER	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
100	MODEOFTRANSPORT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
101	ALTERNATEORIGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
102	ALTERNATEDESTINATION	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
103	TRUCKNUMBER	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
104	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
105	EXTERNALLICENSE	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
106	VALIDFROM	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
107	VALIDTO	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
108	LICENSETYPE	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
109	INTERNALLICENSE	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
110	FOLLOWONLICENSE	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
111	FOLLOWONQUANTITY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
112	EXTERNALBILLOFLADING	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
113	MISCDELIVERYNUMBER	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
114	HANDLING_TYPE	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
115	ED_PRICING_EXTERN	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
116	INTTRACKINGNUMBER	☐	OIH_TRKNR	OIH_TRKNR	CHAR	10	0	Tracking number
117	TRACKINGNUMBERYEAR	☐	OIH_TRKJR	NUMC4	NUMC	4	0	Tracking number year
118	EXTTRACKINGNUMBER	☐	OIH_EXTNR	OIH_EXTNR	CHAR	18	0	External tracking number
119	TRACKINGITEM	☐	OIH_ITMNR	OIH_ITMNR	NUMC	5	0	Tracking number item line
120	FINALTRANSFERIND	☐	OIH_FTIND	OIH_FTIND	CHAR	1	0	Final transfer indicator
121	ISSUINGVALUATIONTYPE	☐	OIH_UMBAR	BWTAR	CHAR	10	0	Valuation type of issuing location for two-step transfer	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIOIL2017_GM_ITM_SHOW	ASSET_NO	ANLH	ANLN1
2	BAPIOIL2017_GM_ITM_SHOW	BATCH	MCHA	CHARG
3	BAPIOIL2017_GM_ITM_SHOW	CALC_MOTIVE	TBMOT	BEMOT
4	BAPIOIL2017_GM_ITM_SHOW	CMMT_ITEM	FMFPO	FIPOS
5	BAPIOIL2017_GM_ITM_SHOW	COMP_SHIP	T027C	EVERE
6	BAPIOIL2017_GM_ITM_SHOW	COSTCENTER	CSKS	KOSTL
7	BAPIOIL2017_GM_ITM_SHOW	COST_OBJ	CKPH	KSTRG
8	BAPIOIL2017_GM_ITM_SHOW	CURRENCY	TCURC	WAERS
9	BAPIOIL2017_GM_ITM_SHOW	CUSTOMER	KNA1	KUNNR
10	BAPIOIL2017_GM_ITM_SHOW	ENTRY_UOM	T006	MSEHI
11	BAPIOIL2017_GM_ITM_SHOW	ENTRY_UOM_ISO	T006I	ISOCODE
12	BAPIOIL2017_GM_ITM_SHOW	FUND	FMFINCODE	FINCODE
13	BAPIOIL2017_GM_ITM_SHOW	FUNDS_CTR	FMFCTR	FICTR
14	BAPIOIL2017_GM_ITM_SHOW	MATERIAL	MARA	MATNR
15	BAPIOIL2017_GM_ITM_SHOW	MOVE_BATCH	MCHA	CHARG
16	BAPIOIL2017_GM_ITM_SHOW	MOVE_MAT	MARA	MATNR
17	BAPIOIL2017_GM_ITM_SHOW	MOVE_PLANT	T001W	WERKS
18	BAPIOIL2017_GM_ITM_SHOW	MOVE_REAS	T157D	GRUND
19	BAPIOIL2017_GM_ITM_SHOW	MOVE_STLOC	T001L	LGORT
20	BAPIOIL2017_GM_ITM_SHOW	MOVE_TYPE	T156	BWART
21	BAPIOIL2017_GM_ITM_SHOW	MOVE_VAL_TYPE	T149D	BWTAR
22	BAPIOIL2017_GM_ITM_SHOW	NETWORK	AUFK	AUFNR
23	BAPIOIL2017_GM_ITM_SHOW	ORDERID	AUFK	AUFNR
24	BAPIOIL2017_GM_ITM_SHOW	ORDERPR_UN	T006	MSEHI
25	BAPIOIL2017_GM_ITM_SHOW	ORDERPR_UN_ISO	T006I	ISOCODE
26	BAPIOIL2017_GM_ITM_SHOW	PART_ACCT	KNA1	KUNNR
27	BAPIOIL2017_GM_ITM_SHOW	PLANT	T001W	WERKS
28	BAPIOIL2017_GM_ITM_SHOW	PO_ITEM	EKPO	EBELP
29	BAPIOIL2017_GM_ITM_SHOW	PO_NUMBER	EKKO	EBELN
30	BAPIOIL2017_GM_ITM_SHOW	PROFIT_CTR	CEPC	PRCTR
31	BAPIOIL2017_GM_ITM_SHOW	RESERV_NO	RESB	RSNUM
32	BAPIOIL2017_GM_ITM_SHOW	SALES_ORD	VBUK	VBELN
33	BAPIOIL2017_GM_ITM_SHOW	SHIPPING	T027A	EVERS
34	BAPIOIL2017_GM_ITM_SHOW	SPEC_STOCK	T148	SOBKZ
35	BAPIOIL2017_GM_ITM_SHOW	STGE_LOC	T001L	LGORT
36	BAPIOIL2017_GM_ITM_SHOW	SUB_NUMBER	ANLA	ANLN2
37	BAPIOIL2017_GM_ITM_SHOW	VAL_SALES_ORD	VBUK	VBELN
38	BAPIOIL2017_GM_ITM_SHOW	VAL_TYPE	T149D	BWTAR
39	BAPIOIL2017_GM_ITM_SHOW	VENDOR	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	472