SAP Table MSEG - Document Segment: Material

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
MBLNR X MBLNR CHAR 3 10 0 Number of Material Document
MJAHR X MJAHR NUMC 13 4 0 Material Document Year
ZEILE X MBLPO NUMC 17 4 0 Item in Material Document
LINE_ID MB_LINE_ID NUMC 21 6 0 Unique identification of document line
PARENT_ID MB_PARENT_ID NUMC 27 6 0 Identifier of immediately superior line
LINE_DEPTH MB_LINE_DEPTH NUMC 33 2 0 Hierarchy level of line in document
BWART BWART CHAR 35 3 0 T156 Movement Type (Inventory Management)
XAUTO MB_XAUTO CHAR 38 1 0 Item automatically created
MATNR MATNR CHAR 39 18 0 MARA Material Number
WERKS WERKS_D CHAR 57 4 0 T001W Plant
LGORT LGORT_D CHAR 61 4 0 T001L Storage Location
CHARG CHARG_D CHAR 65 10 0 MCH1 Batch Number
INSMK MB_INSMK CHAR 75 1 0 Stock Type
ZUSCH DZUSCH CHAR 76 1 0 Batch status key
ZUSTD DZUSTD CHAR 77 1 0 Batch in Restricted-Use Stock
SOBKZ SOBKZ CHAR 78 1 0 T148 Special Stock Indicator
LIFNR ELIFN CHAR 79 10 0 LFA1 Vendor Account Number
KUNNR EKUNN CHAR 89 10 0 KNA1 Account Number of Customer
KDAUF KDAUF CHAR 99 10 0 Sales Order Number
KDPOS KDPOS NUMC 109 6 0 Item Number in Sales Order
KDEIN KDEIN NUMC 115 4 0 Delivery Schedule for Sales Order
PLPLA PLPLA CHAR 119 10 0 Distribution of Differences
SHKZG SHKZG CHAR 129 1 0 Debit/Credit Indicator
WAERS WAERS CUKY 130 5 0 TCURC Currency Key
DMBTR DMBTR CURR 135 13 2 Amount in Local Currency
BNBTR BNBTR CURR 142 13 2 Delivery costs in local currency
BUALT BUALT CURR 149 13 2 Amount Posted in Alternative Price Control
SHKUM SHKUM CHAR 156 1 0 Debit/credit indicator in revaluation
DMBUM DMBUM CURR 157 13 2 Revaluation amount on back-posting to a previous period
BWTAR BWTAR_D CHAR 164 10 0 T149D Valuation Type
MENGE MENGE_D QUAN 174 13 3 Quantity
MEINS MEINS UNIT 181 3 0 T006 Base Unit of Measure
ERFMG ERFMG QUAN 184 13 3 Quantity in Unit of Entry
ERFME ERFME UNIT 191 3 0 T006 Unit of Entry
BPMNG BPMNG QUAN 194 13 3 Quantity in Purchase Order Price Unit
BPRME BBPRM UNIT 201 3 0 T006 Order Price Unit (Purchasing)
EBELN BSTNR CHAR 204 10 0 EKKO Purchase Order Number
EBELP EBELP NUMC 214 5 0 EKPO Item Number of Purchasing Document
LFBJA LFBJA NUMC 219 4 0 Fiscal Year of a Reference Document
LFBNR LFBNR CHAR 223 10 0 Document No. of a Reference Document
LFPOS LFPOS NUMC 233 4 0 Item of a Reference Document
SJAHR MJAHR NUMC 237 4 0 Material Document Year
SMBLN MBLNR CHAR 241 10 0 Number of Material Document
SMBLP MBLPO NUMC 251 4 0 Item in Material Document
ELIKZ ELIKZ CHAR 255 1 0 "Delivery Completed" Indicator
SGTXT SGTXT CHAR 256 50 0 Item Text
EQUNR EQUNR CHAR 306 18 0 Equipment Number
WEMPF WEMPF CHAR 324 12 0 Goods Recipient/Ship-To Party
ABLAD ABLAD CHAR 336 25 0 Unloading Point
GSBER GSBER CHAR 361 4 0 TGSB Business Area
KOKRS KOKRS CHAR 365 4 0 TKA01 Controlling Area
PARGB PARGB CHAR 369 4 0 TGSB Trading Partner's Business Area
PARBU PARBU CHAR 373 4 0 T001 Clearing company code
KOSTL KOSTL CHAR 377 10 0 Cost Center
PROJN PROJN CHAR 387 16 0 Old: Project number : No longer used --> PS_POSNR
AUFNR AUFNR CHAR 403 12 0 AUFK Order Number
ANLN1 ANLN1 CHAR 415 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 427 4 0 ANLA Asset Subnumber
XSKST XSKST CHAR 431 1 0 Indicator: Statistical Posting to Cost Center
XSAUF XSAUF CHAR 432 1 0 Indicator: Posting to Order Is Statistical
XSPRO XSPRO CHAR 433 1 0 Indicator: Posting to Project Is Statistical
XSERG XSERG CHAR 434 1 0 Indicator: Posting to Profitability Analysis Is Statistical
GJAHR GJAHR NUMC 435 4 0 Fiscal Year
XRUEM XRUEM CHAR 439 1 0 Allow Posting to Previous Period (Backposting)
XRUEJ XRUEJ CHAR 440 1 0 Indicator: post to previous year
BUKRS BUKRS CHAR 441 4 0 T001 Company Code
BELNR BELNR_D CHAR 445 10 0 Accounting Document Number
BUZEI BUZEI NUMC 455 3 0 Number of Line Item Within Accounting Document
BELUM BELNR_D CHAR 458 10 0 Accounting Document Number
BUZUM BUZEI NUMC 468 3 0 Number of Line Item Within Accounting Document
RSNUM RSNUM NUMC 471 10 0 Number of Reservation/Dependent Requirement
RSPOS RSPOS NUMC 481 4 0 Item Number of Reservation/Dependent Requirement
KZEAR KZEAR CHAR 485 1 0 Final Issue for This Reservation
PBAMG MENGE_D QUAN 486 13 3 Quantity
KZSTR KZSTR CHAR 493 1 0 Transaction/event is relevant to statistics
UMMAT UMMAT CHAR 494 18 0 MARA Receiving/Issuing Material
UMWRK UMWRK CHAR 512 4 0 T001W Receiving/Issuing Plant
UMLGO UMLGO CHAR 516 4 0 T001L Receiving/Issuing Storage Location
UMCHA UMCHA CHAR 520 10 0 MCH1 Receiving/Issuing Batch
UMZST UMZST CHAR 530 1 0 Status of Transfer Batch
UMZUS UMZUS CHAR 531 1 0 Status key of transfer batch
UMBAR UMBAR CHAR 532 10 0 T149D Valuation Type of Transfer Batch
UMSOK UMSOK CHAR 542 1 0 T148 Special Stock Indicator for Physical Stock Transfer
KZBEW KZBEW CHAR 543 1 0 Movement Indicator
KZVBR KZVBR CHAR 544 1 0 Consumption Posting
KZZUG KZZUG CHAR 545 1 0 Receipt Indicator
WEUNB WEUNB CHAR 546 1 0 Goods Receipt, Non-Valuated
PALAN PALAN DEC 547 11 0 WMS Number of pallets
LGNUM LGNUM CHAR 553 3 0 T300 Warehouse Number / Warehouse Complex
LGTYP LGTYP CHAR 556 3 0 T301 Storage Type
LGPLA LGPLA CHAR 559 10 0 LAGP Storage Bin
BESTQ BESTQ CHAR 569 1 0 Stock Category in the Warehouse Management System
BWLVS BWLVS NUMC 570 3 0 T333 Movement Type for Warehouse Management
TBNUM TBNUM NUMC 573 10 0 Transfer Requirement Number
TBPOS TBPOS NUMC 583 4 0 Transfer Requirement Item
XBLVS XBLVS CHAR 587 1 0 Indicator: posting in warehouse management system
VSCHN T333_VSCHN CHAR 588 1 0 Ind: interim storage posting for source stor.type and bin
NSCHN T333_NSCHN CHAR 589 1 0 Ind.: interim storage posting for dest.stor.type and bin
DYPLA DYPLA CHAR 590 1 0 Indicator: dynamic storage bin
UBNUM UBNUM NUMC 591 10 0 Posting Change Number
TBPRI TBPRI CHAR 601 1 0 Transfer Priority
TANUM TANUM NUMC 602 10 0 Transfer Order Number
WEANZ WEANZ NUMC 612 3 0 Number of GR/GI Slips to Be Printed
GRUND MB_GRBEW NUMC 615 4 0 Reason for Movement
EVERS EVERS CHAR 619 2 0 T027A Shipping Instructions
EVERE EVERE CHAR 621 2 0 Compliance with Shipping Instructions
IMKEY IMKEY CHAR 623 8 0 Internal Key for Real Estate Object
KSTRG KSTRG CHAR 631 12 0 CKPH Cost Object
PAOBJNR RKEOBJNR NUMC 643 10 0 Profitability Segment Number (CO-PA)
PRCTR PRCTR CHAR 653 10 0 Profit Center
PS_PSP_PNR PS_PSP_PNR NUMC 663 8 0 PRPS Work Breakdown Structure Element (WBS Element)
NPLNR NPLNR CHAR 671 12 0 AUFK Network Number for Account Assignment
AUFPL CO_AUFPL NUMC 683 10 0 Routing number of operations in the order
APLZL CIM_COUNT NUMC 693 8 0 Internal counter
AUFPS CO_POSNR NUMC 701 4 0 Order Item Number
VPTNR JV_PART CHAR 705 10 0 KNA1 Partner Account Number
FIPOS FIPOS CHAR 715 14 0 Commitment Item
SAKTO SAKNR CHAR 729 10 0 G/L Account Number
BSTMG MB_BSTMG QUAN 739 13 3 Goods receipt quantity in order unit
BSTME BSTME UNIT 746 3 0 T006 Purchase Order Unit of Measure
XWSBR XWSBR CHAR 749 1 0 Reversal of GR allowed for GR-based IV despite invoice
EMLIF EMLIF CHAR 750 10 0 LFA1 Vendor to be supplied/who is to receive delivery
EXBWR EXBWR CURR 760 13 2 Externally Entered Posting Amount in Local Currency
VKWRT VKWRT CURR 767 13 2 Value at Sales Prices Including Value-Added Tax
AKTNR WAKTION CHAR 774 10 0 Promotion
ZEKKN DZEKKN NUMC 784 2 0 Sequential Number of Account Assignment
VFDAT VFDAT DATS 786 8 0 Shelf Life Expiration or Best-Before Date
CUOBJ_CH CUOBJ_CH NUMC 794 18 0 Internal object number of the batch classification
EXVKW EXVKW CURR 812 13 2 Externally Entered Sales Value in Local Currency
PPRCTR PPRCTR CHAR 819 10 0 Partner Profit Center
RSART RSART CHAR 829 1 0 Record type
GEBER BP_GEBER CHAR 830 10 0 Fund
FISTL FISTL CHAR 840 16 0 Funds Center
MATBF MATBF CHAR 856 18 0 MARA Material in Respect of Which Stock is Managed
UMMAB UMMAT CHAR 874 18 0 MARA Receiving/Issuing Material
BUSTM BUSTM CHAR 892 4 0 Posting string for quantities
BUSTW BUSTW CHAR 896 4 0 Posting String for Values
MENGU MENGU CHAR 900 1 0 Quantity Updating in Material Master Record
WERTU WERTU CHAR 901 1 0 Value Update in Material Master Record
LBKUM LBKUM_MSEG QUAN 902 13 3 Total valuated stock before the posting
SALK3 SALK3_MSEG CURR 909 13 2 Value of total valuated stock before the posting
VPRSV VPRSV CHAR 916 1 0 Price Control Indicator
FKBER FKBER CHAR 917 16 0 Functional Area
DABRBZ DABRBEZ DATS 933 8 0 Reference Date for Settlement
VKWRA VKWRA CURR 941 13 2 Value at sales prices excluding value-added tax
DABRZ DABRBEZ DATS 948 8 0 Reference Date for Settlement
XBEAU XBEAU CHAR 956 1 0 Purchase order created at time of goods receipt
LSMNG LSMNG QUAN 957 13 3 Quantity in Unit of Measure from Delivery Note
LSMEH LSMEH UNIT 964 3 0 T006 Unit of Measure From Delivery Note
KZBWS KZBWS CHAR 967 1 0 Valuation of Special Stock
QINSPST QINSPST CHAR 968 1 0 Status of Goods Receipt Inspection
URZEI URZEI NUMC 969 4 0 Original line in material document
J_1BEXBASE J_1BEXBASE CURR 973 13 2 Alternate base amount in document currency
MWSKZ MWSKZ CHAR 980 2 0 Sales Tax Code
TXJCD TXJCD CHAR 982 15 0 TTXJ Tax Jurisdiction
EMATN EMATN CHAR 997 18 0 MARA Material Number Corresponding to Manufacturer Part Number
J_1AGIRUPD J_1AGIRUPD CHAR 1015 1 0 Goods issue revaluation performed
VKMWS MWSKZ CHAR 1016 2 0 Sales Tax Code
HSDAT HSDAT DATS 1018 8 0 Date of Manufacture
BERKZ BERKZ CHAR 1026 1 0 Material Staging Indicator for Production Supply
MAT_KDAUF MAT_KDAUF CHAR 1027 10 0 Sales Order Number of Valuated Sales Order Stock
MAT_KDPOS MAT_KDPOS NUMC 1037 6 0 Sales Order Item of Valuated Sales Order Stock
MAT_PSPNR MAT_PSPNR NUMC 1043 8 0 PRPS Valuated Sales Order Stock WBS Element
XWOFF XWOFF CHAR 1051 1 0 Calculation of val. open
BEMOT BEMOT CHAR 1052 2 0 TBMOT Accounting Indicator
PRZNR CO_PRZNR CHAR 1054 12 0 CBPR Business Process
LLIEF LLIEF CHAR 1066 10 0 LFA1 Supplying Vendor
LSTAR LSTAR CHAR 1076 6 0 Activity Type
XOBEW XOBEW CHAR 1082 1 0 Vendor Stock Valuation Indicator
GRANT_NBR GM_GRANT_NBR CHAR 1083 20 0 Grant
ZUSTD_T156M BAMOK_MSEG CHAR 1103 1 0 Stock Type Modification (Read from Table T156M)
SPE_GTS_STOCK_TY /SPE/GTS_STOCK_TYPE CHAR 1104 1 0 GTS Stock Type
KBLNR KBLNR_FI CHAR 1105 10 0 KBLK Document Number for Earmarked Funds
KBLPOS KBLPOS NUMC 1115 3 0 KBLP Earmarked Funds: Document Item
/BEV2/ED_KZ_VER /BEV2/EDKZ_VER CHAR 1118 1 0 Processing Status of Material Document for Excise Duties
/BEV2/ED_USER USNAM CHAR 1119 12 0 USR02 User name
/BEV2/ED_AEDAT AEDAT DATS 1131 8 0 Changed On
/BEV2/ED_AETIM SYUZEIT TIMS 1139 6 0 Current Time of Application Server
OINAVNW NAVNW CURR 1145 13 2 Non-deductible input tax
OICONDCOD JV_CONDCOD CHAR 1152 2 0 Joint Venture Indicator (Condition Key)
CONDI JV_CONDCOD CHAR 1154 2 0 Joint Venture Indicator (Condition Key)

