SAP ABAP View WB2_V_MKPF_MSEG (Data Selection from Material Documents)
Hierarchy
EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   LO-GT-TEW (Application Component) Trading Execution Workbench
     WB2B_TEW (Package) Trading Execution Workbench
Basic Data
View Type D Database View 
Database View WB2_V_MKPF_MSEG  
Short Description Data Selection from Material Documents    
Root table MKPF   Header: Material Document 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MKPF MKPF
2 MSEG  
3 WBGT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 MSEG MANDT JL EQ 0 0
2 MKPF MANDT JR EQ AND 0 0
3 MSEG MBLNR JL EQ 0 0
4 MKPF MBLNR JR EQ AND 0 0
5 MSEG MJAHR JL EQ 0 0
6 MKPF MJAHR JR EQ AND 0 0
7 WBGT MANDT JL EQ 0 0
8 MKPF MANDT JR EQ AND 0 0
9 WBGT VBELN JL EQ 0 0
10 MKPF MBLNR JR EQ AND 0 0
11 WBGT GJAHR JL EQ 0 0
12 MKPF MJAHR JR EQ AND 0 0
13 WBGT DOC_TYPE EQ 'G' OR 0 0
14 WBGT DOC_TYPE EQ 'L' OR 0 0
15 WBGT DOC_TYPE EQ 'L1' AND 0 0
16 WBGT POSNR EQ '000000' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MKPF MANDT   MANDT Client
2 MBLNR MKPF MBLNR   MBLNR Number of Material Document
3 MJAHR MKPF MJAHR   MJAHR Year of material document
4 MANDT_I MSEG MANDT   MANDT Client
5 MBLNR_I MSEG MBLNR   MBLNR Number of Material Document
6 MJAHR_I MSEG MJAHR   MJAHR Year of material document
7 ZEILE_I MSEG ZEILE   MBLPO Item in material document
8 MANDT_W WBGT MANDT   MANDT Client
9 DOC_TYPE_W WBGT DOC_TYPE   WB2_DOC_TYPE Document Type
10 VBELN_W WBGT VBELN   WB2_DOCUMENT_NUMBER General Document Number
11 POSNR_W WBGT POSNR   WB2_DOCUMENT_ITEM Item Number of a Document
12 POSNR_SUB_W WBGT POSNR_SUB   WB2_SUB_ITEM Sub-Item Number of a Document
13 GJAHR_W WBGT GJAHR   GJAHR Fiscal Year
14 VGART MKPF VGART   VGART Transaction/Event Type
15 BLART MKPF BLART   BLART Document type
16 BLAUM MKPF BLAUM   BLAUM Document type of revaluation document
17 BLDAT MKPF BLDAT   BLDAT Document Date in Document
18 BUDAT MKPF BUDAT   BUDAT Posting Date in the Document
19 CPUDT MKPF CPUDT   CPUDT Accounting document entry date
20 CPUTM MKPF CPUTM   CPUTM Time of data entry
21 AEDAT MKPF AEDAT   AEDAT Last Changed On
22 USNAM MKPF USNAM   USNAM User name
23 TCODE MKPF TCODE   CHAR4 Not More Closely Defined Area, Possibly Used for Patchlevels
24 XBLNR MKPF XBLNR   XBLNR1 Reference Document Number
25 BKTXT MKPF BKTXT   BKTXT Document Header Text
26 FRATH MKPF FRATH   FRATH Unplanned Delivery Costs
27 FRBNR MKPF FRBNR   FRBNR1 Number of Bill of Lading at Time of Goods Receipt
28 WEVER MKPF WEVER   WEVER Version for Printing GR/GI Slip
29 XABLN MKPF XABLN   XABLN Goods receipt/issue slip number
30 AWSYS MKPF AWSYS   LOGSYSTEM Logical System
31 BLA2D MKPF BLA2D   BLA2D Doc. type for additional doc. in purchase account management
32 TCODE2 MKPF TCODE2   TCODE Transaction Code
33 BFWMS MKPF BFWMS   BFWMS Control posting for external WMS
34 EXNUM MKPF EXNUM   EXNUM Number of foreign trade data in MM and SD documents
35 LINE_ID_I MSEG LINE_ID   MB_LINE_ID Unique identification of document line
36 PARENT_ID_I MSEG PARENT_ID   MB_PARENT_ID Identifier of immediately superior line
37 LINE_DEPTH_I MSEG LINE_DEPTH   MB_LINE_DEPTH Hierarchy level of line in document
38 BWART_I MSEG BWART   BWART Movement type (inventory management)
39 XAUTO_I MSEG XAUTO   MB_XAUTO Item automatically created
40 MATNR_I MSEG MATNR   MATNR Material Number
41 WERKS_I MSEG WERKS   WERKS_D Plant
42 LGORT_I MSEG LGORT   LGORT_D Storage location
43 CHARG_I MSEG CHARG   CHARG_D Batch Number
44 INSMK_I MSEG INSMK   MB_INSMK Stock Type
45 ZUSCH_I MSEG ZUSCH   DZUSCH Batch status key
46 ZUSTD_I MSEG ZUSTD   DZUSTD Batch in Restricted-Use Stock
47 SOBKZ_I MSEG SOBKZ   SOBKZ Special Stock Indicator
48 LIFNR_I MSEG LIFNR   ELIFN Vendor's account number
49 KUNNR_I MSEG KUNNR   EKUNN Account number of customer
50 KDAUF_I MSEG KDAUF   KDAUF Sales Order Number
51 KDPOS_I MSEG KDPOS   KDPOS Item number in Sales Order
52 KDEIN_I MSEG KDEIN   KDEIN Delivery schedule for sales order
53 PLPLA_I MSEG PLPLA   PLPLA Distribution of Differences
54 SHKZG_I MSEG SHKZG   SHKZG Debit/Credit Indicator
55 WAERS_I MSEG WAERS   WAERS Currency Key
56 DMBTR_I MSEG DMBTR   DMBTR Amount in local currency
57 BNBTR_I MSEG BNBTR   BNBTR Delivery costs in local currency
58 BUALT_I MSEG BUALT   BUALT Amount posted in alternative price control
59 SHKUM_I MSEG SHKUM   SHKUM Debit/credit indicator in revaluation
60 DMBUM_I MSEG DMBUM   DMBUM Revaluation amount on back-posting to a previous period
61 BWTAR_I MSEG BWTAR   BWTAR_D Valuation type
62 MENGE_I MSEG MENGE   MENGE_D Quantity
63 MEINS_I MSEG MEINS   MEINS Base Unit of Measure
64 ERFMG_I MSEG ERFMG   ERFMG Quantity in unit of entry
65 ERFME_I MSEG ERFME   ERFME Unit of entry
66 BPMNG_I MSEG BPMNG   BPMNG Quantity in order price quantity unit
67 BPRME_I MSEG BPRME   BBPRM Order Price Unit (purchasing)
68 EBELN_I MSEG EBELN   BSTNR Purchase order number
69 EBELP_I MSEG EBELP   EBELP Item Number of Purchasing Document
70 LFBJA_I MSEG LFBJA   LFBJA Fiscal Year of a Reference Document
71 LFBNR_I MSEG LFBNR   LFBNR Document number of a reference document
72 LFPOS_I MSEG LFPOS   LFPOS Item of a reference document
73 SJAHR_I MSEG SJAHR   MJAHR Year of material document
74 SMBLN_I MSEG SMBLN   MBLNR Number of Material Document
75 SMBLP_I MSEG SMBLP   MBLPO Item in material document
76 ELIKZ_I MSEG ELIKZ   ELIKZ "Delivery Completed" Indicator
77 SGTXT_I MSEG SGTXT   SGTXT Item Text
78 EQUNR_I MSEG EQUNR   EQUNR Equipment Number
79 WEMPF_I MSEG WEMPF   WEMPF Goods recipient
80 ABLAD_I MSEG ABLAD   ABLAD Unloading Point
81 GSBER_I MSEG GSBER   GSBER Business Area
82 KOKRS_I MSEG KOKRS   KOKRS Controlling Area
83 PARGB_I MSEG PARGB   PARGB Trading partner's business area
84 PARBU_I MSEG PARBU   PARBU Clearing company code
85 KOSTL_I MSEG KOSTL   KOSTL Cost Center
86 PROJN_I MSEG PROJN   PROJN Old: Project number : No longer used --> PS_POSNR
87 AUFNR_I MSEG AUFNR   AUFNR Order Number
88 ANLN1_I MSEG ANLN1   ANLN1 Main Asset Number
89 ANLN2_I MSEG ANLN2   ANLN2 Asset Subnumber
90 XSKST_I MSEG XSKST   XSKST Indicator: Statistical Posting to Cost Center
91 XSAUF_I MSEG XSAUF   XSAUF Indicator: Posting to Order Is Statistical
92 XSPRO_I MSEG XSPRO   XSPRO Indicator: Posting to Project Is Statistical
93 XSERG_I MSEG XSERG   XSERG Indicator: Posting to Profitability Analysis Is Statistical
94 GJAHR_I MSEG GJAHR   GJAHR Fiscal Year
95 XRUEM_I MSEG XRUEM   XRUEM Allow Posting to Previous Period (Backposting)
96 XRUEJ_I MSEG XRUEJ   XRUEJ Indicator: post to previous year
97 BUKRS_I MSEG BUKRS   BUKRS Company Code
98 BELNR_I MSEG BELNR   BELNR_D Accounting Document Number
99 BUZEI_I MSEG BUZEI   BUZEI Number of Line Item Within Accounting Document
100 BELUM_I MSEG BELUM   BELNR_D Accounting Document Number
101 BUZUM_I MSEG BUZUM   BUZEI Number of Line Item Within Accounting Document
102 RSNUM_I MSEG RSNUM   RSNUM Number of reservation/dependent requirements
103 RSPOS_I MSEG RSPOS   RSPOS Item Number of Reservation / Dependent Requirements
104 KZEAR_I MSEG KZEAR   KZEAR Final issue for this reservation
105 PBAMG_I MSEG PBAMG   MENGE_D Quantity
106 KZSTR_I MSEG KZSTR   KZSTR Transaction/event is relevant to statistics
107 UMMAT_I MSEG UMMAT   UMMAT Receiving/issuing material
108 UMWRK_I MSEG UMWRK   UMWRK Receiving plant/issuing plant
109 UMLGO_I MSEG UMLGO   UMLGO Receiving/issuing storage location
110 UMCHA_I MSEG UMCHA   UMCHA Receiving/issuing batch
111 UMZST_I MSEG UMZST   UMZST Status of receiving batch
112 UMZUS_I MSEG UMZUS   UMZUS Status key of transfer batch
113 UMBAR_I MSEG UMBAR   UMBAR Valuation type of transfer batch
114 UMSOK_I MSEG UMSOK   UMSOK Special stock indicator for physical stock transfer
115 KZBEW_I MSEG KZBEW   KZBEW Movement Indicator
116 KZVBR_I MSEG KZVBR   KZVBR Consumption posting
117 KZZUG_I MSEG KZZUG   KZZUG Receipt indicator
118 WEUNB_I MSEG WEUNB   WEUNB Goods Receipt, Non-Valuated
119 PALAN_I MSEG PALAN   PALAN WMS Number of pallets
120 LGNUM_I MSEG LGNUM   LGNUM Warehouse Number / Warehouse Complex
121 LGTYP_I MSEG LGTYP   LGTYP Storage Type
122 LGPLA_I MSEG LGPLA   LGPLA Storage Bin
123 BESTQ_I MSEG BESTQ   BESTQ Stock Category in the Warehouse Management System
124 BWLVS_I MSEG BWLVS   BWLVS Movement Type for Warehouse Management
125 TBNUM_I MSEG TBNUM   TBNUM Transfer Requirement Number
126 TBPOS_I MSEG TBPOS   TBPOS Transfer Requirement Item
127 XBLVS_I MSEG XBLVS   XBLVS Indicator: posting in warehouse management system
128 VSCHN_I MSEG VSCHN   T333_VSCHN Ind: interim storage posting for source stor.type and bin
129 NSCHN_I MSEG NSCHN   T333_NSCHN Ind.: interim storage posting for dest.stor.type and bin
130 DYPLA_I MSEG DYPLA   DYPLA Indicator: dynamic storage bin
131 UBNUM_I MSEG UBNUM   UBNUM Posting Change Number
132 TBPRI_I MSEG TBPRI   TBPRI Transfer Priority
133 TANUM_I MSEG TANUM   TANUM Transfer Order Number
134 WEANZ_I MSEG WEANZ   WEANZ Number of GR/GI slips to be printed
135 GRUND_I MSEG GRUND   MB_GRBEW Reason for movement
136 EVERS_I MSEG EVERS   EVERS Shipping Instructions
137 EVERE_I MSEG EVERE   EVERE Compliance with Shipping Instructions
138 IMKEY_I MSEG IMKEY   IMKEY Internal Key for Real Estate Object
139 KSTRG_I MSEG KSTRG   KSTRG Cost Object
140 PAOBJNR_I MSEG PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
141 PRCTR_I MSEG PRCTR   PRCTR Profit Center
142 PS_PSP_PNR_I MSEG PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
143 NPLNR_I MSEG NPLNR   NPLNR Network Number for Account Assignment
144 AUFPL_I MSEG AUFPL   CO_AUFPL Routing number of operations in the order
145 APLZL_I MSEG APLZL   CIM_COUNT Internal counter
146 AUFPS_I MSEG AUFPS   CO_POSNR Order item number
147 VPTNR_I MSEG VPTNR   JV_PART Partner account number
148 FIPOS_I MSEG FIPOS   FIPOS Commitment Item
149 SAKTO_I MSEG SAKTO   SAKNR G/L Account Number
150 BSTMG_I MSEG BSTMG   MB_BSTMG Goods receipt quantity in order unit
151 BSTME_I MSEG BSTME   BSTME Order unit
152 XWSBR_I MSEG XWSBR   XWSBR Reversal of GR allowed for GR-based IV despite invoice
153 EMLIF_I MSEG EMLIF   EMLIF Vendor to be supplied/who is to receive delivery
154 EXBWR_I MSEG EXBWR   EXBWR Externally Entered Posting Amount in Local Currency
155 VKWRT_I MSEG VKWRT   VKWRT Value at sales prices including value-added tax
156 AKTNR_I MSEG AKTNR   WAKTION Promotion
157 ZEKKN_I MSEG ZEKKN   DZEKKN Sequential Number of Account Assignment
158 VFDAT_I MSEG VFDAT   VFDAT Shelf Life Expiration or Best-Before Date
159 CUOBJ_CH_I MSEG CUOBJ_CH   CUOBJ_CH Internal object number of the batch classification
160 EXVKW_I MSEG EXVKW   EXVKW Externally Entered Sales Value in Local Currency
161 PPRCTR_I MSEG PPRCTR   PPRCTR Partner Profit Center
162 RSART_I MSEG RSART   RSART Record type
163 GEBER_I MSEG GEBER   BP_GEBER Fund
164 FISTL_I MSEG FISTL   FISTL Funds Center
165 MATBF_I MSEG MATBF   MATBF Material in Respect of Which Stock is Managed
166 UMMAB_I MSEG UMMAB   UMMAT Receiving/issuing material
167 BUSTM_I MSEG BUSTM   BUSTM Posting string for quantities
168 BUSTW_I MSEG BUSTW   BUSTW Posting string for values
169 MENGU_I MSEG MENGU   MENGU Quantity Updating in Material Master Record
170 WERTU_I MSEG WERTU   WERTU Value Updating in Material Master Record
171 LBKUM_I MSEG LBKUM   LBKUM_MSEG Total valuated stock before the posting
172 SALK3_I MSEG SALK3   SALK3_MSEG Value of total valuated stock before the posting
173 VPRSV_I MSEG VPRSV   VPRSV Price control indicator
174 FKBER_I MSEG FKBER   FKBER Functional Area
175 DABRBZ_I MSEG DABRBZ   DABRBEZ Reference date for settlement
176 VKWRA_I MSEG VKWRA   VKWRA Value at sales prices excluding value-added tax
177 DABRZ_I MSEG DABRZ   DABRBEZ Reference date for settlement
178 XBEAU_I MSEG XBEAU   XBEAU Purchase order created at time of goods receipt
179 LSMNG_I MSEG LSMNG   LSMNG Quantity in Unit of Measure from Delivery Note
180 LSMEH_I MSEG LSMEH   LSMEH Unit of Measure From Delivery Note
181 KZBWS_I MSEG KZBWS   KZBWS Valuation of Special Stock
182 QINSPST_I MSEG QINSPST   QINSPST Status of Goods Receipt Inspection
183 URZEI_I MSEG URZEI   URZEI Original line in material document
184 J_1BEXBASE_I MSEG J_1BEXBASE   J_1BEXBASE Alternate base amount in document currency
185 MWSKZ_I MSEG MWSKZ   MWSKZ Tax on sales/purchases code
186 TXJCD_I MSEG TXJCD   TXJCD Tax Jurisdiction
187 EMATN_I MSEG EMATN   EMATN Material number corresponding to manufacturer part number
188 J_1AGIRUPD_I MSEG J_1AGIRUPD   J_1AGIRUPD Goods issue revaluation performed
189 VKMWS_I MSEG VKMWS   MWSKZ Tax on sales/purchases code
190 HSDAT_I MSEG HSDAT   HSDAT Date of Manufacture
191 BERKZ_I MSEG BERKZ   BERKZ Material Staging Indicator for Production Supply
192 MAT_KDAUF_I MSEG MAT_KDAUF   MAT_KDAUF Sales order number of valuated sales order stock
193 MAT_KDPOS_I MSEG MAT_KDPOS   MAT_KDPOS Sales Order Item of Valuated Sales Order Stock
194 MAT_PSPNR_I MSEG MAT_PSPNR   MAT_PSPNR Valuated customer stock WBS element
195 XWOFF_I MSEG XWOFF   XWOFF Calculation of val. open
196 BEMOT_I MSEG BEMOT   BEMOT Accounting Indicator
197 PRZNR_I MSEG PRZNR   CO_PRZNR Business Process
198 LLIEF_I MSEG LLIEF   LLIEF Supplying Vendor
199 LSTAR_I MSEG LSTAR   LSTAR Activity Type
200 XOBEW_I MSEG XOBEW   XOBEW Vendor Stock Valuation Indicator
201 TKONN_W WBGT TKONN   TKONN Trading Contract: Trading Contract Number
202 TPOSN_W WBGT TPOSN   TPOSN Trading Contract: Item Number
203 TPOSN_SUB_W WBGT TPOSN_SUB   TPOSN_SUB Trading Contract: Sub-Item Number
204 ERNAM_W WBGT ERNAM   ERNAM Name of Person who Created the Object
205 ERDAT_W WBGT ERDAT   ERDAT Date on which the record was created
206 TEW_TYPE_W WBGT TEW_TYPE   WB2_TEW_TYPE Trading Execution Workbench Type
207 SCENARIO_W WBGT SCENARIO   WB2_BUSINESS_SCENARIO Business Scenario
208 TKONN_EX_W WBGT TKONN_EX   TKONN_EX Trading Contract: External Document Number
209 COMPLETE_W WBGT COMPLETE   WB2_DOCUMENT_COMPLETE_2 Global Trade: Item Closed
210 ERROR_TEW_W WBGT ERROR_TEW   WB2B_ERROR_TEW Global Trade: Error in Follow-On Document Creation
211 BUSINESS_STEP_W WBGT BUSINESS_STEP   WB2_STEP Business Process Step
212 MASTER_STEP_W WBGT MASTER_STEP   WB2_MASTER_STEP Main Step
213 PRE_STEP_W WBGT PRE_STEP   WB2_PRE_STEP Previous Step of Business Process
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C