SAP ABAP Table MGV_WBHI (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_WBHI	ABGRU	TVAG	ABGRU	REF	1	CN
2	MGV_WBHI	ASSOC_GROUP	TASSGROUP	ASSOC_GROUP	REF	1	CN
3	MGV_WBHI	BASIS_MEINS	T006	MSEHI	REF	1	CN
4	MGV_WBHI	BPRME_MM	T006	MSEHI	REF	1	CN
5	MGV_WBHI	BWTAR	T149D	BWTAR	KEY	1	CN
6	MGV_WBHI	BWTTY_MM	T149C	BWTTY	REF	1	CN
7	MGV_WBHI	COMMODITY	TCOM	COMMODITY
8	MGV_WBHI	FAKSP_SD	TVFS	FAKSP	REF	1	CN
9	MGV_WBHI	GEWEI	T006	MSEHI	REF	1	CN
10	MGV_WBHI	GSBER	TGSB	GSBER	REF	1	CN
11	MGV_WBHI	HKPSTP	TB2BK	HKPSTP	REF	1	CN
12	MGV_WBHI	KBELN	WKBK	KBELN	KEY	1	CN
13	MGV_WBHI	KBELP	WKBP	KBELP	KEY	1	CN
14	MGV_WBHI	KMEIN_SD	T006	MSEHI	REF	1	CN
15	MGV_WBHI	KNTTP_MM	T163K	KNTTP	REF	1	CN
16	MGV_WBHI	KOSTL	CSKS	KOSTL	REF	1	CN
17	MGV_WBHI	LGORT	T001L	LGORT	REF	1	CN
18	MGV_WBHI	MANDT	T000	MANDT	KEY	1	CN
19	MGV_WBHI	MATNR	MARA	MATNR	REF	1	CN
20	MGV_WBHI	MATWA	MARA	MATNR
21	MGV_WBHI	MEINS	T006	MSEHI	REF	1	CN
22	MGV_WBHI	MVGR1	TVM1	MVGR1	REF	1	CN
23	MGV_WBHI	MVGR2	TVM2	MVGR2	REF	1	CN
24	MGV_WBHI	MVGR3	TVM3	MVGR3	REF	1	CN
25	MGV_WBHI	MVGR4	TVM4	MVGR4	REF	1	CN
26	MGV_WBHI	MVGR5	TVM5	MVGR5	REF	1	CN
27	MGV_WBHI	MWSKZ_MM	T007A	MWSKZ	REF	1	CN
28	MGV_WBHI	PMATN	MARA	MATNR	REF	1	CN
29	MGV_WBHI	PORTFOLIO	KONHM	KNUMH	REF	1	CN
30	MGV_WBHI	PRCTR	CEPC	PRCTR	REF	1	CN
31	MGV_WBHI	PRODH	T179	PRODH	REF	1	CN
32	MGV_WBHI	PSTYP	T163	PSTYP
33	MGV_WBHI	PSTYP_MM	T163	PSTYP	REF	1	CN
34	MGV_WBHI	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
35	MGV_WBHI	ROUTE_SD	TVRO	ROUTE	REF	1	CN
36	MGV_WBHI	SCENARIO	TEWSCENARIO	SCENARIO	REF	1	CN
37	MGV_WBHI	SDWRS	TCURC	WAERS	REF	1	CN
38	MGV_WBHI	SPART	TSPA	SPART	REF	1	CN
39	MGV_WBHI	TKONN	WBHK	TKONN	KEY	1	CN
40	MGV_WBHI	TXJCD_MM	TTXJ	TXJCD		1	CN
41	MGV_WBHI	VKAUS	TVLV	ABRVW	REF	1	CN
42	MGV_WBHI	VOLEH	T006	MSEHI	REF	1	CN
43	MGV_WBHI	VRKME	T006	MSEHI	REF	1	CN
44	MGV_WBHI	VSTEL_SD	TVST	VSTEL	REF	1	CN
45	MGV_WBHI	WAERS_MM	TCURC	WAERS	REF	1	CN
46	MGV_WBHI	WAERS_PURCH	TCURC	WAERS	REF	1	CN
47	MGV_WBHI	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in