SAPI_MD_ITEM SAP (Step API: Item Data For Material Document) Structure details

Dictionary Type: Structure
Description: Step API: Item Data For Material Document




ABAP Code to SELECT data from SAPI_MD_ITEM
Related tables to SAPI_MD_ITEM
Access table SAPI_MD_ITEM




Structure field list including key, data, relationships and ABAP select examples

SAPI_MD_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Step API: Item Data For Material Document" 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_SAPI_MD_ITEM TYPE SAPI_MD_ITEM.

The SAPI_MD_ITEM table consists of various fields, each holding specific information or linking keys about Step API: Item Data For Material Document data available in SAP. These include ITEM_KEY (Item Key), MBLNR (Number of Material Document), MJAHR (Material Document Year), ZEILE (Item in Material Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SAPI_MD_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DOC_KEYDocument Key WB2_DOC_KEYCHAR42
ITEM_KEYItem Key WB2_ITEM_KEYCHAR16
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
MKPF 0
MANDTClient MANDTCLNT3MANDT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
VGARTTransaction/Event Type VGARTCHAR2VGART
BLARTDocument Type BLARTCHAR2BLARTBAR
BLAUMDocument type of revaluation document BLAUMCHAR2BLART
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AEDATChanged On AEDATDATS8DATUM
USNAMUser name USNAMCHAR12XUBNAMEUSR
TCODENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BKTXTDocument Header Text BKTXTCHAR25TEXT25
FRATHUnplanned delivery costs FRATHCURR13(2) WERT7
FRBNRNumber of Bill of Lading at Time of Goods Receipt FRBNR1CHAR16XBLNR1
WEVERVersion for Printing GR/GI Slip WEVERCHAR1WEVERWEV
XABLNGoods Receipt/Issue Slip Number XABLNCHAR10ALPHABELNR
AWSYSLogical System LOGSYSTEMCHAR10ALPHALOGSYS
BLA2DDoc. type for additional doc. in purchase account management BLA2DCHAR2BLART
TCODE2Transaction Code TCODECHAR20TCODETCD
BFWMSControl posting for external WMS BFWMSCHAR1BFWMS
EXNUMNumber of foreign trade data in MM and SD documents EXNUMCHAR10EXNUM
SPE_BUDAT_UHRTime of Goods Issue (Local, Relating to a Plant) WAUHRTIMS6TIME_PLANT
SPE_BUDAT_ZONETime Zone TZNZONECHAR6TZNZONE
LE_VBELNDelivery VBELN_VLCHAR10ALPHAVBELNVL
SPE_LOGSYSLogical System of EWM Material Document /SPE/_LOGSYS_MDCHAR10ALPHALOGSYS
SPE_MDNUM_EWMNumber of Material Document in EWM /SPE/MDNUM_EWMCHAR16/SPE/MDNUM_EWM
GTS_CUSREF_NOCustoms Reference Number for Scrapping /SAPSLL/SCREF_SPICHAR35CHAR35
FLS_RSTOStore Return with Inbound and Outbound Delivery FLS_RSTOCHAR1XFELD
MSR_ACTIVEAdvanced Returns Management Active MSR_ACTIVECHAR1MSR_ACTIVE
.INCLU--AP 0
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
.INCLU--AP 0
XCOMPLMaterial document can only be canceled in full MILL_CANCEL_COMPLETECHAR1CHAR1
.INCLU--AP 0
LFSNRNumber of External Delivery Note LFSNR1CHAR16XBLNR1
OIB_BLTIMEPosting time in the document OIB_BLTIMETIMS6TIMES
.INCLU-_GT 0
SCENARIO_GTBusiness Scenario WB2_BUSINESS_SCENARIOCHAR2WB2_BUSINESS_SCENARIO
FILTERED_OUT_GTFiltered Out WB2_FILTERED_OUTCHAR1WB2_FILTERED_OUT
EXTERNAL_NO_GTTrading Contract: External Document Number TKONN_EXCHAR30TKONN_EXWKN_EX
GUID_GTGUID in 'CHAR' format with upper-/lowercase (!) GUID_22CHAR22SYSUUID_22
T001_WAERS_GTCurrency Key WAERSCUKY5WAERSFWS
MSEG 0
MANDTClient MANDTCLNT3MANDT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
LINE_IDUnique identification of document line MB_LINE_IDNUMC6MB_LINE_ID
PARENT_IDIdentifier of immediately superior line MB_PARENT_IDNUMC6MB_LINE_ID
LINE_DEPTHHierarchy level of line in document MB_LINE_DEPTHNUMC2MB_LINE_DEPTH
MAA_URZEIOriginal Line for Account Assignment Item in Material Doc. MAA_URZEINUMC4MBLPOPOS
BWARTMovement Type (Inventory Management) BWARTCHAR3BWARTBWA
XAUTOItem automatically created MB_XAUTOCHAR1MB_XAUTO
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
CHARGBatch Number CHARG_DCHAR10CHARGCHA
INSMKStock Type MB_INSMKCHAR1MB_INSMK
ZUSCHBatch status key DZUSCHCHAR1ZUSCH
ZUSTDBatch in Restricted-Use Stock DZUSTDCHAR1XFELD
SOBKZSpecial Stock Indicator SOBKZCHAR1SOBKZ
LIFNRVendor Account Number ELIFNCHAR10ALPHALIFNRLIFKRED_C
KUNNRAccount Number of Customer EKUNNCHAR10ALPHAKUNNRKUN
KDAUFSales Order Number KDAUFCHAR10ALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
PLPLADistribution of Differences PLPLACHAR10PLPLA
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
WAERSCurrency Key WAERSCUKY5WAERSFWS
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
BNBTRDelivery costs in local currency BNBTRCURR13(2) WERT13N
BUALTAmount posted in alternative price control BUALTCURR13(2) WERTV7
SHKUMDebit/credit indicator in revaluation SHKUMCHAR1SHKZG
DMBUMRevaluation amount on back-posting to a previous period DMBUMCURR13(2) WERT7
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3CUNITMEINS
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
BPRMEOrder Price Unit (Purchasing) BBPRMUNIT3CUNITMEINS
EBELNPurchase Order Number BSTNRCHAR10ALPHAEBELNBES
EBELPItem Number of Purchasing Document EBELPNUMC5EBELPBSP
LFBJAFiscal Year of a Reference Document LFBJANUMC4GJAHRGJAHR
LFBNRDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
LFPOSItem of a Reference Document LFPOSNUMC4MBLPO
SJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
SMBLNNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
SMBLPItem in Material Document MBLPONUMC4MBLPOPOS
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
SGTXTItem Text SGTXTCHAR50TEXT50
EQUNREquipment Number EQUNRCHAR18ALPHAEQUNREQNEQUI
WEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
ABLADUnloading Point ABLADCHAR25TEXT25
GSBERBusiness Area GSBERCHAR4GSBERGSB
KOKRSControlling Area KOKRSCHAR4CACCDCAC
PARGBTrading partner's business area PARGBCHAR4GSBERGSB
PARBUClearing company code PARBUCHAR4BUKRS
KOSTLCost Center KOSTLCHAR10ALPHAKOSTLKOS
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
AUFNROrder Number AUFNRCHAR12ALPHAAUFNRANR
ANLN1Main Asset Number ANLN1CHAR12ALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ALPHAANLN2AN2
XSKSTIndicator: Statistical posting to cost center XSKSTCHAR1XFELD
XSAUFIndicator: Posting to order is statistical XSAUFCHAR1XFELD
XSPROIndicator: Posting to project is statistical XSPROCHAR1XFELD
XSERGIndicator: Posting to prof.analysis is statistical XSERGCHAR1XFELD
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
XRUEMAllow Posting to Previous Period (Backposting) XRUEMCHAR1XFELD
XRUEJIndicator: post to previous year XRUEJCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BELUMAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZUMNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
PBAMGQuantity MENGE_DQUAN13(3) MENG13
KZSTRTransaction/event is relevant to statistics KZSTRCHAR1KZSTR
UMMATReceiving/Issuing Material UMMATCHAR18MATN1MATNR
UMWRKReceiving/Issuing Plant UMWRKCHAR4WERKS
UMLGOReceiving/Issuing Storage Location UMLGOCHAR4LGORT
UMCHAReceiving/Issuing Batch UMCHACHAR10CHARG
UMZSTStatus of Transfer Batch UMZSTCHAR1ZUSTD
UMZUSStatus key of transfer batch UMZUSCHAR1ZUSCH
UMBARValuation Type of Transfer Batch UMBARCHAR10BWTAR
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1SOBKZ
KZBEWMovement Indicator KZBEWCHAR1KZBEW
KZVBRConsumption Posting KZVBRCHAR1KZVBR
KZZUGReceipt Indicator KZZUGCHAR1KZZUG
WEUNBGoods Receipt, Non-Valuated WEUNBCHAR1XFELD
PALANWMS Number of pallets PALANDEC11PALAN
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3LGNUMLGN
LGTYPStorage Type LGTYPCHAR3LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LGPLALGPLAG1
BESTQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
BWLVSMovement Type for Warehouse Management BWLVSNUMC3BWLVSBWL
TBNUMTransfer Requirement Number TBNUMNUMC10TBNUMTBN
TBPOSTransfer Requirement Item TBPOSNUMC4TBPOSTBP
XBLVSIndicator: posting in warehouse management system XBLVSCHAR1XFELD
VSCHNInd: interim storage posting for source stor.type and bin T333_VSCHNCHAR1XFELD
NSCHNInd.: interim storage posting for dest.stor.type and bin T333_NSCHNCHAR1XFELD
DYPLAIndicator: dynamic storage bin DYPLACHAR1XFELD
UBNUMPosting Change Number UBNUMNUMC10UBNUMUBN
TBPRITransfer Priority TBPRICHAR1TBPRI
TANUMTransfer Order Number TANUMNUMC10TANUMTAN
WEANZNumber of GR/GI Slips to Be Printed WEANZNUMC3NUM3
GRUNDReason for Movement MB_GRBEWNUMC4MB_GRBEW
EVERSShipping Instructions EVERSCHAR2EVERS
EVERECompliance with Shipping Instructions EVERECHAR2EVERE
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KSTRGCost Object KSTRGCHAR12KSTRGKTR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8KONPRPS_POSNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12ALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPSOrder Item Number CO_POSNRNUMC4CO_POSNR
VPTNRPartner account number JV_PARTCHAR10ALPHAKUNNR
FIPOSCommitment Item FIPOSCHAR14FIPOSFIP
SAKTOG/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
BSTMGGoods receipt quantity in order unit MB_BSTMGQUAN13(3) MENG13
BSTMEPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
XWSBRReversal of GR allowed for GR-based IV despite invoice XWSBRCHAR1XFELD
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10ALPHALIFNR
EXBWRExternally Entered Posting Amount in Local Currency EXBWRCURR13(2) WERT7
VKWRTValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
AKTNRCOUPON WAKTIONCHAR10ALPHAWAKTIONWAK
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
VFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
EXVKWExternally Entered Sales Value in Local Currency EXVKWCURR13(2) WERT7
PPRCTRPartner Profit Center PPRCTRCHAR10ALPHAPRCTRPPC
RSARTRecord type RSARTCHAR1RSART
GEBERFund BP_GEBERCHAR10BP_GEBERFIC
FISTLFunds Center FISTLCHAR16FISTLFIS
MATBFMaterial in Respect of Which Stock is Managed MATBFCHAR18MATN1MATNR
UMMABReceiving/Issuing Material UMMATCHAR18MATN1MATNR
BUSTMPosting string for quantities BUSTMCHAR4BUSTM
BUSTWPosting string for values BUSTWCHAR4BUSTW
MENGUQuantity Updating in Material Master Record MENGUCHAR1XFELD
WERTUValue Update in Material Master Record WERTUCHAR1XFELD
LBKUMTotal valuated stock before the posting LBKUM_MSEGQUAN13(3) MENGV13
SALK3Value of total valuated stock before the posting SALK3_MSEGCURR13(2) WERT13N
VPRSVPrice control indicator VPRSVCHAR1VPRSV
FKBERFunctional Area FKBERCHAR16FKBERFBE
DABRBZReference Date for Settlement DABRBEZDATS8DDAT
VKWRAValue at sales prices excluding value-added tax VKWRACURR13(2) WERT7
DABRZReference Date for Settlement DABRBEZDATS8DDAT
XBEAUPurchase order created at time of goods receipt XBEAUCHAR1XFELD
LSMNGQuantity in Unit of Measure from Delivery Note LSMNGQUAN13(3) MENG13
LSMEHUnit of Measure From Delivery Note LSMEHUNIT3CUNITMEINS
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
QINSPSTStatus of Goods Receipt Inspection QINSPSTCHAR1QINSPST
URZEIOriginal line in material document URZEINUMC4MBLPOPOS
J_1BEXBASEAlternate base amount in document currency J_1BEXBASECURR13(2) WERT7
MWSKZTax on sales/purchases code MWSKZCHAR2MWSKZ
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18MATN1MATNRHTN
J_1AGIRUPDGoods issue revaluation performed J_1AGIRUPDCHAR1J_1AGIRUPD
VKMWSTax on sales/purchases code MWSKZCHAR2MWSKZ
HSDATDate of Manufacture HSDATDATS8DATUM
BERKZMaterial Staging Indicator for Production Supply BERKZCHAR1LVS_BERKZ
MAT_KDAUFSales Order Number of Valuated Sales Order Stock MAT_KDAUFCHAR10ALPHAVBELNAUN
MAT_KDPOSSales Order Item of Valuated Sales Order Stock MAT_KDPOSNUMC6NUM06KPO
MAT_PSPNRValuated Sales Order Stock WBS Element MAT_PSPNRNUMC8KONPRPS_POSNR
XWOFFCalculation of val. open XWOFFCHAR1XFELD
BEMOTAccounting Indicator BEMOTCHAR2BEMOT
PRZNRBusiness Process CO_PRZNRCHAR12ALPHACO_PRZNRKWP
LLIEFSupplying Vendor LLIEFCHAR10ALPHALIFNRLLI
LSTARActivity Type LSTARCHAR6LSTARLARLART_EMPTY
XOBEWVendor Stock Valuation Indicator XOBEWCHAR1XFELD
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
ZUSTD_T156MStock Type Modification (Read from Table T156M) BAMOK_MSEGCHAR1BAMOK_MSEG
SPE_GTS_STOCK_TYGTS Stock Type /SPE/GTS_STOCK_TYPECHAR1/SPE/GTS_STOCK_TYPE
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10ALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3KBLPOSKBP
XMACCMultiple Account Assignment XMACCCHAR1CHAR1
VGART_MKPFTransaction/Event Type VGARTCHAR2VGART
BUDAT_MKPFPosting Date in the Document BUDATDATS8DATUM
CPUDT_MKPFDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTM_MKPFTime of Entry CPUTMTIMS6UZEIT
USNAM_MKPFUser name USNAMCHAR12XUBNAMEUSR
XBLNR_MKPFReference Document Number XBLNRCHAR16XBLNR
TCODE2_MKPFTransaction Code TCODECHAR20TCODETCD
VBELN_IMDelivery VBELN_VLCHAR10ALPHAVBELNVL
VBELP_IMDelivery Item POSNR_VLNUMC6POSNR
.INCLU--AP 0
/BEV2/ED_KZ_VERProcessing Status of Material Document for Excise Duties /BEV2/EDKZ_VERCHAR1/BEV2/EDKZ_VER
/BEV2/ED_USERUser name USNAMCHAR12XUBNAMEUSR
/BEV2/ED_AEDATChanged On AEDATDATS8DATUM
/BEV2/ED_AETIMSystem Time SYUZEITTIMS6SYTIME
.INCLU--AP 0
DISUB_OWNEROwner of stock OWNER_DCHAR10ALPHALIFNR
.INCLU--AP 0
COMPL_MARKCompleted indicator COMPL_MARKCHAR1XFELD
.INCLU--AP 0
FZGLS_MARKDo Not Adjust Cumulative Received Quantity FZGLSCHAR1XFELD
ETANP_MARKAdjust Open Quantity in Scheduling Agreement Item ETANPCHAR1XFELD
POPUP_MARKDisplay Dialog Box POPUPCHAR1KENZX
.INCLU--AP 0
OINAVNWNon-deductible input tax NAVNWCURR13(2) WERT7
OICONDCODJoint Venture Indicator (Condition Key) JV_CONDCODCHAR2ALPHAJV_CONDCOD
CONDIJoint Venture Indicator (Condition Key) JV_CONDCODCHAR2ALPHAJV_CONDCOD
.INCLU--AP 0
OIKNUMVNumber of the document condition KNUMVCHAR10KNUMV
OIEXGPTRExchange partner (vendor number) OIA_EXGPTRCHAR10ALPHALIFNRLIFKREDO
OIMATPSTPosting rules for material OIA_MATPSTCHAR1OIA_MATPST
OIMATIEMaterial internal / external posting indicator OIA_MATIECHAR1ALPHAOIA_MATIE
OIEXGTYPExchange type OIA_EXGTYPCHAR4OIA_EXGTYPOI3
OIFEETOTFee total OIA_FEETOTCURR13(2) OIA_FEETOT
OIFEEPSTPosting rules for fees OIA_FEEPSTCHAR1OIA_FEEPST
OIFEEDTFee pricing condition date OIA_FEEDTDATS8DATUM
OIMATREFMaterial group reference for exchange balance reporting OIA_MATREFCHAR20ALPHAOIA_MATREF
OIEXGNUMExchange agreement number OIA_EXGNUMCHAR10ALPHAOIA_EXGNUMOI1OIAE
OINETCYCNetting cycle (FI blocking indicator) OIA_NETCYCCHAR1ZAHLSNTG
OIJ1BNFFIMControl Flag for Nota Fiscal creation (Gain/Loss) OIH_J1B_NFFICHAR1XFELD
OITRKNRTracking number OIH_TRKNRCHAR10ALPHAOIH_TRKNROIH_TRKNR
OITRKJRTracking number year OIH_TRKJRNUMC4NUMC4OIH_TRKJR
OIEXTNRExternal tracking number OIH_EXTNRCHAR18OIH_EXTNR
OIITMNRTracking number item line OIH_ITMNRNUMC5OIH_ITMNR
OIFTINDFinal transfer indicator OIH_FTINDCHAR1OIH_FTIND
OIPRIOPPrice options for gain calculation OIH_PRIOPCHAR1OIH_PRIOP
OITRINDTransfer sign for plant-to-plant transfers OIH_TRINDCHAR1OIH_TRIND
OIGHNDLGain handling OIH_GHNDLCHAR1OIH_GHNDL
OIUMBARValuation type of issuing location for two-step transfer OIH_UMBARCHAR10BWTAR
OISBRELSub product/ base product relevence indicator OIA_SBRELNUMC3OIA_SBREL
OIBASPRODBase product number OIA_SBMATCHAR18MATN1MATNR
OIBASVALBase product value OIA_BASVALCURR13(2) WERT7
OIGLERFQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
OIGLSKUQuantity MENGE_DQUAN13(3) MENG13
OIGLBPRQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
OIGLBSTGoods receipt quantity in order unit MB_BSTMGQUAN13(3) MENG13
OIGLCALCDebit/Credit Indicator SHKZGCHAR1SHKZG
OIBBSWQTYAdditional Oil and Gas Quantity OIB_ADQNTFLTP16(16) OIB_ADQNT
OIASTBWReversal movement type XSTBWCHAR1XFELD
OIVBELNDelivery VBELN_VLCHAR10ALPHAVBELNVL
OIPOSNRDelivery Item POSNR_VLNUMC6POSNR
OIPIPEVALValidation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEVCHAR1X
OIC_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
OIC_DCITYCDestination city code OIC_DCITYCCHAR4CITYC
OIC_DCOUNCDestination county code OIC_DCOUNCCHAR3COUNC
OIC_DREGIODestination region OIC_DREGIOCHAR3REGIO
OIC_DLAND1Destination country OIC_DLAND1CHAR3LAND1
OIC_OCITYCOrigin city code OIC_OCITYCCHAR4CITYC
OIC_OCOUNCOrigin county code OIC_OCOUNCCHAR3COUNC
OIC_OREGIOOrigin region OIC_OREGIOCHAR3REGIO
OIC_OLAND1Origin country OIC_OLAND1CHAR3LAND1
OIC_PORGINTax origin OIC_PORGINCHAR15OIC_PORGIN
OIC_PDESTNTax destination OIC_PDESTNCHAR15OIC_PDESTN
OIC_PTRIPPipeline trip number (external) OIC_PTRIPCHAR16OIC_PTRIP
OIC_PBATCHPipeline operator´s external batch number OIC_PBATCHCHAR16OIC_PBATCH
OIC_MOTIS-OIL MAP external details mode of transport OIC_MOTCHAR2VKTRA
OIC_AORGINAlternate origin OIC_AORGINCHAR15OIC_PORGIN
OIC_ADESTNAlternate destination OIC_ADESTNCHAR15OIC_PDESTN
OIC_TRUCKNTruck number OIC_TRUCKNCHAR10OIC_TRUCKN
OIA_BASELOBase location OIA_BASELOCHAR15OIA_BASELO
OICERTF1Excise tax external license number OIH_CERTF1CHAR15OIH_CERTF1
OIDATFM1Excise Duty License Valid from Date OIH_DATFM1DATS8DATUM
OIDATTO1Valid to date for excise duty tax certificate OIH_DATTO1DATS8DATUM
OIH_LICTPLicense type OIH_LICTPCHAR4OIH_LICTPOII
OIH_LICINExcise tax internal license number OIH_LICINCHAR10ALPHAOIH_LICINOIHOIHL
OIH_LCFOLFollow-on license for quantity license OIH_LCFOLCHAR10ALPHAOIH_LICIN
OIH_FOLQTYExcise Tax Follow-On License Quantity OIH_FOLQTYQUAN13(3) MENG13
OID_EXTBOLExternal bill of lading OID_EXTBOLCHAR16OID_EXTBOL
OID_MISCDLMiscellaneous delivery number OID_MISCDLCHAR16OID_MISCDL
OIBOMHEADBoM header material number OIA_BOMHMCHAR18MATN1MATNR
OIB_TIMESTAMPTank dip time stamp OIB_TMSTMNUMC14OII_TIMEST
OIB_GUID_OPENGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
OIB_GUID_CLOSEGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
OIB_SOCNRSOC: Storage object characteristic segment number OII_SOCNRCHAR20OII_SOCNR
OITAXFROMExcise duty tax key for 'from' location OIH_TAXFROCHAR2OIH_TAXKEY
OITAXTOExcise duty tax key for 'to' location OIH_TAXTOCHAR2OIH_TAXKEY
OIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2OIH_HANTYP
OITAXGRPExcise Duty Group OIH_TAXGRPCHAR2OIH_TAXGRP
OIPRICIEED pricing: external (indicator) OIH_PRICIECHAR1X
OIINVRECIndicator whether ED pricing is external (not used?) OIH_INVRECCHAR1X
OIOILCONOil content in a material as a percentage OIH_OILCONDEC5(2) OIH_OILCON
OIOILCON2Oil content of a material as a percentage (2) OIH_OILCN2DEC5(2) OIH_OILCON
OIFUTDTFuture tax date OIH_FUTDTDATS8DATUM
OIFUTDT2Future tax date 2 OIH_FUTDT2DATS8DATUM
OIUOMQTBase quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQTUNIT3CUNITMEINS
OITAXQTExcise duty tax quantity in STBME OIH_TAXQTQUAN13(3) MENGE
OIFUTQTFuture tax quantity OIH_FUTQTQUAN13(3) MENGE
OIFUTQT2Future tax quantity 2 OIH_FUTQT2QUAN13(3) MENGE
OITAXGRP2Excise Duty Group OIH_TAXGRPCHAR2OIH_TAXGRP
OIEDBAL_GIExcise Duty Balancing is Required for Mat. (STO) OIH_EDBAL_GICHAR1X
OIEDBALM_GIExcise Duty Balancing Method Indicator for Mat. (STO) OIH_EDBALM_GICHAR1OIH_EDBALM
OICERTF1_GIExcise Tax External License Number Used During GI (STO) OIH_CERTF1_GICHAR15OIH_CERTF1
OIDATFM1_GIExcise Duty License Valid from Date for Mat. (STO) OIH_DATFM1_GIDATS8DATUM
OIDATTO1_GIValid To Date for Excise Duty Tax Certificate for Mat. (STO) OIH_DATTO1_GIDATS8DATUM
OIH_LICTP_GILicense Type to Material (STO) OIH_LICTP_GICHAR4OIH_LICTPOII
OIH_LICIN_GIExcise Tax Internal License Number to Mat. (STO) OIH_LICIN_GICHAR10ALPHAOIH_LICINOIHOIHL
OIH_LCFOL_GIFollow-On License for Quantity License to Mat. (STO) OIH_LCFOL_GICHAR10ALPHAOIH_LICIN
OIH_FOLQTY_GIExcise Tax Follow-On License Quantity to Mat. (STO) OIH_FOLQTY_GIQUAN13(3) MENG13
OIHANTYP_GIExcise Duty Handling Type - Denotes Use of Material OIH_HANTYP_GICHAR2OIH_HANTYP
.INCLU-_GT 0
SCENARIO_GTBusiness Scenario WB2_BUSINESS_SCENARIOCHAR2WB2_BUSINESS_SCENARIO
FILTERED_OUT_GTFiltered Out WB2_FILTERED_OUTCHAR1WB2_FILTERED_OUT
NOT_REF_QUAN_GTOpen Quantity WB2_NOT_REF_QUANQUAN15(3) MENG15
NOT_REF_QUAN_UNIT_GTOpen Quantity Unit WB2_NOT_REF_QUAN_UNITUNIT3CUNITMEINS
EXTERNAL_NO_GTTrading Contract: External Document Number TKONN_EXCHAR30TKONN_EXWKN_EX
NOT_REF_QUAN_DOC_GTOpen Quantity WB2_NOT_REF_QUANQUAN15(3) MENG15
NOT_REF_QUAN_VAR_GTOpen Quantity WB2_NOT_REF_QUANQUAN15(3) MENG15
BSEG_MEINS_GTBase Unit of Measure MEINSUNIT3CUNITMEINS
ASSOC_QUAN_BAssoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUANQUAN15(3) MENGV15
UNIT_OF_QUAN_BBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
ASSOC_QUAN_SAssoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUANQUAN15(3) MENGV15
UNIT_OF_QUAN_SBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
ASSOC_QUAN_PAssoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUANQUAN15(3) MENGV15
UNIT_OF_QUAN_PBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
PORTFOLIOGlobal Trade: (Internal) Portfolio Number WB2_PORTFOLIOCHAR10KNUMB
MATERIALMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PLANTPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
STGE_LOCStorage Location LGORT_DCHAR4T001LLGORTLAG
BATCHBatch Number CHARG_DCHAR10MCHACHARGCHA
MOVE_TYPEMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
STCK_TYPEStock Type MB_INSMKCHAR1MB_INSMK
SPEC_STOCKSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
VENDORVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
CUSTOMERAccount Number of Customer EKUNNCHAR10KNA1ALPHAKUNNRKUN
SALES_ORDSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
S_ORD_ITEMItem Number in Sales Order KDPOSNUMC6NUM06KPO
SCHED_LINEDelivery Schedule for Sales Order KDEINNUMC4NUM04
VAL_TYPEValuation Type BWTAR_DCHAR10T149DBWTARBWT
ENTRY_QNTQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ENTRY_UOMUnit of Entry ERFMEUNIT3T006CUNITMEINS
ENTRY_UOM_ISOISO code for unit of measurement ISOCD_UNITCHAR3T006IISOCD_UNIT
PO_PR_QNTQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
ORDERPR_UNOrder Price Unit (Purchasing) BBPRMUNIT3T006CUNITMEINS
ORDERPR_UN_ISOISO code for unit of measurement ISOCD_UNITCHAR3T006IISOCD_UNIT
PO_NUMBERPurchase Order Number BSTNRCHAR10EKKOALPHAEBELNBES
PO_ITEMItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
SHIPPINGShipping Instructions EVERSCHAR2T027AEVERS
COMP_SHIPCompliance with Shipping Instructions EVERECHAR2T027CEVERE
NO_MORE_GR'Delivery Completed' Indicator ELIKZCHAR1XFELD
ITEM_TEXTItem Text SGTXTCHAR50TEXT50
GR_RCPTGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
UNLOAD_PTUnloading Point ABLADCHAR25TEXT25
COSTCENTERCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
ORDERIDOrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
ORDER_ITNOOrder Item Number CO_POSNRNUMC4CO_POSNR
CALC_MOTIVEAccounting Indicator BEMOTCHAR2TBMOTBEMOT
ASSET_NOMain Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
SUB_NUMBERAsset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
RESERV_NONumber of Reservation/Dependent Requirement RSNUMNUMC10RESBRSNUMRES
RES_ITEMItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RES_TYPERecord type RSARTCHAR1RSART
WITHDRAWNFinal Issue for This Reservation KZEARCHAR1XFELD
MOVE_MATReceiving/Issuing Material UMMATCHAR18MARAMATN1MATNR
MOVE_PLANTReceiving/Issuing Plant UMWRKCHAR4T001WWERKS
MOVE_STLOCReceiving/Issuing Storage Location UMLGOCHAR4T001LLGORT
MOVE_BATCHReceiving/Issuing Batch UMCHACHAR10MCHACHARG
MOVE_VAL_TYPEValuation Type of Transfer Batch UMBARCHAR10T149DBWTAR
MVT_INDMovement Indicator KZBEWCHAR1KZBEW
MOVE_REASReason for Movement MB_GRBEWNUMC4T157DMB_GRBEW
RL_EST_KEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
REF_DATEReference Date for Settlement DABRBEZDATS8DDAT
COST_OBJCost Object KSTRGCHAR12CKPHKSTRGKTR
PROFIT_SEGM_NOProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PROFIT_CTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
WBS_ELEMWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
NETWORKNetwork Number for Account Assignment NPLNRCHAR12AUFKALPHAAUFNRNET
ACTIVITYOperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
PART_ACCTPartner account number JV_PARTCHAR10KNA1ALPHAKUNNR
AMOUNT_LCExternally entered posting amount in local currency BAPI_EXBWRDEC23(4) BAPICURR
AMOUNT_SVExternally entered sales value in local currency BAPI_EXVKWDEC23(4) BAPICURR
REF_DOC_YRFiscal Year of a Reference Document LFBJANUMC4GJAHRGJAHR
REF_DOCDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
REF_DOC_ITItem of a Reference Document LFPOSNUMC4MBLPO
EXPIRYDATEShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
PROD_DATEDate of Manufacture HSDATDATS8DATUM
FUNDFund BP_GEBERCHAR10FMFINCODEBP_GEBERFIC
FUNDS_CTRFunds Center FISTLCHAR16FMFCTRFISTLFIS
CMMT_ITEMCommitment Item FIPOSCHAR14FMFPOFIPOSFIP
VAL_SALES_ORDSales Order Number of Valuated Sales Order Stock MAT_KDAUFCHAR10VBUKALPHAVBELNAUN
VAL_S_ORD_ITEMSales Order Item of Valuated Sales Order Stock MAT_KDPOSNUMC6NUM06KPO
VAL_WBS_ELEMWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
GL_ACCOUNTG/L Account Number SAKNRCHAR10SKA1ALPHASAKNRSAKC_SAKNR
IND_PROPOSE_QUANXPropose quantities XMEVOCHAR1XFELD
XSTOBUse Reversal Movement Type Indicator XSTOBCHAR1XFELD
EAN_UPCInternational Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
DELIV_NUMB_TO_SEARCHDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
DELIV_ITEM_TO_SEARCHDelivery Item POSNR_VLNUMC6VBUPPOSNR
SERIALNO_AUTO_NUMBERASSIGNMENTCreate serial number automatically XSAUTCHAR1XFELD
VENDRBATCHVendor Batch Number LICHNCHAR15LICHN
STGE_TYPEStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
STGE_BINStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
SU_PL_STCK_1Number of Storage Units to be Placed Into Storage LVS_ANZLEDEC3LVS_ANZLE
ST_UN_QTYY_1Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMENQUAN13(3) MENG13
ST_UN_QTYY_1_ISOISO code for unit of measurement ISOCD_UNITCHAR3T006IISOCD_UNIT
UNITTYPE_1Storage Unit Type LVS_LETYPCHAR3T307LVS_LETYP
SU_PL_STCK_2Number of Storage Units to be Placed Into Storage LVS_ANZLEDEC3LVS_ANZLE
ST_UN_QTYY_2Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMENQUAN13(3) MENG13
ST_UN_QTYY_2_ISOISO code for unit of measurement ISOCD_UNITCHAR3T006IISOCD_UNIT
UNITTYPE_2Storage Unit Type LVS_LETYPCHAR3T307LVS_LETYP
STGE_TYPE_PCStorage type for transfer posting UBTYPCHAR3T301LGTYPLGT
STGE_BIN_PCStorage bin for transfer posting UBPLACHAR10LAGPLGPLALGP
NO_PST_CHGNTIndicator: Do not create posting change notice LVS_KZKUBCHAR1XFELD
GR_NUMBERGoods Receipt Number LVS_WENUMCHAR10ALPHABELNR
STGE_TYPE_STStorage type for stock transfer UMLGTCHAR3T301LGTYPLGT
STGE_BIN_STStorage bin for stock transfer UMLGPCHAR10LAGPLGPLALGP
MATDOC_TR_CANCELMaterial doc. no. of transfer requirement to be cancelled LVS_TBBELCHAR10ALPHABELNRMBN
MATITEM_TR_CANCELMaterial doc. item of transf.reqmnt item to be cancelled LVS_TBBPONUMC4MBLPOPOS
MATYEAR_TR_CANCELMaterial doc. year of transfer requirement to be cancelled LVS_TBBJRNUMC4GJAHRGJAHRMJA
NO_TRANSFER_REQIndicator: No Transfer Requirement Created LVS_TBFKZCHAR1XFELD
CO_BUSPROCBusiness Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
ACTTYPEActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
SUPPL_VENDSupplying Vendor LLIEFCHAR10Assigned to domainALPHALIFNRLLI
MATERIAL_EXTERNALLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MATERIAL_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MATERIAL_VERSIONVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
MOVE_MAT_EXTERNALLong Material Number for MOVE_MAT Field MGV_MOVE_MAT_EXTERNALCHAR40MATNR_EXT
MOVE_MAT_GUIDExternal GUID for MOVE_MAT Field MGV_MOVE_MAT_GUIDCHAR32MATNR_EGUID
MOVE_MAT_VERSIONVersion Number for MOVE_MAT Field MGV_MOVE_MAT_VERSIONCHAR10MATNWMATNR_VERS
FUNC_AREAFunctional Area FKBER_SHORTCHAR4FKBER_SHORTFBE
TR_PART_BATrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
PAR_COMPCOClearing company code PARBUCHAR4Assigned to domainBUKRS
DELIV_NUMBDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
DELIV_ITEMDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
NB_SLIPSNumber of GR/GI Slips to Be Printed WEANZNUMC3NUM3
NB_SLIPSXUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GR_RCPTXUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UNLOAD_PTXUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SPEC_MVMTSpecial movement indicator for warehouse management LVS_BSSKZCHAR1Assigned to domainLVS_BSSKZ
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
CMMT_ITEM_LONGCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FUNC_AREA_LONGFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
LINE_IDUnique identification of document line MB_LINE_IDNUMC6MB_LINE_ID
PARENT_IDIdentifier of immediately superior line MB_PARENT_IDNUMC6MB_LINE_ID
LINE_DEPTHHierarchy level of line in document MB_LINE_DEPTHNUMC2MB_LINE_DEPTH
QUANTITYQuantity MENGE_DQUAN13(3) MENG13
BASE_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
LONGNUMSmart Number /SAPPSPRO/LONGNUMCHAR40/SAPPSPRO/LONGNUM/SAPPSPRO/LONG_BES/SAPPSPRO/MEKK
BUDGET_PERIODFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
EARMARKED_NUMBERDocument Number for Earmarked Funds KBLNRCHAR10Assigned to domainALPHAKBLNRKBL
EARMARKED_ITEMEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP

Key field Non-key field



How do I retrieve data from SAP structure SAPI_MD_ITEM using ABAP code?

As SAPI_MD_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SAPI_MD_ITEM as there is no data to select.

How to access SAP table SAPI_MD_ITEM

Within an ECC or HANA version of SAP you can also view further information about SAPI_MD_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!