SAP ABAP View WB2_V_MKPF_MSEG2 (Data Selection from Material Documents (without WBGT))

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_MSEG2
Short Description	Data Selection from Material Documents (without WBGT)
Root table	MKPF	Header: Material Document

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MKPF	MKPF
2	MSEG

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

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