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

Field Description Data Type Length Decimals Checktable Data Element
DOC_KEY Document Key CHAR 42 0 WB2_DOC_KEY
ITEM_KEY Item Key CHAR 16 0 WB2_ITEM_KEY
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
MKPF STRU 0 0 WB2_MKPF
MANDT Client CLNT 3 0 MANDT
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
VGART Transaction/Event Type CHAR 2 0 VGART
BLART Document Type CHAR 2 0 BLART
BLAUM Document type of revaluation document CHAR 2 0 BLAUM
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
AEDAT Last Changed On DATS 8 0 AEDAT
USNAM User Name CHAR 12 0 USNAM
TCODE Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BKTXT Document Header Text CHAR 25 0 BKTXT
FRATH Unplanned delivery costs CURR 13 2 FRATH
FRBNR Number of Bill of Lading at Time of Goods Receipt CHAR 16 0 FRBNR1
WEVER Version for Printing GR/GI Slip CHAR 1 0 WEVER
1 Individual Slip
2 Individual Slip with Inspection Text
3 Collective Slip
XABLN Goods Receipt/Issue Slip Number CHAR 10 0 XABLN
AWSYS Logical System CHAR 10 0 LOGSYSTEM
BLA2D Doc. type for additional doc. in purchase account management CHAR 2 0 BLA2D
TCODE2 Transaction Code CHAR 20 0 TCODE
BFWMS Control posting for external WMS CHAR 1 0 BFWMS
1 Create delivery and transmit to WM
2 Execute stock change in ERP
3 Post goods movement synchronously to EWM
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
SPE_BUDAT_UHR Time of Goods Issue (Local, Relating to a Plant) TIMS 6 0 WAUHR
SPE_BUDAT_ZONE Time Zone CHAR 6 0 TZNZONE
LE_VBELN Delivery CHAR 10 0 VBELN_VL
SPE_LOGSYS Logical System of EWM Material Document CHAR 10 0 /SPE/_LOGSYS_MD
SPE_MDNUM_EWM Number of Material Document in EWM CHAR 16 0 /SPE/MDNUM_EWM
GTS_CUSREF_NO Customs Reference Number for Scrapping CHAR 35 0 /SAPSLL/SCREF_SPI
FLS_RSTO Store Return with Inbound and Outbound Delivery CHAR 1 0 FLS_RSTO
MSR_ACTIVE Advanced Returns Management Active CHAR 1 0 MSR_ACTIVE
Adv. Returns Is Not Active
X Adv. Returns Is Active
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
XCOMPL Material document can only be canceled in full CHAR 1 0 MILL_CANCEL_COMPLETE
SCENARIO_GT Business Scenario CHAR 2 0 WB2_BUSINESS_SCENARIO
FILTERED_OUT_GT Filtered Out CHAR 1 0 WB2_FILTERED_OUT
EXTERNAL_NO_GT External Identifier in Trading Contract CHAR 30 0 TKONN_EX
GUID_GT GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 GUID_22
T001_WAERS_GT Currency Key CUKY 5 0 WAERS
MSEG STRU 0 0 WB2_MSEG
MANDT Client CLNT 3 0 MANDT
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
LINE_ID Unique identification of document line NUMC 6 0 MB_LINE_ID
PARENT_ID Identifier of immediately superior line NUMC 6 0 MB_PARENT_ID
LINE_DEPTH Hierarchy level of line in document NUMC 2 0 MB_LINE_DEPTH
MAA_URZEI Original Line for Account Assignment Item in Material Doc. NUMC 4 0 MAA_URZEI
BWART Movement type (inventory management) CHAR 3 0 BWART
XAUTO Item automatically created CHAR 1 0 MB_XAUTO
No automatically created item
F Tied 'empties' (full product managed on a value basis)
L Standard tied 'empties' material
M Tied 'empties' in transfer (stocks on a material basis)
S Component of a structured material
U Component of a structured material in stock transfer
W Tied 'empties' in transfer (stocks on a value basis)
X General automatically created item
MATNR Material Number CHAR 40 0 MATNR
WERKS Plant CHAR 4 0 WERKS_D
LGORT Storage location CHAR 4 0 LGORT_D
CHARG Batch Number CHAR 10 0 CHARG_D
INSMK Stock Type CHAR 1 0 MB_INSMK
Unrestricted-use
2 Quality inspection
3 Blocked
F Unrestricted-use
S Blocked
X Quality inspection
ZUSCH Batch status key CHAR 1 0 DZUSCH
ZUSTD Batch in Restricted-Use Stock CHAR 1 0 DZUSTD
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
LIFNR Vendor's account number CHAR 10 0 ELIFN
KUNNR Account number of customer CHAR 10 0 EKUNN
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
PLPLA Distribution of Differences CHAR 10 0 PLPLA
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
WAERS Currency Key CUKY 5 0 WAERS
DMBTR Amount in Local Currency CURR 13 2 DMBTR_CS
BNBTR Delivery costs in local currency CURR 13 2 BNBTR
BUALT Amount Posted in Alternative Price Control CURR 13 2 BUALT
SHKUM Debit/credit indicator in revaluation CHAR 1 0 SHKUM
DMBUM Revaluation amount on back-posting to a previous period CURR 13 2 DMBUM
BWTAR Valuation Type CHAR 10 0 BWTAR_D
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 MEINS
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
ERFME Unit of entry UNIT 3 0 ERFME
BPMNG Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
BPRME Order Price Unit (Purchasing) UNIT 3 0 BBPRM
EBELN Purchase order number CHAR 10 0 BSTNR
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
LFBJA Fiscal Year of a Reference Document NUMC 4 0 LFBJA
LFBNR Document No. of a Reference Document CHAR 10 0 LFBNR
LFPOS Item of a Reference Document NUMC 4 0 LFPOS
SJAHR Material Document Year NUMC 4 0 MJAHR
SMBLN Number of Material Document CHAR 10 0 MBLNR
SMBLP Item in Material Document NUMC 4 0 MBLPO
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
SGTXT Item Text CHAR 50 0 SGTXT
EQUNR Equipment Number CHAR 18 0 EQUNR
WEMPF Goods Recipient CHAR 12 0 WEMPF
ABLAD Unloading Point CHAR 25 0 ABLAD
GSBER Business Area CHAR 4 0 GSBER
KOKRS Controlling Area CHAR 4 0 KOKRS
PARGB Trading partner's business area CHAR 4 0 PARGB
PARBU Clearing company code CHAR 4 0 PARBU
KOSTL Cost Center CHAR 10 0 KOSTL
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
AUFNR Order Number CHAR 12 0 AUFNR
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
XSKST Indicator: Statistical Posting to Cost Center CHAR 1 0 XSKST
XSAUF Indicator: Posting to Order Is Statistical CHAR 1 0 XSAUF
XSPRO Indicator: Posting to Project Is Statistical CHAR 1 0 XSPRO
XSERG Indicator: Posting to Profitability Analysis Is Statistical CHAR 1 0 XSERG
GJAHR Fiscal Year NUMC 4 0 GJAHR
XRUEM Allow Posting to Previous Period (Backposting) CHAR 1 0 XRUEM
XRUEJ Indicator: post to previous year CHAR 1 0 XRUEJ
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BELUM Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZUM Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
PBAMG Quantity QUAN 13 3 MENGE_D
KZSTR Transaction/event is relevant to statistics CHAR 1 0 KZSTR
Not relevant
2 Document evaluations and standard analyses (update)
3 Standard analyses only (update)
UMMAT Receiving/Issuing Material CHAR 40 0 UMMAT
UMWRK Receiving plant/issuing plant CHAR 4 0 UMWRK
UMLGO Receiving/issuing storage location CHAR 4 0 UMLGO
UMCHA Receiving/Issuing Batch CHAR 10 0 UMCHA
UMZST Status of Transfer Batch CHAR 1 0 UMZST
UMZUS Status key of transfer batch CHAR 1 0 UMZUS
UMBAR Valuation Type of Transfer Batch CHAR 10 0 UMBAR
UMSOK Special stock indicator for physical stock transfer CHAR 1 0 UMSOK
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
KZZUG Receipt Indicator CHAR 1 0 KZZUG
Normal receipt
L Tied empties
X Stock transport order
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
PALAN WMS Number of pallets DEC 11 0 PALAN
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 LGNUM
LGTYP Storage Type CHAR 3 0 LGTYP
LGPLA Storage Bin CHAR 10 0 LGPLA
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
BWLVS Movement Type for Warehouse Management NUMC 3 0 BWLVS
TBNUM Transfer Requirement Number NUMC 10 0 TBNUM
TBPOS Transfer Requirement Item NUMC 4 0 TBPOS
XBLVS Indicator: posting in warehouse management system CHAR 1 0 XBLVS
VSCHN Ind: interim storage posting for source stor.type and bin CHAR 1 0 T333_VSCHN
NSCHN Ind.: interim storage posting for dest.stor.type and bin CHAR 1 0 T333_NSCHN
DYPLA Indicator: dynamic storage bin CHAR 1 0 DYPLA
UBNUM Posting Change Number NUMC 10 0 UBNUM
TBPRI Transfer Priority CHAR 1 0 TBPRI
TANUM Transfer Order Number NUMC 10 0 TANUM
WEANZ Number of GR/GI Slips to Be Printed NUMC 3 0 WEANZ
GRUND Reason for Movement NUMC 4 0 MB_GRBEW
EVERS Shipping Instructions CHAR 2 0 EVERS
EVERE Compliance with Shipping Instructions CHAR 2 0 EVERE
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
KSTRG Cost Object CHAR 12 0 KSTRG
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
AUFPS Order item number NUMC 4 0 CO_POSNR
VPTNR Partner account number CHAR 10 0 JV_PART
FIPOS Commitment Item CHAR 14 0 FIPOS
SAKTO G/L Account Number CHAR 10 0 SAKNR
BSTMG Goods receipt quantity in order unit QUAN 13 3 MB_BSTMG
BSTME Purchase Order Unit of Measure UNIT 3 0 BSTME
XWSBR Reversal of GR allowed for GR-based IV despite invoice CHAR 1 0 XWSBR
EMLIF Supplier to be Supplied/Who is to Receive Delivery CHAR 10 0 EMLIF
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
EXBWR Externally Entered Posting Amount in Local Currency CURR 13 2 EXBWR
VKWRT Value at Sales Prices Including Value-Added Tax CURR 13 2 VKWRT
AKTNR Promotion CHAR 10 0 WAKTION
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
EXVKW Externally Entered Sales Value in Local Currency CURR 13 2 EXVKW
PPRCTR Partner Profit Center CHAR 10 0 PPRCTR
RSART Record type CHAR 1 0 RSART
GEBER Fund CHAR 10 0 BP_GEBER
FISTL Funds Center CHAR 16 0 FISTL
MATBF Material in Respect of Which Stock is Managed CHAR 40 0 MATBF
UMMAB Receiving/Issuing Material CHAR 40 0 UMMAT
BUSTM Posting string for quantities CHAR 4 0 BUSTM
BUSTW Posting String for Values CHAR 4 0 BUSTW
MENGU Quantity Updating in Material Master Record CHAR 1 0 MENGU
WERTU Value Updating in Material Master Record CHAR 1 0 WERTU
LBKUM Total valuated stock before the posting QUAN 13 3 LBKUM_MSEG
SALK3 Value of total valuated stock before the posting CURR 13 2 SALK3_MSEG
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
FKBER Functional Area CHAR 16 0 FKBER
DABRBZ Reference date for settlement DATS 8 0 DABRBEZ
VKWRA Value at Sales Prices Excluding Value Added Tax CURR 13 2 VKWRA
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
XBEAU Purchase order created at time of goods receipt CHAR 1 0 XBEAU
LSMNG Quantity in Unit of Measure from Delivery Note QUAN 13 3 LSMNG
LSMEH Unit of Measure From Delivery Note UNIT 3 0 LSMEH
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
QINSPST Status of Goods Receipt Inspection CHAR 1 0 QINSPST
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 NUMC 4 0 URZEI
J_1BEXBASE Alternate base amount in document currency CURR 13 2 J_1BEXBASE
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
EMATN Material number corresponding to manufacturer part number CHAR 40 0 EMATN
J_1AGIRUPD Goods issue revaluation performed CHAR 1 0 J_1AGIRUPD
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 CHAR 2 0 MWSKZ
HSDAT Date of Manufacture DATS 8 0 HSDAT
BERKZ Material Staging Indicator for Production Supply CHAR 1 0 BERKZ
MAT_KDAUF Sales order number of valuated sales order stock CHAR 10 0 MAT_KDAUF
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock NUMC 6 0 MAT_KDPOS
MAT_PSPNR Valuated Sales Order Stock WBS Element NUMC 8 0 MAT_PSPNR
XWOFF Calculation of val. open CHAR 1 0 XWOFF
BEMOT Accounting Indicator CHAR 2 0 BEMOT
PRZNR Business Process CHAR 12 0 CO_PRZNR
LLIEF Goods Supplier CHAR 10 0 LLIEF
LSTAR Activity Type CHAR 6 0 LSTAR
XOBEW Vendor Stock Valuation Indicator CHAR 1 0 XOBEW
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
ZUSTD_T156M Stock Type Modification (Read from Table T156M) CHAR 1 0 BAMOK_MSEG
0 Restricted-Use Stock
1 Unrestricted-Use Stock
2 Stock in Quality Inspection
3 Blocked Stock
F Unrestricted-Use Stock (T156M-ZUSTD Read with ' ')
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
SPE_GTS_STOCK_TY GTS Stock Type CHAR 1 0 /SPE/GTS_STOCK_TYPE
Normal Stock
1 Temporary Storage Relevant
2 Scrapping Relevant
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLPOS
XMACC Multiple Account Assignment CHAR 1 0 XMACC
VGART_MKPF Transaction/Event Type CHAR 2 0 VGART
BUDAT_MKPF Posting Date in the Document DATS 8 0 BUDAT
CPUDT_MKPF Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM_MKPF Time of Entry TIMS 6 0 CPUTM
USNAM_MKPF User Name CHAR 12 0 USNAM
XBLNR_MKPF Reference Document Number CHAR 16 0 XBLNR1
TCODE2_MKPF Transaction Code CHAR 20 0 TCODE
VBELN_IM Delivery CHAR 10 0 VBELN_VL
VBELP_IM Delivery Item NUMC 6 0 POSNR_VL
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
SGT_UMSCAT Receiving/Issuing Stock Segment CHAR 40 0 SGT_UMSCAT
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SERVICEPERFORMER Service Performer CHAR 10 0 SERVICEPERFORMER
PERNR Personnel Number NUMC 8 0 PERNR_D
KNTTP_GR Account Assignment Category CHAR 1 0 KNTTP
WORK_ITEM_ID Work Item ID CHAR 10 0 /CPD/PFP_WORKITEM_ID
FBUDA Date on which services are rendered DATS 8 0 FBUDA
XPRINT Print via Output Control CHAR 1 0 XNAPR
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 /CWM/MEINS
/CWM/ERFMG Quantity in Parallel Unit of Entry QUAN 13 3 /CWM/ERFMG
/CWM/ERFME PUoM Entry Unit of Measure UNIT 3 0 /CWM/ERFME
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
EWM_LGNUM Warehouse Number/Warehouse Complex CHAR 4 0 /SCWM/LGNUM
EWM_GMDOC Warehouse Document for Goods Movement NUMC 12 0 /SCWM/DE_GM_DOC
RESOURCENAME_SID Resource Name (Stock Identifier) CHAR 40 0 NSDM_RESOURCENAME_SID
RESOURCENAME_CID Resource Name (Stock Identifier Complement) CHAR 40 0 NSDM_RESOURCENAME_CID
DUMMY_MATDOC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
DISUB_OWNER Owner of stock CHAR 10 0 OWNER_D
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_UMSEA_YR Receiving/Issuing Season Year CHAR 4 0 FSH_UMSEA_YR
FSH_UMSEA Receiving/Issuing Season CHAR 10 0 FSH_UMSEA
FSH_UMCOLL Receiving/Issuing Collection CHAR 10 0 FSH_UMCOLL
FSH_UMTHEME Receiving/Issuing Theme CHAR 10 0 FSH_UMTHEME
SGT_CHINT Discrete Batch Number [Obsolete] CHAR 1 0 SGT_CHINT
COMPL_MARK Completed indicator CHAR 1 0 COMPL_MARK
FZGLS_MARK Do Not Adjust Cumulative Received Quantity CHAR 1 0 FZGLS
ETANP_MARK Adjust Open Quantity in Scheduling Agreement Item CHAR 1 0 ETANP
POPUP_MARK Display Dialog Box CHAR 1 0 POPUP
OINAVNW Non-deductible input tax CURR 13 2 NAVNW
OICONDCOD Joint Venture Indicator (Condition Key) CHAR 2 0 JV_CONDCOD
CONDI Joint Venture Indicator (Condition Key) CHAR 2 0 JV_CONDCOD
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3
SCENARIO_GT Business Scenario CHAR 2 0 WB2_BUSINESS_SCENARIO
FILTERED_OUT_GT Filtered Out CHAR 1 0 WB2_FILTERED_OUT
NOT_REF_QUAN_GT Open Quantity QUAN 15 3 WB2_NOT_REF_QUAN
NOT_REF_QUAN_UNIT_GT Open Quantity Unit UNIT 3 0 WB2_NOT_REF_QUAN_UNIT
EXTERNAL_NO_GT External Identifier in Trading Contract CHAR 30 0 TKONN_EX
NOT_REF_QUAN_DOC_GT Open Quantity QUAN 15 3 WB2_NOT_REF_QUAN
NOT_REF_QUAN_VAR_GT Open Quantity QUAN 15 3 WB2_NOT_REF_QUAN
BSEG_MEINS_GT Base Unit of Measure UNIT 3 0 MEINS
ASSOC_QUAN_B Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_B Base Unit of Measure UNIT 3 0 * MEINS
ASSOC_QUAN_S Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_S Base Unit of Measure UNIT 3 0 * MEINS
ASSOC_QUAN_P Actually Associated Quantity of an Item QUAN 15 3 WB2_ASSOCIATED_QUAN
UNIT_OF_QUAN_P Base Unit of Measure UNIT 3 0 * MEINS
PORTFOLIO Portfolio Number(Internal) CHAR 10 0 WB2_PORTFOLIO
MATERIAL Material Number (18 Characters) CHAR 18 0 * MATNR18
PLANT Plant CHAR 4 0 T001W WERKS_D
STGE_LOC Storage location CHAR 4 0 T001L LGORT_D
BATCH Batch Number CHAR 10 0 MCHA CHARG_D
MOVE_TYPE Movement type (inventory management) CHAR 3 0 T156 BWART
STCK_TYPE Stock Type CHAR 1 0 MB_INSMK
Unrestricted-use
2 Quality inspection
3 Blocked
F Unrestricted-use
S Blocked
X Quality inspection
SPEC_STOCK Special Stock Indicator CHAR 1 0 T148 SOBKZ
VENDOR Vendor's account number CHAR 10 0 LFA1 ELIFN
CUSTOMER Account number of customer CHAR 10 0 KNA1 EKUNN
SALES_ORD Sales Order Number CHAR 10 0 * KDAUF
S_ORD_ITEM Item number in Sales Order NUMC 6 0 KDPOS
SCHED_LINE Delivery schedule for sales order NUMC 4 0 KDEIN
VAL_TYPE Valuation Type CHAR 10 0 T149D BWTAR_D
ENTRY_QNT Quantity in unit of entry QUAN 13 3 ERFMG
ENTRY_UOM Unit of entry UNIT 3 0 T006 ERFME
ENTRY_UOM_ISO ISO code for unit of measurement CHAR 3 0 T006I ISOCD_UNIT
PO_PR_QNT Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
ORDERPR_UN Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
ORDERPR_UN_ISO ISO code for unit of measurement CHAR 3 0 T006I ISOCD_UNIT
PO_NUMBER Purchase order number CHAR 10 0 EKKO BSTNR
PO_ITEM Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
SHIPPING Shipping Instructions CHAR 2 0 T027A EVERS
COMP_SHIP Compliance with Shipping Instructions CHAR 2 0 T027C EVERE
NO_MORE_GR "Delivery Completed" Indicator CHAR 1 0 ELIKZ
ITEM_TEXT Item Text CHAR 50 0 SGTXT
GR_RCPT Goods Recipient CHAR 12 0 WEMPF
UNLOAD_PT Unloading Point CHAR 25 0 ABLAD
COSTCENTER Cost Center CHAR 10 0 CSKS KOSTL
ORDERID Order Number CHAR 12 0 AUFK AUFNR
ORDER_ITNO Order item number NUMC 4 0 CO_POSNR
CALC_MOTIVE Accounting Indicator CHAR 2 0 TBMOT BEMOT
ASSET_NO Main Asset Number CHAR 12 0 ANLH ANLN1
SUB_NUMBER Asset Subnumber CHAR 4 0 ANLA ANLN2
RESERV_NO Number of reservation/dependent requirements NUMC 10 0 RESB RSNUM
RES_ITEM Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
RES_TYPE Record type CHAR 1 0 RSART
WITHDRAWN Final Issue for Reservation CHAR 1 0 KZEAR
MOVE_MAT Receiving/Issuing Material CHAR 18 0 * UMMAT18
MOVE_PLANT Receiving plant/issuing plant CHAR 4 0 T001W UMWRK
MOVE_STLOC Receiving/issuing storage location CHAR 4 0 T001L UMLGO
MOVE_BATCH Receiving/Issuing Batch CHAR 10 0 MCHA UMCHA
MOVE_VAL_TYPE Valuation Type of Transfer Batch CHAR 10 0 T149D UMBAR
MVT_IND Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
MOVE_REAS Reason for Movement NUMC 4 0 T157D MB_GRBEW
RL_EST_KEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
REF_DATE Reference date for settlement DATS 8 0 DABRBEZ
COST_OBJ Cost Object CHAR 12 0 CKPH KSTRG
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PROFIT_CTR Profit Center CHAR 10 0 CEPC PRCTR
WBS_ELEM Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
NETWORK Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
ACTIVITY Operation/Activity Number CHAR 4 0 VORNR
PART_ACCT Partner account number CHAR 10 0 KNA1 JV_PART
AMOUNT_LC Externally entered posting amount in local currency DEC 23 4 BAPI_EXBWR
AMOUNT_SV Externally entered sales value in local currency DEC 23 4 BAPI_EXVKW
REF_DOC_YR Fiscal Year of a Reference Document NUMC 4 0 LFBJA
REF_DOC Document No. of a Reference Document CHAR 10 0 LFBNR
REF_DOC_IT Item of a Reference Document NUMC 4 0 LFPOS
EXPIRYDATE Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
PROD_DATE Date of Manufacture DATS 8 0 HSDAT
FUND Fund CHAR 10 0 FMFINCODE BP_GEBER
FUNDS_CTR Funds Center CHAR 16 0 FMFCTR FISTL
CMMT_ITEM Commitment Item CHAR 14 0 FMFPO FIPOS
VAL_SALES_ORD Sales order number of valuated sales order stock CHAR 10 0 * MAT_KDAUF
VAL_S_ORD_ITEM Sales Order Item of Valuated Sales Order Stock NUMC 6 0 MAT_KDPOS
VAL_WBS_ELEM Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
GL_ACCOUNT G/L Account Number CHAR 10 0 SKA1 SAKNR
IND_PROPOSE_QUANX Propose quantities CHAR 1 0 XMEVO
XSTOB Use Reversal Movement Type Indicator CHAR 1 0 XSTOB
EAN_UPC International Article Number (EAN/UPC) CHAR 18 0 EAN11
DELIV_NUMB_TO_SEARCH Delivery CHAR 10 0 * VBELN_VL
DELIV_ITEM_TO_SEARCH Delivery Item NUMC 6 0 * POSNR_VL
SERIALNO_AUTO_NUMBERASSIGNMENT Create serial number automatically CHAR 1 0 XSAUT
VENDRBATCH Supplier Batch Number CHAR 15 0 LICHN
STGE_TYPE Storage Type CHAR 3 0 T301 LGTYP
STGE_BIN Storage Bin CHAR 10 0 LAGP LGPLA
SU_PL_STCK_1 Number of Storage Units to be Placed Into Storage DEC 3 0 LVS_ANZLE
ST_UN_QTYY_1 Quantity per Storage Unit to be Placed into Stock in Alt.UoM QUAN 13 3 LVS_LEMEN
ST_UN_QTYY_1_ISO ISO code for unit of measurement CHAR 3 0 T006I ISOCD_UNIT
UNITTYPE_1 Storage Unit Type CHAR 3 0 T307 LVS_LETYP
SU_PL_STCK_2 Number of Storage Units to be Placed Into Storage DEC 3 0 LVS_ANZLE
ST_UN_QTYY_2 Quantity per Storage Unit to be Placed into Stock in Alt.UoM QUAN 13 3 LVS_LEMEN
ST_UN_QTYY_2_ISO ISO code for unit of measurement CHAR 3 0 T006I ISOCD_UNIT
UNITTYPE_2 Storage Unit Type CHAR 3 0 T307 LVS_LETYP
STGE_TYPE_PC Storage type for transfer posting CHAR 3 0 T301 UBTYP
STGE_BIN_PC Storage bin for transfer posting CHAR 10 0 LAGP UBPLA
NO_PST_CHGNT Indicator: Do not create posting change notice CHAR 1 0 LVS_KZKUB
GR_NUMBER Goods Receipt Number CHAR 10 0 LVS_WENUM
STGE_TYPE_ST Storage type for stock transfer CHAR 3 0 T301 UMLGT
STGE_BIN_ST Storage bin for stock transfer CHAR 10 0 LAGP UMLGP
MATDOC_TR_CANCEL Material doc. no. of transfer requirement to be cancelled CHAR 10 0 LVS_TBBEL
MATITEM_TR_CANCEL Material doc. item of transf.reqmnt item to be cancelled NUMC 4 0 LVS_TBBPO
MATYEAR_TR_CANCEL Material doc. year of transfer requirement to be cancelled NUMC 4 0 LVS_TBBJR
NO_TRANSFER_REQ Indicator: No Transfer Requirement Created CHAR 1 0 LVS_TBFKZ
CO_BUSPROC Business Process CHAR 12 0 * CO_PRZNR
ACTTYPE Activity Type CHAR 6 0 LSTAR
SUPPL_VEND Goods Supplier CHAR 10 0 * LLIEF
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
MATERIAL_GUID External GUID for MATERIAL Field CHAR 32 0 MGV_MATERIAL_GUID
MATERIAL_VERSION Version Number for MATERIAL Field CHAR 10 0 MGV_MATERIAL_VERSION
MOVE_MAT_EXTERNAL Long Material Number for MOVE_MAT Field CHAR 40 0 MGV_MOVE_MAT_EXTERNAL
MOVE_MAT_GUID External GUID for MOVE_MAT Field CHAR 32 0 MGV_MOVE_MAT_GUID
MOVE_MAT_VERSION Version Number for MOVE_MAT Field CHAR 10 0 MGV_MOVE_MAT_VERSION
FUNC_AREA Functional Area CHAR 4 0 FKBER_SHORT
TR_PART_BA Trading partner's business area CHAR 4 0 * PARGB
PAR_COMPCO Clearing company code CHAR 4 0 * PARBU
DELIV_NUMB Delivery CHAR 10 0 VBELN_VL
DELIV_ITEM Delivery Item NUMC 6 0 POSNR_VL
NB_SLIPS Number of GR/GI Slips to Be Printed NUMC 3 0 WEANZ
NB_SLIPSX Updated information in related user data field CHAR 1 0 BAPIUPDATE
No update for the field
X Update for the field
GR_RCPTX Updated information in related user data field CHAR 1 0 BAPIUPDATE
No update for the field
X Update for the field
UNLOAD_PTX Updated information in related user data field CHAR 1 0 BAPIUPDATE
No update for the field
X Update for the field
SPEC_MVMT Special movement indicator for warehouse management CHAR 1 0 * LVS_BSSKZ
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
CMMT_ITEM_LONG Commitment Item CHAR 24 0 * FM_FIPEX
FUNC_AREA_LONG Functional Area CHAR 16 0 * FKBER
LINE_ID Unique identification of document line NUMC 6 0 MB_LINE_ID
PARENT_ID Identifier of immediately superior line NUMC 6 0 MB_PARENT_ID
LINE_DEPTH Hierarchy level of line in document NUMC 2 0 MB_LINE_DEPTH
QUANTITY Quantity QUAN 13 3 MENGE_D
BASE_UOM Base Unit of Measure UNIT 3 0 * MEINS
LONGNUM Smart Number CHAR 40 0 /SAPPSPRO/LONGNUM
BUDGET_PERIOD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
EARMARKED_NUMBER Document Number for Earmarked Funds CHAR 10 0 * KBLNR
EARMARKED_ITEM Earmarked Funds: Document Item NUMC 3 0 * KBLPOS
STK_SEGMENT Stock Segment CHAR 16 0 SGT_SCAT16
MOVE_SEGMENT Receiving/Issuing Stock Segment CHAR 16 0 SGT_UMSCAT16
MATERIAL_LONG Material No. CHAR 40 0 * MATNR40
MOVE_MAT_LONG Receiving/Issuing Material CHAR 40 0 * UMMAT40
STK_SEG_LONG Stock Segment CHAR 40 0 SGT_SCAT40
MOV_SEG_LONG Receiving/Issuing Stock Segment CHAR 40 0 SGT_UMSCAT40
CREATE_DELIVERY Create Delivery (Shipping) CHAR 1 0 XDELIV
WAREHOUSE_EWM Warehouse Number/Warehouse Complex CHAR 4 0 /SCWM/LGNUM
STGE_BIN_EWM Storage Bin CHAR 18 0 * /SCWM/LGPLA
EWM_DIFF_ANA Post Goods Movement to Difference Analyzer CHAR 1 0 /SCWM/DE_GM_DIFF_ANA
SERVICE_DOC Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_ITEM Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SUPPLYAREA Production Supply Area CHAR 10 0 * PRVBE
EWM_INSPUUID Inspection Finding: Stock GUID Set by EWM CHAR 32 0 /SCWM/DE_EWM_INSP_GUID
XSTOR Reversal, return delivery, or transfer posting CHAR 1 0 KZSTO
Neither return delivery nor reversal
1 Return deliv.(qty can be entered; no gener.of matchcode)
2 Reversal(qty cannot be entered; gener.of matchcode)
3 Transfer posting (qty can be entered; no gener.of matchcode)

SAPI_MD_ITEM foreign key relationships

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