MSEG

Document Segment: Material

Explore another table

Enter a table code or keyword to continue exploring.

The SAP table MSEG is a critical component within the SAP system, primarily used for storing detailed information about material document items. It functions as an integral part of inventory management and material valuation, capturing all transaction data related to goods movements, including goods receipts, goods issues, stock transfers, and physical inventory counts. Each entry in MSEG records specific details such as material number, plant, storage location, movement type, quantity, and valuation type, allowing for comprehensive tracking and auditing of inventory changes across various processes in the supply chain. This table is essential for ensuring accurate and real-time inventory management, financial accounting, and reporting within the SAP environment.

SAP table MSEG has 4 primary key fields: MANDT,MBLNR,MJAHR,ZEILE.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

MSEG fields.

228 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 MANDT
Key MBLNR Number of Material DocumentCHAR100 MBLNR
Key MJAHR Material Document YearNUMC40 MJAHR
Key ZEILE Item in Material DocumentNUMC40 MBLPO
LINE_ID Unique identification of document lineNUMC60 MB_LINE_ID
PARENT_ID Identifier of immediately superior lineNUMC60 MB_PARENT_ID
LINE_DEPTH Hierarchy level of line in documentNUMC20 MB_LINE_DEPTH
MAA_URZEI Original Line for Account Assignment Item in Material Doc.NUMC40 MAA_URZEI
BWART Movement type (inventory management)CHAR30 T156 BWART
XAUTO Item automatically createdCHAR10 MB_XAUTO
MATNR Material NumberCHAR400 MARA MATNR
WERKS PlantCHAR40 T001W WERKS_D
LGORT Storage locationCHAR40 T001L LGORT_D
CHARG Batch NumberCHAR100 MCHA CHARG_D
INSMK Stock TypeCHAR10 MB_INSMK
ZUSCH Batch status keyCHAR10 DZUSCH
ZUSTD Batch in Restricted-Use StockCHAR10 DZUSTD
SOBKZ Special Stock IndicatorCHAR10 T148 SOBKZ
LIFNR Vendor's account numberCHAR100 LFA1 ELIFN
KUNNR Account number of customerCHAR100 KNA1 EKUNN
KDAUF Sales Order NumberCHAR100 VBAK KDAUF
KDPOS Item number in Sales OrderNUMC60 KDPOS
KDEIN Delivery schedule for sales orderNUMC40 KDEIN
PLPLA Distribution of DifferencesCHAR100 PLPLA
SHKZG Debit/Credit IndicatorCHAR10 SHKZG
WAERS Currency KeyCUKY50 TCURC WAERS
DMBTR Amount in Local CurrencyCURR132 DMBTR_CS
BNBTR Delivery costs in local currencyCURR132 BNBTR
BUALT Amount Posted in Alternative Price ControlCURR132 BUALT
SHKUM Debit/credit indicator in revaluationCHAR10 SHKUM
DMBUM Revaluation amount on back-posting to a previous periodCURR132 DMBUM
BWTAR Valuation TypeCHAR100 T149D BWTAR_D
MENGE QuantityQUAN133 MENGE_D
MEINS Base Unit of MeasureUNIT30 T006 MEINS
ERFMG Quantity in unit of entryQUAN133 ERFMG
ERFME Unit of entryUNIT30 T006 ERFME
BPMNG Quantity in Purchase Order Price UnitQUAN133 BPMNG
BPRME Order Price Unit (Purchasing)UNIT30 T006 BBPRM
EBELN Purchase order numberCHAR100 EKKO BSTNR
EBELP Item Number of Purchasing DocumentNUMC50 EKPO EBELP
LFBJA Fiscal Year of a Reference DocumentNUMC40 LFBJA
LFBNR Document No. of a Reference DocumentCHAR100 LFBNR
LFPOS Item of a Reference DocumentNUMC40 LFPOS
SJAHR Material Document YearNUMC40 MJAHR
SMBLN Number of Material DocumentCHAR100 MBLNR
SMBLP Item in Material DocumentNUMC40 MBLPO
ELIKZ "Delivery Completed" IndicatorCHAR10 ELIKZ
SGTXT Item TextCHAR500 SGTXT
EQUNR Equipment NumberCHAR180 EQUNR
WEMPF Goods RecipientCHAR120 WEMPF
ABLAD Unloading PointCHAR250 ABLAD
GSBER Business AreaCHAR40 TGSB GSBER
KOKRS Controlling AreaCHAR40 TKA01 KOKRS
PARGB Trading partner's business areaCHAR40 TGSB PARGB
PARBU Clearing company codeCHAR40 T001 PARBU
KOSTL Cost CenterCHAR100 CSKS KOSTL
PROJN Old: Project number : No longer used --> PS_POSNRCHAR160 PROJN
AUFNR Order NumberCHAR120 AUFK AUFNR
ANLN1 Main Asset NumberCHAR120 ANLH ANLN1
ANLN2 Asset SubnumberCHAR40 ANLA ANLN2
XSKST Indicator: Statistical Posting to Cost CenterCHAR10 XSKST
XSAUF Indicator: Posting to Order Is StatisticalCHAR10 XSAUF
XSPRO Indicator: Posting to Project Is StatisticalCHAR10 XSPRO
XSERG Indicator: Posting to Profitability Analysis Is StatisticalCHAR10 XSERG
GJAHR Fiscal YearNUMC40 GJAHR
XRUEM Allow Posting to Previous Period (Backposting)CHAR10 XRUEM
XRUEJ Indicator: post to previous yearCHAR10 XRUEJ
BUKRS Company CodeCHAR40 T001 BUKRS
BELNR Document Number of an Accounting DocumentCHAR100 BELNR_D
BUZEI Number of Line Item Within Accounting DocumentNUMC30 BUZEI
BELUM Document Number of an Accounting DocumentCHAR100 BELNR_D
BUZUM Number of Line Item Within Accounting DocumentNUMC30 BUZEI
RSNUM Number of reservation/dependent requirementsNUMC100 RSNUM
RSPOS Item Number of Reservation / Dependent RequirementsNUMC40 RSPOS
KZEAR Final Issue for ReservationCHAR10 KZEAR
PBAMG QuantityQUAN133 MENGE_D
KZSTR Transaction/event is relevant to statisticsCHAR10 KZSTR
UMMAT Receiving/Issuing MaterialCHAR400 MARA UMMAT
UMWRK Receiving plant/issuing plantCHAR40 T001W UMWRK
UMLGO Receiving/issuing storage locationCHAR40 T001L UMLGO
UMCHA Receiving/Issuing BatchCHAR100 MCHA UMCHA
UMZST Status of Transfer BatchCHAR10 UMZST
UMZUS Status key of transfer batchCHAR10 UMZUS
UMBAR Valuation Type of Transfer BatchCHAR100 T149D UMBAR
UMSOK Special stock indicator for physical stock transferCHAR10 T148 UMSOK
KZBEW Movement IndicatorCHAR10 KZBEW
KZVBR Consumption postingCHAR10 KZVBR
KZZUG Receipt IndicatorCHAR10 KZZUG
WEUNB Goods Receipt, Non-ValuatedCHAR10 WEUNB
PALAN WMS Number of palletsDEC110 PALAN
LGNUM Warehouse Number / Warehouse ComplexCHAR30 T300 LGNUM
LGTYP Storage TypeCHAR30 T301 LGTYP
LGPLA Storage BinCHAR100 LAGP LGPLA
BESTQ Stock Category in the Warehouse Management SystemCHAR10 BESTQ
BWLVS Movement Type for Warehouse ManagementNUMC30 T333 BWLVS
TBNUM Transfer Requirement NumberNUMC100 LTBK TBNUM
TBPOS Transfer Requirement ItemNUMC40 TBPOS
XBLVS Indicator: posting in warehouse management systemCHAR10 XBLVS
VSCHN Ind: interim storage posting for source stor.type and binCHAR10 T333_VSCHN
NSCHN Ind.: interim storage posting for dest.stor.type and binCHAR10 T333_NSCHN
DYPLA Indicator: dynamic storage binCHAR10 DYPLA
UBNUM Posting Change NumberNUMC100 UBNUM
TBPRI Transfer PriorityCHAR10 TBPRI
TANUM Transfer Order NumberNUMC100 TANUM
WEANZ Number of GR/GI Slips to Be PrintedNUMC30 WEANZ
GRUND Reason for MovementNUMC40 T157D MB_GRBEW
EVERS Shipping InstructionsCHAR20 T027A EVERS
EVERE Compliance with Shipping InstructionsCHAR20 T027C EVERE
IMKEY Internal Key for Real Estate ObjectCHAR80 IMKEY
KSTRG Cost ObjectCHAR120 KSTRG
PAOBJNR Profitability Segment Number (CO-PA)NUMC100 RKEOBJNR
PRCTR Profit CenterCHAR100 PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element)NUMC80 PS_PSP_PNR
NPLNR Network Number for Account AssignmentCHAR120 AUFK NPLNR
AUFPL Routing number of operations in the orderNUMC100 CO_AUFPL
APLZL Internal counterNUMC80 CIM_COUNT
AUFPS Order item numberNUMC40 CO_POSNR
VPTNR Partner account numberCHAR100 KNA1 JV_PART
FIPOS Commitment ItemCHAR140 FMFPO FIPOS
SAKTO G/L Account NumberCHAR100 SKA1 SAKNR
BSTMG Goods receipt quantity in order unitQUAN133 MB_BSTMG
BSTME Purchase Order Unit of MeasureUNIT30 BSTME
XWSBR Reversal of GR allowed for GR-based IV despite invoiceCHAR10 XWSBR
EMLIF Supplier to be Supplied/Who is to Receive DeliveryCHAR100 EMLIF
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
EXBWR Externally Entered Posting Amount in Local CurrencyCURR132 EXBWR
VKWRT Value at Sales Prices Including Value-Added TaxCURR132 VKWRT
AKTNR PromotionCHAR100 WAKTION
ZEKKN Sequential Number of Account AssignmentNUMC20 DZEKKN
VFDAT Shelf Life Expiration or Best-Before DateDATS80 VFDAT
CUOBJ_CH Internal object number of the batch classificationNUMC180 CUOBJ_CH
EXVKW Externally Entered Sales Value in Local CurrencyCURR132 EXVKW
PPRCTR Partner Profit CenterCHAR100 PPRCTR
RSART Record typeCHAR10 RSART
GEBER FundCHAR100 BP_GEBER
FISTL Funds CenterCHAR160 FISTL
MATBF Material in Respect of Which Stock is ManagedCHAR400 MATBF
UMMAB Receiving/Issuing MaterialCHAR400 UMMAT
BUSTM Posting string for quantitiesCHAR40 BUSTM
BUSTW Posting String for ValuesCHAR40 BUSTW
MENGU Quantity Updating in Material Master RecordCHAR10 MENGU
WERTU Value Updating in Material Master RecordCHAR10 WERTU
LBKUM Total valuated stock before the postingQUAN133 LBKUM_MSEG
SALK3 Value of total valuated stock before the postingCURR132 SALK3_MSEG
VPRSV Price control indicatorCHAR10 VPRSV
FKBER Functional AreaCHAR160 FKBER
DABRBZ Reference date for settlementDATS80 DABRBEZ
VKWRA Value at Sales Prices Excluding Value Added TaxCURR132 VKWRA
DABRZ Reference date for settlementDATS80 DABRBEZ
XBEAU Purchase order created at time of goods receiptCHAR10 XBEAU
LSMNG Quantity in Unit of Measure from Delivery NoteQUAN133 LSMNG
LSMEH Unit of Measure From Delivery NoteUNIT30 T006 LSMEH
KZBWS Valuation of Special StockCHAR10 KZBWS
QINSPST Status of Goods Receipt InspectionCHAR10 QINSPST
URZEI Original line in material documentNUMC40 URZEI
J_1BEXBASE Alternate base amount in document currencyCURR132 J_1BEXBASE
MWSKZ Tax on sales/purchases codeCHAR20 T007A MWSKZ
TXJCD Tax JurisdictionCHAR150 TTXJ TXJCD
EMATN Material number corresponding to manufacturer part numberCHAR400 EMATN
J_1AGIRUPD Goods issue revaluation performedCHAR10 J_1AGIRUPD
VKMWS Tax on sales/purchases codeCHAR20 MWSKZ
HSDAT Date of ManufactureDATS80 HSDAT
BERKZ Material Staging Indicator for Production SupplyCHAR10 BERKZ
MAT_KDAUF Sales order number of valuated sales order stockCHAR100 MAT_KDAUF
MAT_KDPOS Sales Order Item of Valuated Sales Order StockNUMC60 MAT_KDPOS
MAT_PSPNR Valuated Sales Order Stock WBS ElementNUMC80 MAT_PSPNR
XWOFF Calculation of val. openCHAR10 XWOFF
BEMOT Accounting IndicatorCHAR20 TBMOT BEMOT
PRZNR Business ProcessCHAR120 CO_PRZNR
LLIEF Goods SupplierCHAR100 LLIEF
LSTAR Activity TypeCHAR60 LSTAR
XOBEW Vendor Stock Valuation IndicatorCHAR10 XOBEW
GRANT_NBR GrantCHAR200 GM_GRANT_NBR
ZUSTD_T156M Stock Type Modification (Read from Table T156M)CHAR10 BAMOK_MSEG
SPE_GTS_STOCK_TY GTS Stock TypeCHAR10 /SPE/GTS_STOCK_TYPE
KBLNR Document Number for Earmarked FundsCHAR100 KBLNR_FI
KBLPOS Earmarked Funds: Document ItemNUMC30 KBLPOS
XMACC Multiple Account AssignmentCHAR10 XMACC
VGART_MKPF Transaction/Event TypeCHAR20 VGART
BUDAT_MKPF Posting Date in the DocumentDATS80 BUDAT
CPUDT_MKPF Day On Which Accounting Document Was EnteredDATS80 CPUDT
CPUTM_MKPF Time of EntryTIMS60 CPUTM
USNAM_MKPF User NameCHAR120 USNAM
XBLNR_MKPF Reference Document NumberCHAR160 XBLNR1
TCODE2_MKPF Transaction CodeCHAR200 TCODE
VBELN_IM DeliveryCHAR100 VBELN_VL
VBELP_IM Delivery ItemNUMC60 POSNR_VL
SGT_SCAT Stock SegmentCHAR400 SGT_SCAT
SGT_UMSCAT Receiving/Issuing Stock SegmentCHAR400 SGT_UMSCAT
SGT_RCAT Requirement SegmentCHAR400 SGT_RCAT
SERVICEPERFORMER Service PerformerCHAR100 * SERVICEPERFORMER
PERNR Personnel NumberNUMC80 PERNR_D
KNTTP_GR Account Assignment CategoryCHAR10 * KNTTP
WORK_ITEM_ID Work Item IDCHAR100 /CPD/PFP_WORKITEM_ID
FBUDA Date on which services are renderedDATS80 FBUDA
XPRINT Print via Output ControlCHAR10 XNAPR
/CWM/MENGE Quantity in Parallel Unit of MeasureQUAN133 /CWM/MENGE
/CWM/MEINS Parallel Unit of MeasureUNIT30 * /CWM/MEINS
/CWM/ERFMG Quantity in Parallel Unit of EntryQUAN133 /CWM/ERFMG
/CWM/ERFME PUoM Entry Unit of MeasureUNIT30 * /CWM/ERFME
SERVICE_DOC_TYPE Service Document TypeCHAR40 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document IDCHAR100 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item IDNUMC60 FCO_SRVDOC_ITEM_ID
EWM_LGNUM Warehouse Number/Warehouse ComplexCHAR40 /SCWM/LGNUM
EWM_GMDOC Warehouse Document for Goods MovementNUMC120 /SCWM/DE_GM_DOC
RESOURCENAME_SID Resource Name (Stock Identifier)CHAR400 NSDM_RESOURCENAME_SID
RESOURCENAME_CID Resource Name (Stock Identifier Complement)CHAR400 NSDM_RESOURCENAME_CID
DUMMY_MATDOC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
DISUB_OWNER Owner of stockCHAR100 * OWNER_D
FSH_SEASON_YEAR Season YearCHAR40 FSH_SAISJ
FSH_SEASON SeasonCHAR100 FSH_SAISO
FSH_COLLECTION Fashion CollectionCHAR100 * FSH_COLLECTION
FSH_THEME Fashion ThemeCHAR100 FSH_THEME
FSH_UMSEA_YR Receiving/Issuing Season YearCHAR40 FSH_UMSEA_YR
FSH_UMSEA Receiving/Issuing SeasonCHAR100 FSH_UMSEA
FSH_UMCOLL Receiving/Issuing CollectionCHAR100 * FSH_UMCOLL
FSH_UMTHEME Receiving/Issuing ThemeCHAR100 FSH_UMTHEME
SGT_CHINT Discrete Batch Number [Obsolete]CHAR10 SGT_CHINT
COMPL_MARK Completed indicatorCHAR10 COMPL_MARK
FZGLS_MARK Do Not Adjust Cumulative Received QuantityCHAR10 FZGLS
ETANP_MARK Adjust Open Quantity in Scheduling Agreement ItemCHAR10 ETANP
POPUP_MARK Display Dialog BoxCHAR10 POPUP
OINAVNW Non-deductible input taxCURR132 NAVNW
OICONDCOD Joint Venture Indicator (Condition Key)CHAR20 * JV_CONDCOD
CONDI Joint Venture Indicator (Condition Key)CHAR20 * JV_CONDCOD
WRF_CHARSTC1 Characteristic Value 1CHAR180 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2CHAR180 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3CHAR180 WRF_CHARSTC3

