MSEG - Document Segment: Material
Document Segment: Material information is stored in SAP table MSEG.
It is part of development package MB in software component MM-IM. This development package consists of objects that can be grouped under "Application development R/3 inventory management".
It is part of development package MB in software component MM-IM. This development package consists of objects that can be grouped under "Application development R/3 inventory management".
Fields for table MSEG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
MBLNR | Number of Material Document | X | MBLNR | CHAR | 20 | |
MJAHR | Material Document Year | X | MJAHR | NUMC | 8 | |
.INCLUDE | DOCUMENT_STRUCTURE | 0 | ||||
LINE_ID | Unique identification of document line | MB_LINE_ID | NUMC | 12 | ||
PARENT_ID | Identifier of immediately superior line | MB_PARENT_ID | NUMC | 12 | ||
LINE_DEPTH | Hierarchy level of line in document | MB_LINE_DEPTH | NUMC | 4 | ||
MAA_URZEI | Original Line for Account Assignment Item in Material Doc. | MAA_URZEI | NUMC | 8 | ||
BWART | Movement type (inventory management) | BWART | CHAR | 6 | T156 | |
XAUTO | Item automatically created | MB_XAUTO | CHAR | 2 | ||
MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
CHARG | Batch Number | CHARG_D | CHAR | 20 | MCHA | |
INSMK | Stock Type | MB_INSMK | CHAR | 2 | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 2 | T148 | |
LIFNR | Vendor's account number | ELIFN | CHAR | 20 | LFA1 | |
KUNNR | Account number of customer | EKUNN | CHAR | 20 | KNA1 | |
KDAUF | Sales Order Number | KDAUF | CHAR | 20 | VBAK | |
KDPOS | Item number in Sales Order | KDPOS | NUMC | 12 | ||
KDEIN | Delivery schedule for sales order | KDEIN | NUMC | 8 | ||
PLPLA | Distribution of Differences | PLPLA | CHAR | 20 | ||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 7 | ||
BNBTR | Delivery costs in local currency | BNBTR | CURR | 7 | ||
BUALT | Amount Posted in Alternative Price Control | BUALT | CURR | 7 | ||
SHKUM | Debit/credit indicator in revaluation | SHKUM | CHAR | 2 | ||
DMBUM | Revaluation amount on back-posting to a previous period | DMBUM | CURR | 7 | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 20 | T149D | |
MENGE | Quantity | MENGE_D | QUAN | 7 | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
ERFMG | Quantity in unit of entry | ERFMG | QUAN | 7 | ||
ERFME | Unit of entry | ERFME | UNIT | 6 | T006 | |
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 7 | ||
BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 6 | T006 | |
EBELN | Purchase order number | BSTNR | CHAR | 20 | EKKO | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 10 | EKPO | |
LFBJA | Fiscal Year of a Reference Document | LFBJA | NUMC | 8 | ||
LFBNR | Document No. of a Reference Document | LFBNR | CHAR | 20 | ||
LFPOS | Item of a Reference Document | LFPOS | NUMC | 8 | ||
SJAHR | Material Document Year | MJAHR | NUMC | 8 | ||
SMBLN | Number of Material Document | MBLNR | CHAR | 20 | ||
SMBLP | Item in Material Document | MBLPO | NUMC | 8 | ||
ELIKZ | "Delivery Completed" Indicator | ELIKZ | CHAR | 2 | ||
SGTXT | Item Text | SGTXT | CHAR | 100 | ||
EQUNR | Equipment Number | EQUNR | CHAR | 36 | ||
WEMPF | Goods Recipient | WEMPF | CHAR | 24 | ||
ABLAD | Unloading Point | ABLAD | CHAR | 50 | ||
GSBER | Business Area | GSBER | CHAR | 8 | TGSB | |
KOKRS | Controlling Area | KOKRS | CHAR | 8 | TKA01 | |
PARGB | Trading partner's business area | PARGB | CHAR | 8 | TGSB | |
PARBU | Clearing company code | PARBU | CHAR | 8 | T001 | |
KOSTL | Cost Center | KOSTL | CHAR | 20 | CSKS | |
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 32 | ||
AUFNR | Order Number | AUFNR | CHAR | 24 | AUFK | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 24 | ANLH | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 8 | ANLA | |
XSKST | Indicator: Statistical Posting to Cost Center | XSKST | CHAR | 2 | ||
XSAUF | Indicator: Posting to Order Is Statistical | XSAUF | CHAR | 2 | ||
XSPRO | Indicator: Posting to Project Is Statistical | XSPRO | CHAR | 2 | ||
XSERG | Indicator: Posting to Profitability Analysis Is Statistical | XSERG | CHAR | 2 | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
XRUEM | Allow Posting to Previous Period (Backposting) | XRUEM | CHAR | 2 | ||
XRUEJ | Indicator: post to previous year | XRUEJ | CHAR | 2 | ||
BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
BELUM | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
BUZUM | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 20 | ||
RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 8 | ||
KZEAR | Final issue for this reservation | KZEAR | CHAR | 2 | ||
PBAMG | Quantity | MENGE_D | QUAN | 7 | ||
KZSTR | Transaction/event is relevant to statistics | KZSTR | CHAR | 2 | ||
UMMAT | Receiving/Issuing Material | UMMAT | CHAR | 80 | MARA | |
UMWRK | Receiving plant/issuing plant | UMWRK | CHAR | 8 | T001W | |
UMLGO | Receiving/issuing storage location | UMLGO | CHAR | 8 | T001L | |
UMCHA | Receiving/Issuing Batch | UMCHA | CHAR | 20 | MCHA | |
UMZST | Status of Transfer Batch | UMZST | CHAR | 2 | ||
UMZUS | Status key of transfer batch | UMZUS | CHAR | 2 | ||
UMBAR | Valuation Type of Transfer Batch | UMBAR | CHAR | 20 | T149D | |
UMSOK | Special stock indicator for physical stock transfer | UMSOK | CHAR | 2 | T148 | |
KZBEW | Movement Indicator | KZBEW | CHAR | 2 | ||
KZVBR | Consumption posting | KZVBR | CHAR | 2 | ||
KZZUG | Receipt Indicator | KZZUG | CHAR | 2 | ||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 2 | ||
PALAN | WMS Number of pallets | PALAN | DEC | 6 | ||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 6 | T300 | |
LGTYP | Storage Type | LGTYP | CHAR | 6 | T301 | |
LGPLA | Storage Bin | LGPLA | CHAR | 20 | LAGP | |
BESTQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 2 | ||
BWLVS | Movement Type for Warehouse Management | BWLVS | NUMC | 6 | T333 | |
TBNUM | Transfer Requirement Number | TBNUM | NUMC | 20 | LTBK | |
TBPOS | Transfer Requirement Item | TBPOS | NUMC | 8 | ||
XBLVS | Indicator: posting in warehouse management system | XBLVS | CHAR | 2 | ||
VSCHN | Ind: interim storage posting for source stor.type and bin | T333_VSCHN | CHAR | 2 | ||
NSCHN | Ind.: interim storage posting for dest.stor.type and bin | T333_NSCHN | CHAR | 2 | ||
DYPLA | Indicator: dynamic storage bin | DYPLA | CHAR | 2 | ||
UBNUM | Posting Change Number | UBNUM | NUMC | 20 | ||
TBPRI | Transfer Priority | TBPRI | CHAR | 2 | ||
TANUM | Transfer Order Number | TANUM | NUMC | 20 | ||
WEANZ | Number of GR/GI Slips to Be Printed | WEANZ | NUMC | 6 | ||
GRUND | Reason for Movement | MB_GRBEW | NUMC | 8 | T157D | |
EVERS | Shipping Instructions | EVERS | CHAR | 4 | T027A | |
EVERE | Compliance with Shipping Instructions | EVERE | CHAR | 4 | T027C | |
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 16 | ||
KSTRG | Cost Object | KSTRG | CHAR | 24 | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 20 | ||
PRCTR | Profit Center | PRCTR | CHAR | 20 | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 24 | AUFK | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 20 | ||
APLZL | Internal counter | CIM_COUNT | NUMC | 16 | ||
AUFPS | Order item number | CO_POSNR | NUMC | 8 | ||
VPTNR | Partner account number | JV_PART | CHAR | 20 | KNA1 | |
FIPOS | Commitment Item | FIPOS | CHAR | 28 | FMFPO | |
SAKTO | G/L Account Number | SAKNR | CHAR | 20 | SKA1 | |
BSTMG | Goods receipt quantity in order unit | MB_BSTMG | QUAN | 7 | ||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 6 | ||
XWSBR | Reversal of GR allowed for GR-based IV despite invoice | XWSBR | CHAR | 2 | ||
EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | CHAR | 20 | ||
.INCLUDE | INCL_EEW_COBL | 0 | ||||
.INCLUDE | CI_COBL | 0 | ||||
DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
EXBWR | Externally Entered Posting Amount in Local Currency | EXBWR | CURR | 7 | ||
VKWRT | Value at Sales Prices Including Value-Added Tax | VKWRT | CURR | 7 | ||
AKTNR | Promotion | WAKTION | CHAR | 20 | ||
VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 16 | ||
CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 36 | ||
EXVKW | Externally Entered Sales Value in Local Currency | EXVKW | CURR | 7 | ||
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 20 | ||
RSART | Record type | RSART | CHAR | 2 | ||
GEBER | Fund | BP_GEBER | CHAR | 20 | ||
FISTL | Funds Center | FISTL | CHAR | 32 | ||
MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 80 | ||
UMMAB | Receiving/Issuing Material | UMMAT | CHAR | 80 | ||
BUSTM | Posting string for quantities | BUSTM | CHAR | 8 | ||
BUSTW | Posting String for Values | BUSTW | CHAR | 8 | ||
MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 2 | ||
WERTU | Value Updating in Material Master Record | WERTU | CHAR | 2 | ||
LBKUM | Total valuated stock before the posting | LBKUM_MSEG | QUAN | 7 | ||
SALK3 | Value of total valuated stock before the posting | SALK3_MSEG | CURR | 7 | ||
VPRSV | Price control indicator | VPRSV | CHAR | 2 | ||
FKBER | Functional Area | FKBER | CHAR | 32 | ||
DABRBZ | Reference date for settlement | DABRBEZ | DATS | 16 | ||
VKWRA | Value at Sales Prices Excluding Value Added Tax | VKWRA | CURR | 7 | ||
DABRZ | Reference date for settlement | DABRBEZ | DATS | 16 | ||
XBEAU | Purchase order created at time of goods receipt | XBEAU | CHAR | 2 | ||
LSMNG | Quantity in Unit of Measure from Delivery Note | LSMNG | QUAN | 7 | ||
LSMEH | Unit of Measure From Delivery Note | LSMEH | UNIT | 6 | T006 | |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 2 | ||
QINSPST | Status of Goods Receipt Inspection | QINSPST | CHAR | 2 | ||
URZEI | Original line in material document | URZEI | NUMC | 8 | ||
J_1BEXBASE | Alternate base amount in document currency | J_1BEXBASE | CURR | 7 | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | T007A | |
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 30 | TTXJ | |
EMATN | Material number corresponding to manufacturer part number | EMATN | CHAR | 80 | ||
J_1AGIRUPD | Goods issue revaluation performed | J_1AGIRUPD | CHAR | 2 | ||
VKMWS | Tax on sales/purchases code | MWSKZ | CHAR | 4 | ||
HSDAT | Date of Manufacture | HSDAT | DATS | 16 | ||
BERKZ | Material Staging Indicator for Production Supply | BERKZ | CHAR | 2 | ||
MAT_KDAUF | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR | 20 | ||
MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 12 | ||
MAT_PSPNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 16 | ||
XWOFF | Calculation of val. open | XWOFF | CHAR | 2 | ||
BEMOT | Accounting Indicator | BEMOT | CHAR | 4 | TBMOT | |
PRZNR | Business Process | CO_PRZNR | CHAR | 24 | ||
LLIEF | Goods Supplier | LLIEF | CHAR | 20 | ||
LSTAR | Activity Type | LSTAR | CHAR | 12 | ||
XOBEW | Vendor Stock Valuation Indicator | XOBEW | CHAR | 2 | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 40 | ||
SPE_GTS_STOCK_TY | GTS Stock Type | /SPE/GTS_STOCK_TYPE | CHAR | 2 | ||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 20 | ||
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 6 | ||
XMACC | Multiple Account Assignment | XMACC | CHAR | 2 | ||
VGART_MKPF | Transaction/Event Type | VGART | CHAR | 4 | ||
BUDAT_MKPF | Posting Date in the Document | BUDAT | DATS | 16 | ||
CPUDT_MKPF | Day On Which Accounting Document Was Entered | CPUDT | DATS | 16 | ||
CPUTM_MKPF | Time of Entry | CPUTM | TIMS | 12 | ||
USNAM_MKPF | User Name | USNAM | CHAR | 24 | ||
XBLNR_MKPF | Reference Document Number | XBLNR1 | CHAR | 32 | ||
TCODE2_MKPF | Transaction Code | TCODE | CHAR | 40 | ||
VBELN_IM | Delivery | VBELN_VL | CHAR | 20 | ||
VBELP_IM | Delivery Item | POSNR_VL | NUMC | 12 | ||
SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 80 | ||
SGT_UMSCAT | Receiving/Issuing Stock Segment | SGT_UMSCAT | CHAR | 80 | ||
SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR | 80 | ||
.INCLUDE | NSDM_S_ITEM_SRV | 0 | ||||
SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR | 20 | * | |
PERNR | Personnel Number | PERNR_D | NUMC | 16 | ||
KNTTP_GR | Account Assignment Category | KNTTP | CHAR | 2 | * | |
.INCLUDE | /CPD/S_SS_PROJ_INCLUDE | 0 | ||||
WORK_ITEM_ID | Work Item ID | /CPD/PFP_WORKITEM_ID | CHAR | 20 | ||
FBUDA | Date on which services are rendered | FBUDA | DATS | 16 | ||
XPRINT | Print via Output Control | XNAPR | CHAR | 2 | ||
.INCLUDE | /CWM/S_MSEG | 0 | ||||
.INCLUDE | /CWM/MSEG_PQ | 0 | ||||
/CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 7 | ||
/CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | UNIT | 6 | * | |
/CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | QUAN | 7 | ||
/CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | UNIT | 6 | * | |
SERVICE_DOC_TYPE | Service Document Type | FCO_SRVDOC_TYPE | CHAR | 8 | ||
SERVICE_DOC_ID | Service Document ID | FCO_SRVDOC_ID | CHAR | 20 | ||
SERVICE_DOC_ITEM_ID | Service Document Item ID | FCO_SRVDOC_ITEM_ID | NUMC | 12 | ||
EWM_LGNUM | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | ||
EWM_GMDOC | Warehouse Document for Goods Movement | /SCWM/DE_GM_DOC | NUMC | 24 | ||
RESOURCENAME_SID | Resource Name (Stock Identifier) | NSDM_RESOURCENAME_SID | CHAR | 80 | ||
RESOURCENAME_CID | Resource Name (Stock Identifier Complement) | NSDM_RESOURCENAME_CID | CHAR | 80 | ||
.INCLUDE | MATDOC_INCL_EEW_PS | 0 | ||||
DUMMY_MATDOC_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
.INCLU--AP | DISUB_MSEG_DATA | 0 | ||||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 20 | * | |
.INCLU--AP | FSH_MSEGDATA_APPEND | 0 | ||||
FSH_SEASON_YEAR | Season Year | FSH_SAISJ | CHAR | 8 | ||
FSH_SEASON | Season | FSH_SAISO | CHAR | 20 | ||
FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | CHAR | 20 | * | |
FSH_THEME | Fashion Theme | FSH_THEME | CHAR | 20 | ||
FSH_UMSEA_YR | Receiving/Issuing Season Year | FSH_UMSEA_YR | CHAR | 8 | ||
FSH_UMSEA | Receiving/Issuing Season | FSH_UMSEA | CHAR | 20 | ||
FSH_UMCOLL | Receiving/Issuing Collection | FSH_UMCOLL | CHAR | 20 | * | |
FSH_UMTHEME | Receiving/Issuing Theme | FSH_UMTHEME | CHAR | 20 | ||
SGT_CHINT | Discrete Batch Number [Obsolete] | SGT_CHINT | CHAR | 2 | ||
.INCLU--AP | ISAUTO_COMPL_MSEG | 0 | ||||
COMPL_MARK | Completed indicator | COMPL_MARK | CHAR | 2 | ||
.INCLU--AP | ISAUTO_ESCR_QTY_DIFFMSEG | 0 | ||||
FZGLS_MARK | Do Not Adjust Cumulative Received Quantity | FZGLS | CHAR | 2 | ||
ETANP_MARK | Adjust Open Quantity in Scheduling Agreement Item | ETANP | CHAR | 2 | ||
POPUP_MARK | Display Dialog Box | POPUP | CHAR | 2 | ||
.INCLU--AP | JVMSEG | 0 | ||||
OINAVNW | Non-deductible input tax | NAVNW | CURR | 7 | ||
OICONDCOD | Joint Venture Indicator (Condition Key) | JV_CONDCOD | CHAR | 4 | * | |
CONDI | Joint Venture Indicator (Condition Key) | JV_CONDCOD | CHAR | 4 | * | |
.INCLU--AP | WRF_MSEG_APPEND | 0 | ||||
WRF_CHARSTC1 | Characteristic Value 1 | WRF_CHARSTC1 | CHAR | 36 | ||
WRF_CHARSTC2 | Characteristic Value 2 | WRF_CHARSTC2 | CHAR | 36 | ||
WRF_CHARSTC3 | Characteristic Value 3 | WRF_CHARSTC3 | CHAR | 36 |