SAP ABAP Table WB2_V_MKPF_MSEG2 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure WB2_V_MKPF_MSEG2   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 T000
2 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
3 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
4 MANDT_I MANDT MANDT CLNT 3   0   Client  
5 MBLNR_I MBLNR BELNR CHAR 10   0   Number of Material Document  
6 MJAHR_I MJAHR GJAHR NUMC 4   0   Year of material document  
7 ZEILE_I MBLPO MBLPO NUMC 4   0   Item in material document  
8 VGART VGART VGART CHAR 2   0   Transaction/Event Type T158V
9 BLART BLART BLART CHAR 2   0   Document type T003
10 BLAUM BLAUM BLART CHAR 2   0   Document type of revaluation document T003
11 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
12 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
13 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
14 CPUTM CPUTM UZEIT TIMS 6   0   Time of data entry  
15 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
16 USNAM USNAM XUBNAME CHAR 12   0   User name  
17 TCODE CHAR4 CHAR4 CHAR 4   0   Not More Closely Defined Area, Possibly Used for Patchlevels  
18 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
19 BKTXT BKTXT TEXT25 CHAR 25   0   Document Header Text  
20 FRATH FRATH WERT7 CURR 13   2   Unplanned Delivery Costs  
21 FRBNR FRBNR1 XBLNR1 CHAR 16   0   Number of Bill of Lading at Time of Goods Receipt  
22 WEVER WEVER WEVER CHAR 1   0   Version for Printing GR/GI Slip  
23 XABLN XABLN BELNR CHAR 10   0   Goods receipt/issue slip number  
24 AWSYS LOGSYSTEM LOGSYS CHAR 10   0   Logical System  
25 BLA2D BLA2D BLART CHAR 2   0   Doc. type for additional doc. in purchase account management  
26 TCODE2 TCODE TCODE CHAR 20   0   Transaction Code  
27 BFWMS BFWMS BFWMS CHAR 1   0   Control posting for external WMS  
28 EXNUM EXNUM EXNUM CHAR 10   0   Number of foreign trade data in MM and SD documents  
29 LINE_ID_I MB_LINE_ID MB_LINE_ID NUMC 6   0   Unique identification of document line  
30 PARENT_ID_I MB_PARENT_ID MB_LINE_ID NUMC 6   0   Identifier of immediately superior line  
31 LINE_DEPTH_I MB_LINE_DEPTH MB_LINE_DEPTH NUMC 2   0   Hierarchy level of line in document  
32 BWART_I BWART BWART CHAR 3   0   Movement type (inventory management) T156
33 XAUTO_I MB_XAUTO MB_XAUTO CHAR 1   0   Item automatically created  
34 MATNR_I MATNR MATNR CHAR 18   0   Material Number MARA
35 WERKS_I WERKS_D WERKS CHAR 4   0   Plant T001W
36 LGORT_I LGORT_D LGORT CHAR 4   0   Storage location T001L
37 CHARG_I CHARG_D CHARG CHAR 10   0   Batch Number MCHA
38 INSMK_I MB_INSMK MB_INSMK CHAR 1   0   Stock Type  
39 ZUSCH_I DZUSCH ZUSCH CHAR 1   0   Batch status key  
40 ZUSTD_I DZUSTD XFELD CHAR 1   0   Batch in Restricted-Use Stock  
41 SOBKZ_I SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
42 LIFNR_I ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
43 KUNNR_I EKUNN KUNNR CHAR 10   0   Account number of customer KNA1
44 KDAUF_I KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
45 KDPOS_I KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
46 KDEIN_I KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
47 PLPLA_I PLPLA PLPLA CHAR 10   0   Distribution of Differences  
48 SHKZG_I SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
49 WAERS_I WAERS WAERS CUKY 5   0   Currency Key TCURC
50 DMBTR_I DMBTR WERT7 CURR 13   2   Amount in local currency  
51 BNBTR_I BNBTR WERT13N CURR 13   2   Delivery costs in local currency  
52 BUALT_I BUALT WERTV7 CURR 13   2   Amount posted in alternative price control  
53 SHKUM_I SHKUM SHKZG CHAR 1   0   Debit/credit indicator in revaluation  
54 DMBUM_I DMBUM WERT7 CURR 13   2   Revaluation amount on back-posting to a previous period  
55 BWTAR_I BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
56 MENGE_I MENGE_D MENG13 QUAN 13   3   Quantity  
57 MEINS_I MEINS MEINS UNIT 3   0   Base Unit of Measure T006
58 ERFMG_I ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
59 ERFME_I ERFME MEINS UNIT 3   0   Unit of entry T006
60 BPMNG_I BPMNG MENG13 QUAN 13   3   Quantity in order price quantity unit  
61 BPRME_I BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
62 EBELN_I BSTNR EBELN CHAR 10   0   Purchase order number EKKO
63 EBELP_I EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
64 LFBJA_I LFBJA GJAHR NUMC 4   0   Fiscal Year of a Reference Document  
65 LFBNR_I LFBNR BELNR CHAR 10   0   Document number of a reference document  
66 LFPOS_I LFPOS MBLPO NUMC 4   0   Item of a reference document  
67 SJAHR_I MJAHR GJAHR NUMC 4   0   Year of material document  
68 SMBLN_I MBLNR BELNR CHAR 10   0   Number of Material Document  
69 SMBLP_I MBLPO MBLPO NUMC 4   0   Item in material document  
70 ELIKZ_I ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
71 SGTXT_I SGTXT TEXT50 CHAR 50   0   Item Text  
72 EQUNR_I EQUNR EQUNR CHAR 18   0   Equipment Number  
73 WEMPF_I WEMPF WEMPF CHAR 12   0   Goods recipient  
74 ABLAD_I ABLAD TEXT25 CHAR 25   0   Unloading Point  
75 GSBER_I GSBER GSBER CHAR 4   0   Business Area TGSB
76 KOKRS_I KOKRS CACCD CHAR 4   0   Controlling Area TKA01
77 PARGB_I PARGB GSBER CHAR 4   0   Trading partner's business area TGSB
78 PARBU_I PARBU BUKRS CHAR 4   0   Clearing company code T001
79 KOSTL_I KOSTL KOSTL CHAR 10   0   Cost Center CSKS
80 PROJN_I PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
81 AUFNR_I AUFNR AUFNR CHAR 12   0   Order Number AUFK
82 ANLN1_I ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
83 ANLN2_I ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
84 XSKST_I XSKST XFELD CHAR 1   0   Indicator: Statistical Posting to Cost Center  
85 XSAUF_I XSAUF XFELD CHAR 1   0   Indicator: Posting to Order Is Statistical  
86 XSPRO_I XSPRO XFELD CHAR 1   0   Indicator: Posting to Project Is Statistical  
87 XSERG_I XSERG XFELD CHAR 1   0   Indicator: Posting to Profitability Analysis Is Statistical  
88 GJAHR_I GJAHR GJAHR NUMC 4   0   Fiscal Year  
89 XRUEM_I XRUEM XFELD CHAR 1   0   Allow Posting to Previous Period (Backposting)  
90 XRUEJ_I XRUEJ XFELD CHAR 1   0   Indicator: post to previous year  
91 BUKRS_I BUKRS BUKRS CHAR 4   0   Company Code T001
92 BELNR_I BELNR_D BELNR CHAR 10   0   Accounting Document Number  
93 BUZEI_I BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
94 BELUM_I BELNR_D BELNR CHAR 10   0   Accounting Document Number  
95 BUZUM_I BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
96 RSNUM_I RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements  
97 RSPOS_I RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
98 KZEAR_I KZEAR XFELD CHAR 1   0   Final issue for this reservation  
99 PBAMG_I MENGE_D MENG13 QUAN 13   3   Quantity  
100 KZSTR_I KZSTR KZSTR CHAR 1   0   Transaction/event is relevant to statistics  
101 UMMAT_I UMMAT MATNR CHAR 18   0   Receiving/issuing material MARA
102 UMWRK_I UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
103 UMLGO_I UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
104 UMCHA_I UMCHA CHARG CHAR 10   0   Receiving/issuing batch MCHA
105 UMZST_I UMZST ZUSTD CHAR 1   0   Status of receiving batch  
106 UMZUS_I UMZUS ZUSCH CHAR 1   0   Status key of transfer batch  
107 UMBAR_I UMBAR BWTAR CHAR 10   0   Valuation type of transfer batch T149D
108 UMSOK_I UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer T148
109 KZBEW_I KZBEW KZBEW CHAR 1   0   Movement Indicator  
110 KZVBR_I KZVBR KZVBR CHAR 1   0   Consumption posting  
111 KZZUG_I KZZUG KZZUG CHAR 1   0   Receipt indicator  
112 WEUNB_I WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
113 PALAN_I PALAN PALAN DEC 11   0   WMS Number of pallets  
114 LGNUM_I LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
115 LGTYP_I LGTYP LGTYP CHAR 3   0   Storage Type T301
116 LGPLA_I LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
117 BESTQ_I BESTQ BESTQ CHAR 1   0   Stock Category in the Warehouse Management System  
118 BWLVS_I BWLVS BWLVS NUMC 3   0   Movement Type for Warehouse Management T333
119 TBNUM_I TBNUM TBNUM NUMC 10   0   Transfer Requirement Number LTBK
120 TBPOS_I TBPOS TBPOS NUMC 4   0   Transfer Requirement Item  
121 XBLVS_I XBLVS XFELD CHAR 1   0   Indicator: posting in warehouse management system  
122 VSCHN_I T333_VSCHN XFELD CHAR 1   0   Ind: interim storage posting for source stor.type and bin  
123 NSCHN_I T333_NSCHN XFELD CHAR 1   0   Ind.: interim storage posting for dest.stor.type and bin  
124 DYPLA_I DYPLA XFELD CHAR 1   0   Indicator: dynamic storage bin  
125 UBNUM_I UBNUM UBNUM NUMC 10   0   Posting Change Number  
126 TBPRI_I TBPRI TBPRI CHAR 1   0   Transfer Priority  
127 TANUM_I TANUM TANUM NUMC 10   0   Transfer Order Number  
128 WEANZ_I WEANZ NUM3 NUMC 3   0   Number of GR/GI slips to be printed  
129 GRUND_I MB_GRBEW MB_GRBEW NUMC 4   0   Reason for movement T157D
130 EVERS_I EVERS EVERS CHAR 2   0   Shipping Instructions T027A
131 EVERE_I EVERE EVERE CHAR 2   0   Compliance with Shipping Instructions T027C
132 IMKEY_I IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
133 KSTRG_I KSTRG KSTRG CHAR 12   0   Cost Object  
134 PAOBJNR_I RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
135 PRCTR_I PRCTR PRCTR CHAR 10   0   Profit Center  
136 PS_PSP_PNR_I PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element)  
137 NPLNR_I NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment AUFK
138 AUFPL_I CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
139 APLZL_I CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
140 AUFPS_I CO_POSNR CO_POSNR NUMC 4   0   Order item number  
141 VPTNR_I JV_PART KUNNR CHAR 10   0   Partner account number KNA1
142 FIPOS_I FIPOS FIPOS CHAR 14   0   Commitment Item FMFPO
143 SAKTO_I SAKNR SAKNR CHAR 10   0   G/L Account Number SKA1
144 BSTMG_I MB_BSTMG MENG13 QUAN 13   3   Goods receipt quantity in order unit  
145 BSTME_I BSTME MEINS UNIT 3   0   Order unit  
146 XWSBR_I XWSBR XFELD CHAR 1   0   Reversal of GR allowed for GR-based IV despite invoice  
147 EMLIF_I EMLIF LIFNR CHAR 10   0   Vendor to be supplied/who is to receive delivery  
148 EXBWR_I EXBWR WERT7 CURR 13   2   Externally Entered Posting Amount in Local Currency  
149 VKWRT_I VKWRT WERT7 CURR 13   2   Value at sales prices including value-added tax  
150 AKTNR_I WAKTION WAKTION CHAR 10   0   Promotion  
151 ZEKKN_I DZEKKN NUM02 NUMC 2   0   Sequential Number of Account Assignment  
152 VFDAT_I VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
153 CUOBJ_CH_I CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
154 EXVKW_I EXVKW WERT7 CURR 13   2   Externally Entered Sales Value in Local Currency  
155 PPRCTR_I PPRCTR PRCTR CHAR 10   0   Partner Profit Center  
156 RSART_I RSART RSART CHAR 1   0   Record type  
157 GEBER_I BP_GEBER BP_GEBER CHAR 10   0   Fund  
158 FISTL_I FISTL FISTL CHAR 16   0   Funds Center  
159 MATBF_I MATBF MATNR CHAR 18   0   Material in Respect of Which Stock is Managed  
160 UMMAB_I UMMAT MATNR CHAR 18   0   Receiving/issuing material  
161 BUSTM_I BUSTM BUSTM CHAR 4   0   Posting string for quantities  
162 BUSTW_I BUSTW BUSTW CHAR 4   0   Posting string for values  
163 MENGU_I MENGU XFELD CHAR 1   0   Quantity Updating in Material Master Record  
164 WERTU_I WERTU XFELD CHAR 1   0   Value Updating in Material Master Record  
165 LBKUM_I LBKUM_MSEG MENGV13 QUAN 13   3   Total valuated stock before the posting  
166 SALK3_I SALK3_MSEG WERT13N CURR 13   2   Value of total valuated stock before the posting  
167 VPRSV_I VPRSV VPRSV CHAR 1   0   Price control indicator  
168 FKBER_I FKBER FKBER CHAR 16   0   Functional Area  
169 DABRBZ_I DABRBEZ DDAT DATS 8   0   Reference date for settlement  
170 VKWRA_I VKWRA WERT7 CURR 13   2   Value at sales prices excluding value-added tax  
171 DABRZ_I DABRBEZ DDAT DATS 8   0   Reference date for settlement  
172 XBEAU_I XBEAU XFELD CHAR 1   0   Purchase order created at time of goods receipt  
173 LSMNG_I LSMNG MENG13 QUAN 13   3   Quantity in Unit of Measure from Delivery Note  
174 LSMEH_I LSMEH MEINS UNIT 3   0   Unit of Measure From Delivery Note T006
175 KZBWS_I KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
176 QINSPST_I QINSPST QINSPST CHAR 1   0   Status of Goods Receipt Inspection  
177 URZEI_I URZEI MBLPO NUMC 4   0   Original line in material document  
178 J_1BEXBASE_I J_1BEXBASE WERT7 CURR 13   2   Alternate base amount in document currency  
179 MWSKZ_I MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
180 TXJCD_I TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
181 EMATN_I EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number  
182 J_1AGIRUPD_I J_1AGIRUPD J_1AGIRUPD CHAR 1   0   Goods issue revaluation performed  
183 VKMWS_I MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code  
184 HSDAT_I HSDAT DATUM DATS 8   0   Date of Manufacture  
185 BERKZ_I BERKZ LVS_BERKZ CHAR 1   0   Material Staging Indicator for Production Supply  
186 MAT_KDAUF_I MAT_KDAUF VBELN CHAR 10   0   Sales order number of valuated sales order stock  
187 MAT_KDPOS_I MAT_KDPOS NUM06 NUMC 6   0   Sales Order Item of Valuated Sales Order Stock  
188 MAT_PSPNR_I MAT_PSPNR PS_POSNR NUMC 8   0   Valuated customer stock WBS element  
189 XWOFF_I XWOFF XFELD CHAR 1   0   Calculation of val. open  
190 BEMOT_I BEMOT BEMOT CHAR 2   0   Accounting Indicator TBMOT
191 PRZNR_I CO_PRZNR CO_PRZNR CHAR 12   0   Business Process  
192 LLIEF_I LLIEF LIFNR CHAR 10   0   Supplying Vendor  
193 LSTAR_I LSTAR LSTAR CHAR 6   0   Activity Type  
194 XOBEW_I XOBEW XFELD CHAR 1   0   Vendor Stock Valuation Indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WB2_V_MKPF_MSEG2 ANLN1_I ANLH ANLN1 REF C CN
2 WB2_V_MKPF_MSEG2 ANLN2_I ANLA ANLN2 REF C CN
3 WB2_V_MKPF_MSEG2 AUFNR_I AUFK AUFNR REF C CN
4 WB2_V_MKPF_MSEG2 BEMOT_I TBMOT BEMOT    
5 WB2_V_MKPF_MSEG2 BLART T003 BLART REF 1 CN
6 WB2_V_MKPF_MSEG2 BLAUM T003 BLART REF 1 CN
7 WB2_V_MKPF_MSEG2 BPRME_I T006 MSEHI REF C CN
8 WB2_V_MKPF_MSEG2 BUKRS_I T001 BUKRS REF C CN
9 WB2_V_MKPF_MSEG2 BWART_I T156 BWART REF 1 CN
10 WB2_V_MKPF_MSEG2 BWLVS_I T333 BWLVS REF C CN
11 WB2_V_MKPF_MSEG2 BWTAR_I T149D BWTAR REF C CN
12 WB2_V_MKPF_MSEG2 CHARG_I MCHA CHARG REF C CN
13 WB2_V_MKPF_MSEG2 EBELN_I EKKO EBELN REF C CN
14 WB2_V_MKPF_MSEG2 EBELP_I EKPO EBELP REF C CN
15 WB2_V_MKPF_MSEG2 ERFME_I T006 MSEHI REF 1 N
16 WB2_V_MKPF_MSEG2 EVERE_I T027C EVERE    
17 WB2_V_MKPF_MSEG2 EVERS_I T027A EVERS    
18 WB2_V_MKPF_MSEG2 FIPOS_I FMFPO FIPOS REF C CN
19 WB2_V_MKPF_MSEG2 GRUND_I T157D GRUND REF C CN
20 WB2_V_MKPF_MSEG2 GSBER_I TGSB GSBER REF C CN
21 WB2_V_MKPF_MSEG2 KDAUF_I VBUK VBELN REF C CN
22 WB2_V_MKPF_MSEG2 KOKRS_I TKA01 KOKRS REF C CN
23 WB2_V_MKPF_MSEG2 KOSTL_I CSKS KOSTL REF C CN
24 WB2_V_MKPF_MSEG2 KUNNR_I KNA1 KUNNR REF C CN
25 WB2_V_MKPF_MSEG2 LGNUM_I T300 LGNUM REF C CN
26 WB2_V_MKPF_MSEG2 LGORT_I T001L LGORT REF C CN
27 WB2_V_MKPF_MSEG2 LGPLA_I LAGP LGPLA REF C CN
28 WB2_V_MKPF_MSEG2 LGTYP_I T301 LGTYP REF C CN
29 WB2_V_MKPF_MSEG2 LIFNR_I LFA1 LIFNR REF C CN
30 WB2_V_MKPF_MSEG2 LSMEH_I T006 MSEHI REF 1 N
31 WB2_V_MKPF_MSEG2 MANDT T000 MANDT KEY 1 CN
32 WB2_V_MKPF_MSEG2 MATNR_I MARA MATNR REF C CN
33 WB2_V_MKPF_MSEG2 MEINS_I T006 MSEHI REF C CN
34 WB2_V_MKPF_MSEG2 MWSKZ_I T007A MWSKZ    
35 WB2_V_MKPF_MSEG2 NPLNR_I AUFK AUFNR REF 1 CN
36 WB2_V_MKPF_MSEG2 PARBU_I T001 BUKRS REF C CN
37 WB2_V_MKPF_MSEG2 PARGB_I TGSB GSBER REF C CN
38 WB2_V_MKPF_MSEG2 SAKTO_I SKA1 SAKNR REF C CN
39 WB2_V_MKPF_MSEG2 SOBKZ_I T148 SOBKZ REF C CN
40 WB2_V_MKPF_MSEG2 TBNUM_I LTBK TBNUM REF C CN
41 WB2_V_MKPF_MSEG2 TXJCD_I TTXJ TXJCD    
42 WB2_V_MKPF_MSEG2 UMBAR_I T149D BWTAR REF C CN
43 WB2_V_MKPF_MSEG2 UMCHA_I MCHA CHARG REF C CN
44 WB2_V_MKPF_MSEG2 UMLGO_I T001L LGORT REF C CN
45 WB2_V_MKPF_MSEG2 UMMAT_I MARA MATNR REF C CN
46 WB2_V_MKPF_MSEG2 UMSOK_I T148 SOBKZ REF C CN
47 WB2_V_MKPF_MSEG2 UMWRK_I T001W WERKS REF C CN
48 WB2_V_MKPF_MSEG2 VGART T158V VGART KEY 1 CN
49 WB2_V_MKPF_MSEG2 VPTNR_I KNA1 KUNNR REF C CN
50 WB2_V_MKPF_MSEG2 WAERS_I TCURC WAERS REF 1 CN
51 WB2_V_MKPF_MSEG2 WERKS_I T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in