MSEG

Document Segment: Material | view | #transactional | Component: Inventory Management
Column Name Description
MANDT Client
MBLNR Number of Material Document
MJAHR Material Document Year
ZEILE Item in Material Document
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
OINAVNW Non-deductible input tax
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
PBAMG Quantity
LBKUM Total valuated stock before the posting
📏 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
📏 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
Column Name Description
VFDAT Shelf Life Expiration or Best-Before Date
DABRBZ Reference date for settlement
DABRZ Reference date for settlement
HSDAT Date of Manufacture
BUDAT_MKPF Posting Date in the Document
CPUDT_MKPF Day On Which Accounting Document Was Entered
CPUTM_MKPF Time of Entry
FBUDA Date on which services are rendered
Column Name Description
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
MENGU Quantity Updating in Material Master Record Show values
WERTU Value Updating in Material Master Record Show values
VPRSV Price control indicator Show values
XBEAU Purchase order created at time of goods receipt Show values
KZBWS Valuation of Special Stock 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
XPRINT Print via Output Control Show values
SGT_CHINT Discrete Batch Number [Obsolete] 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
Column Name Description Domain name
LINE_ID Unique identification of document line MB_LINE_ID
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
ZUSCH Batch status key ZUSCH
KDPOS Item number in Sales Order NUM06
KDEIN Delivery schedule for sales order NUM04
PLPLA Distribution of Differences PLPLA
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
SGTXT Item Text TEXT50
EQUNR Equipment Number EQUNR
WEMPF Goods Recipient WEMPF
ABLAD Unloading Point TEXT25
PROJN Old: Project number : No longer used --> PS_POSNR PROJN
GJAHR Fiscal Year GJAHR
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
UMZST Status of Transfer Batch ZUSTD
UMZUS Status key of transfer batch ZUSCH
PALAN WMS Number of pallets PALAN
TBPOS Transfer Requirement Item TBPOS
UBNUM Posting Change Number UBNUM
TBPRI Transfer Priority TBPRI
TANUM Transfer Order Number TANUM
WEANZ Number of GR/GI Slips to Be Printed NUM3
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
AUFPL Routing number of operations in the order AUFPL
APLZL Internal counter CIM_COUNT
AUFPS Order item number CO_POSNR
EMLIF Supplier to be Supplied/Who is to Receive Delivery LIFNR
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
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
MATBF Material in Respect of Which Stock is Managed MATNR
UMMAB Receiving/Issuing Material MATNR
BUSTM Posting string for quantities BUSTM
BUSTW Posting String for Values BUSTW
FKBER Functional Area FKBER
URZEI Original line in material document MBLPO
EMATN Material number corresponding to manufacturer part number MATNR
VKMWS Tax on sales/purchases code MWSKZ
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
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
VGART_MKPF Transaction/Event Type VGART
USNAM_MKPF User Name XUBNAME
XBLNR_MKPF Reference Document Number XBLNR1
TCODE2_MKPF Transaction Code TCODE
VBELN_IM Delivery VBELN
VBELP_IM Delivery Item POSNR
SGT_SCAT Stock Segment SGT_SRCA
SGT_UMSCAT Receiving/Issuing Stock Segment SGT_SRCA
SGT_RCAT Requirement Segment SGT_SRCA
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
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
RESOURCENAME_SID Resource Name (Stock Identifier) NSDM_RESOURCENAME
RESOURCENAME_CID Resource Name (Stock Identifier Complement) NSDM_RESOURCENAME
DUMMY_MATDOC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
DISUB_OWNER Owner of stock LIFNR
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
FSH_UMSEA_YR Receiving/Issuing Season Year FSH_CJAHR
FSH_UMSEA Receiving/Issuing Season RFM_SAISO
FSH_UMCOLL Receiving/Issuing Collection FSH_COLLECTION
FSH_UMTHEME Receiving/Issuing Theme FSH_THEME
OICONDCOD Joint Venture Indicator (Condition Key) JV_CONDCOD
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Asset Subnumber
  • Asset Subnumber
  • Clearing company code
  • Main Asset Number
  • MSEG.MANDT == ANLA.MANDT
  • MSEG.ANLN2 == ANLA.ANLN2
  • MSEG.PARBU == ANLA.BUKRS
  • MSEG.ANLN1 == ANLA.ANLN1
Order Number
  • Order Number
  • Client
  • MSEG.AUFNR == AUFK.AUFNR
  • MSEG.MANDT == AUFK.MANDT
Accounting Indicator
  • MSEG.MANDT == TBMOT.MANDT
  • MSEG.BEMOT == TBMOT.BEMOT
Order Price Unit (Purchasing)
  • MSEG.MANDT == T006.MANDT
  • MSEG.BPRME == T006.MSEHI
Company Code
  • MSEG.MANDT == T001.MANDT
  • MSEG.BUKRS == T001.BUKRS
Movement type (inventory management)
  • MSEG.MANDT == T156.MANDT
  • MSEG.BWART == T156.BWART
Movement Type for Warehouse Management
  • Warehouse Number / Warehouse Complex
  • Movement Type for Warehouse Management
  • Client
  • MSEG.LGNUM == T333.LGNUM
  • MSEG.BWLVS == T333.BWLVS
  • MSEG.MANDT == T333.MANDT
Valuation Type
  • MSEG.MANDT == T149D.MANDT
  • MSEG.BWTAR == T149D.BWTAR
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • MSEG.MANDT == MCHA.MANDT
  • MSEG.MATNR == MCHA.MATNR
  • MSEG.CHARG == MCHA.CHARG
  • MSEG.WERKS == MCHA.WERKS
