SAP TABLES | Industry Solution Oil(IS-OIL) SAP IS

BAPI2017_GM_ITEM_SHOW_OIL SAP BAPI Communication Structure: Display Material Document Item Structure and data







BAPI2017_GM_ITEM_SHOW_OIL is an SAP Structure so does not store data like a database table does but can be used to process "BAPI Communication Structure: Display Material Document Item" Information within sap ABAP programs. This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BAPI2017_GM_ITEM_SHOW_OIL TYPE BAPI2017_GM_ITEM_SHOW_OIL .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


SAP BAPI2017_GM_ITEM_SHOW_OIL Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
MAT_DOCMBLNRCHAR10 Number of Material DocumentALPHA
DOC_YEARMJAHRNUMC4 Material Document YearGJAHR
MATDOC_ITMMBLPONUMC4 Item in Material Document
LINE_IDMB_LINE_IDNUMC6 Unique identification of document line
PARENT_IDMB_PARENT_IDNUMC6 Identifier of immediately superior line
LINE_DEPTHMB_LINE_DEPTHNUMC2 Hierarchy level of line in document
MATERIALMATNRCHAR18 MARAMaterial NumberMATN1
PLANTWERKS_DCHAR4 T001WPlant
STGE_LOCLGORT_DCHAR4 T001LStorage Location
BATCHCHARG_DCHAR10 MCHABatch Number
MOVE_TYPEBWARTCHAR3 T156Movement Type (Inventory Management)
STCK_TYPEMB_INSMKCHAR1 Stock Type
SPEC_STOCKSOBKZCHAR1 T148Special Stock Indicator
VENDORELIFNCHAR10 LFA1Vendor Account NumberALPHA
CUSTOMEREKUNNCHAR10 KNA1Account Number of CustomerALPHA
SALES_ORDKDAUFCHAR10 VBUKSales Order NumberALPHA
S_ORD_ITEMKDPOSNUMC6 Item Number in Sales Order
SCHED_LINEKDEINNUMC4 Delivery Schedule for Sales Order
VAL_TYPEBWTAR_DCHAR10 T149DValuation Type
ENTRY_QNTERFMGQUAN13(3) Quantity in Unit of Entry
ENTRY_UOMERFMEUNIT3 T006Unit of EntryCUNIT
ENTRY_UOM_ISOISOCD_UNITCHAR3 T006IISO code for unit of measurement
PO_PR_QNTBPMNGQUAN13(3) Quantity in Purchase Order Price Unit
ORDERPR_UNBBPRMUNIT3 T006Order Price Unit (Purchasing)CUNIT
ORDERPR_UN_ISOISOCD_UNITCHAR3 T006IISO code for unit of measurement
PO_NUMBERBSTNRCHAR10 EKKOPurchase Order NumberALPHA
PO_ITEMEBELPNUMC5 EKPOItem Number of Purchasing Document
SHIPPINGEVERSCHAR2 T027AShipping Instructions
COMP_SHIPEVERECHAR2 T027CCompliance with Shipping Instructions



NO_MORE_GRELIKZCHAR1 "Delivery Completed" Indicator
ITEM_TEXTSGTXTCHAR50 Item Text
GR_RCPTWEMPFCHAR12 Goods Recipient/Ship-To Party
UNLOAD_PTABLADCHAR25 Unloading Point
COSTCENTERKOSTLCHAR10 CSKSCost CenterALPHA
ORDERIDAUFNRCHAR12 AUFKOrder NumberALPHA
ORDER_ITNOCO_POSNRNUMC4 Order Item Number
CALC_MOTIVEBEMOTCHAR2 TBMOTAccounting Indicator
ASSET_NOANLN1CHAR12 ANLHMain Asset NumberALPHA
SUB_NUMBERANLN2CHAR4 ANLAAsset SubnumberALPHA
RESERV_NORSNUMNUMC10 RESBNumber of Reservation/Dependent Requirement
RES_ITEMRSPOSNUMC4 Item Number of Reservation/Dependent Requirement
RES_TYPERSARTCHAR1 Record type
WITHDRAWNKZEARCHAR1 Final Issue for This Reservation
MOVE_MATUMMATCHAR18 MARAReceiving/Issuing MaterialMATN1
MOVE_PLANTUMWRKCHAR4 T001WReceiving/Issuing Plant
MOVE_STLOCUMLGOCHAR4 T001LReceiving/Issuing Storage Location
MOVE_BATCHUMCHACHAR10 MCHAReceiving/Issuing Batch
MOVE_VAL_TYPEUMBARCHAR10 T149DValuation Type of Transfer Batch
MVT_INDKZBEWCHAR1 Movement Indicator
MOVE_REASMB_GRBEWNUMC4 T157DReason for Movement
RL_EST_KEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
REF_DATEDABRBEZDATS8 Reference Date for Settlement
COST_OBJKSTRGCHAR12 CKPHCost Object
PROFIT_SEGM_NORKEOBJNRNUMC10 Profitability Segment Number (CO-PA)
PROFIT_CTRPRCTRCHAR10 CEPCProfit CenterALPHA
WBS_ELEMPS_POSIDCHAR24 Work Breakdown Structure Element (WBS Element)ABPSN
NETWORKNPLNRCHAR12 AUFKNetwork Number for Account AssignmentALPHA
ACTIVITYVORNRCHAR4 Operation/Activity NumberNUMCV
PART_ACCTJV_PARTCHAR10 KNA1Partner account numberALPHA
AMOUNT_LCBAPI_EXBWRDEC23(4) Externally entered posting amount in local currency
AMOUNT_SVBAPI_EXVKWDEC23(4) Externally entered sales value in local currency
CURRENCYWAERSCUKY5 TCURCCurrency Key
CURRENCY_ISOISOCDCHAR3 ISO currency code
REF_DOC_YRLFBJANUMC4 Fiscal Year of a Reference DocumentGJAHR
REF_DOCLFBNRCHAR10 Document No. of a Reference DocumentALPHA
REF_DOC_ITLFPOSNUMC4 Item of a Reference Document
EXPIRYDATEVFDATDATS8 Shelf Life Expiration or Best-Before Date
PROD_DATEHSDATDATS8 Date of Manufacture
FUNDBP_GEBERCHAR10 FMFINCODEFund
FUNDS_CTRFISTLCHAR16 FMFCTRFunds Center
CMMT_ITEMFIPOSCHAR14 FMFPOCommitment ItemFMCIS
VAL_SALES_ORDMAT_KDAUFCHAR10 VBUKSales Order Number of Valuated Sales Order StockALPHA
VAL_S_ORD_ITEMMAT_KDPOSNUMC6 Sales Order Item of Valuated Sales Order Stock
VAL_WBS_ELEMPS_POSIDCHAR24 Work Breakdown Structure Element (WBS Element)ABPSN
CO_BUSPROCCO_PRZNRCHAR12
*
Business ProcessALPHA
ACTTYPELSTARCHAR6
*
Activity Type
SUPPL_VENDLLIEFCHAR10
*
Supplying VendorALPHA
X_AUTO_CREMB_XAUTOCHAR1 Item automatically created





