1. Home
  2. Resources
  3. SAP Tables
  4. SAPI_MD_ITEM - Step API: Item Data For Material Document

SAP Table SAPI_MD_ITEM

Step API: Item Data For Material Document

SAPI_MD_ITEM (Step API: Item Data For Material Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SAPI_MD_ITEM to other SAP tables.

Source: SAPI_MD_ITEM (Step API: Item Data For Material Document)

SAPI_MD_ITEM table fields

Field Data element Checktable Datatype Length Decimals
DOC_KEY Document Key WB2_DOC_KEY CHAR 42 0
ITEM_KEY Item Key WB2_ITEM_KEY CHAR 16 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
MKPF WB2_MKPF STRU 0 0
MANDT Client MANDT CLNT 3 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
VGART Transaction/Event Type VGART CHAR 2 0
BLART Document Type BLART CHAR 2 0
BLAUM Document type of revaluation document BLAUM CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
AEDAT Changed On AEDAT DATS 8 0
USNAM User name USNAM CHAR 12 0
TCODE Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BKTXT Document Header Text BKTXT CHAR 25 0
FRATH Unplanned delivery costs FRATH CURR 13 2
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
WEVER Version for Printing GR/GI Slip WEVER CHAR 1 0
1 Individual Slip
2 Individual Slip with Inspection Text
3 Collective Slip
XABLN Goods Receipt/Issue Slip Number XABLN CHAR 10 0
AWSYS Logical System LOGSYSTEM CHAR 10 0
BLA2D Doc. type for additional doc. in purchase account management BLA2D CHAR 2 0
TCODE2 Transaction Code TCODE CHAR 20 0
BFWMS Control posting for external WMS BFWMS CHAR 1 0
2 Execute stock change in ERP
1 Create delivery and transmit to WM
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
SPE_BUDAT_UHR Time of Goods Issue (Local, Relating to a Plant) WAUHR TIMS 6 0
SPE_BUDAT_ZONE Time Zone TZNZONE CHAR 6 0
LE_VBELN Delivery VBELN_VL CHAR 10 0
SPE_LOGSYS Logical System of EWM Material Document /SPE/_LOGSYS_MD CHAR 10 0
SPE_MDNUM_EWM Number of Material Document in EWM /SPE/MDNUM_EWM CHAR 16 0
GTS_CUSREF_NO Customs Reference Number for Scrapping /SAPSLL/SCREF_SPI CHAR 35 0
FLS_RSTO Store Return with Inbound and Outbound Delivery FLS_RSTO CHAR 1 0
X Yes
NULL No
MSR_ACTIVE Advanced Returns Management Active MSR_ACTIVE CHAR 1 0
X Adv. Returns Is Active
NULL Adv. Returns Is Not Active
KNUMV Number of the document condition KNUMV CHAR 10 0
LFSNR Number of External Delivery Note LFSNR1 CHAR 16 0
OIB_BLTIME Posting time in the document OIB_BLTIME TIMS 6 0
SCENARIO_GT Business Scenario WB2_BUSINESS_SCENARIO CHAR 2 0
FILTERED_OUT_GT Filtered Out WB2_FILTERED_OUT CHAR 1 0
EXTERNAL_NO_GT Trading Contract: External Document Number TKONN_EX CHAR 30 0
GUID_GT GUID in 'CHAR' format with upper-/lowercase (!) GUID_22 CHAR 22 0
T001_WAERS_GT Currency Key WAERS CUKY 5 0
MSEG WB2_MSEG STRU 0 0
MANDT Client MANDT CLNT 3 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6 0
PARENT_ID Identifier of immediately superior line MB_PARENT_ID NUMC 6 0
LINE_DEPTH Hierarchy level of line in document MB_LINE_DEPTH NUMC 2 0
MAA_URZEI Original Line for Account Assignment Item in Material Doc. MAA_URZEI NUMC 4 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
XAUTO Item automatically created MB_XAUTO CHAR 1 0
NULL No automatically created item
X General automatically created item
S Component of a structured material
U Component of a structured material in stock transfer
L Standard tied 'empties' material
M Tied 'empties' in transfer (stocks on a material basis)
W Tied 'empties' in transfer (stocks on a value basis)
F Tied 'empties' (full product managed on a value basis)
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
INSMK Stock Type MB_INSMK CHAR 1 0
X Quality inspection
S Blocked
2 Quality inspection
3 Blocked
NULL Unrestricted-use
F Unrestricted-use
ZUSCH Batch status key DZUSCH CHAR 1 0
ZUSTD Batch in Restricted-Use Stock DZUSTD CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
KUNNR Account Number of Customer EKUNN CHAR 10 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PLPLA Distribution of Differences PLPLA CHAR 10 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS CUKY 5 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
BNBTR Delivery costs in local currency BNBTR CURR 13 2
BUALT Amount posted in alternative price control BUALT CURR 13 2
SHKUM Debit/credit indicator in revaluation SHKUM CHAR 1 0
H Credit
S Debit
DMBUM Revaluation amount on back-posting to a previous period DMBUM CURR 13 2
BWTAR Valuation Type BWTAR_D CHAR 10 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BBPRM UNIT 3 0
EBELN Purchase Order Number BSTNR CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
LFBJA Fiscal Year of a Reference Document LFBJA NUMC 4 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
SJAHR Material Document Year MJAHR NUMC 4 0
SMBLN Number of Material Document MBLNR CHAR 10 0
SMBLP Item in Material Document MBLPO NUMC 4 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
SGTXT Item Text SGTXT CHAR 50 0
EQUNR Equipment Number EQUNR CHAR 18 0
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
GSBER Business Area GSBER CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
PARBU Clearing company code PARBU CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR CHAR 12 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
XSKST Indicator: Statistical posting to cost center XSKST CHAR 1 0
X Yes
NULL No
XSAUF Indicator: Posting to order is statistical XSAUF CHAR 1 0
X Yes
NULL No
XSPRO Indicator: Posting to project is statistical XSPRO CHAR 1 0
X Yes
NULL No
XSERG Indicator: Posting to prof.analysis is statistical XSERG CHAR 1 0
X Yes
NULL No
GJAHR Fiscal Year GJAHR NUMC 4 0
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BELUM Accounting Document Number BELNR_D CHAR 10 0
BUZUM Number of Line Item Within Accounting Document BUZEI NUMC 3 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
KZEAR Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
PBAMG Quantity MENGE_D QUAN 13 3
KZSTR Transaction/event is relevant to statistics KZSTR CHAR 1 0
NULL Not relevant
2 Document evaluations and standard analyses (update)
3 Standard analyses only (update)
UMMAT Receiving/Issuing Material UMMAT CHAR 18 0
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 0
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 0
UMZST Status of Transfer Batch UMZST CHAR 1 0
UMZUS Status key of transfer batch UMZUS CHAR 1 0
UMBAR Valuation Type of Transfer Batch UMBAR CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KZZUG Receipt Indicator KZZUG CHAR 1 0
NULL Normal receipt
X Stock transport order
L Tied empties
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
PALAN WMS Number of pallets PALAN DEC 11 0
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LGTYP Storage Type LGTYP CHAR 3 0
LGPLA Storage Bin LGPLA CHAR 10 0
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
BWLVS Movement Type for Warehouse Management BWLVS NUMC 3 0
TBNUM Transfer Requirement Number TBNUM NUMC 10 0
TBPOS Transfer Requirement Item TBPOS NUMC 4 0
XBLVS Indicator: posting in warehouse management system XBLVS CHAR 1 0
X Yes
NULL No
VSCHN Ind: interim storage posting for source stor.type and bin T333_VSCHN CHAR 1 0
X Yes
NULL No
NSCHN Ind.: interim storage posting for dest.stor.type and bin T333_NSCHN CHAR 1 0
X Yes
NULL No
DYPLA Indicator: dynamic storage bin DYPLA CHAR 1 0
X Yes
NULL No
UBNUM Posting Change Number UBNUM NUMC 10 0
TBPRI Transfer Priority TBPRI CHAR 1 0
TANUM Transfer Order Number TANUM NUMC 10 0
WEANZ Number of GR/GI Slips to Be Printed WEANZ NUMC 3 0
GRUND Reason for Movement MB_GRBEW NUMC 4 0
EVERS Shipping Instructions EVERS CHAR 2 0
EVERE Compliance with Shipping Instructions EVERE CHAR 2 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KSTRG Cost Object KSTRG CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
VPTNR Partner account number JV_PART CHAR 10 0
FIPOS Commitment Item FIPOS CHAR 14 0
SAKTO G/L Account Number SAKNR CHAR 10 0
BSTMG Goods receipt quantity in order unit MB_BSTMG QUAN 13 3
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
XWSBR Reversal of GR allowed for GR-based IV despite invoice XWSBR CHAR 1 0
X Yes
NULL No
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
EXBWR Externally Entered Posting Amount in Local Currency EXBWR CURR 13 2
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
AKTNR Promotion WAKTION CHAR 10 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13 2
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
RSART Record type RSART CHAR 1 0
GEBER Fund BP_GEBER CHAR 10 0
FISTL Funds Center FISTL CHAR 16 0
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
UMMAB Receiving/Issuing Material UMMAT CHAR 18 0
BUSTM Posting string for quantities BUSTM CHAR 4 0
BUSTW Posting string for values BUSTW CHAR 4 0
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
LBKUM Total valuated stock before the posting LBKUM_MSEG QUAN 13 3
SALK3 Value of total valuated stock before the posting SALK3_MSEG CURR 13 2
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
FKBER Functional Area FKBER CHAR 16 0
DABRBZ Reference Date for Settlement DABRBEZ DATS 8 0
VKWRA Value at sales prices excluding value-added tax VKWRA CURR 13 2
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
XBEAU Purchase order created at time of goods receipt XBEAU CHAR 1 0
X Yes
NULL No
LSMNG Quantity in Unit of Measure from Delivery Note LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
QINSPST Status of Goods Receipt Inspection QINSPST CHAR 1 0
1 Inspection active (insp. lot created)
2 QM system certified in QINF (no insp. lot)
3 QM system certified for the vendor/manuf. (no insp. lot)
4 Indicator 'No inspection' active in QINF (no insp. lot)
5 Source insp. instead of GR insp. active in QINF (NoInspLot)
6 Insp. lot already created from previous document
7 Inspection lot is created at inbound delivery
8 Inspection Lot for External Inspection Can Be Created
URZEI Original line in material document URZEI NUMC 4 0
J_1BEXBASE Alternate base amount in document currency J_1BEXBASE CURR 13 2
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
J_1AGIRUPD Goods issue revaluation performed J_1AGIRUPD CHAR 1 0
0 Goods issue revaluation not relevant
1 Goods issue revaluation relevant, but not yet performed
2 Goods issue revaluation relevant and already performed
VKMWS Tax on sales/purchases code MWSKZ CHAR 2 0
HSDAT Date of Manufacture HSDAT DATS 8 0
BERKZ Material Staging Indicator for Production Supply BERKZ CHAR 1 0
0 Not relevant for WM
1 Pick list item
2 Crate part
3 Rel.ord.part
4 Manual staging
MAT_KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 0
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 0
XWOFF Calculation of val. open XWOFF CHAR 1 0
X Yes
NULL No
BEMOT Accounting Indicator BEMOT CHAR 2 0
PRZNR Business Process CO_PRZNR CHAR 12 0
LLIEF Supplying Vendor LLIEF CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1 0
X Yes
NULL No
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
ZUSTD_T156M Stock Type Modification (Read from Table T156M) BAMOK_MSEG CHAR 1 0
0 Restricted-Use Stock
1 Unrestricted-Use Stock
2 Stock in Quality Inspection
3 Blocked Stock
L Tied Empties
M Stock Transfer of 'Empties', on Mat. Basis After Val. Basis
W Stock Transfer of 'Empties', on Val. Basis After Mat. Basis
F Unrestricted-Use Stock (T156M-ZUSTD Read with ' ')
SPE_GTS_STOCK_TY GTS Stock Type /SPE/GTS_STOCK_TYPE CHAR 1 0
NULL Normal Stock
1 Temporary Storage Relevant
2 Scrapping Relevant
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
XMACC Multiple Account Assignment XMACC CHAR 1 0
VGART_MKPF Transaction/Event Type VGART CHAR 2 0
BUDAT_MKPF Posting Date in the Document BUDAT DATS 8 0
CPUDT_MKPF Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM_MKPF Time of Entry CPUTM TIMS 6 0
USNAM_MKPF User name USNAM CHAR 12 0
XBLNR_MKPF Reference Document Number XBLNR CHAR 16 0
TCODE2_MKPF Transaction Code TCODE CHAR 20 0
VBELN_IM Delivery VBELN_VL CHAR 10 0
VBELP_IM Delivery Item POSNR_VL NUMC 6 0
/BEV2/ED_KZ_VER Processing Status of Material Document for Excise Duties /BEV2/EDKZ_VER CHAR 1 0
NULL Not Yet Processed
0 Not Tax-Relevant
1 Partially Processed
2 Tax-Relevant
/BEV2/ED_USER User name USNAM CHAR 12 0
/BEV2/ED_AEDAT Changed On AEDAT DATS 8 0
/BEV2/ED_AETIM System Time SYUZEIT TIMS 6 0
/CWM/MENGE Quantity in Parallel Unit of Measure /CWM/MENGE QUAN 13 3
/CWM/MEINS Parallel Unit of Measure /CWM/MEINS UNIT 3 0
/CWM/ERFMG Quantity in Parallel Unit of Entry /CWM/ERFMG QUAN 13 3
/CWM/ERFME PUoM Entry Unit of Measure /CWM/ERFME UNIT 3 0
/CWM/BUSTW Posting string for values BUSTW CHAR 4 0
/CWM/SMBLU Original line in material document URZEI NUMC 4 0
/CWM/FI Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 0
/CWM/TY2TQ Type of Parallel Unit of Measure /CWM/TY2TQ CHAR 1 0
A Parallel Unit of Measure and Valuation Unit of Measure
B Parallel Unit of Measure (BUoM is Valuation Unit of Measure)
C Alternative Parallel Unit of Measure
/CWM/UMTY2TQ Type of Parallel Unit of Measure /CWM/TY2TQ CHAR 1 0
A Parallel Unit of Measure and Valuation Unit of Measure
B Parallel Unit of Measure (BUoM is Valuation Unit of Measure)
C Alternative Parallel Unit of Measure
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
OINAVNW Non-deductible input tax NAVNW CURR 13 2
OICONDCOD Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 0
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 0
OIKNUMV Number of the document condition KNUMV CHAR 10 0
OIEXGPTR Exchange partner (vendor number) OIA_EXGPTR CHAR 10 0
OIMATPST Posting rules for material OIA_MATPST CHAR 1 0
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
OIMATIE Material internal / external posting indicator OIA_MATIE CHAR 1 0
NULL Externally-posted material
X Internally-posted material
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIFEEPST Posting rules for fees OIA_FEEPST CHAR 1 0
1 External
2 Internal
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIJ1BNFFIM Control Flag for Nota Fiscal creation (Gain/Loss) OIH_J1B_NFFI CHAR 1 0
X Yes
NULL No
OITRKNR Tracking number OIH_TRKNR CHAR 10 0
OITRKJR Tracking number year OIH_TRKJR NUMC 4 0
OIEXTNR External tracking number OIH_EXTNR CHAR 18 0
OIITMNR Tracking number item line OIH_ITMNR NUMC 5 0
OIFTIND Final transfer indicator OIH_FTIND CHAR 1 0
X Final transfer indicator
OIPRIOP Price options for gain calculation OIH_PRIOP CHAR 1 0
1 G/L calculation based on the sending plant (from GI)
2 G/L calculation based on the receiving plant (current)
3 G/L calculation based on the sending plant (at time of GR)
4 G/L calculation based on condition record
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1 0
NULL SAP standard procedure
1 SAP standard procedure with tracking records for statistics
2 IS-OIL plant to plant transfers with tracking records
OIGHNDL Gain handling OIH_GHNDL CHAR 1 0
NULL Post transit gain only on final transfer
1 Post transit gain when GR > in-transit quantity
OIUMBAR Valuation type of issuing location for two-step transfer OIH_UMBAR CHAR 10 0
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OIBASVAL Base product value OIA_BASVAL CURR 13 2
OIGLERF Quantity in Unit of Entry ERFMG QUAN 13 3
OIGLSKU Quantity MENGE_D QUAN 13 3
OIGLBPR Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
OIGLBST Goods receipt quantity in order unit MB_BSTMG QUAN 13 3
OIGLCALC Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
OIBBSWQTY Additional Oil and Gas Quantity OIB_ADQNT FLTP 16 16
OIASTBW Reversal movement type XSTBW CHAR 1 0
X Yes
NULL No
OIVBELN Delivery VBELN_VL CHAR 10 0
OIPOSNR Delivery Item POSNR_VL NUMC 6 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 CHAR 3 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operator´s external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT CHAR 2 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIDATFM1 Excise Duty License Valid from Date OIH_DATFM1 DATS 8 0
OIDATTO1 Valid to date for excise duty tax certificate OIH_DATTO1 DATS 8 0
OIH_LICTP License type OIH_LICTP CHAR 4 0
OIH_LICIN Excise tax internal license number OIH_LICIN CHAR 10 0
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL CHAR 10 0
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIBOMHEAD BoM header material number OIA_BOMHM CHAR 18 0
OIB_TIMESTAMP Tank dip time stamp OIB_TMSTM NUMC 14 0
OIB_GUID_OPEN GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
OIB_GUID_CLOSE GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
OIB_SOCNR SOC: Storage object characteristic segment number OII_SOCNR CHAR 20 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIINVREC Indicator whether ED pricing is external (not used?) OIH_INVREC CHAR 1 0
X Yes
NULL No
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT UNIT 3 0
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13 3
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13 3
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OITAXGRP2 Excise Duty Group OIH_TAXGRP CHAR 2 0
OIEDBAL_GI Excise Duty Balancing is Required for Mat. (STO) OIH_EDBAL_GI CHAR 1 0
X Yes
NULL No
OIEDBALM_GI Excise Duty Balancing Method Indicator for Mat. (STO) OIH_EDBALM_GI CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
OICERTF1_GI Excise Tax External License Number Used During GI (STO) OIH_CERTF1_GI CHAR 15 0
OIDATFM1_GI Excise Duty License Valid from Date for Mat. (STO) OIH_DATFM1_GI DATS 8 0
OIDATTO1_GI Valid To Date for Excise Duty Tax Certificate for Mat. (STO) OIH_DATTO1_GI DATS 8 0
OIH_LICTP_GI License Type to Material (STO) OIH_LICTP_GI CHAR 4 0
OIH_LICIN_GI Excise Tax Internal License Number to Mat. (STO) OIH_LICIN_GI CHAR 10 0
OIH_LCFOL_GI Follow-On License for Quantity License to Mat. (STO) OIH_LCFOL_GI CHAR 10 0
OIH_FOLQTY_GI Excise Tax Follow-On License Quantity to Mat. (STO) OIH_FOLQTY_GI QUAN 13 3
OIHANTYP_GI Excise Duty Handling Type - Denotes Use of Material OIH_HANTYP_GI CHAR 2 0
OIO_VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
OIO_SPROC Supply Process OIO_SPROC CHAR 4 0
SCENARIO_GT Business Scenario WB2_BUSINESS_SCENARIO CHAR 2 0
FILTERED_OUT_GT Filtered Out WB2_FILTERED_OUT CHAR 1 0
NOT_REF_QUAN_GT Open Quantity WB2_NOT_REF_QUAN QUAN 15 3
NOT_REF_QUAN_UNIT_GT Open Quantity Unit WB2_NOT_REF_QUAN_UNIT UNIT 3 0
EXTERNAL_NO_GT Trading Contract: External Document Number TKONN_EX CHAR 30 0
NOT_REF_QUAN_DOC_GT Open Quantity WB2_NOT_REF_QUAN QUAN 15 3
NOT_REF_QUAN_VAR_GT Open Quantity WB2_NOT_REF_QUAN QUAN 15 3
BSEG_MEINS_GT Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_B Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_B Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_S Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_S Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_P Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_P Base Unit of Measure MEINS UNIT 3 0
PORTFOLIO Global Trade: (Internal) Portfolio Number WB2_PORTFOLIO CHAR 10 0
MATERIAL Material Number MATNR MARA CHAR 18 0
PLANT Plant WERKS_D T001W CHAR 4 0
STGE_LOC Storage Location LGORT_D T001L CHAR 4 0
BATCH Batch Number CHARG_D MCHA CHAR 10 0
MOVE_TYPE Movement Type (Inventory Management) BWART T156 CHAR 3 0
STCK_TYPE Stock Type MB_INSMK CHAR 1 0
X Quality inspection
S Blocked
2 Quality inspection
3 Blocked
NULL Unrestricted-use
F Unrestricted-use
SPEC_STOCK Special Stock Indicator SOBKZ T148 CHAR 1 0
VENDOR Vendor Account Number ELIFN LFA1 CHAR 10 0
CUSTOMER Account Number of Customer EKUNN KNA1 CHAR 10 0
SALES_ORD Sales Order Number KDAUF VBUK CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
SCHED_LINE Delivery Schedule for Sales Order KDEIN NUMC 4 0
VAL_TYPE Valuation Type BWTAR_D T149D CHAR 10 0
ENTRY_QNT Quantity in Unit of Entry ERFMG QUAN 13 3
ENTRY_UOM Unit of Entry ERFME T006 UNIT 3 0
ENTRY_UOM_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
PO_PR_QNT Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
ORDERPR_UN Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
ORDERPR_UN_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
PO_NUMBER Purchase Order Number BSTNR EKKO CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP EKPO NUMC 5 0
SHIPPING Shipping Instructions EVERS T027A CHAR 2 0
COMP_SHIP Compliance with Shipping Instructions EVERE T027C CHAR 2 0
NO_MORE_GR "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
ITEM_TEXT Item Text SGTXT CHAR 50 0
GR_RCPT Goods Recipient/Ship-To Party WEMPF CHAR 12 0
UNLOAD_PT Unloading Point ABLAD CHAR 25 0
COSTCENTER Cost Center KOSTL CSKS CHAR 10 0
ORDERID Order Number AUFNR AUFK CHAR 12 0
ORDER_ITNO Order Item Number CO_POSNR NUMC 4 0
CALC_MOTIVE Accounting Indicator BEMOT TBMOT CHAR 2 0
ASSET_NO Main Asset Number ANLN1 ANLH CHAR 12 0
SUB_NUMBER Asset Subnumber ANLN2 ANLA CHAR 4 0
RESERV_NO Number of Reservation/Dependent Requirement RSNUM RESB NUMC 10 0
RES_ITEM Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RES_TYPE Record type RSART CHAR 1 0
WITHDRAWN Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
MOVE_MAT Receiving/Issuing Material UMMAT MARA CHAR 18 0
MOVE_PLANT Receiving/Issuing Plant UMWRK T001W CHAR 4 0
MOVE_STLOC Receiving/Issuing Storage Location UMLGO T001L CHAR 4 0
MOVE_BATCH Receiving/Issuing Batch UMCHA MCHA CHAR 10 0
MOVE_VAL_TYPE Valuation Type of Transfer Batch UMBAR T149D CHAR 10 0
MVT_IND Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
MOVE_REAS Reason for Movement MB_GRBEW T157D NUMC 4 0
RL_EST_KEY Internal Key for Real Estate Object IMKEY CHAR 8 0
REF_DATE Reference Date for Settlement DABRBEZ DATS 8 0
COST_OBJ Cost Object KSTRG CKPH CHAR 12 0
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PROFIT_CTR Profit Center PRCTR CEPC CHAR 10 0
WBS_ELEM Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
NETWORK Network Number for Account Assignment NPLNR AUFK CHAR 12 0
ACTIVITY Operation/Activity Number VORNR CHAR 4 0
PART_ACCT Partner account number JV_PART KNA1 CHAR 10 0
AMOUNT_LC Externally entered posting amount in local currency BAPI_EXBWR DEC 23 4
AMOUNT_SV Externally entered sales value in local currency BAPI_EXVKW DEC 23 4
REF_DOC_YR Fiscal Year of a Reference Document LFBJA NUMC 4 0
REF_DOC Document No. of a Reference Document LFBNR CHAR 10 0
REF_DOC_IT Item of a Reference Document LFPOS NUMC 4 0
EXPIRYDATE Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
PROD_DATE Date of Manufacture HSDAT DATS 8 0
FUND Fund BP_GEBER FMFINCODE CHAR 10 0
FUNDS_CTR Funds Center FISTL FMFCTR CHAR 16 0
CMMT_ITEM Commitment Item FIPOS FMFPO CHAR 14 0
VAL_SALES_ORD Sales Order Number of Valuated Sales Order Stock MAT_KDAUF VBUK CHAR 10 0
VAL_S_ORD_ITEM Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
VAL_WBS_ELEM Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
GL_ACCOUNT G/L Account Number SAKNR SKA1 CHAR 10 0
IND_PROPOSE_QUANX Propose quantities XMEVO CHAR 1 0
X Yes
NULL No
XSTOB Use Reversal Movement Type Indicator XSTOB CHAR 1 0
X Yes
NULL No
EAN_UPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
DELIV_NUMB_TO_SEARCH Delivery VBELN_VL VBUK CHAR 10 0
DELIV_ITEM_TO_SEARCH Delivery Item POSNR_VL VBUP NUMC 6 0
SERIALNO_AUTO_NUMBERASSIGNMENT Create serial number automatically XSAUT CHAR 1 0
X Yes
NULL No
VENDRBATCH Vendor Batch Number LICHN CHAR 15 0
STGE_TYPE Storage Type LGTYP T301 CHAR 3 0
STGE_BIN Storage Bin LGPLA LAGP CHAR 10 0
SU_PL_STCK_1 Number of Storage Units to be Placed Into Storage LVS_ANZLE DEC 3 0
ST_UN_QTYY_1 Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMEN QUAN 13 3
ST_UN_QTYY_1_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
UNITTYPE_1 Storage Unit Type LVS_LETYP T307 CHAR 3 0
SU_PL_STCK_2 Number of Storage Units to be Placed Into Storage LVS_ANZLE DEC 3 0
ST_UN_QTYY_2 Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMEN QUAN 13 3
ST_UN_QTYY_2_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
UNITTYPE_2 Storage Unit Type LVS_LETYP T307 CHAR 3 0
STGE_TYPE_PC Storage type for transfer posting UBTYP T301 CHAR 3 0
STGE_BIN_PC Storage bin for transfer posting UBPLA LAGP CHAR 10 0
NO_PST_CHGNT Indicator: Do not create posting change notice LVS_KZKUB CHAR 1 0
X Yes
NULL No
GR_NUMBER Goods Receipt Number LVS_WENUM CHAR 10 0
STGE_TYPE_ST Storage type for stock transfer UMLGT T301 CHAR 3 0
STGE_BIN_ST Storage bin for stock transfer UMLGP LAGP CHAR 10 0
MATDOC_TR_CANCEL Material doc. no. of transfer requirement to be cancelled LVS_TBBEL CHAR 10 0
MATITEM_TR_CANCEL Material doc. item of transf.reqmnt item to be cancelled LVS_TBBPO NUMC 4 0
MATYEAR_TR_CANCEL Material doc. year of transfer requirement to be cancelled LVS_TBBJR NUMC 4 0
NO_TRANSFER_REQ Indicator: No Transfer Requirement Created LVS_TBFKZ CHAR 1 0
X Yes
NULL No
CO_BUSPROC Business Process CO_PRZNR CHAR 12 0
ACTTYPE Activity Type LSTAR CHAR 6 0
SUPPL_VEND Supplying Vendor LLIEF CHAR 10 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
MOVE_MAT_EXTERNAL Long Material Number for MOVE_MAT Field MGV_MOVE_MAT_EXTERNAL CHAR 40 0
MOVE_MAT_GUID External GUID for MOVE_MAT Field MGV_MOVE_MAT_GUID CHAR 32 0
MOVE_MAT_VERSION Version Number for MOVE_MAT Field MGV_MOVE_MAT_VERSION CHAR 10 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
TR_PART_BA Trading partner's business area PARGB CHAR 4 0
PAR_COMPCO Clearing company code PARBU CHAR 4 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
DELIV_ITEM Delivery Item POSNR_VL NUMC 6 0
NB_SLIPS Number of GR/GI Slips to Be Printed WEANZ NUMC 3 0
NB_SLIPSX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
GR_RCPTX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
UNLOAD_PTX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
SPEC_MVMT Special movement indicator for warehouse management LVS_BSSKZ CHAR 1 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
CMMT_ITEM_LONG Commitment Item FM_FIPEX CHAR 24 0
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6 0
PARENT_ID Identifier of immediately superior line MB_PARENT_ID NUMC 6 0
LINE_DEPTH Hierarchy level of line in document MB_LINE_DEPTH NUMC 2 0
QUANTITY Quantity MENGE_D QUAN 13 3
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
LONGNUM Smart Number /SAPPSPRO/LONGNUM CHAR 40 0
BUDGET_PERIOD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
EARMARKED_NUMBER Document Number for Earmarked Funds KBLNR CHAR 10 0
EARMARKED_ITEM Earmarked Funds: Document Item KBLPOS NUMC 3 0

SAPI_MD_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SAPI_MD_ITEM ASSET_NO SY MANDT ANLH Main asset number MANDT
SAPI_MD_ITEM ASSET_NO * ANLH Main asset number BUKRS
SAPI_MD_ITEM ASSET_NO SAPI_MD_ITEM ASSET_NO ANLH Main asset number ANLN1
SAPI_MD_ITEM BATCH SY MANDT MCHA Batches MANDT
SAPI_MD_ITEM BATCH SAPI_MD_ITEM MATERIAL MCHA Batches MATNR
SAPI_MD_ITEM BATCH SAPI_MD_ITEM PLANT MCHA Batches WERKS
SAPI_MD_ITEM BATCH SAPI_MD_ITEM BATCH MCHA Batches CHARG
SAPI_MD_ITEM CALC_MOTIVE SY MANDT TBMOT Accounting indicators MANDT
SAPI_MD_ITEM CALC_MOTIVE SAPI_MD_ITEM CALC_MOTIVE TBMOT Accounting indicators BEMOT
SAPI_MD_ITEM CMMT_ITEM SY MANDT FMFPO FIFM: Commitment Item MANDT
SAPI_MD_ITEM CMMT_ITEM * FMFPO FIFM: Commitment Item FIKRS
SAPI_MD_ITEM CMMT_ITEM SAPI_MD_ITEM CMMT_ITEM FMFPO FIFM: Commitment Item FIPOS
SAPI_MD_ITEM CMMT_ITEM SAPI_MD_ITEM EXPIRYDATE FMFPO FIFM: Commitment Item DATBIS
SAPI_MD_ITEM COMP_SHIP SY MANDT T027C Codes for Compliance with Shipping Instructions MANDT
SAPI_MD_ITEM COMP_SHIP SAPI_MD_ITEM SHIPPING T027C Codes for Compliance with Shipping Instructions EVERS
SAPI_MD_ITEM COMP_SHIP SAPI_MD_ITEM COMP_SHIP T027C Codes for Compliance with Shipping Instructions EVERE
SAPI_MD_ITEM COSTCENTER SY MANDT CSKS Cost Center Master Data MANDT
SAPI_MD_ITEM COSTCENTER * CSKS Cost Center Master Data KOKRS
SAPI_MD_ITEM COSTCENTER SAPI_MD_ITEM COSTCENTER CSKS Cost Center Master Data KOSTL
SAPI_MD_ITEM COSTCENTER SAPI_MD_ITEM EXPIRYDATE CSKS Cost Center Master Data DATBI
SAPI_MD_ITEM COST_OBJ SY MANDT CKPH Master Record: Cost Object ID Number MANDT
SAPI_MD_ITEM COST_OBJ SAPI_MD_ITEM COST_OBJ CKPH Master Record: Cost Object ID Number KSTRG
SAPI_MD_ITEM COST_OBJ SAPI_MD_ITEM EXPIRYDATE CKPH Master Record: Cost Object ID Number DATBI
SAPI_MD_ITEM CUSTOMER SY MANDT KNA1 General Data in Customer Master MANDT
SAPI_MD_ITEM CUSTOMER SAPI_MD_ITEM CUSTOMER KNA1 General Data in Customer Master KUNNR
SAPI_MD_ITEM DELIV_ITEM_TO_SEARCH SY MANDT VBUP Sales Document: Item Status MANDT
SAPI_MD_ITEM DELIV_ITEM_TO_SEARCH SAPI_MD_ITEM SALES_ORD VBUP Sales Document: Item Status VBELN
SAPI_MD_ITEM DELIV_ITEM_TO_SEARCH SAPI_MD_ITEM DELIV_ITEM_TO_SEARCH VBUP Sales Document: Item Status POSNR
SAPI_MD_ITEM DELIV_NUMB_TO_SEARCH SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
SAPI_MD_ITEM DELIV_NUMB_TO_SEARCH SAPI_MD_ITEM DELIV_NUMB_TO_SEARCH VBUK Sales Document: Header Status and Administrative Data VBELN
SAPI_MD_ITEM ENTRY_UOM SY MANDT T006 Units of Measurement MANDT
SAPI_MD_ITEM ENTRY_UOM SAPI_MD_ITEM ENTRY_UOM T006 Units of Measurement MSEHI
SAPI_MD_ITEM ENTRY_UOM_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
SAPI_MD_ITEM ENTRY_UOM_ISO SAPI_MD_ITEM ENTRY_UOM_ISO T006I ISO codes for units of measurement ISOCODE
SAPI_MD_ITEM FUND SY MANDT FMFINCODE FIFM: Financing code MANDT
SAPI_MD_ITEM FUND * FMFINCODE FIFM: Financing code FIKRS
SAPI_MD_ITEM FUND SAPI_MD_ITEM FUND FMFINCODE FIFM: Financing code FINCODE
SAPI_MD_ITEM FUNDS_CTR SY MANDT FMFCTR Funds Center Master Record MANDT
SAPI_MD_ITEM FUNDS_CTR * FMFCTR Funds Center Master Record FIKRS
SAPI_MD_ITEM FUNDS_CTR SAPI_MD_ITEM FUNDS_CTR FMFCTR Funds Center Master Record FICTR
SAPI_MD_ITEM FUNDS_CTR SAPI_MD_ITEM EXPIRYDATE FMFCTR Funds Center Master Record DATBIS
SAPI_MD_ITEM GL_ACCOUNT SY MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
SAPI_MD_ITEM GL_ACCOUNT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
SAPI_MD_ITEM GL_ACCOUNT SAPI_MD_ITEM GL_ACCOUNT SKA1 G/L Account Master (Chart of Accounts) SAKNR
SAPI_MD_ITEM MATERIAL SY MANDT MARA General Material Data MANDT
SAPI_MD_ITEM MATERIAL SAPI_MD_ITEM MATERIAL MARA General Material Data MATNR
SAPI_MD_ITEM MOVE_BATCH SY MANDT MCHA Batches MANDT
SAPI_MD_ITEM MOVE_BATCH SAPI_MD_ITEM MATERIAL MCHA Batches MATNR
SAPI_MD_ITEM MOVE_BATCH SAPI_MD_ITEM PLANT MCHA Batches WERKS
SAPI_MD_ITEM MOVE_BATCH SAPI_MD_ITEM MOVE_BATCH MCHA Batches CHARG
SAPI_MD_ITEM MOVE_MAT SY MANDT MARA General Material Data MANDT
SAPI_MD_ITEM MOVE_MAT SAPI_MD_ITEM MOVE_MAT MARA General Material Data MATNR
SAPI_MD_ITEM MOVE_PLANT SY MANDT T001W Plants/Branches MANDT
SAPI_MD_ITEM MOVE_PLANT SAPI_MD_ITEM MOVE_PLANT T001W Plants/Branches WERKS
SAPI_MD_ITEM MOVE_REAS SY MANDT T157D Reason for Movement MANDT
SAPI_MD_ITEM MOVE_REAS SAPI_MD_ITEM MOVE_TYPE T157D Reason for Movement BWART
SAPI_MD_ITEM MOVE_REAS SAPI_MD_ITEM MOVE_REAS T157D Reason for Movement GRUND
SAPI_MD_ITEM MOVE_STLOC SY MANDT T001L Storage Locations MANDT
SAPI_MD_ITEM MOVE_STLOC SAPI_MD_ITEM PLANT T001L Storage Locations WERKS
SAPI_MD_ITEM MOVE_STLOC SAPI_MD_ITEM MOVE_STLOC T001L Storage Locations LGORT
SAPI_MD_ITEM MOVE_TYPE SY MANDT T156 Movement Type MANDT
SAPI_MD_ITEM MOVE_TYPE SAPI_MD_ITEM MOVE_TYPE T156 Movement Type BWART
SAPI_MD_ITEM MOVE_VAL_TYPE SY MANDT T149D Global Valuation Types MANDT
SAPI_MD_ITEM MOVE_VAL_TYPE SAPI_MD_ITEM MOVE_VAL_TYPE T149D Global Valuation Types BWTAR
SAPI_MD_ITEM NETWORK SY MANDT AUFK Order master data MANDT
SAPI_MD_ITEM NETWORK SAPI_MD_ITEM NETWORK AUFK Order master data AUFNR
SAPI_MD_ITEM ORDERID SY MANDT AUFK Order master data MANDT
SAPI_MD_ITEM ORDERID SAPI_MD_ITEM ORDERID AUFK Order master data AUFNR
SAPI_MD_ITEM ORDERPR_UN SY MANDT T006 Units of Measurement MANDT
SAPI_MD_ITEM ORDERPR_UN SAPI_MD_ITEM ORDERPR_UN T006 Units of Measurement MSEHI
SAPI_MD_ITEM ORDERPR_UN_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
SAPI_MD_ITEM ORDERPR_UN_ISO SAPI_MD_ITEM ORDERPR_UN_ISO T006I ISO codes for units of measurement ISOCODE
SAPI_MD_ITEM PART_ACCT SY MANDT KNA1 General Data in Customer Master MANDT
SAPI_MD_ITEM PART_ACCT SAPI_MD_ITEM PART_ACCT KNA1 General Data in Customer Master KUNNR
SAPI_MD_ITEM PLANT SY MANDT T001W Plants/Branches MANDT
SAPI_MD_ITEM PLANT SAPI_MD_ITEM PLANT T001W Plants/Branches WERKS
SAPI_MD_ITEM PO_ITEM SY MANDT EKPO Purchasing Document Item MANDT
SAPI_MD_ITEM PO_ITEM SAPI_MD_ITEM PO_NUMBER EKPO Purchasing Document Item EBELN
SAPI_MD_ITEM PO_ITEM SAPI_MD_ITEM PO_ITEM EKPO Purchasing Document Item EBELP
SAPI_MD_ITEM PO_NUMBER SY MANDT EKKO Purchasing Document Header MANDT
SAPI_MD_ITEM PO_NUMBER SAPI_MD_ITEM PO_NUMBER EKKO Purchasing Document Header EBELN
SAPI_MD_ITEM PROFIT_CTR SY MANDT CEPC Profit Center Master Data Table MANDT
SAPI_MD_ITEM PROFIT_CTR SAPI_MD_ITEM PROFIT_CTR CEPC Profit Center Master Data Table PRCTR
SAPI_MD_ITEM PROFIT_CTR SAPI_MD_ITEM EXPIRYDATE CEPC Profit Center Master Data Table DATBI
SAPI_MD_ITEM PROFIT_CTR * CEPC Profit Center Master Data Table KOKRS
SAPI_MD_ITEM RESERV_NO SY MANDT RESB Reservation/dependent requirements MANDT
SAPI_MD_ITEM RESERV_NO SAPI_MD_ITEM RESERV_NO RESB Reservation/dependent requirements RSNUM
SAPI_MD_ITEM RESERV_NO SAPI_MD_ITEM RES_ITEM RESB Reservation/dependent requirements RSPOS
SAPI_MD_ITEM RESERV_NO SAPI_MD_ITEM RES_TYPE RESB Reservation/dependent requirements RSART
SAPI_MD_ITEM SALES_ORD SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
SAPI_MD_ITEM SALES_ORD SAPI_MD_ITEM SALES_ORD VBUK Sales Document: Header Status and Administrative Data VBELN
SAPI_MD_ITEM SHIPPING SY MANDT T027A Shipping Instructions, Purchasing MANDT
SAPI_MD_ITEM SHIPPING SAPI_MD_ITEM SHIPPING T027A Shipping Instructions, Purchasing EVERS
SAPI_MD_ITEM SPEC_STOCK SY MANDT T148 Special Stock Indicator MANDT
SAPI_MD_ITEM SPEC_STOCK SAPI_MD_ITEM SPEC_STOCK T148 Special Stock Indicator SOBKZ
SAPI_MD_ITEM STGE_BIN SY MANDT LAGP Storage bins MANDT
SAPI_MD_ITEM STGE_BIN * LAGP Storage bins LGNUM
SAPI_MD_ITEM STGE_BIN SAPI_MD_ITEM STGE_TYPE LAGP Storage bins LGTYP
SAPI_MD_ITEM STGE_BIN SAPI_MD_ITEM STGE_BIN LAGP Storage bins LGPLA
SAPI_MD_ITEM STGE_BIN_PC SY MANDT LAGP Storage bins MANDT
SAPI_MD_ITEM STGE_BIN_PC * LAGP Storage bins LGNUM
SAPI_MD_ITEM STGE_BIN_PC SAPI_MD_ITEM STGE_TYPE LAGP Storage bins LGTYP
SAPI_MD_ITEM STGE_BIN_PC SAPI_MD_ITEM STGE_BIN_PC LAGP Storage bins LGPLA
SAPI_MD_ITEM STGE_BIN_ST SY MANDT LAGP Storage bins MANDT
SAPI_MD_ITEM STGE_BIN_ST * LAGP Storage bins LGNUM
SAPI_MD_ITEM STGE_BIN_ST SAPI_MD_ITEM STGE_TYPE LAGP Storage bins LGTYP
SAPI_MD_ITEM STGE_BIN_ST SAPI_MD_ITEM STGE_BIN_ST LAGP Storage bins LGPLA
SAPI_MD_ITEM STGE_LOC SY MANDT T001L Storage Locations MANDT
SAPI_MD_ITEM STGE_LOC SAPI_MD_ITEM PLANT T001L Storage Locations WERKS
SAPI_MD_ITEM STGE_LOC SAPI_MD_ITEM STGE_LOC T001L Storage Locations LGORT
SAPI_MD_ITEM STGE_TYPE SY MANDT T301 WM Storage Types MANDT
SAPI_MD_ITEM STGE_TYPE * T301 WM Storage Types LGNUM
SAPI_MD_ITEM STGE_TYPE SAPI_MD_ITEM STGE_TYPE T301 WM Storage Types LGTYP
SAPI_MD_ITEM STGE_TYPE_PC SY MANDT T301 WM Storage Types MANDT
SAPI_MD_ITEM STGE_TYPE_PC * T301 WM Storage Types LGNUM
SAPI_MD_ITEM STGE_TYPE_PC SAPI_MD_ITEM STGE_TYPE_PC T301 WM Storage Types LGTYP
SAPI_MD_ITEM STGE_TYPE_ST SY MANDT T301 WM Storage Types MANDT
SAPI_MD_ITEM STGE_TYPE_ST * T301 WM Storage Types LGNUM
SAPI_MD_ITEM STGE_TYPE_ST SAPI_MD_ITEM STGE_TYPE_ST T301 WM Storage Types LGTYP
SAPI_MD_ITEM ST_UN_QTYY_1_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
SAPI_MD_ITEM ST_UN_QTYY_1_ISO SAPI_MD_ITEM ST_UN_QTYY_1_ISO T006I ISO codes for units of measurement ISOCODE
SAPI_MD_ITEM ST_UN_QTYY_2_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
SAPI_MD_ITEM ST_UN_QTYY_2_ISO SAPI_MD_ITEM ST_UN_QTYY_2_ISO T006I ISO codes for units of measurement ISOCODE
SAPI_MD_ITEM SUB_NUMBER SY MANDT ANLA Asset Master Record Segment MANDT
SAPI_MD_ITEM SUB_NUMBER * ANLA Asset Master Record Segment BUKRS
SAPI_MD_ITEM SUB_NUMBER SAPI_MD_ITEM ASSET_NO ANLA Asset Master Record Segment ANLN1
SAPI_MD_ITEM SUB_NUMBER SAPI_MD_ITEM SUB_NUMBER ANLA Asset Master Record Segment ANLN2
SAPI_MD_ITEM UNITTYPE_1 SY MANDT T307 Storage Unit Types MANDT
SAPI_MD_ITEM UNITTYPE_1 * T307 Storage Unit Types LGNUM
SAPI_MD_ITEM UNITTYPE_1 SAPI_MD_ITEM UNITTYPE_1 T307 Storage Unit Types LETYP
SAPI_MD_ITEM UNITTYPE_2 SY MANDT T307 Storage Unit Types MANDT
SAPI_MD_ITEM UNITTYPE_2 * T307 Storage Unit Types LGNUM
SAPI_MD_ITEM UNITTYPE_2 SAPI_MD_ITEM UNITTYPE_2 T307 Storage Unit Types LETYP
SAPI_MD_ITEM VAL_SALES_ORD SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
SAPI_MD_ITEM VAL_SALES_ORD SAPI_MD_ITEM VAL_SALES_ORD VBUK Sales Document: Header Status and Administrative Data VBELN
SAPI_MD_ITEM VAL_TYPE SY MANDT T149D Global Valuation Types MANDT
SAPI_MD_ITEM VAL_TYPE SAPI_MD_ITEM VAL_TYPE T149D Global Valuation Types BWTAR
SAPI_MD_ITEM VENDOR SY MANDT LFA1 Vendor Master (General Section) MANDT
SAPI_MD_ITEM VENDOR SAPI_MD_ITEM VENDOR LFA1 Vendor Master (General Section) LIFNR