Unit of entry
  • MSEG.MANDT == T006.MANDT
  • MSEG.ERFME == T006.MSEHI
Compliance with Shipping Instructions
  • Compliance with Shipping Instructions
  • Shipping Instructions
  • MSEG.MANDT == T027C.MANDT
  • MSEG.EVERE == T027C.EVERE
  • MSEG.EVERS == T027C.EVERS
Shipping Instructions
  • Shipping Instructions
  • Client
  • MSEG.EVERS == T027A.EVERS
  • MSEG.MANDT == T027A.MANDT
Commitment Item
  • Commitment Item
  • ?
  • ?
  • MSEG.MANDT == FMFPO.MANDT
  • MSEG.FIPOS == FMFPO.FIPOS
  • MSEG.[column in domain "FIKRS"] == FMFPO.FIKRS
  • MSEG.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
Reason for Movement
  • Reason for Movement
  • Movement type (inventory management)
  • MSEG.MANDT == T157D.MANDT
  • MSEG.GRUND == T157D.GRUND
  • MSEG.BWART == T157D.BWART
Business Area
  • MSEG.MANDT == TGSB.MANDT
  • MSEG.GSBER == TGSB.GSBER
Controlling Area
  • MSEG.MANDT == TKA01.MANDT
  • MSEG.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • MSEG.MANDT == CSKS.MANDT
  • MSEG.[column in domain "DATBI"] == CSKS.DATBI
  • MSEG.KOSTL == CSKS.KOSTL
  • MSEG.KOKRS == CSKS.KOKRS
Account number of customer
  • MSEG.MANDT == KNA1.MANDT
  • MSEG.KUNNR == KNA1.KUNNR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • MSEG.LGNUM == T300.LGNUM
  • MSEG.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • MSEG.LGORT == T001L.LGORT
  • MSEG.MANDT == T001L.MANDT
  • MSEG.WERKS == T001L.WERKS
Storage Bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • MSEG.MANDT == LAGP.MANDT
  • MSEG.LGPLA == LAGP.LGPLA
  • MSEG.LGNUM == LAGP.LGNUM
  • MSEG.LGTYP == LAGP.LGTYP
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • MSEG.LGNUM == T301.LGNUM
  • MSEG.MANDT == T301.MANDT
  • MSEG.LGTYP == T301.LGTYP
Vendor's account number
  • MSEG.MANDT == LFA1.MANDT
  • MSEG.LIFNR == LFA1.LIFNR
Unit of Measure From Delivery Note
  • MSEG.MANDT == T006.MANDT
  • MSEG.LSMEH == T006.MSEHI
Material Number
  • Material Number
  • Client
  • MSEG.MATNR == MARA.MATNR
  • MSEG.MANDT == MARA.MANDT
Base Unit of Measure
  • MSEG.MANDT == T006.MANDT
  • MSEG.MEINS == T006.MSEHI
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • MSEG.MANDT == T007A.MANDT
  • MSEG.[column in domain "KALSM_D"] == T007A.KALSM
  • MSEG.MWSKZ == T007A.MWSKZ
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • MSEG.NPLNR == AUFK.AUFNR
  • MSEG.MANDT == AUFK.MANDT
Clearing company code
  • MSEG.MANDT == T001.MANDT
  • MSEG.PARBU == T001.BUKRS
Trading partner's business area
  • MSEG.MANDT == TGSB.MANDT
  • MSEG.PARGB == TGSB.GSBER
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • MSEG.[column in domain "KTOPL"] == SKA1.KTOPL
  • MSEG.MANDT == SKA1.MANDT
  • MSEG.SAKTO == SKA1.SAKNR
Special Stock Indicator
  • MSEG.MANDT == T148.MANDT
  • MSEG.SOBKZ == T148.SOBKZ
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • MSEG.MANDT == TTXJ.MANDT
  • MSEG.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • MSEG.TXJCD == TTXJ.TXJCD
Valuation Type of Transfer Batch
  • MSEG.MANDT == T149D.MANDT
  • MSEG.UMBAR == T149D.BWTAR
Receiving/Issuing Batch
  • Receiving/Issuing Material
  • Receiving/Issuing Batch
  • Receiving plant/issuing plant
  • MSEG.MANDT == MCHA.MANDT
  • MSEG.UMMAT == MCHA.MATNR
  • MSEG.UMCHA == MCHA.CHARG
  • MSEG.UMWRK == MCHA.WERKS
Receiving/issuing storage location
  • Receiving/issuing storage location
  • Client
  • Receiving plant/issuing plant
  • MSEG.UMLGO == T001L.LGORT
  • MSEG.MANDT == T001L.MANDT
  • MSEG.UMWRK == T001L.WERKS
Receiving/Issuing Material
  • Receiving/Issuing Material
  • Client
  • MSEG.UMMAT == MARA.MATNR
  • MSEG.MANDT == MARA.MANDT
Special stock indicator for physical stock transfer
  • MSEG.MANDT == T148.MANDT
  • MSEG.UMSOK == T148.SOBKZ
Receiving plant/issuing plant
  • MSEG.MANDT == T001W.MANDT
  • MSEG.UMWRK == T001W.WERKS
Partner account number
  • MSEG.MANDT == KNA1.MANDT
  • MSEG.VPTNR == KNA1.KUNNR
Currency Key
  • MSEG.MANDT == TCURC.MANDT
  • MSEG.WAERS == TCURC.WAERS
Plant
  • MSEG.MANDT == T001W.MANDT
  • MSEG.WERKS == T001W.WERKS