SAP ABAP Table MSEG (Document Segment: Material)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
MB (Package) Application development R/3 inventory management

⤷

⤷

⤷

Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | MSEG |
![]() |
Short Description | Document Segment: Material |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
![]() |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | ![]() |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
3 | ![]() |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
4 | ![]() |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
5 | ![]() |
0 | 0 | Docmt Structure | |||||
6 | ![]() |
MB_LINE_ID | MB_LINE_ID | NUMC | 6 | 0 | Unique identification of document line | ||
7 | ![]() |
MB_PARENT_ID | MB_LINE_ID | NUMC | 6 | 0 | Identifier of immediately superior line | ||
8 | ![]() |
MB_LINE_DEPTH | MB_LINE_DEPTH | NUMC | 2 | 0 | Hierarchy level of line in document | ||
9 | ![]() |
MAA_URZEI | MBLPO | NUMC | 4 | 0 | Original Line for Account Assignment Item in Material Doc. | ||
10 | ![]() |
BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | T156 | |
11 | ![]() |
MB_XAUTO | MB_XAUTO | CHAR | 1 | 0 | Item automatically created | ||
12 | ![]() |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
13 | ![]() |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
14 | ![]() |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
15 | ![]() |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
16 | ![]() |
MB_INSMK | MB_INSMK | CHAR | 1 | 0 | Stock Type | ||
17 | ![]() |
DZUSCH | ZUSCH | CHAR | 1 | 0 | Batch status key | ||
18 | ![]() |
DZUSTD | XFELD | CHAR | 1 | 0 | Batch in Restricted-Use Stock | ||
19 | ![]() |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
20 | ![]() |
ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
21 | ![]() |
EKUNN | KUNNR | CHAR | 10 | 0 | Account number of customer | KNA1 | |
22 | ![]() |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
23 | ![]() |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
24 | ![]() |
KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
25 | ![]() |
PLPLA | PLPLA | CHAR | 10 | 0 | Distribution of Differences | ||
26 | ![]() |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
27 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
28 | ![]() |
DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
29 | ![]() |
BNBTR | WERT13N | CURR | 13 | 2 | Delivery costs in local currency | ||
30 | ![]() |
BUALT | WERTV7 | CURR | 13 | 2 | Amount posted in alternative price control | ||
31 | ![]() |
SHKUM | SHKZG | CHAR | 1 | 0 | Debit/credit indicator in revaluation | ||
32 | ![]() |
DMBUM | WERT7 | CURR | 13 | 2 | Revaluation amount on back-posting to a previous period | ||
33 | ![]() |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
34 | ![]() |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
35 | ![]() |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
36 | ![]() |
ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
37 | ![]() |
ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
38 | ![]() |
BPMNG | MENG13 | QUAN | 13 | 3 | Quantity in order price quantity unit | ||
39 | ![]() |
BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
40 | ![]() |
BSTNR | EBELN | CHAR | 10 | 0 | Purchase order number | EKKO | |
41 | ![]() |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
42 | ![]() |
LFBJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of a Reference Document | ||
43 | ![]() |
LFBNR | BELNR | CHAR | 10 | 0 | Document number of a reference document | ||
44 | ![]() |
LFPOS | MBLPO | NUMC | 4 | 0 | Item of a reference document | ||
45 | ![]() |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
46 | ![]() |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
47 | ![]() |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
48 | ![]() |
ELIKZ | XFELD | CHAR | 1 | 0 | "Delivery Completed" Indicator | ||
49 | ![]() |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
50 | ![]() |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
51 | ![]() |
WEMPF | WEMPF | CHAR | 12 | 0 | Goods recipient | ||
52 | ![]() |
ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
53 | ![]() |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
54 | ![]() |
KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
55 | ![]() |
PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | TGSB | |
56 | ![]() |
PARBU | BUKRS | CHAR | 4 | 0 | Clearing company code | T001 | |
57 | ![]() |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
58 | ![]() |
PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
59 | ![]() |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
60 | ![]() |
ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | ANLH | |
61 | ![]() |
ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ANLA | |
62 | ![]() |
XSKST | XFELD | CHAR | 1 | 0 | Indicator: Statistical Posting to Cost Center | ||
63 | ![]() |
XSAUF | XFELD | CHAR | 1 | 0 | Indicator: Posting to Order Is Statistical | ||
64 | ![]() |
XSPRO | XFELD | CHAR | 1 | 0 | Indicator: Posting to Project Is Statistical | ||
65 | ![]() |
XSERG | XFELD | CHAR | 1 | 0 | Indicator: Posting to Profitability Analysis Is Statistical | ||
66 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
67 | ![]() |
XRUEM | XFELD | CHAR | 1 | 0 | Allow Posting to Previous Period (Backposting) | ||
68 | ![]() |
XRUEJ | XFELD | CHAR | 1 | 0 | Indicator: post to previous year | ||
69 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
70 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
71 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
72 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
73 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
74 | ![]() |
RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
75 | ![]() |
RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
76 | ![]() |
KZEAR | XFELD | CHAR | 1 | 0 | Final issue for this reservation | ||
77 | ![]() |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
78 | ![]() |
KZSTR | KZSTR | CHAR | 1 | 0 | Transaction/event is relevant to statistics | ||
79 | ![]() |
UMMAT | MATNR | CHAR | 18 | 0 | Receiving/issuing material | MARA | |
80 | ![]() |
UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | T001W | |
81 | ![]() |
UMLGO | LGORT | CHAR | 4 | 0 | Receiving/issuing storage location | T001L | |
82 | ![]() |
UMCHA | CHARG | CHAR | 10 | 0 | Receiving/issuing batch | MCHA | |
83 | ![]() |
UMZST | ZUSTD | CHAR | 1 | 0 | Status of receiving batch | ||
84 | ![]() |
UMZUS | ZUSCH | CHAR | 1 | 0 | Status key of transfer batch | ||
85 | ![]() |
UMBAR | BWTAR | CHAR | 10 | 0 | Valuation type of transfer batch | T149D | |
86 | ![]() |
UMSOK | SOBKZ | CHAR | 1 | 0 | Special stock indicator for physical stock transfer | T148 | |
87 | ![]() |
KZBEW | KZBEW | CHAR | 1 | 0 | Movement Indicator | ||
88 | ![]() |
KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
89 | ![]() |
KZZUG | KZZUG | CHAR | 1 | 0 | Receipt indicator | ||
90 | ![]() |
WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
91 | ![]() |
PALAN | PALAN | DEC | 11 | 0 | WMS Number of pallets | ||
92 | ![]() |
LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | T300 | |
93 | ![]() |
LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | T301 | |
94 | ![]() |
LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | LAGP | |
95 | ![]() |
BESTQ | BESTQ | CHAR | 1 | 0 | Stock Category in the Warehouse Management System | ||
96 | ![]() |
BWLVS | BWLVS | NUMC | 3 | 0 | Movement Type for Warehouse Management | T333 | |
97 | ![]() |
TBNUM | TBNUM | NUMC | 10 | 0 | Transfer Requirement Number | LTBK | |
98 | ![]() |
TBPOS | TBPOS | NUMC | 4 | 0 | Transfer Requirement Item | ||
99 | ![]() |
XBLVS | XFELD | CHAR | 1 | 0 | Indicator: posting in warehouse management system | ||
100 | ![]() |
T333_VSCHN | XFELD | CHAR | 1 | 0 | Ind: interim storage posting for source stor.type and bin | ||
101 | ![]() |
T333_NSCHN | XFELD | CHAR | 1 | 0 | Ind.: interim storage posting for dest.stor.type and bin | ||
102 | ![]() |
DYPLA | XFELD | CHAR | 1 | 0 | Indicator: dynamic storage bin | ||
103 | ![]() |
UBNUM | UBNUM | NUMC | 10 | 0 | Posting Change Number | ||
104 | ![]() |
TBPRI | TBPRI | CHAR | 1 | 0 | Transfer Priority | ||
105 | ![]() |
TANUM | TANUM | NUMC | 10 | 0 | Transfer Order Number | ||
106 | ![]() |
WEANZ | NUM3 | NUMC | 3 | 0 | Number of GR/GI slips to be printed | ||
107 | ![]() |
MB_GRBEW | MB_GRBEW | NUMC | 4 | 0 | Reason for movement | T157D | |
108 | ![]() |
EVERS | EVERS | CHAR | 2 | 0 | Shipping Instructions | T027A | |
109 | ![]() |
EVERE | EVERE | CHAR | 2 | 0 | Compliance with Shipping Instructions | T027C | |
110 | ![]() |
IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
111 | ![]() |
KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
112 | ![]() |
RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
113 | ![]() |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
114 | ![]() |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
115 | ![]() |
NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | AUFK | |
116 | ![]() |
CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
117 | ![]() |
CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
118 | ![]() |
CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
119 | ![]() |
JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | KNA1 | |
120 | ![]() |
FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | FMFPO | |
121 | ![]() |
SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
122 | ![]() |
MB_BSTMG | MENG13 | QUAN | 13 | 3 | Goods receipt quantity in order unit | ||
123 | ![]() |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
124 | ![]() |
XWSBR | XFELD | CHAR | 1 | 0 | Reversal of GR allowed for GR-based IV despite invoice | ||
125 | ![]() |
EMLIF | LIFNR | CHAR | 10 | 0 | Vendor to be supplied/who is to receive delivery | * | |
126 | ![]() |
0 | 0 | ||||||
127 | ![]() |
EXBWR | WERT7 | CURR | 13 | 2 | Externally Entered Posting Amount in Local Currency | ||
128 | ![]() |
VKWRT | WERT7 | CURR | 13 | 2 | Value at sales prices including value-added tax | ||
129 | ![]() |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
130 | ![]() |
DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
131 | ![]() |
VFDAT | DATUM | DATS | 8 | 0 | Shelf Life Expiration or Best-Before Date | ||
132 | ![]() |
CUOBJ_CH | CUOBJ | NUMC | 18 | 0 | Internal object number of the batch classification | ||
133 | ![]() |
EXVKW | WERT7 | CURR | 13 | 2 | Externally Entered Sales Value in Local Currency | ||
134 | ![]() |
PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
135 | ![]() |
RSART | RSART | CHAR | 1 | 0 | Record type | ||
136 | ![]() |
BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
137 | ![]() |
FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
138 | ![]() |
MATBF | MATNR | CHAR | 18 | 0 | Material in Respect of Which Stock is Managed | * | |
139 | ![]() |
UMMAT | MATNR | CHAR | 18 | 0 | Receiving/issuing material | * | |
140 | ![]() |
BUSTM | BUSTM | CHAR | 4 | 0 | Posting string for quantities | ||
141 | ![]() |
BUSTW | BUSTW | CHAR | 4 | 0 | Posting string for values | ||
142 | ![]() |
MENGU | XFELD | CHAR | 1 | 0 | Quantity Updating in Material Master Record | ||
143 | ![]() |
WERTU | XFELD | CHAR | 1 | 0 | Value Updating in Material Master Record | ||
144 | ![]() |
LBKUM_MSEG | MENGV13 | QUAN | 13 | 3 | Total valuated stock before the posting | ||
145 | ![]() |
SALK3_MSEG | WERT13N | CURR | 13 | 2 | Value of total valuated stock before the posting | ||
146 | ![]() |
VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
147 | ![]() |
FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
148 | ![]() |
DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
149 | ![]() |
VKWRA | WERT7 | CURR | 13 | 2 | Value at sales prices excluding value-added tax | ||
150 | ![]() |
DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
151 | ![]() |
XBEAU | XFELD | CHAR | 1 | 0 | Purchase order created at time of goods receipt | ||
152 | ![]() |
LSMNG | MENG13 | QUAN | 13 | 3 | Quantity in Unit of Measure from Delivery Note | ||
153 | ![]() |
LSMEH | MEINS | UNIT | 3 | 0 | Unit of Measure From Delivery Note | T006 | |
154 | ![]() |
KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
155 | ![]() |
QINSPST | QINSPST | CHAR | 1 | 0 | Status of Goods Receipt Inspection | ||
156 | ![]() |
URZEI | MBLPO | NUMC | 4 | 0 | Original line in material document | ||
157 | ![]() |
J_1BEXBASE | WERT7 | CURR | 13 | 2 | Alternate base amount in document currency | ||
158 | ![]() |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
159 | ![]() |
TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
160 | ![]() |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
161 | ![]() |
J_1AGIRUPD | J_1AGIRUPD | CHAR | 1 | 0 | Goods issue revaluation performed | ||
162 | ![]() |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
163 | ![]() |
HSDAT | DATUM | DATS | 8 | 0 | Date of Manufacture | ||
164 | ![]() |
BERKZ | LVS_BERKZ | CHAR | 1 | 0 | Material Staging Indicator for Production Supply | ||
165 | ![]() |
MAT_KDAUF | VBELN | CHAR | 10 | 0 | Sales order number of valuated sales order stock | * | |
166 | ![]() |
MAT_KDPOS | NUM06 | NUMC | 6 | 0 | Sales Order Item of Valuated Sales Order Stock | ||
167 | ![]() |
MAT_PSPNR | PS_POSNR | NUMC | 8 | 0 | Valuated customer stock WBS element | * | |
168 | ![]() |
XWOFF | XFELD | CHAR | 1 | 0 | Calculation of val. open | ||
169 | ![]() |
BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | TBMOT | |
170 | ![]() |
CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
171 | ![]() |
LLIEF | LIFNR | CHAR | 10 | 0 | Supplying Vendor | * | |
172 | ![]() |
LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
173 | ![]() |
XOBEW | XFELD | CHAR | 1 | 0 | Vendor Stock Valuation Indicator | ||
174 | ![]() |
GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
175 | ![]() |
BAMOK_MSEG | BAMOK_MSEG | CHAR | 1 | 0 | Stock Type Modification (Read from Table T156M) | ||
176 | ![]() |
/SPE/GTS_STOCK_TYPE | /SPE/GTS_STOCK_TYPE | CHAR | 1 | 0 | GTS Stock Type | ||
177 | ![]() |
KBLNR_FI | KBLNR | CHAR | 10 | 0 | Document number for earmarked funds | * | |
178 | ![]() |
KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
179 | ![]() |
XMACC | CHAR1 | CHAR | 1 | 0 | Multiple Account Assignment | ||
180 | ![]() |
VGART | VGART | CHAR | 2 | 0 | Transaction/Event Type | * | |
181 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
182 | ![]() |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
183 | ![]() |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
184 | ![]() |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
185 | ![]() |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
186 | ![]() |
TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | * | |
187 | ![]() |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
188 | ![]() |
POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
189 | ![]() |
0 | 0 | Fields for Excise Duties in Material Document (MSEG) | |||||
190 | ![]() |
/BEV2/EDKZ_VER | /BEV2/EDKZ_VER | CHAR | 1 | 0 | Processing Status of Material Document for Excise Duties | ||
191 | ![]() |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
192 | ![]() |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
193 | ![]() |
SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
194 | ![]() |
0 | 0 | Joint Venture Fields | |||||
195 | ![]() |
NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
196 | ![]() |
JV_CONDCOD | JV_CONDCOD | CHAR | 2 | 0 | Joint Venture Indicator (Condition Key) | * | |
197 | ![]() |
JV_CONDCOD | JV_CONDCOD | CHAR | 2 | 0 | Joint Venture Indicator (Condition Key) | * |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |