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 | ||
2 | ![]() |
|||
3 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
MBLNR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
MBLNR | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
MJAHR | JL | EQ | 0 | 0 | ||||
6 | ![]() |
MJAHR | JR | EQ | AND | 0 | 0 | |||
7 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
8 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
9 | ![]() |
VBELN | JL | EQ | 0 | 0 | ||||
10 | ![]() |
MBLNR | JR | EQ | AND | 0 | 0 | |||
11 | ![]() |
GJAHR | JL | EQ | 0 | 0 | ||||
12 | ![]() |
MJAHR | JR | EQ | AND | 0 | 0 | |||
13 | ![]() |
DOC_TYPE | EQ | 'G' | OR | 0 | 0 | |||
14 | ![]() |
DOC_TYPE | EQ | 'L' | OR | 0 | 0 | |||
15 | ![]() |
DOC_TYPE | EQ | 'L1' | AND | 0 | 0 | |||
16 | ![]() |
POSNR | EQ | '000000' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
MANDT | MANDT | Client | |||
2 | ![]() |
![]() |
MBLNR | MBLNR | Number of Material Document | |||
3 | ![]() |
![]() |
MJAHR | MJAHR | Year of material document | |||
4 | ![]() |
![]() |
MANDT | MANDT | Client | |||
5 | ![]() |
![]() |
MBLNR | MBLNR | Number of Material Document | |||
6 | ![]() |
![]() |
MJAHR | MJAHR | Year of material document | |||
7 | ![]() |
![]() |
ZEILE | MBLPO | Item in material document | |||
8 | ![]() |
![]() |
MANDT | MANDT | Client | |||
9 | ![]() |
![]() |
DOC_TYPE | WB2_DOC_TYPE | Document Type | |||
10 | ![]() |
![]() |
VBELN | WB2_DOCUMENT_NUMBER | General Document Number | |||
11 | ![]() |
![]() |
POSNR | WB2_DOCUMENT_ITEM | Item Number of a Document | |||
12 | ![]() |
![]() |
POSNR_SUB | WB2_SUB_ITEM | Sub-Item Number of a Document | |||
13 | ![]() |
![]() |
GJAHR | GJAHR | Fiscal Year | |||
14 | ![]() |
![]() |
VGART | VGART | Transaction/Event Type | |||
15 | ![]() |
![]() |
BLART | BLART | Document type | |||
16 | ![]() |
![]() |
BLAUM | BLAUM | Document type of revaluation document | |||
17 | ![]() |
![]() |
BLDAT | BLDAT | Document Date in Document | |||
18 | ![]() |
![]() |
BUDAT | BUDAT | Posting Date in the Document | |||
19 | ![]() |
![]() |
CPUDT | CPUDT | Accounting document entry date | |||
20 | ![]() |
![]() |
CPUTM | CPUTM | Time of data entry | |||
21 | ![]() |
![]() |
AEDAT | AEDAT | Last Changed On | |||
22 | ![]() |
![]() |
USNAM | USNAM | User name | |||
23 | ![]() |
![]() |
TCODE | CHAR4 | Not More Closely Defined Area, Possibly Used for Patchlevels | |||
24 | ![]() |
![]() |
XBLNR | XBLNR1 | Reference Document Number | |||
25 | ![]() |
![]() |
BKTXT | BKTXT | Document Header Text | |||
26 | ![]() |
![]() |
FRATH | FRATH | Unplanned Delivery Costs | |||
27 | ![]() |
![]() |
FRBNR | FRBNR1 | Number of Bill of Lading at Time of Goods Receipt | |||
28 | ![]() |
![]() |
WEVER | WEVER | Version for Printing GR/GI Slip | |||
29 | ![]() |
![]() |
XABLN | XABLN | Goods receipt/issue slip number | |||
30 | ![]() |
![]() |
AWSYS | LOGSYSTEM | Logical System | |||
31 | ![]() |
![]() |
BLA2D | BLA2D | Doc. type for additional doc. in purchase account management | |||
32 | ![]() |
![]() |
TCODE2 | TCODE | Transaction Code | |||
33 | ![]() |
![]() |
BFWMS | BFWMS | Control posting for external WMS | |||
34 | ![]() |
![]() |
EXNUM | EXNUM | Number of foreign trade data in MM and SD documents | |||
35 | ![]() |
![]() |
LINE_ID | MB_LINE_ID | Unique identification of document line | |||
36 | ![]() |
![]() |
PARENT_ID | MB_PARENT_ID | Identifier of immediately superior line | |||
37 | ![]() |
![]() |
LINE_DEPTH | MB_LINE_DEPTH | Hierarchy level of line in document | |||
38 | ![]() |
![]() |
BWART | BWART | Movement type (inventory management) | |||
39 | ![]() |
![]() |
XAUTO | MB_XAUTO | Item automatically created | |||
40 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
41 | ![]() |
![]() |
WERKS | WERKS_D | Plant | |||
42 | ![]() |
![]() |
LGORT | LGORT_D | Storage location | |||
43 | ![]() |
![]() |
CHARG | CHARG_D | Batch Number | |||
44 | ![]() |
![]() |
INSMK | MB_INSMK | Stock Type | |||
45 | ![]() |
![]() |
ZUSCH | DZUSCH | Batch status key | |||
46 | ![]() |
![]() |
ZUSTD | DZUSTD | Batch in Restricted-Use Stock | |||
47 | ![]() |
![]() |
SOBKZ | SOBKZ | Special Stock Indicator | |||
48 | ![]() |
![]() |
LIFNR | ELIFN | Vendor's account number | |||
49 | ![]() |
![]() |
KUNNR | EKUNN | Account number of customer | |||
50 | ![]() |
![]() |
KDAUF | KDAUF | Sales Order Number | |||
51 | ![]() |
![]() |
KDPOS | KDPOS | Item number in Sales Order | |||
52 | ![]() |
![]() |
KDEIN | KDEIN | Delivery schedule for sales order | |||
53 | ![]() |
![]() |
PLPLA | PLPLA | Distribution of Differences | |||
54 | ![]() |
![]() |
SHKZG | SHKZG | Debit/Credit Indicator | |||
55 | ![]() |
![]() |
WAERS | WAERS | Currency Key | |||
56 | ![]() |
![]() |
DMBTR | DMBTR | Amount in local currency | |||
57 | ![]() |
![]() |
BNBTR | BNBTR | Delivery costs in local currency | |||
58 | ![]() |
![]() |
BUALT | BUALT | Amount posted in alternative price control | |||
59 | ![]() |
![]() |
SHKUM | SHKUM | Debit/credit indicator in revaluation | |||
60 | ![]() |
![]() |
DMBUM | DMBUM | Revaluation amount on back-posting to a previous period | |||
61 | ![]() |
![]() |
BWTAR | BWTAR_D | Valuation type | |||
62 | ![]() |
![]() |
MENGE | MENGE_D | Quantity | |||
63 | ![]() |
![]() |
MEINS | MEINS | Base Unit of Measure | |||
64 | ![]() |
![]() |
ERFMG | ERFMG | Quantity in unit of entry | |||
65 | ![]() |
![]() |
ERFME | ERFME | Unit of entry | |||
66 | ![]() |
![]() |
BPMNG | BPMNG | Quantity in order price quantity unit | |||
67 | ![]() |
![]() |
BPRME | BBPRM | Order Price Unit (purchasing) | |||
68 | ![]() |
![]() |
EBELN | BSTNR | Purchase order number | |||
69 | ![]() |
![]() |
EBELP | EBELP | Item Number of Purchasing Document | |||
70 | ![]() |
![]() |
LFBJA | LFBJA | Fiscal Year of a Reference Document | |||
71 | ![]() |
![]() |
LFBNR | LFBNR | Document number of a reference document | |||
72 | ![]() |
![]() |
LFPOS | LFPOS | Item of a reference document | |||
73 | ![]() |
![]() |
SJAHR | MJAHR | Year of material document | |||
74 | ![]() |
![]() |
SMBLN | MBLNR | Number of Material Document | |||
75 | ![]() |
![]() |
SMBLP | MBLPO | Item in material document | |||
76 | ![]() |
![]() |
ELIKZ | ELIKZ | "Delivery Completed" Indicator | |||
77 | ![]() |
![]() |
SGTXT | SGTXT | Item Text | |||
78 | ![]() |
![]() |
EQUNR | EQUNR | Equipment Number | |||
79 | ![]() |
![]() |
WEMPF | WEMPF | Goods recipient | |||
80 | ![]() |
![]() |
ABLAD | ABLAD | Unloading Point | |||
81 | ![]() |
![]() |
GSBER | GSBER | Business Area | |||
82 | ![]() |
![]() |
KOKRS | KOKRS | Controlling Area | |||
83 | ![]() |
![]() |
PARGB | PARGB | Trading partner's business area | |||
84 | ![]() |
![]() |
PARBU | PARBU | Clearing company code | |||
85 | ![]() |
![]() |
KOSTL | KOSTL | Cost Center | |||
86 | ![]() |
![]() |
PROJN | PROJN | Old: Project number : No longer used --> PS_POSNR | |||
87 | ![]() |
![]() |
AUFNR | AUFNR | Order Number | |||
88 | ![]() |
![]() |
ANLN1 | ANLN1 | Main Asset Number | |||
89 | ![]() |
![]() |
ANLN2 | ANLN2 | Asset Subnumber | |||
90 | ![]() |
![]() |
XSKST | XSKST | Indicator: Statistical Posting to Cost Center | |||
91 | ![]() |
![]() |
XSAUF | XSAUF | Indicator: Posting to Order Is Statistical | |||
92 | ![]() |
![]() |
XSPRO | XSPRO | Indicator: Posting to Project Is Statistical | |||
93 | ![]() |
![]() |
XSERG | XSERG | Indicator: Posting to Profitability Analysis Is Statistical | |||
94 | ![]() |
![]() |
GJAHR | GJAHR | Fiscal Year | |||
95 | ![]() |
![]() |
XRUEM | XRUEM | Allow Posting to Previous Period (Backposting) | |||
96 | ![]() |
![]() |
XRUEJ | XRUEJ | Indicator: post to previous year | |||
97 | ![]() |
![]() |
BUKRS | BUKRS | Company Code | |||
98 | ![]() |
![]() |
BELNR | BELNR_D | Accounting Document Number | |||
99 | ![]() |
![]() |
BUZEI | BUZEI | Number of Line Item Within Accounting Document | |||
100 | ![]() |
![]() |
BELUM | BELNR_D | Accounting Document Number | |||
101 | ![]() |
![]() |
BUZUM | BUZEI | Number of Line Item Within Accounting Document | |||
102 | ![]() |
![]() |
RSNUM | RSNUM | Number of reservation/dependent requirements | |||
103 | ![]() |
![]() |
RSPOS | RSPOS | Item Number of Reservation / Dependent Requirements | |||
104 | ![]() |
![]() |
KZEAR | KZEAR | Final issue for this reservation | |||
105 | ![]() |
![]() |
PBAMG | MENGE_D | Quantity | |||
106 | ![]() |
![]() |
KZSTR | KZSTR | Transaction/event is relevant to statistics | |||
107 | ![]() |
![]() |
UMMAT | UMMAT | Receiving/issuing material | |||
108 | ![]() |
![]() |
UMWRK | UMWRK | Receiving plant/issuing plant | |||
109 | ![]() |
![]() |
UMLGO | UMLGO | Receiving/issuing storage location | |||
110 | ![]() |
![]() |
UMCHA | UMCHA | Receiving/issuing batch | |||
111 | ![]() |
![]() |
UMZST | UMZST | Status of receiving batch | |||
112 | ![]() |
![]() |
UMZUS | UMZUS | Status key of transfer batch | |||
113 | ![]() |
![]() |
UMBAR | UMBAR | Valuation type of transfer batch | |||
114 | ![]() |
![]() |
UMSOK | UMSOK | Special stock indicator for physical stock transfer | |||
115 | ![]() |
![]() |
KZBEW | KZBEW | Movement Indicator | |||
116 | ![]() |
![]() |
KZVBR | KZVBR | Consumption posting | |||
117 | ![]() |
![]() |
KZZUG | KZZUG | Receipt indicator | |||
118 | ![]() |
![]() |
WEUNB | WEUNB | Goods Receipt, Non-Valuated | |||
119 | ![]() |
![]() |
PALAN | PALAN | WMS Number of pallets | |||
120 | ![]() |
![]() |
LGNUM | LGNUM | Warehouse Number / Warehouse Complex | |||
121 | ![]() |
![]() |
LGTYP | LGTYP | Storage Type | |||
122 | ![]() |
![]() |
LGPLA | LGPLA | Storage Bin | |||
123 | ![]() |
![]() |
BESTQ | BESTQ | Stock Category in the Warehouse Management System | |||
124 | ![]() |
![]() |
BWLVS | BWLVS | Movement Type for Warehouse Management | |||
125 | ![]() |
![]() |
TBNUM | TBNUM | Transfer Requirement Number | |||
126 | ![]() |
![]() |
TBPOS | TBPOS | Transfer Requirement Item | |||
127 | ![]() |
![]() |
XBLVS | XBLVS | Indicator: posting in warehouse management system | |||
128 | ![]() |
![]() |
VSCHN | T333_VSCHN | Ind: interim storage posting for source stor.type and bin | |||
129 | ![]() |
![]() |
NSCHN | T333_NSCHN | Ind.: interim storage posting for dest.stor.type and bin | |||
130 | ![]() |
![]() |
DYPLA | DYPLA | Indicator: dynamic storage bin | |||
131 | ![]() |
![]() |
UBNUM | UBNUM | Posting Change Number | |||
132 | ![]() |
![]() |
TBPRI | TBPRI | Transfer Priority | |||
133 | ![]() |
![]() |
TANUM | TANUM | Transfer Order Number | |||
134 | ![]() |
![]() |
WEANZ | WEANZ | Number of GR/GI slips to be printed | |||
135 | ![]() |
![]() |
GRUND | MB_GRBEW | Reason for movement | |||
136 | ![]() |
![]() |
EVERS | EVERS | Shipping Instructions | |||
137 | ![]() |
![]() |
EVERE | EVERE | Compliance with Shipping Instructions | |||
138 | ![]() |
![]() |
IMKEY | IMKEY | Internal Key for Real Estate Object | |||
139 | ![]() |
![]() |
KSTRG | KSTRG | Cost Object | |||
140 | ![]() |
![]() |
PAOBJNR | RKEOBJNR | Profitability Segment Number (CO-PA) | |||
141 | ![]() |
![]() |
PRCTR | PRCTR | Profit Center | |||
142 | ![]() |
![]() |
PS_PSP_PNR | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | |||
143 | ![]() |
![]() |
NPLNR | NPLNR | Network Number for Account Assignment | |||
144 | ![]() |
![]() |
AUFPL | CO_AUFPL | Routing number of operations in the order | |||
145 | ![]() |
![]() |
APLZL | CIM_COUNT | Internal counter | |||
146 | ![]() |
![]() |
AUFPS | CO_POSNR | Order item number | |||
147 | ![]() |
![]() |
VPTNR | JV_PART | Partner account number | |||
148 | ![]() |
![]() |
FIPOS | FIPOS | Commitment Item | |||
149 | ![]() |
![]() |
SAKTO | SAKNR | G/L Account Number | |||
150 | ![]() |
![]() |
BSTMG | MB_BSTMG | Goods receipt quantity in order unit | |||
151 | ![]() |
![]() |
BSTME | BSTME | Order unit | |||
152 | ![]() |
![]() |
XWSBR | XWSBR | Reversal of GR allowed for GR-based IV despite invoice | |||
153 | ![]() |
![]() |
EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
154 | ![]() |
![]() |
EXBWR | EXBWR | Externally Entered Posting Amount in Local Currency | |||
155 | ![]() |
![]() |
VKWRT | VKWRT | Value at sales prices including value-added tax | |||
156 | ![]() |
![]() |
AKTNR | WAKTION | Promotion | |||
157 | ![]() |
![]() |
ZEKKN | DZEKKN | Sequential Number of Account Assignment | |||
158 | ![]() |
![]() |
VFDAT | VFDAT | Shelf Life Expiration or Best-Before Date | |||
159 | ![]() |
![]() |
CUOBJ_CH | CUOBJ_CH | Internal object number of the batch classification | |||
160 | ![]() |
![]() |
EXVKW | EXVKW | Externally Entered Sales Value in Local Currency | |||
161 | ![]() |
![]() |
PPRCTR | PPRCTR | Partner Profit Center | |||
162 | ![]() |
![]() |
RSART | RSART | Record type | |||
163 | ![]() |
![]() |
GEBER | BP_GEBER | Fund | |||
164 | ![]() |
![]() |
FISTL | FISTL | Funds Center | |||
165 | ![]() |
![]() |
MATBF | MATBF | Material in Respect of Which Stock is Managed | |||
166 | ![]() |
![]() |
UMMAB | UMMAT | Receiving/issuing material | |||
167 | ![]() |
![]() |
BUSTM | BUSTM | Posting string for quantities | |||
168 | ![]() |
![]() |
BUSTW | BUSTW | Posting string for values | |||
169 | ![]() |
![]() |
MENGU | MENGU | Quantity Updating in Material Master Record | |||
170 | ![]() |
![]() |
WERTU | WERTU | Value Updating in Material Master Record | |||
171 | ![]() |
![]() |
LBKUM | LBKUM_MSEG | Total valuated stock before the posting | |||
172 | ![]() |
![]() |
SALK3 | SALK3_MSEG | Value of total valuated stock before the posting | |||
173 | ![]() |
![]() |
VPRSV | VPRSV | Price control indicator | |||
174 | ![]() |
![]() |
FKBER | FKBER | Functional Area | |||
175 | ![]() |
![]() |
DABRBZ | DABRBEZ | Reference date for settlement | |||
176 | ![]() |
![]() |
VKWRA | VKWRA | Value at sales prices excluding value-added tax | |||
177 | ![]() |
![]() |
DABRZ | DABRBEZ | Reference date for settlement | |||
178 | ![]() |
![]() |
XBEAU | XBEAU | Purchase order created at time of goods receipt | |||
179 | ![]() |
![]() |
LSMNG | LSMNG | Quantity in Unit of Measure from Delivery Note | |||
180 | ![]() |
![]() |
LSMEH | LSMEH | Unit of Measure From Delivery Note | |||
181 | ![]() |
![]() |
KZBWS | KZBWS | Valuation of Special Stock | |||
182 | ![]() |
![]() |
QINSPST | QINSPST | Status of Goods Receipt Inspection | |||
183 | ![]() |
![]() |
URZEI | URZEI | Original line in material document | |||
184 | ![]() |
![]() |
J_1BEXBASE | J_1BEXBASE | Alternate base amount in document currency | |||
185 | ![]() |
![]() |
MWSKZ | MWSKZ | Tax on sales/purchases code | |||
186 | ![]() |
![]() |
TXJCD | TXJCD | Tax Jurisdiction | |||
187 | ![]() |
![]() |
EMATN | EMATN | Material number corresponding to manufacturer part number | |||
188 | ![]() |
![]() |
J_1AGIRUPD | J_1AGIRUPD | Goods issue revaluation performed | |||
189 | ![]() |
![]() |
VKMWS | MWSKZ | Tax on sales/purchases code | |||
190 | ![]() |
![]() |
HSDAT | HSDAT | Date of Manufacture | |||
191 | ![]() |
![]() |
BERKZ | BERKZ | Material Staging Indicator for Production Supply | |||
192 | ![]() |
![]() |
MAT_KDAUF | MAT_KDAUF | Sales order number of valuated sales order stock | |||
193 | ![]() |
![]() |
MAT_KDPOS | MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | |||
194 | ![]() |
![]() |
MAT_PSPNR | MAT_PSPNR | Valuated customer stock WBS element | |||
195 | ![]() |
![]() |
XWOFF | XWOFF | Calculation of val. open | |||
196 | ![]() |
![]() |
BEMOT | BEMOT | Accounting Indicator | |||
197 | ![]() |
![]() |
PRZNR | CO_PRZNR | Business Process | |||
198 | ![]() |
![]() |
LLIEF | LLIEF | Supplying Vendor | |||
199 | ![]() |
![]() |
LSTAR | LSTAR | Activity Type | |||
200 | ![]() |
![]() |
XOBEW | XOBEW | Vendor Stock Valuation Indicator | |||
201 | ![]() |
![]() |
TKONN | TKONN | Trading Contract: Trading Contract Number | |||
202 | ![]() |
![]() |
TPOSN | TPOSN | Trading Contract: Item Number | |||
203 | ![]() |
![]() |
TPOSN_SUB | TPOSN_SUB | Trading Contract: Sub-Item Number | |||
204 | ![]() |
![]() |
ERNAM | ERNAM | Name of Person who Created the Object | |||
205 | ![]() |
![]() |
ERDAT | ERDAT | Date on which the record was created | |||
206 | ![]() |
![]() |
TEW_TYPE | WB2_TEW_TYPE | Trading Execution Workbench Type | |||
207 | ![]() |
![]() |
SCENARIO | WB2_BUSINESS_SCENARIO | Business Scenario | |||
208 | ![]() |
![]() |
TKONN_EX | TKONN_EX | Trading Contract: External Document Number | |||
209 | ![]() |
![]() |
COMPLETE | WB2_DOCUMENT_COMPLETE_2 | Global Trade: Item Closed | |||
210 | ![]() |
![]() |
ERROR_TEW | WB2B_ERROR_TEW | Global Trade: Error in Follow-On Document Creation | |||
211 | ![]() |
![]() |
BUSINESS_STEP | WB2_STEP | Business Process Step | |||
212 | ![]() |
![]() |
MASTER_STEP | WB2_MASTER_STEP | Main Step | |||
213 | ![]() |
![]() |
PRE_STEP | WB2_PRE_STEP | Previous Step of Business Process | |||
Maintenance Status
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 |