MSEG relationships.

90 relationships
TableFieldCheck tableDescriptionCheck field
MSEGANLN1ANLHMain asset numberBUKRS
MSEGANLN1ANLHMain asset numberANLN1
MSEGANLN2ANLAAsset Master Record SegmentBUKRS
MSEGANLN2ANLAAsset Master Record SegmentANLN1
MSEGANLN2ANLAAsset Master Record SegmentANLN2
MSEGAUFNRAUFKOrder master dataAUFNR
MSEGBEMOTTBMOTAccounting indicatorsMANDT
MSEGBEMOTTBMOTAccounting indicatorsBEMOT
MSEGBPRMET006Units of MeasurementMANDT
MSEGBUKRST001Company CodesBUKRS
MSEGBWARTT156Movement TypeMANDT
MSEGBWARTT156Movement TypeBWART
MSEGBWLVST333WM Movement TypesMANDT
MSEGBWLVST333WM Movement TypesLGNUM
MSEGBWTART149DGlobal Valuation TypesMANDT
MSEGBWTART149DGlobal Valuation TypesBWTAR
MSEGCHARGMCHABatchesMANDT
MSEGCHARGMCHABatchesWERKS
MSEGCHARGMCHABatchesCHARG
MSEGEBELNEKKOPurchasing Document HeaderEBELN
MSEGEBELPEKPOPurchasing Document ItemMANDT
MSEGEBELPEKPOPurchasing Document ItemEBELN
MSEGERFMET006Units of MeasurementMANDT
MSEGEVERET027CCodes for Compliance with Shipping InstructionsEVERE
MSEGEVERST027AShipping Instructions, PurchasingEVERS
MSEGFIPOSFMFPOFIFM: Commitment ItemMANDT
MSEGFIPOSFMFPOFIFM: Commitment ItemFIKRS
MSEGFIPOSFMFPOFIFM: Commitment ItemDATBIS
MSEGGRUNDT157DReason for MovementMANDT
MSEGGSBERTGSBBusiness AreasMANDT
MSEGGSBERTGSBBusiness AreasGSBER
MSEGKDAUFVBAKSales Document: Header DataMANDT
MSEGKDAUFVBAKSales Document: Header DataVBELN
MSEGKOKRSTKA01Controlling AreasMANDT
MSEGKOSTLCSKSCost Center Master RecordMANDT
MSEGKOSTLCSKSCost Center Master RecordKOKRS
MSEGKOSTLCSKSCost Center Master RecordKOSTL
MSEGKOSTLCSKSCost Center Master RecordDATBI
MSEGKUNNRKNA1General Data in Customer MasterMANDT
MSEGKUNNRKNA1General Data in Customer MasterKUNNR
MSEGLGNUMT300WM Warehouse NumbersMANDT
MSEGLGNUMT300WM Warehouse NumbersLGNUM
MSEGLGORTT001LStorage LocationsMANDT
MSEGLGORTT001LStorage LocationsWERKS
MSEGLGPLALAGPStorage binsMANDT
MSEGLGPLALAGPStorage binsLGNUM
MSEGLGPLALAGPStorage binsLGPLA
MSEGLGTYPT301WM Storage TypesMANDT
MSEGLGTYPT301WM Storage TypesLGNUM
MSEGLGTYPT301WM Storage TypesLGTYP
MSEGLIFNRLFA1Supplier Master (General Section)MANDT
MSEGLIFNRLFA1Supplier Master (General Section)LIFNR
MSEGLSMEHT006Units of MeasurementMANDT
MSEGMATNRMARAGeneral Material DataMANDT
MSEGMATNRMARAGeneral Material DataMATNR
MSEGMEINST006Units of MeasurementMANDT
MSEGMEINST006Units of MeasurementMSEHI
MSEGMWSKZT007ATax KeysKALSM
MSEGMWSKZT007ATax KeysMWSKZ
MSEGNPLNRAUFKOrder master dataAUFNR
MSEGPARBUT001Company CodesBUKRS
MSEGPARGBTGSBBusiness AreasMANDT
MSEGPARGBTGSBBusiness AreasGSBER
MSEGSAKTOSKA1G/L Account Master (Chart of Accounts)MANDT
MSEGSAKTOSKA1G/L Account Master (Chart of Accounts)KTOPL
MSEGSAKTOSKA1G/L Account Master (Chart of Accounts)SAKNR
MSEGSOBKZT148Special Stock IndicatorMANDT
MSEGSOBKZT148Special Stock IndicatorSOBKZ
MSEGTBNUMLTBKTransfer requirement headerMANDT
MSEGTBNUMLTBKTransfer requirement headerLGNUM
MSEGTXJCDTTXJCheck Table for Tax JurisdictionMANDT
MSEGTXJCDTTXJCheck Table for Tax JurisdictionKALSM
MSEGUMBART149DGlobal Valuation TypesMANDT
MSEGUMBART149DGlobal Valuation TypesBWTAR
MSEGUMCHAMCHABatchesMANDT
MSEGUMCHAMCHABatchesWERKS
MSEGUMCHAMCHABatchesCHARG
MSEGUMLGOT001LStorage LocationsMANDT
MSEGUMLGOT001LStorage LocationsWERKS
MSEGUMMATMARAGeneral Material DataMANDT
MSEGUMMATMARAGeneral Material DataMATNR
MSEGUMSOKT148Special Stock IndicatorMANDT
MSEGUMSOKT148Special Stock IndicatorSOBKZ
MSEGUMWRKT001WPlants/BranchesWERKS
MSEGVPTNRKNA1General Data in Customer MasterMANDT
MSEGVPTNRKNA1General Data in Customer MasterKUNNR
MSEGWAERSTCURCCurrency CodesMANDT
MSEGWAERSTCURCCurrency CodesWAERS
MSEGWERKST001WPlants/BranchesMANDT
MSEGWERKST001WPlants/BranchesWERKS