SAP ABAP View MGV_WBHI (Selection WBHI with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_WBHI
Short Description	Selection WBHI with material version, see: http://material
Root table	WBHI	Trading Contract: Item Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WBHI	WBHI
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WBHI	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	WBHI	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WBHI	*		☐		☐
2	MANDT	WBHI	MANDT		☐	MANDT	☐	Client
3	TKONN	WBHI	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
4	TPOSN	WBHI	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
5	TPOSN_SUB	WBHI	TPOSN_SUB		☐	TPOSN_SUB	☐	Trading Contract: Sub-Item Number
6	MATNR	WBHI	MATNR		☐	MATNR	☐	Material Number
7	WERKS	WBHI	WERKS		☐	WERKS_D	☐	Plant
8	LGORT	WBHI	LGORT		☐	LGORT_D	☐	Storage location
9	KWMENG	WBHI	KWMENG		☐	WKWMENG	☐	Cumulative Order Quantity in Sales Units
10	VRKME	WBHI	VRKME		☐	VRKME	☐	Sales unit
11	UMVKZ	WBHI	UMVKZ		☐	UMVKZ	☐	Numerator (factor) for conversion of sales quantity into SKU
12	UMVKN	WBHI	UMVKN		☐	UMVKN	☐	Denominator (divisor) for conversion of sales qty. into SKU
13	BASIS_MEINS	WBHI	BASIS_MEINS		☐	MEINS	☐	Base Unit of Measure
14	ARKTX	WBHI	ARKTX		☐	ARKTX	☐	Short text for sales order item
15	BWTAR	WBHI	BWTAR		☐	BWTAR_D	☐	Valuation type
16	CHARG	WBHI	CHARG		☐	CHARG_D	☐	Batch Number
17	GROES	WBHI	GROES		☐	GROES	☐	Size/dimensions
18	MENGE	WBHI	MENGE		☐	BSMNG	☐	Quantity ordered against this purchase requisition
19	MEINS	WBHI	MEINS		☐	BSTME	☐	Order unit
20	BPRME_MM	WBHI	BPRME_MM		☐	BBPRM	☐	Order Price Unit (purchasing)
21	BPUMZ_MM	WBHI	BPUMZ_MM		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
22	BPUMN_MM	WBHI	BPUMN_MM		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
23	UMREZ_MM	WBHI	UMREZ_MM		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
24	UMREN_MM	WBHI	UMREN_MM		☐	UMREN	☐	Denominator for conversion to base units of measure
25	PEINH_MM	WBHI	PEINH_MM		☐	EPEIN	☐	Price unit
26	NETPR_MM	WBHI	NETPR_MM		☐	MMBTR	☐	Trading Contract: Purchase Price
27	WAERS_MM	WBHI	WAERS_MM		☐	MMWRS	☐	Trading Contract: Purchasing Currency
28	NETPR_SD	WBHI	NETPR_SD		☐	SDBTR	☐	Trading Contract: Sales Price
29	ERNAM	WBHI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
30	ERDAT	WBHI	ERDAT		☐	ERDAT	☐	Date on which the record was created
31	ERZET	WBHI	ERZET		☐	ERZET	☐	Entry time
32	MATKL	WBHI	MATKL		☐	MATKL	☐	Material Group
33	UEBTK_SD	WBHI	UEBTK_SD		☐	UEBTK_V	☐	Unlimited overdelivery allowed
34	UEBTO_SD	WBHI	UEBTO_SD		☐	UEBTO	☐	Overdelivery Tolerance Limit
35	UNTTO_SD	WBHI	UNTTO_SD		☐	UNTTO	☐	Underdelivery Tolerance Limit
36	HKPSTP	WBHI	HKPSTP		☐	HKPSTP	☐	Trading Contract: Item Category
37	FT_ITEM_COM	WBHI	FT_ITEM_COM		☐	HKCOM	☐	Trading Contract: Document is Complete
38	ABGRU	WBHI	ABGRU		☐	ABGRU_VA	☐	Reason for rejection of quotations and sales orders
39	PRODH	WBHI	PRODH		☐	PRODH_D	☐	Product Hierarchy
40	KDMAT	WBHI	KDMAT		☐	MATNR_KU	☐	Customer Material Number
41	SPART	WBHI	SPART		☐	SPART	☐	Division
42	GSBER	WBHI	GSBER		☐	GSBER	☐	Business Area
43	BRGEW	WBHI	BRGEW		☐	BRGEW_AP	☐	Gross weight of item
44	NTGEW	WBHI	NTGEW		☐	NTGEW_AP	☐	Net weight of item
45	GEWEI	WBHI	GEWEI		☐	GEWEI	☐	Weight Unit
46	VOLUM	WBHI	VOLUM		☐	VOLUM_AP	☐	Volume of the item
47	VOLEH	WBHI	VOLEH		☐	VOLEH	☐	Volume unit
48	TAXM1	WBHI	TAXM1		☐	TAXMT	☐	Tax classification material
49	TAXM2	WBHI	TAXM2		☐	TAXMT	☐	Tax classification material
50	TAXM3	WBHI	TAXM3		☐	TAXMT	☐	Tax classification material
51	TAXM4	WBHI	TAXM4		☐	TAXMT	☐	Tax classification material
52	TAXM5	WBHI	TAXM5		☐	TAXMT	☐	Tax classification material
53	TAXM6	WBHI	TAXM6		☐	TAXMT	☐	Tax classification material
54	TAXM7	WBHI	TAXM7		☐	TAXMT	☐	Tax classification material
55	TAXM8	WBHI	TAXM8		☐	TAXMT	☐	Tax classification material
56	TAXM9	WBHI	TAXM9		☐	TAXMT	☐	Tax classification material
57	EAN11	WBHI	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
58	PRCTR	WBHI	PRCTR		☐	PRCTR	☐	Profit Center
59	KOSTL	WBHI	KOSTL		☐	KOSTL	☐	Cost Center
60	MVGR1	WBHI	MVGR1		☐	MVGR1	☐	Material group 1
61	MVGR2	WBHI	MVGR2		☐	MVGR2	☐	Material group 2
62	MVGR3	WBHI	MVGR3		☐	MVGR3	☐	Material group 3
63	MVGR4	WBHI	MVGR4		☐	MVGR4	☐	Material group 4
64	MVGR5	WBHI	MVGR5		☐	MVGR5	☐	Material group 5
65	FAKSP_SD	WBHI	FAKSP_SD		☐	FAKSP_AP	☐	Billing block for item
66	ANTLF_SD	WBHI	ANTLF_SD		☐	ANTLF	☐	Maximum number of partial deliveries allowed per item
67	KZTLF_SD	WBHI	KZTLF_SD		☐	KZTLF	☐	Partial delivery at item level
68	VSTEL_SD	WBHI	VSTEL_SD		☐	VSTEL	☐	Shipping Point/Receiving Point
69	ROUTE_SD	WBHI	ROUTE_SD		☐	ROUTE	☐	Route
70	SDWRS	WBHI	SDWRS		☐	WAERK	☐	SD document currency
71	NETWRT_SD	WBHI	NETWRT_SD		☐	WB2_NETWRT_SD_TC	☐	Net Value at Retail for Item in Document Currency
72	WAERS_PURCH	WBHI	WAERS_PURCH		☐	WAERS	☐	Currency Key
73	NETWRT_MM	WBHI	NETWRT_MM		☐	BWERT	☐	Net Order Value in PO Currency
74	MWSKZ_MM	WBHI	MWSKZ_MM		☐	MWSKZ	☐	Tax on sales/purchases code
75	UEBTK_MM	WBHI	UEBTK_MM		☐	UEBTK	☐	Indicator: Unlimited Overdelivery Allowed
76	UNTTO_MM	WBHI	UNTTO_MM		☐	UNTTO	☐	Underdelivery Tolerance Limit
77	BWTTY_MM	WBHI	BWTTY_MM		☐	BWTTY_D	☐	Valuation Category
78	PSTYP_MM	WBHI	PSTYP_MM		☐	PSTYP	☐	Item category in purchasing document
79	KNTTP_MM	WBHI	KNTTP_MM		☐	KNTTP	☐	Account assignment category
80	LEWED_MM	WBHI	LEWED_MM		☐	LEWED	☐	Latest Possible Goods Receipt
81	UEBTO_MM	WBHI	UEBTO_MM		☐	UEBTO	☐	Overdelivery Tolerance Limit
82	KPEIN_SD	WBHI	KPEIN_SD		☐	KPEIN	☐	Condition pricing unit
83	KMEIN_SD	WBHI	KMEIN_SD		☐	KMEIN	☐	Condition Unit
84	BPUMZ_SD	WBHI	BPUMZ_SD		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
85	BPUMN_SD	WBHI	BPUMN_SD		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
86	LOEKZ	WBHI	LOEKZ		☐	WB2_DEL_IND	☐	Deletion Indicator in Trading Contract
87	KBELN	WBHI	KBELN		☐	KBELN	☐	Number of pricing document
88	KBELP	WBHI	KBELP		☐	KBELP	☐	Item Number of Pricing Document
89	NTGEW_MM	WBHI	NTGEW_MM		☐	ENTGE	☐	Net Weight
90	BRGEW_MM	WBHI	BRGEW_MM		☐	BRGEW	☐	Gross weight
91	VOLUM_MM	WBHI	VOLUM_MM		☐	VOLUM	☐	Volume
92	PSTYP	WBHI	PSTYP		☐	PSTYP	☐	Item category in purchasing document
93	CUOBJ_CH	WBHI	CUOBJ_CH		☐	CUOBJ_CH	☐	Internal object number of the batch classification
94	NETWRT_IN_SDWRS	WBHI	NETWRT_IN_SDWRS		☐	NETWR_AP	☐	Net value of the order item in document currency
95	PORTFOLIO	WBHI	PORTFOLIO		☐	WB2_PORTFOLIO	☐	Global Trade: (Internal) Portfolio Number
96	PORTFOLIO_DATE	WBHI	PORTFOLIO_DATE		☐	WB2_PORTFOLIO_DATE	☐	Date for Portfolio Determination
97	TKONN_FROM	WBHI	TKONN_FROM		☐	TKONN_FROM	☐	Trading Contract: Reference Document
98	TPOSN_FROM	WBHI	TPOSN_FROM		☐	TPOSN_FROM	☐	Trading Contract: Reference Item
99	TPOSN_SUB_FROM	WBHI	TPOSN_SUB_FROM		☐	TPOSN_SUB_FROM	☐	Trading Contract: Reference Subitem
100	TCTYP_FROM	WBHI	TCTYP_FROM		☐	TCTYP	☐	Trading Contract: Trading Contract Type
101	SCENARIO	WBHI	SCENARIO		☐	WB2_BUSINESS_SCENARIO	☐	Business Scenario
102	ASSOC_GROUP	WBHI	ASSOC_GROUP		☐	WB2_ASSOC_GROUP	☐	Assoc. Mngt: Association Group
103	COMPLETE	WBHI	COMPLETE		☐	WB2_DOCUMENT_COMPLETE	☐	Trading Contract: Item Is Completed
104	IDNLF	WBHI	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
105	NETWRT_IN_WAERS	WBHI	NETWRT_IN_WAERS		☐	NETWRT_MM	☐	Global Trade: Value in PO Currency
106	TKONN_FROM_2	WBHI	TKONN_FROM_2		☐	TKONN_FROM	☐	Trading Contract: Reference Document
107	TPOSN_FROM_2	WBHI	TPOSN_FROM_2		☐	TPOSN_FROM	☐	Trading Contract: Reference Item
108	TPOSN_SUB_FROM_2	WBHI	TPOSN_SUB_FROM_2		☐	TPOSN_SUB_FROM	☐	Trading Contract: Reference Subitem
109	TCTYP_FROM_2	WBHI	TCTYP_FROM_2		☐	TCTYP	☐	Trading Contract: Trading Contract Type
110	MATWA	WBHI	MATWA		☐	MATWA	☐	Material entered
111	CHANGE_INFOS	WBHI	CHANGE_INFOS		☐	CHANGE_INFOS	☐	Bit Encrypted Flags for WBHI
112	KZWI1	WBHI	KZWI1		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
113	KZWI2	WBHI	KZWI2		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
114	KZWI3	WBHI	KZWI3		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
115	KZWI4	WBHI	KZWI4		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
116	KZWI5	WBHI	KZWI5		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
117	KZWI6	WBHI	KZWI6		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
118	KZWI1D	WBHI	KZWI1D		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
119	KZWI2D	WBHI	KZWI2D		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
120	KZWI3D	WBHI	KZWI3D		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
121	KZWI4D	WBHI	KZWI4D		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
122	KZWI5D	WBHI	KZWI5D		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
123	KZWI6D	WBHI	KZWI6D		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
124	UEPOS	WBHI	UEPOS		☐	UEPOS	☐	Higher-level item in bill of material structures
125	WUVPRS	WBHI	WUVPRS		☐	WB2UVPRS	☐	Global Trade: Incompleteness Price Determination
126	KMPMG	WBHI	KMPMG		☐	KMPMG	☐	Component Quantity
127	FMENG	WBHI	FMENG		☐	FMENG	☐	Quantity is fixed
128	STDAT	WBHI	STDAT		☐	STDAT	☐	Date of Bill of Material
129	STLTY	WBHI	STLTY		☐	STLTY	☐	BOM Category
130	STLNR	WBHI	STLNR		☐	STNUM	☐	Bill of Material
131	STKEY	WBHI	STKEY		☐	STKEY	☐	Origin of the bill of material
132	KMPMG_SD	WBHI	KMPMG_SD		☐	KMPMG	☐	Component Quantity
133	PMATN	WBHI	PMATN		☐	PMATN	☐	Pricing Reference Material
134	VKAUS	WBHI	VKAUS		☐	ABRVW	☐	Usage Indicator
135	POSEX	WBHI	POSEX		☐	POSEX	☐	Item Number of the Underlying Purchase Order
136	PS_PSP_PNR	WBHI	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
137	EFFWR_SD	WBHI	EFFWR_SD		☐	EFFWR	☐	Effective value of item
138	EFFWR_MM	WBHI	EFFWR_MM		☐	EFFWR	☐	Effective value of item
139	COMMODITY	WBHI	COMMODITY		☐	WCOMMODITY	☐	Commodity Definition
140	SKTOF_SD	WBHI	SKTOF_SD		☐	SKTOF	☐	Cash discount indicator
141	SKTOF_MM	WBHI	SKTOF_MM		☐	SKTOF	☐	Cash discount indicator
142	MWSBP_MM	WBHI	MWSBP_MM		☐	MWSBP	☐	Tax amount in document currency
143	MWSBP_SD	WBHI	MWSBP_SD		☐	MWSBP	☐	Tax amount in document currency
144	TXJCD_MM	WBHI	TXJCD_MM		☐	TXJCD	☐	Tax Jurisdiction
145	CUOBJ_SD	WBHI	CUOBJ_SD		☐	WB2B_VC_CUOBJ_SD	☐	Configuration in the Trading Contract: CUOBJ SD Side
146	CUOBJ_MM	WBHI	CUOBJ_MM		☐	WB2B_VC_CUOBJ_MM	☐	Configuration in the Trading Contract: CUOBJ MM Side
147	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
148	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☐	Material Version Number

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