Menu

SAP Table MSEG

Document Segment: Material

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table MSEG (Document Segment: Material) is a standard table in SAP ERP. It belongs to the package MB.

Technical Information

Table MSEG
Short Text Document Segment: Material
Package MB
Table Type Transparent Table

Fields for Table MSEG

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
MBLNR Number of Material Document MBLNR CHAR 10
MJAHR Material Document Year MJAHR NUMC 4
ZEILE Item in Material Document MBLPO NUMC 4
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6
PARENT_ID Identifier of immediately superior line MB_PARENT_ID NUMC 6
LINE_DEPTH Hierarchy level of line in document MB_LINE_DEPTH NUMC 2
MAA_URZEI Original Line for Account Assignment Item in Material Doc. MAA_URZEI NUMC 4
BWART Movement Type (Inventory Management) BWART CHAR 3 T156
XAUTO Item automatically created MB_XAUTO CHAR 1
MATNR Material Number MATNR CHAR 18 MARA
WERKS Plant WERKS_D CHAR 4 T001W
LGORT Storage Location LGORT_D CHAR 4 T001L
CHARG Batch Number CHARG_D CHAR 10 MCHA
INSMK Stock Type MB_INSMK CHAR 1
ZUSCH Batch status key DZUSCH CHAR 1
ZUSTD Batch in Restricted-Use Stock DZUSTD CHAR 1
SOBKZ Special Stock Indicator SOBKZ CHAR 1 T148
LIFNR Vendor Account Number ELIFN CHAR 10 LFA1
KUNNR Account Number of Customer EKUNN CHAR 10 KNA1
KDAUF Sales Order Number KDAUF CHAR 10 VBUK
KDPOS Item Number in Sales Order KDPOS NUMC 6
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4
PLPLA Distribution of Differences PLPLA CHAR 10
SHKZG Debit/Credit Indicator SHKZG CHAR 1
WAERS Currency Key WAERS CUKY 5 TCURC
DMBTR Amount in Local Currency DMBTR CURR 13
BNBTR Delivery costs in local currency BNBTR CURR 13
BUALT Amount posted in alternative price control BUALT CURR 13
SHKUM Debit/credit indicator in revaluation SHKUM CHAR 1
DMBUM Revaluation amount on back-posting to a previous period DMBUM CURR 13
BWTAR Valuation Type BWTAR_D CHAR 10 T149D
MENGE Quantity MENGE_D QUAN 13
MEINS Base Unit of Measure MEINS UNIT 3 T006
ERFMG Quantity in Unit of Entry ERFMG QUAN 13
ERFME Unit of Entry ERFME UNIT 3 T006
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13
BPRME Order Price Unit (Purchasing) BBPRM UNIT 3 T006
EBELN Purchase Order Number BSTNR CHAR 10 EKKO
EBELP Item Number of Purchasing Document EBELP NUMC 5 EKPO
LFBJA Fiscal Year of a Reference Document LFBJA NUMC 4
LFBNR Document No. of a Reference Document LFBNR CHAR 10
LFPOS Item of a Reference Document LFPOS NUMC 4
SJAHR Material Document Year MJAHR NUMC 4
SMBLN Number of Material Document MBLNR CHAR 10
SMBLP Item in Material Document MBLPO NUMC 4
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1
SGTXT Item Text SGTXT CHAR 50
EQUNR Equipment Number EQUNR CHAR 18 *
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12
ABLAD Unloading Point ABLAD CHAR 25
GSBER Business Area GSBER CHAR 4 TGSB
KOKRS Controlling Area KOKRS CHAR 4 TKA01
PARGB Trading partner's business area PARGB CHAR 4 TGSB
PARBU Clearing company code PARBU CHAR 4 T001
KOSTL Cost Center KOSTL CHAR 10 CSKS
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16
AUFNR Order Number AUFNR CHAR 12 AUFK
ANLN1 Main Asset Number ANLN1 CHAR 12 ANLH
ANLN2 Asset Subnumber ANLN2 CHAR 4 ANLA
XSKST Indicator: Statistical posting to cost center XSKST CHAR 1
XSAUF Indicator: Posting to order is statistical XSAUF CHAR 1
XSPRO Indicator: Posting to project is statistical XSPRO CHAR 1
XSERG Indicator: Posting to prof.analysis is statistical XSERG CHAR 1
GJAHR Fiscal Year GJAHR NUMC 4
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1
XRUEJ Indicator: post to previous year XRUEJ CHAR 1
BUKRS Company Code BUKRS CHAR 4 T001
BELNR Accounting Document Number BELNR_D CHAR 10
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3
BELUM Accounting Document Number BELNR_D CHAR 10
BUZUM Number of Line Item Within Accounting Document BUZEI NUMC 3
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 *
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4
KZEAR Final Issue for This Reservation KZEAR CHAR 1
PBAMG Quantity MENGE_D QUAN 13
KZSTR Transaction/event is relevant to statistics KZSTR CHAR 1
UMMAT Receiving/Issuing Material UMMAT CHAR 18 MARA
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 T001W
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 T001L
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 MCHA
UMZST Status of Transfer Batch UMZST CHAR 1
UMZUS Status key of transfer batch UMZUS CHAR 1
UMBAR Valuation Type of Transfer Batch UMBAR CHAR 10 T149D
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 T148
KZBEW Movement Indicator KZBEW CHAR 1
KZVBR Consumption Posting KZVBR CHAR 1
KZZUG Receipt Indicator KZZUG CHAR 1
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1
PALAN WMS Number of pallets PALAN DEC 11
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 T300
LGTYP Storage Type LGTYP CHAR 3 T301
LGPLA Storage Bin LGPLA CHAR 10 LAGP
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1
BWLVS Movement Type for Warehouse Management BWLVS NUMC 3 T333
TBNUM Transfer Requirement Number TBNUM NUMC 10 LTBK
TBPOS Transfer Requirement Item TBPOS NUMC 4
XBLVS Indicator: posting in warehouse management system XBLVS CHAR 1
VSCHN Ind: interim storage posting for source stor.type and bin T333_VSCHN CHAR 1
NSCHN Ind.: interim storage posting for dest.stor.type and bin T333_NSCHN CHAR 1
DYPLA Indicator: dynamic storage bin DYPLA CHAR 1
UBNUM Posting Change Number UBNUM NUMC 10
TBPRI Transfer Priority TBPRI CHAR 1
TANUM Transfer Order Number TANUM NUMC 10
WEANZ Number of GR/GI Slips to Be Printed WEANZ NUMC 3
GRUND Reason for Movement MB_GRBEW NUMC 4 T157D
EVERS Shipping Instructions EVERS CHAR 2 T027A
EVERE Compliance with Shipping Instructions EVERE CHAR 2 T027C
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8
KSTRG Cost Object KSTRG CHAR 12 *
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10
PRCTR Profit Center PRCTR CHAR 10 *
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 *
NPLNR Network Number for Account Assignment NPLNR CHAR 12 AUFK
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10
APLZL Internal counter CIM_COUNT NUMC 8
AUFPS Order Item Number CO_POSNR NUMC 4
VPTNR Partner account number JV_PART CHAR 10 KNA1
FIPOS Commitment Item FIPOS CHAR 14 FMFPO
SAKTO G/L Account Number SAKNR CHAR 10 SKA1
BSTMG Goods receipt quantity in order unit MB_BSTMG QUAN 13
BSTME Purchase Order Unit of Measure BSTME UNIT 3 *
XWSBR Reversal of GR allowed for GR-based IV despite invoice XWSBR CHAR 1
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 *
EXBWR Externally Entered Posting Amount in Local Currency EXBWR CURR 13
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13
PPRCTR Partner Profit Center PPRCTR CHAR 10 *
RSART Record type RSART CHAR 1
GEBER Fund BP_GEBER CHAR 10 *
FISTL Funds Center FISTL CHAR 16 *
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 *
UMMAB Receiving/Issuing Material UMMAT CHAR 18 *
BUSTM Posting string for quantities BUSTM CHAR 4
BUSTW Posting string for values BUSTW CHAR 4
MENGU Quantity Updating in Material Master Record MENGU CHAR 1
WERTU Value Update in Material Master Record WERTU CHAR 1
LBKUM Total valuated stock before the posting LBKUM_MSEG QUAN 13
SALK3 Value of total valuated stock before the posting SALK3_MSEG CURR 13
VPRSV Price control indicator VPRSV CHAR 1
FKBER Functional Area FKBER CHAR 16 *
DABRBZ Reference Date for Settlement DABRBEZ DATS 8
VKWRA Value at sales prices excluding value-added tax VKWRA CURR 13
DABRZ Reference Date for Settlement DABRBEZ DATS 8
XBEAU Purchase order created at time of goods receipt XBEAU CHAR 1
LSMNG Quantity in Unit of Measure from Delivery Note LSMNG QUAN 13
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 T006
KZBWS Valuation of Special Stock KZBWS CHAR 1
QINSPST Status of Goods Receipt Inspection QINSPST CHAR 1
URZEI Original line in material document URZEI NUMC 4
J_1BEXBASE Alternate base amount in document currency J_1BEXBASE CURR 13
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 T007A
TXJCD Tax Jurisdiction TXJCD CHAR 15 TTXJ
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 *
J_1AGIRUPD Goods issue revaluation performed J_1AGIRUPD CHAR 1
VKMWS Tax on sales/purchases code MWSKZ CHAR 2 *
HSDAT Date of Manufacture HSDAT DATS 8
BERKZ Material Staging Indicator for Production Supply BERKZ CHAR 1
MAT_KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 *
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 *
XWOFF Calculation of val. open XWOFF CHAR 1
BEMOT Accounting Indicator BEMOT CHAR 2 TBMOT
PRZNR Business Process CO_PRZNR CHAR 12 *
LLIEF Supplying Vendor LLIEF CHAR 10 *
LSTAR Activity Type LSTAR CHAR 6 *
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1
GRANT_NBR Grant GM_GRANT_NBR CHAR 20
ZUSTD_T156M Stock Type Modification (Read from Table T156M) BAMOK_MSEG CHAR 1
SPE_GTS_STOCK_TY GTS Stock Type /SPE/GTS_STOCK_TYPE CHAR 1
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 *
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 *
XMACC Multiple Account Assignment XMACC CHAR 1
VGART_MKPF Transaction/Event Type VGART CHAR 2 *
BUDAT_MKPF Posting Date in the Document BUDAT DATS 8
CPUDT_MKPF Day On Which Accounting Document Was Entered CPUDT DATS 8
CPUTM_MKPF Time of Entry CPUTM TIMS 6
USNAM_MKPF User name USNAM CHAR 12 *
XBLNR_MKPF Reference Document Number XBLNR CHAR 16
TCODE2_MKPF Transaction Code TCODE CHAR 20 *
VBELN_IM Delivery VBELN_VL CHAR 10 *
VBELP_IM Delivery Item POSNR_VL NUMC 6 *
/BEV2/ED_KZ_VER Processing Status of Material Document for Excise Duties /BEV2/EDKZ_VER CHAR 1
/BEV2/ED_USER User name USNAM CHAR 12 *
/BEV2/ED_AEDAT Changed On AEDAT DATS 8
/BEV2/ED_AETIM System Time SYUZEIT TIMS 6
DISUB_OWNER Owner of stock OWNER_D CHAR 10 *
COMPL_MARK Completed indicator COMPL_MARK CHAR 1
FZGLS_MARK Do Not Adjust Cumulative Received Quantity FZGLS CHAR 1
ETANP_MARK Adjust Open Quantity in Scheduling Agreement Item ETANP CHAR 1
POPUP_MARK Display Dialog Box POPUP CHAR 1
OINAVNW Non-deductible input tax NAVNW CURR 13
OICONDCOD Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 *
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 *
OIKNUMV Number of the document condition KNUMV CHAR 10
OIEXGPTR Exchange partner (vendor number) OIA_EXGPTR CHAR 10 *
OIMATPST Posting rules for material OIA_MATPST CHAR 1
OIMATIE Material internal / external posting indicator OIA_MATIE CHAR 1
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 *
OIFEETOT Fee total OIA_FEETOT CURR 13
OIFEEPST Posting rules for fees OIA_FEEPST CHAR 1
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 *
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 T008
OIJ1BNFFIM Control Flag for Nota Fiscal creation (Gain/Loss) OIH_J1B_NFFI CHAR 1
OITRKNR Tracking number OIH_TRKNR CHAR 10
OITRKJR Tracking number year OIH_TRKJR NUMC 4
OIEXTNR External tracking number OIH_EXTNR CHAR 18
OIITMNR Tracking number item line OIH_ITMNR NUMC 5
OIFTIND Final transfer indicator OIH_FTIND CHAR 1
OIPRIOP Price options for gain calculation OIH_PRIOP CHAR 1
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1
OIGHNDL Gain handling OIH_GHNDL CHAR 1
OIUMBAR Valuation type of issuing location for two-step transfer OIH_UMBAR CHAR 10 T149D
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3
OIBASPROD Base product number OIA_SBMAT CHAR 18 *
OIBASVAL Base product value OIA_BASVAL CURR 13
OIGLERF Quantity in Unit of Entry ERFMG QUAN 13
OIGLSKU Quantity MENGE_D QUAN 13
OIGLBPR Quantity in Purchase Order Price Unit BPMNG QUAN 13
OIGLBST Goods receipt quantity in order unit MB_BSTMG QUAN 13
OIGLCALC Debit/Credit Indicator SHKZG CHAR 1
OIBBSWQTY Additional Oil and Gas Quantity OIB_ADQNT FLTP 16
OIASTBW Reversal movement type XSTBW CHAR 1
OIVBELN Delivery VBELN_VL CHAR 10 *
OIPOSNR Delivery Item POSNR_VL NUMC 6 *
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1
OIC_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 LFA1
OIC_DCITYC Destination city code OIC_DCITYC CHAR 4 T005G
OIC_DCOUNC Destination county code OIC_DCOUNC CHAR 3 T005E
OIC_DREGIO Destination region OIC_DREGIO CHAR 3 T005S
OIC_DLAND1 Destination country OIC_DLAND1 CHAR 3 T005
OIC_OCITYC Origin city code OIC_OCITYC CHAR 4 T005G
OIC_OCOUNC Origin county code OIC_OCOUNC CHAR 3 T005E
OIC_OREGIO Origin region OIC_OREGIO CHAR 3 T005S
OIC_OLAND1 Origin country OIC_OLAND1 CHAR 3 T005
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16
OIC_PBATCH Pipeline operator´s external batch number OIC_PBATCH CHAR 16
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT CHAR 2 TVTR
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10
OIA_BASELO Base location OIA_BASELO CHAR 15
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15
OIDATFM1 Excise Duty License Valid from Date OIH_DATFM1 DATS 8
OIDATTO1 Valid to date for excise duty tax certificate OIH_DATTO1 DATS 8
OIH_LICTP License type OIH_LICTP CHAR 4 OIH20
OIH_LICIN Excise tax internal license number OIH_LICIN CHAR 10 OIHL
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL CHAR 10 OIHL
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16
OIBOMHEAD BoM header material number OIA_BOMHM CHAR 18 *
OIB_TIMESTAMP Tank dip time stamp OIB_TMSTM NUMC 14
OIB_GUID_OPEN GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32
OIB_GUID_CLOSE GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32
OIB_SOCNR SOC: Storage object characteristic segment number OII_SOCNR CHAR 20 *
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 OIH4
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 OIH4
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 OIH5
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 OIH2
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1
OIINVREC Indicator whether ED pricing is external (not used?) OIH_INVREC CHAR 1
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5
OIFUTDT Future tax date OIH_FUTDT DATS 8
OIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT UNIT 3 *
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13
OITAXGRP2 Excise Duty Group OIH_TAXGRP CHAR 2 *
OIEDBAL_GI Excise Duty Balancing is Required for Mat. (STO) OIH_EDBAL_GI CHAR 1
OIEDBALM_GI Excise Duty Balancing Method Indicator for Mat. (STO) OIH_EDBALM_GI CHAR 1
OICERTF1_GI Excise Tax External License Number Used During GI (STO) OIH_CERTF1_GI CHAR 15
OIDATFM1_GI Excise Duty License Valid from Date for Mat. (STO) OIH_DATFM1_GI DATS 8
OIDATTO1_GI Valid To Date for Excise Duty Tax Certificate for Mat. (STO) OIH_DATTO1_GI DATS 8
OIH_LICTP_GI License Type to Material (STO) OIH_LICTP_GI CHAR 4 OIH20
OIH_LICIN_GI Excise Tax Internal License Number to Mat. (STO) OIH_LICIN_GI CHAR 10 OIHL
OIH_LCFOL_GI Follow-On License for Quantity License to Mat. (STO) OIH_LCFOL_GI CHAR 10 OIHL
OIH_FOLQTY_GI Excise Tax Follow-On License Quantity to Mat. (STO) OIH_FOLQTY_GI QUAN 13
OIHANTYP_GI Excise Duty Handling Type - Denotes Use of Material OIH_HANTYP_GI CHAR 2 *