MATERIAL_EXTERNALMGV_MATERIAL_EXTERNALCHAR40 Long Material Number for MATERIAL FieldMATNL
MATERIAL_GUIDMGV_MATERIAL_GUIDCHAR32 External GUID for MATERIAL Field
MATERIAL_VERSIONMGV_MATERIAL_VERSIONCHAR10 Version Number for MATERIAL FieldMATNW
MOVE_MAT_EXTERNALMGV_MOVE_MAT_EXTERNALCHAR40 Long Material Number for MOVE_MAT FieldMATNL
MOVE_MAT_GUIDMGV_MOVE_MAT_GUIDCHAR32 External GUID for MOVE_MAT Field
MOVE_MAT_VERSIONMGV_MOVE_MAT_VERSIONCHAR10 Version Number for MOVE_MAT FieldMATNW
GRANT_NBRGM_GRANT_NBRCHAR20 GrantALPHA
CMMT_ITEM_LONGFM_FIPEXCHAR24
*
Commitment ItemFMCIL
FUNC_AREA_LONGFKBERCHAR16
*
Functional Area
ORIGINCITYOIC_OCITYCCHAR4
*
Origin city code
ORIGINCOUNTYOIC_OCOUNCCHAR3
*
Origin county code
ORIGINREGIONOIC_OREGIOCHAR3
*
Origin region
ORIGINCOUNTRYISOINTCACHAR2 Country ISO code
DESTINATIONCITYOIC_DCITYCCHAR4
*
Destination city code
DESTINATIONCOUNTYOIC_DCOUNCCHAR3
*
Destination county code
DESTINATIONREGIONOIC_DREGIOCHAR3
*
Destination region
DESTINATIONCOUTRYISOINTCACHAR2 Country ISO code
TAXORIGINOIC_PORGINCHAR15 Tax origin
TAXDESTINATIONOIC_PDESTNCHAR15 Tax destination
PIPELINETRIPNUMBEROIC_PTRIPCHAR16 Pipeline trip number (external)
PIPELINEBATCHNUMBEROIC_PBATCHCHAR16 Pipeline operatorĀ“s external batch number
MODEOFTRANSPORTOIC_MOTCHAR2
*
IS-OIL MAP external details mode of transport
ALTERNATEORIGINOIC_AORGINCHAR15 Alternate origin
ALTERNATEDESTINATIONOIC_ADESTNCHAR15 Alternate destination
TRUCKNUMBEROIC_TRUCKNCHAR10 Truck number
VENDOR_NOLIFNRCHAR10
*
Account Number of Vendor or CreditorALPHA
EXTERNALLICENSEOIH_CERTF1CHAR15 Excise tax external license number
VALIDFROMOIH_DATFM1DATS8 Excise Duty License Valid from Date
VALIDTOOIH_DATTO1DATS8 Valid to date for excise duty tax certificate
LICENSETYPEOIH_LICTPCHAR4
*
License type
INTERNALLICENSEOIH_LICINCHAR10
*
Excise tax internal license numberALPHA
FOLLOWONLICENSEOIH_LCFOLCHAR10
*
Follow-on license for quantity licenseALPHA
FOLLOWONQUANTITYOIH_FOLQTYQUAN13(3) Excise Tax Follow-On License Quantity
EXTERNALBILLOFLADINGOID_EXTBOLCHAR16 External bill of lading
MISCDELIVERYNUMBEROID_MISCDLCHAR16 Miscellaneous delivery number
HANDLING_TYPEOIH_HANTYPCHAR2
*
Excise Duty Handling Type
ED_PRICING_EXTERNOIH_INEXCHAR2
*
Code for internal or external excise duty rate determination
INTTRACKINGNUMBEROIH_TRKNRCHAR10 Tracking numberALPHA
TRACKINGNUMBERYEAROIH_TRKJRNUMC4 Tracking number year


EXTTRACKINGNUMBEROIH_EXTNRCHAR18 External tracking number
TRACKINGITEMOIH_ITMNRNUMC5 Tracking number item line
FINALTRANSFERINDOIH_FTINDCHAR1 Final transfer indicator
ISSUINGVALUATIONTYPEOIH_UMBARCHAR10
*
Valuation type of issuing location for two-step transfer



Key field
Non-key field