1516684MKPF fields added to MSEG - Performance optimization
1756236MBGR: Redesign of selection for performance optimization
1598760FAQ: MSEG extension and MB51/MB5B redesign
1550000MB51: Redesign of selection for performance optimization
1638997Performance: CKMDUVMAT selection with new fields in MSEG
1679885MB02: Changes in field XBLNR not updated in MSEG
1668550MSEG: Enhancement: Fields VBELN_IM and VBELP_IM
1567602DB dependent steps to support the redesign of MB51
821722Performance of the join on MSEG and MKPF
921164MB51: Improving the runtime using database hints
1143663FAQ : HPM - Hydrocarbon Product Management
1091276Performance problems in substance volume tracking
921165MB5B: Improving the runtime using database hints
1020462Recommendations for selection criteria
1026638GR Output Integration with MM-SUS Scenario for R/3 <= 47-
431603CJ20N: long run time with project with goods-movment.
555246MM-IM tax reduction law: Logging
492828Determining the transaction key for 2LIS_03_BF + 2LIS_03_UM
747358MIGO Goods Issue movements 201,351 and 551
656703PROMAN: Performance improvement
357187MB51: Fields in field catalog / selection screen
637324Dump when canceling an inbound delivery after reorg EKES
191492Performance: Customer developments in MM/WM
581240 LIS | Updating special stocks
417703Missing/duplicate record during extraction with 2LIS_03_BF
430472OIL: Corrections in goods movements and QCI
428322IS-Oil: Wrong field reference for BW/LIS MCMSEG-structure
504880Correct wrong merge: 851/852 clear LGORT
457499No material document generated for BAPI BAPI_GOODSMVT_CREATE
447701Message handling add.qties check in MB_CREATE_GOODS_MOVEMENT
438649Determination of stock type incorrect