SAP ABAP Table BAPI2017_GM_ITEM_CREATE_OIL (BAPI Communication Structure: Create Material Doc. 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 BAPI2017_GM_ITEM_CREATE_OIL   Table Relationship Diagram
Short Description BAPI Communication Structure: Create Material Doc. 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 LINE_ID MB_LINE_ID MB_LINE_ID NUMC 6   0   Unique identification of document line  
2 PARENT_ID MB_PARENT_ID MB_LINE_ID NUMC 6   0   Identifier of immediately superior line  
3 LINE_DEPTH MB_LINE_DEPTH MB_LINE_DEPTH NUMC 2   0   Hierarchy level of line in document  
4 MATERIAL MATNR MATNR CHAR 18   0   Material Number MARA
5 PLANT WERKS_D WERKS CHAR 4   0   Plant T001W
6 STGE_LOC LGORT_D LGORT CHAR 4   0   Storage location T001L
7 BATCH CHARG_D CHARG CHAR 10   0   Batch Number MCHA
8 MOVE_TYPE BWART BWART CHAR 3   0   Movement type (inventory management) T156
9 STCK_TYPE MB_INSMK MB_INSMK CHAR 1   0   Stock Type  
10 SPEC_STOCK SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
11 VENDOR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
12 CUSTOMER EKUNN KUNNR CHAR 10   0   Account number of customer KNA1
13 SALES_ORD KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
14 S_ORD_ITEM KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
15 SCHED_LINE KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
16 VAL_TYPE BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
17 ENTRY_QNT ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
18 ENTRY_UOM ERFME MEINS UNIT 3   0   Unit of entry T006
19 ENTRY_UOM_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
20 PO_PR_QNT BPMNG MENG13 QUAN 13   3   Quantity in order price quantity unit  
21 ORDERPR_UN BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
22 ORDERPR_UN_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
23 PO_NUMBER BSTNR EBELN CHAR 10   0   Purchase order number EKKO
24 PO_ITEM EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
25 SHIPPING EVERS EVERS CHAR 2   0   Shipping Instructions T027A
26 COMP_SHIP EVERE EVERE CHAR 2   0   Compliance with Shipping Instructions T027C
27 NO_MORE_GR ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
28 ITEM_TEXT SGTXT TEXT50 CHAR 50   0   Item Text  
29 GR_RCPT WEMPF WEMPF CHAR 12   0   Goods recipient  
30 UNLOAD_PT ABLAD TEXT25 CHAR 25   0   Unloading Point  
31 COSTCENTER KOSTL KOSTL CHAR 10   0   Cost Center CSKS
32 ORDERID AUFNR AUFNR CHAR 12   0   Order Number AUFK
33 ORDER_ITNO CO_POSNR CO_POSNR NUMC 4   0   Order item number  
34 CALC_MOTIVE BEMOT BEMOT CHAR 2   0   Accounting Indicator TBMOT
35 ASSET_NO ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
36 SUB_NUMBER ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
37 RESERV_NO RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements RESB
38 RES_ITEM RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
39 RES_TYPE RSART RSART CHAR 1   0   Record type  
40 WITHDRAWN KZEAR XFELD CHAR 1   0   Final issue for this reservation  
41 MOVE_MAT UMMAT MATNR CHAR 18   0   Receiving/issuing material MARA
42 MOVE_PLANT UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
43 MOVE_STLOC UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
44 MOVE_BATCH UMCHA CHARG CHAR 10   0   Receiving/issuing batch MCHA
45 MOVE_VAL_TYPE UMBAR BWTAR CHAR 10   0   Valuation type of transfer batch T149D
46 MVT_IND KZBEW KZBEW CHAR 1   0   Movement Indicator  
47 MOVE_REAS MB_GRBEW MB_GRBEW NUMC 4   0   Reason for movement T157D
48 RL_EST_KEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
49 REF_DATE DABRBEZ DDAT DATS 8   0   Reference date for settlement  
50 COST_OBJ KSTRG KSTRG CHAR 12   0   Cost Object CKPH
51 PROFIT_SEGM_NO RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
52 PROFIT_CTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
53 WBS_ELEM PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
54 NETWORK NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment AUFK
55 ACTIVITY VORNR VORNR CHAR 4   0   Operation/Activity Number  
56 PART_ACCT JV_PART KUNNR CHAR 10   0   Partner account number KNA1
57 AMOUNT_LC BAPI_EXBWR BAPICURR DEC 23   4   Externally entered posting amount in local currency (BAPI)  
58 AMOUNT_SV BAPI_EXVKW BAPICURR DEC 23   4   Externally entered sales value in local currency (for Bapi)  
59 REF_DOC_YR LFBJA GJAHR NUMC 4   0   Fiscal Year of a Reference Document  
60 REF_DOC LFBNR BELNR CHAR 10   0   Document number of a reference document  
61 REF_DOC_IT LFPOS MBLPO NUMC 4   0   Item of a reference document  
62 EXPIRYDATE VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
63 PROD_DATE HSDAT DATUM DATS 8   0   Date of Manufacture  
64 FUND BP_GEBER BP_GEBER CHAR 10   0   Fund FMFINCODE
65 FUNDS_CTR FISTL FISTL CHAR 16   0   Funds Center FMFCTR
66 CMMT_ITEM FIPOS FIPOS CHAR 14   0   Commitment Item FMFPO
67 VAL_SALES_ORD MAT_KDAUF VBELN CHAR 10   0   Sales order number of valuated sales order stock VBUK
68 VAL_S_ORD_ITEM MAT_KDPOS NUM06 NUMC 6   0   Sales Order Item of Valuated Sales Order Stock  
69 VAL_WBS_ELEM PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
70 GL_ACCOUNT SAKNR SAKNR CHAR 10   0   G/L Account Number SKA1
71 IND_PROPOSE_QUANX XMEVO XFELD CHAR 1   0   Propose quantities  
72 XSTOB XSTOB XFELD CHAR 1   0   Use Reversal Movement Type Indicator  
73 EAN_UPC EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
74 DELIV_NUMB_TO_SEARCH VBELN_VL VBELN CHAR 10   0   Delivery VBUK
75 DELIV_ITEM_TO_SEARCH POSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
76 SERIALNO_AUTO_NUMBERASSIGNMENT XSAUT XFELD CHAR 1   0   Serial number to be created automatically via method  
77 VENDRBATCH LICHN LICHN CHAR 15   0   Vendor Batch Number  
78 STGE_TYPE LGTYP LGTYP CHAR 3   0   Storage Type T301
79 STGE_BIN LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
80 SU_PL_STCK_1 LVS_ANZLE LVS_ANZLE DEC 3   0   Number of Storage Units to be Placed Into Storage  
81 ST_UN_QTYY_1 LVS_LEMEN MENG13 QUAN 13   3   Quantity per Storage Unit to be Placed into Stock in Alt.UoM  
82 ST_UN_QTYY_1_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
83 UNITTYPE_1 LVS_LETYP LVS_LETYP CHAR 3   0   Storage Unit Type T307
84 SU_PL_STCK_2 LVS_ANZLE LVS_ANZLE DEC 3   0   Number of Storage Units to be Placed Into Storage  
85 ST_UN_QTYY_2 LVS_LEMEN MENG13 QUAN 13   3   Quantity per Storage Unit to be Placed into Stock in Alt.UoM  
86 ST_UN_QTYY_2_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
87 UNITTYPE_2 LVS_LETYP LVS_LETYP CHAR 3   0   Storage Unit Type T307
88 STGE_TYPE_PC UBTYP LGTYP CHAR 3   0   Storage type for transfer posting T301
89 STGE_BIN_PC UBPLA LGPLA CHAR 10   0   Storage bin for transfer posting LAGP
90 NO_PST_CHGNT LVS_KZKUB XFELD CHAR 1   0   Indicator: Do not create posting change notice  
91 GR_NUMBER LVS_WENUM BELNR CHAR 10   0   Goods Receipt Number  
92 STGE_TYPE_ST UMLGT LGTYP CHAR 3   0   Storage type for stock transfer T301
93 STGE_BIN_ST UMLGP LGPLA CHAR 10   0   Storage bin for stock transfer LAGP
94 MATDOC_TR_CANCEL LVS_TBBEL BELNR CHAR 10   0   Material doc. no. of transfer requirement to be cancelled  
95 MATITEM_TR_CANCEL LVS_TBBPO MBLPO NUMC 4   0   Material doc. item of transf.reqmnt item to be cancelled  
96 MATYEAR_TR_CANCEL LVS_TBBJR GJAHR NUMC 4   0   Material doc. year of transfer requirement to be cancelled  
97 NO_TRANSFER_REQ LVS_TBFKZ XFELD CHAR 1   0   Indicator: No Transfer Requirement Created  
98 CO_BUSPROC CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
99 ACTTYPE LSTAR LSTAR CHAR 6   0   Activity Type *
100 SUPPL_VEND LLIEF LIFNR CHAR 10   0   Supplying Vendor *
101 MATERIAL_EXTERNAL MGV_MATERIAL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for MATERIAL Field  
102 MATERIAL_GUID MGV_MATERIAL_GUID MATNR_EGUID CHAR 32   0   External GUID for MATERIAL Field  
103 MATERIAL_VERSION MGV_MATERIAL_VERSION MATNR_VERS CHAR 10   0   Version Number for MATERIAL Field  
104 MOVE_MAT_EXTERNAL MGV_MOVE_MAT_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for MOVE_MAT Field  
105 MOVE_MAT_GUID MGV_MOVE_MAT_GUID MATNR_EGUID CHAR 32   0   External GUID for MOVE_MAT Field  
106 MOVE_MAT_VERSION MGV_MOVE_MAT_VERSION MATNR_VERS CHAR 10   0   Version Number for MOVE_MAT Field  
107 FUNC_AREA FKBER_SHORT FKBER_SHORT CHAR 4   0   Functional Area  
108 TR_PART_BA PARGB GSBER CHAR 4   0   Trading partner's business area *
109 PAR_COMPCO PARBU BUKRS CHAR 4   0   Clearing company code *
110 DELIV_NUMB VBELN_VL VBELN CHAR 10   0   Delivery *
111 DELIV_ITEM POSNR_VL POSNR NUMC 6   0   Delivery Item *
112 NB_SLIPS WEANZ NUM3 NUMC 3   0   Number of GR/GI slips to be printed  
113 NB_SLIPSX BAPIUPDATE BAPIUPDATE CHAR 1   0   Updated information in related user data field  
114 GR_RCPTX BAPIUPDATE BAPIUPDATE CHAR 1   0   Updated information in related user data field  
115 UNLOAD_PTX BAPIUPDATE BAPIUPDATE CHAR 1   0   Updated information in related user data field  
116 SPEC_MVMT LVS_BSSKZ LVS_BSSKZ CHAR 1   0   Special movement indicator for warehouse management *
117 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
118 CMMT_ITEM_LONG FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
119 FUNC_AREA_LONG FKBER FKBER CHAR 16   0   Functional Area *
120 QUANTITY MENGE_D MENG13 QUAN 13   3   Quantity  
121 BASE_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure *
122 ORIGINCITY OIC_OCITYC CITYC CHAR 4   0   Origin city code *
123 ORIGINCOUNTY OIC_OCOUNC COUNC CHAR 3   0   Origin county code *
124 ORIGINREGION OIC_OREGIO REGIO CHAR 3   0   Origin region *
125 ORIGINCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
126 DESTINATIONCITY OIC_DCITYC CITYC CHAR 4   0   Destination city code *
127 DESTINATIONCOUNTY OIC_DCOUNC COUNC CHAR 3   0   Destination county code *
128 DESTINATIONREGION OIC_DREGIO REGIO CHAR 3   0   Destination region *
129 DESTINATIONCOUTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
130 TAXORIGIN OIC_PORGIN OIC_PORGIN CHAR 15   0   Tax origin  
131 TAXDESTINATION OIC_PDESTN OIC_PDESTN CHAR 15   0   Tax destination  
132 PIPELINETRIPNUMBER OIC_PTRIP OIC_PTRIP CHAR 16   0   Pipeline trip number (external)  
133 PIPELINEBATCHNUMBER OIC_PBATCH OIC_PBATCH CHAR 16   0   Pipeline operator´s external batch number  
134 MODEOFTRANSPORT OIC_MOT VKTRA CHAR 2   0   IS-OIL MAP external details mode of transport *
135 ALTERNATEORIGIN OIC_AORGIN OIC_PORGIN CHAR 15   0   Alternate origin  
136 ALTERNATEDESTINATION OIC_ADESTN OIC_PDESTN CHAR 15   0   Alternate destination  
137 TRUCKNUMBER OIC_TRUCKN OIC_TRUCKN CHAR 10   0   Truck number  
138 VENDOR_NO LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
139 EXTERNALLICENSE OIH_CERTF1 OIH_CERTF1 CHAR 15   0   Excise tax external license number  
140 VALIDFROM OIH_DATFM1 DATUM DATS 8   0   Excise duty tax certificate valid from date  
141 VALIDTO OIH_DATTO1 DATUM DATS 8   0   Valid to date for excise duty tax certificate  
142 LICENSETYPE OIH_LICTP OIH_LICTP CHAR 4   0   License type *
143 INTERNALLICENSE OIH_LICIN OIH_LICIN CHAR 10   0   Excise tax internal license number *
144 FOLLOWONLICENSE OIH_LCFOL OIH_LICIN CHAR 10   0   Follow-on license for quantity license *
145 FOLLOWONQUANTITY OIH_FOLQTY MENG13 QUAN 13   3   Excise tax follow-on license quantity  
146 EXTERNALBILLOFLADING OID_EXTBOL OID_EXTBOL CHAR 16   0   External bill of lading  
147 MISCDELIVERYNUMBER OID_MISCDL OID_MISCDL CHAR 16   0   Miscellaneous delivery number  
148 HANDLING_TYPE OIH_HANTYP OIH_HANTYP CHAR 2   0   Excise Duty Handling Type *
149 ED_PRICING_EXTERN OIH_INEX OIH_INEX CHAR 2   0   Code for internal or external excise duty rate determination *
150 INTTRACKINGNUMBER OIH_TRKNR OIH_TRKNR CHAR 10   0   Tracking number  
151 TRACKINGNUMBERYEAR OIH_TRKJR NUMC4 NUMC 4   0   Tracking number year  
152 EXTTRACKINGNUMBER OIH_EXTNR OIH_EXTNR CHAR 18   0   External tracking number  
153 TRACKINGITEM OIH_ITMNR OIH_ITMNR NUMC 5   0   Tracking number item line  
154 FINALTRANSFERIND OIH_FTIND OIH_FTIND CHAR 1   0   Final transfer indicator  
155 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 BAPI2017_GM_ITEM_CREATE_OIL ASSET_NO ANLH ANLN1    
2 BAPI2017_GM_ITEM_CREATE_OIL BATCH MCHA CHARG    
3 BAPI2017_GM_ITEM_CREATE_OIL CALC_MOTIVE TBMOT BEMOT    
4 BAPI2017_GM_ITEM_CREATE_OIL CMMT_ITEM FMFPO FIPOS    
5 BAPI2017_GM_ITEM_CREATE_OIL COMP_SHIP T027C EVERE    
6 BAPI2017_GM_ITEM_CREATE_OIL COSTCENTER CSKS KOSTL    
7 BAPI2017_GM_ITEM_CREATE_OIL COST_OBJ CKPH KSTRG    
8 BAPI2017_GM_ITEM_CREATE_OIL CUSTOMER KNA1 KUNNR    
9 BAPI2017_GM_ITEM_CREATE_OIL DELIV_ITEM_TO_SEARCH VBUP POSNR    
10 BAPI2017_GM_ITEM_CREATE_OIL DELIV_NUMB_TO_SEARCH VBUK VBELN    
11 BAPI2017_GM_ITEM_CREATE_OIL ENTRY_UOM T006 MSEHI    
12 BAPI2017_GM_ITEM_CREATE_OIL ENTRY_UOM_ISO T006I ISOCODE    
13 BAPI2017_GM_ITEM_CREATE_OIL FUND FMFINCODE FINCODE    
14 BAPI2017_GM_ITEM_CREATE_OIL FUNDS_CTR FMFCTR FICTR    
15 BAPI2017_GM_ITEM_CREATE_OIL GL_ACCOUNT SKA1 SAKNR    
16 BAPI2017_GM_ITEM_CREATE_OIL MATERIAL MARA MATNR    
17 BAPI2017_GM_ITEM_CREATE_OIL MOVE_BATCH MCHA CHARG    
18 BAPI2017_GM_ITEM_CREATE_OIL MOVE_MAT MARA MATNR    
19 BAPI2017_GM_ITEM_CREATE_OIL MOVE_PLANT T001W WERKS    
20 BAPI2017_GM_ITEM_CREATE_OIL MOVE_REAS T157D GRUND    
21 BAPI2017_GM_ITEM_CREATE_OIL MOVE_STLOC T001L LGORT    
22 BAPI2017_GM_ITEM_CREATE_OIL MOVE_TYPE T156 BWART    
23 BAPI2017_GM_ITEM_CREATE_OIL MOVE_VAL_TYPE T149D BWTAR    
24 BAPI2017_GM_ITEM_CREATE_OIL NETWORK AUFK AUFNR    
25 BAPI2017_GM_ITEM_CREATE_OIL ORDERID AUFK AUFNR    
26 BAPI2017_GM_ITEM_CREATE_OIL ORDERPR_UN T006 MSEHI    
27 BAPI2017_GM_ITEM_CREATE_OIL ORDERPR_UN_ISO T006I ISOCODE    
28 BAPI2017_GM_ITEM_CREATE_OIL PART_ACCT KNA1 KUNNR    
29 BAPI2017_GM_ITEM_CREATE_OIL PLANT T001W WERKS    
30 BAPI2017_GM_ITEM_CREATE_OIL PO_ITEM EKPO EBELP    
31 BAPI2017_GM_ITEM_CREATE_OIL PO_NUMBER EKKO EBELN    
32 BAPI2017_GM_ITEM_CREATE_OIL PROFIT_CTR CEPC PRCTR    
33 BAPI2017_GM_ITEM_CREATE_OIL RESERV_NO RESB RSNUM    
34 BAPI2017_GM_ITEM_CREATE_OIL SALES_ORD VBUK VBELN    
35 BAPI2017_GM_ITEM_CREATE_OIL SHIPPING T027A EVERS    
36 BAPI2017_GM_ITEM_CREATE_OIL SPEC_STOCK T148 SOBKZ    
37 BAPI2017_GM_ITEM_CREATE_OIL STGE_BIN LAGP LGPLA    
38 BAPI2017_GM_ITEM_CREATE_OIL STGE_BIN_PC LAGP LGPLA    
39 BAPI2017_GM_ITEM_CREATE_OIL STGE_BIN_ST LAGP LGPLA    
40 BAPI2017_GM_ITEM_CREATE_OIL STGE_LOC T001L LGORT    
41 BAPI2017_GM_ITEM_CREATE_OIL STGE_TYPE T301 LGTYP    
42 BAPI2017_GM_ITEM_CREATE_OIL STGE_TYPE_PC T301 LGTYP    
43 BAPI2017_GM_ITEM_CREATE_OIL STGE_TYPE_ST T301 LGTYP    
44 BAPI2017_GM_ITEM_CREATE_OIL ST_UN_QTYY_1_ISO T006I ISOCODE    
45 BAPI2017_GM_ITEM_CREATE_OIL ST_UN_QTYY_2_ISO T006I ISOCODE    
46 BAPI2017_GM_ITEM_CREATE_OIL SUB_NUMBER ANLA ANLN2    
47 BAPI2017_GM_ITEM_CREATE_OIL UNITTYPE_1 T307 LETYP    
48 BAPI2017_GM_ITEM_CREATE_OIL UNITTYPE_2 T307 LETYP    
49 BAPI2017_GM_ITEM_CREATE_OIL VAL_SALES_ORD VBUK VBELN    
50 BAPI2017_GM_ITEM_CREATE_OIL VAL_TYPE T149D BWTAR    
51 BAPI2017_GM_ITEM_CREATE_OIL VENDOR LFA1 LIFNR    
History
Last changed by/on SAP  20130529 
SAP Release Created in 472