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