MATDOC

Material Documents | #transactional | Component: Basic Functions
Column Name Description
MANDT Client
MBLNR Number of Material Document
MJAHR Material Document Year
ZEILE Item in Material Document
LINE_ID Unique identification of document line
Column Name Description
💲 Currency Key (WAERS):
DMBTR Amount in Local Currency
BNBTR Delivery costs in local currency
BUALT Amount Posted in Alternative Price Control
DMBUM Revaluation amount on back-posting to a previous period
EXBWR Externally Entered Posting Amount in Local Currency
VKWRT Value at Sales Prices Including Value-Added Tax
EXVKW Externally Entered Sales Value in Local Currency
SALK3 Value of total valuated stock before the posting
VKWRA Value at Sales Prices Excluding Value Added Tax
J_1BEXBASE Alternate base amount in document currency
STOCK_VKWRT Value at Sales Prices Including Value-Added Tax
DMBTR_STOCK Amount in Local Currency with Sign of Stock Quantity
DMBTR_CONS Amount in Local Currency with Sign of Consumption Quantity
OINAVNW Non-deductible input tax
FRATH Unplanned delivery costs
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
LBKUM Total valuated stock before the posting
STOCK_QTY Stock Quantity
CONSUMPTION_QTY Consumption Quantity
📏 Unit of entry (ERFME):
ERFMG Quantity in unit of entry
📏 Order Price Unit (Purchasing) (BPRME):
BPMNG Quantity in Purchase Order Price Unit
📏 Purchase Order Unit of Measure (BSTME):
BSTMG Goods receipt quantity in order unit
📏 Unit of Measure From Delivery Note (LSMEH):
LSMNG Quantity in Unit of Measure from Delivery Note
PBAMG Quantity
📏 Parallel Unit of Measure (/CWM/MEINS):
/CWM/MENGE Quantity in Parallel Unit of Measure
📏 PUoM Entry Unit of Measure (/CWM/ERFME):
/CWM/ERFMG Quantity in Parallel Unit of Entry
📏 Parallel Unit of Measure (Stock Identifier) (/CWM/MEINS_SID):
/CWM/STOCK_QTY Stock Quantity in PUoM
/CWM/CONSUMPTION_QTY Consumption Quantity in PUoM
Column Name Description
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
BLDAT Document Date in Document
AEDAT Last Changed On
SPE_BUDAT_UHR Time of Goods Issue (Local, Relating to a Plant)
VFDAT Shelf Life Expiration or Best-Before Date
DABRBZ Reference date for settlement
DABRZ Reference date for settlement
HSDAT Date of Manufacture
FBUDA Date on which services are rendered
_DATAAGING Data Filter Value for Data Aging
Column Name Description
RECORD_TYPE Record Type Show values
LBBSA_SID Stock Type of Goods Movement (Stock Identifier) Show values
MENGU Quantity Updating in Material Master Record Show values
WERTU Value Updating in Material Master Record Show values
VBOBJ_SG SD Document Object Show values
KZBWS Valuation of Special Stock Show values
BSTAUS_SG Stock Characteristics Show values
BSTTYP_SG Stock Category Show values
PRICE_SOURCE_A1 Indicator for Analytical Value of Price Source - not used Show values
LBBSA_CID Stock Type of Goods Movement (Stock Identifier) Show values
UMMEN_CG Quantity Updating in Material Master Record Show values
UMWER_CG Value Updating in Material Master Record Show values
VBOBJ_CG SD Document Object Show values
UMKZBWS_CG Valuation of Special Stock Show values
BSTAUS_CG Stock Characteristics Show values
BSTTYP_CG Stock Category Show values
WEEKDAY_BUDAT Week Day Show values
CANCELLED Item has been Cancelled Show values
CANCELLATION_TYPE Relevance for Analytics Show values
REVERSAL_MOVEMENT Reversal movement type Show values
XSTOR Reversal, return delivery, or transfer posting Show values
XAUTO Item automatically created Show values
INSMK Stock Type Show values
ZUSTD Batch in Restricted-Use Stock Show values
SHKZG Debit/Credit Indicator Show values
SHKUM Debit/credit indicator in revaluation Show values
ELIKZ "Delivery Completed" Indicator Show values
XSKST Indicator: Statistical Posting to Cost Center Show values
XSAUF Indicator: Posting to Order Is Statistical Show values
XSPRO Indicator: Posting to Project Is Statistical Show values
XSERG Indicator: Posting to Profitability Analysis Is Statistical Show values
XRUEM Allow Posting to Previous Period (Backposting) Show values
XRUEJ Indicator: post to previous year Show values
KZEAR Final Issue for Reservation Show values
KZSTR Transaction/event is relevant to statistics Show values
KZBEW Movement Indicator Show values
KZVBR Consumption posting Show values
KZZUG Receipt Indicator Show values
WEUNB Goods Receipt, Non-Valuated Show values
BESTQ Stock Category in the Warehouse Management System Show values
XBLVS Indicator: posting in warehouse management system Show values
VSCHN Ind: interim storage posting for source stor.type and bin Show values
NSCHN Ind.: interim storage posting for dest.stor.type and bin Show values
DYPLA Indicator: dynamic storage bin Show values
XWSBR Reversal of GR allowed for GR-based IV despite invoice Show values
VPRSV Price control indicator Show values
XBEAU Purchase order created at time of goods receipt Show values
QINSPST Status of Goods Receipt Inspection Show values
J_1AGIRUPD Goods issue revaluation performed Show values
BERKZ Material Staging Indicator for Production Supply Show values
XWOFF Calculation of val. open Show values
XOBEW Vendor Stock Valuation Indicator Show values
ZUSTD_T156M Stock Type Modification (Read from Table T156M) Show values
SPE_GTS_STOCK_TY GTS Stock Type Show values
COMPL_MARK Completed indicator Show values
FZGLS_MARK Do Not Adjust Cumulative Received Quantity Show values
ETANP_MARK Adjust Open Quantity in Scheduling Agreement Item Show values
POPUP_MARK Display Dialog Box Show values
XSAUT Create serial number automatically Show values
WEVER Version for Printing GR/GI Slip Show values
BFWMS Control posting for external WMS Show values
FLS_RSTO Store Return with Inbound and Outbound Delivery Show values
MSR_ACTIVE Advanced Returns Management Active Show values
XPRINT Print via Output Control Show values
LMBMV Under/Overdelivery Show values
XFMAT Material is a missing part Show values
KNBDR Print kanban card Show values
Column Name Description Domain name
KEY1 null
KEY2 null
KEY3 null
KEY4 null
KEY5 null
KEY6 null
HEADER_COUNTER Material Document Counter NSDM_HEADER_COUNTER
MATBF Material in Respect of Which Stock is Managed MATNR
WERKS Plant WERKS
LGORT_SID Storage Location (Stock Identifier) LGORT
CHARG_SID Batch Number (Stock Identifier) CHARG
LIFNR_SID Supplier for Special Stock LIFNR
MAT_KDAUF Sales order number of valuated sales order stock VBELN
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock NUM06
MAT_PSPNR Valuated Sales Order Stock WBS Element PS_POSNR
KUNNR_SID Customer for Special Stock KUNNR
SOBKZ Special Stock Indicator SOBKZ
DISUB_OWNER_SID Additional Supplier for Special Stock LIFNR
RESOURCENAME_SID Resource Name (Stock Identifier) NSDM_RESOURCENAME
BUKRS Company Code BUKRS
CHARG_WHS_SG Batch Number of Warehouse Stock (Stock Identifier) CHARG
KALNR Cost Estimate Number - Product Costing CK_KALNR
BERID MRP Area BERID
PRICE_A1 Analytical Price of one Base Unit of Measure - not used NSDM_STOCK_VALUE
STOCK_VALUE_A1 Analytical Value of Warehouse Stock - not used NSDM_STOCK_VALUE
CONS_VALUE_A1 Analytical Value of Consumption Quantity - not used NSDM_STOCK_VALUE
UMMAB_CID Receiving/Issuing Material MATNR
UMWRK_CID Plant WERKS
LGORT_CID Storage Location (Stock Identifier) LGORT
CHARG_CID Batch Number (Stock Identifier) CHARG
LIFNR_CID Supplier for Special Stock LIFNR
MAT_KDAUF_CID Sales and Distribution Document Number (Stock Identifier) VBELN
MAT_KDPOS_CID Item Number of the SD Document (Stock Identifier) POSNR
MAT_PSPNR_CID Work Breakdown Structure Element (Stock Identifier) PS_POSNR
KUNNR_CID Customer for Special Stock KUNNR
UMSOK_CID Special Stock Indicator SOBKZ
DISUB_OWNER_CID Account Number of Supplier LIFNR
RESOURCENAME_CID Resource Name (Stock Identifier Complement) NSDM_RESOURCENAME
UMBUK_CG Company Code BUKRS
CHARG_WHS_CG Batch Number of Warehouse Stock (Stock Identifier) CHARG
KALNR_CG Complement Cost Estimate Number - Product Costing CK_KALNR
YEARDAY_BUDAT Year-Day-Combination NSDM_YEARDAY
YEARWEEK_BUDAT Year-Week-Combination NUM6
YEARMONTH_BUDAT Year-Month-Combination NUM6
YEARQUARTER_BUDAT Year-Quarter-Combination NUM5
YEAR_BUDAT Year
QUARTER_BUDAT Quarter (1 - 4)
MONTH_BUDAT Month (1 - 12)
WEEK_BUDAT Calendar Week (1 - 53)
DAY_BUDAT Day of Year (1 - 366)
SPE_BUDAT_ZONE Time Zone TZNZONE
PERIV Fiscal Year Variant PERIV
GJAHR Fiscal Year GJAHR
GJPER Period/Year JAHRPER
GJPER_CURR_PER Period/Year JAHRPER
PARENT_ID Identifier of immediately superior line MB_LINE_ID
LINE_DEPTH Hierarchy level of line in document MB_LINE_DEPTH
MAA_URZEI Original Line for Account Assignment Item in Material Doc. MBLPO
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
KDEIN Delivery schedule for sales order NUM04
EBELN Purchase order number EBELN
EBELP Item Number of Purchasing Document EBELP
LFBJA Fiscal Year of a Reference Document GJAHR
LFBNR Document No. of a Reference Document BELNR
LFPOS Item of a Reference Document MBLPO
SJAHR Material Document Year GJAHR
SMBLN Number of Material Document BELNR
SMBLP Item in Material Document MBLPO
AUFNR Order Number AUFNR
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
BELUM Document Number of an Accounting Document BELNR
BUZUM Number of Line Item Within Accounting Document BUZEI
RSNUM Number of reservation/dependent requirements RSNUM
RSPOS Item Number of Reservation / Dependent Requirements RSPOS
TBNUM Transfer Requirement Number TBNUM
TBPOS Transfer Requirement Item TBPOS
UBNUM Posting Change Number UBNUM
TANUM Transfer Order Number TANUM
URZEI Original line in material document MBLPO
XBLNR Reference Document Number XBLNR1
VBELN_IM Delivery VBELN
VBELP_IM Delivery Item POSNR
LE_VBELN Delivery VBELN
SPE_LOGSYS Logical System of EWM Material Document LOGSYS
SPE_MDNUM_EWM Number of Material Document in EWM /SPE/MDNUM_EWM
SERVICE_DOC_TYPE Service Document Type CRM_PROCESS_TYPE
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
EWM_LGNUM Warehouse Number/Warehouse Complex /SCWM/LGNUM
EWM_GMDOC Warehouse Document for Goods Movement /SCWM/TANUM
EWM_LGPLA Storage Bin /SCWM/LGPLA
BWART Movement type (inventory management) BWART
MATNR Material Number MATNR
LGORT Storage location LGORT
CHARG Batch Number CHARG
BWTAR Valuation Type BWTAR
ZUSCH Batch status key ZUSCH
LIFNR Vendor's account number LIFNR
KUNNR Account number of customer KUNNR
PLPLA Distribution of Differences PLPLA
SGTXT Item Text TEXT50
EQUNR Equipment Number EQUNR
WEMPF Goods Recipient WEMPF
ABLAD Unloading Point TEXT25
GSBER Business Area GSBER
KOKRS Controlling Area CACCD
PARGB Trading partner's business area GSBER
PARBU Clearing company code BUKRS
KOSTL Cost Center KOSTL
PROJN Old: Project number : No longer used --> PS_POSNR PROJN
UMMAT Receiving/Issuing Material MATNR
UMCHA Receiving/Issuing Batch CHARG
UMLGO Receiving/issuing storage location LGORT
UMZST Status of Transfer Batch ZUSTD
UMZUS Status key of transfer batch ZUSCH
PALAN WMS Number of pallets PALAN
LGNUM Warehouse Number / Warehouse Complex LGNUM
LGTYP Storage Type LGTYP
LGPLA Storage Bin LGPLA
BWLVS Movement Type for Warehouse Management BWLVS
TBPRI Transfer Priority TBPRI
WEANZ Number of GR/GI Slips to Be Printed NUM3
GRUND Reason for Movement MB_GRBEW
EVERS Shipping Instructions EVERS
EVERE Compliance with Shipping Instructions EVERE
IMKEY Internal Key for Real Estate Object IMKEY
KSTRG Cost Object KSTRG
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PRCTR Profit Center PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
NPLNR Network Number for Account Assignment AUFNR
AUFPL Routing number of operations in the order AUFPL
APLZL Internal counter CIM_COUNT
AUFPS Order item number CO_POSNR
VPTNR Partner account number KUNNR
FIPOS Commitment Item FIPOS
SAKTO G/L Account Number SAKNR
EMLIF Supplier to be Supplied/Who is to Receive Delivery LIFNR
AKTNR Promotion WAKTION
ZEKKN Sequential Number of Account Assignment NUM02
CUOBJ_CH Internal object number of the batch classification CUOBJ
PPRCTR Partner Profit Center PRCTR
RSART Record type RSART
GEBER Fund BP_GEBER
FISTL Funds Center FISTL
BUSTM Posting string for quantities BUSTM
BUSTW Posting String for Values BUSTW
FKBER Functional Area FKBER
MWSKZ Tax on sales/purchases code MWSKZ
TXJCD Tax Jurisdiction TXJCD
EMATN Material number corresponding to manufacturer part number MATNR
VKMWS Tax on sales/purchases code MWSKZ
BEMOT Accounting Indicator BEMOT
PRZNR Business Process CO_PRZNR
LLIEF Goods Supplier LIFNR
LSTAR Activity Type LSTAR
GRANT_NBR Grant GM_GRANT_NBR
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
XMACC Multiple Account Assignment CHAR1
UMMAB Receiving/Issuing Material MATNR
UMBAR Valuation Type of Transfer Batch BWTAR
UMWRK Plant WERKS
UMSOK Special Stock Indicator SOBKZ
SGT_SCAT Stock Segment SGT_SRCA
SGT_UMSCAT Receiving/Issuing Stock Segment SGT_SRCA
SGT_RCAT Requirement Segment SGT_SRCA
DISUB_OWNER Account Number of Supplier LIFNR
SERVICEPERFORMER Service Performer BU_PARTNER
PERNR Personnel Number PERNR
KNTTP_GR Account Assignment Category KNTTP
WORK_ITEM_ID Work Item ID /CPD/PFP_WORKITEM_ID
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
DUMMY_MATDOC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
OICONDCOD Joint Venture Indicator (Condition Key) JV_CONDCOD
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD
ASS_PSPNR Assigned Operative WBS Element PS_POSNR
BLART Document Type BLART
BLAUM Document type of revaluation document BLART
TCODE Undefined range (can be used for patch levels) CHAR4
BKTXT Document Header Text TEXT25
FRBNR Number of Bill of Lading at Time of Goods Receipt XBLNR1
XABLN Goods Receipt/Issue Slip Number BELNR
AWSYS Logical System LOGSYS
BLA2D Doc. type for additional doc. in purchase account management BLART
VGART Transaction/Event Type VGART
USNAM User Name XUBNAME
TCODE2 Transaction Code TCODE
EXNUM Number of foreign trade data in MM and SD documents EXNUM
GTS_CUSREF_NO Customs Reference Number for Scrapping CHAR35
XCOMPL Single-Character Flag CHAR1
KNUMV Number of the Document Condition KNUMV
PABPM Percentage variance in order price unit PRZ22