SAP ABAP Table BAPI2017_GM_ITEM_SHOW_OIL (BAPI Communication Structure: Display Material Document Item)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL (Application Component) Industry Solution Oil
⤷ OI0_IF (Package) Common objects new Interfaces/BAPI
⤷ 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_SHOW_OIL | Table Relationship Diagram |
Short Description | BAPI Communication Structure: Display Material Document Item |
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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |