SAP ABAP Table ENT6077 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT6077	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster	VBRP
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	VBELN	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
3	POSNR	☑	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
4	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
5	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
6	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
7	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
8	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
10	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
11	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
12	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
13	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
14	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
15	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
16	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
17	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
18	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
19	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
20	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
21	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
22	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
25	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
26	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
27	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
28	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
29	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
30	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
31	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
32	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
33	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment
34	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
35	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
36	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	T005S
37	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
38	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
39	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material
40	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material
41	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material
42	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material
43	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material
44	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material
45	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material
46	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material
47	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material
48	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
49	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
50	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
51	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
52	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
53	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
54	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
55	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
56	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
57	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
58	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
59	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
60	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
61	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
62	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
63	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
64	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
65	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
66	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
67	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
68	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
69	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
70	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
71	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
72	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
73	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
74	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
75	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
76	UVALL	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
77	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
78	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
79	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
80	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
81	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
82	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
83	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
84	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
85	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
86	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
87	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
88	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
89	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
90	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
91	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
92	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
93	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
94	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
95	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
96	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
97	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
98	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
99	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
100	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
101	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
102	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
103	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
104	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT6077	ALAND	T005	LAND1	REF	1	CN
2	ENT6077	AUFNR	AUFK	AUFNR	REF	C	CN
3	ENT6077	BONUS	TVBO	BONUS	REF	C	CN
4	ENT6077	BWTAR	T149D	BWTAR	REF	C	CN
5	ENT6077	CHARG	MCHA	CHARG	REF	C	CN
6	ENT6077	GEWEI	T006	MSEHI	REF	C	CN
7	ENT6077	GSBER	TGSB	GSBER	REF	C	CN
8	ENT6077	KOKRS	TKA01	KOKRS	REF	C	CN
9	ENT6077	KONDM	T178	KONDM	REF	C	CN
10	ENT6077	KTGRM	TVKM	KTGRM	REF	C	CN
11	ENT6077	KVGR1	TVV1	KVGR1	REF	C	CN
12	ENT6077	KVGR2	TVV2	KVGR2	REF	C	CN
13	ENT6077	KVGR3	TVV3	KVGR3	REF	C	CN
14	ENT6077	KVGR4	TVV4	KVGR4	REF	C	CN
15	ENT6077	KVGR5	TVV5	KVGR5	REF	C	CN
16	ENT6077	LGORT	T001L	LGORT	REF	C	CN
17	ENT6077	MANDT	T000	MANDT	KEY	1	CN
18	ENT6077	MATKL	T023	MATKL	REF	C	CN
19	ENT6077	MATNR	MARA	MATNR	REF	C	CN
20	ENT6077	MATWA	MARA	MATNR	REF	C	CN
21	ENT6077	MEINS	T006	MSEHI	REF	C	CN
22	ENT6077	MVGR1	TVM1	MVGR1	REF	C	CN
23	ENT6077	MVGR2	TVM2	MVGR2	REF	C	CN
24	ENT6077	MVGR3	TVM3	MVGR3	REF	C	CN
25	ENT6077	MVGR4	TVM4	MVGR4	REF	C	CN
26	ENT6077	MVGR5	TVM5	MVGR5	REF	C	CN
27	ENT6077	PMATN	MARA	MATNR	REF	C	CN
28	ENT6077	POSNR	VBUP	POSNR	KEY	1	C
29	ENT6077	PRODH	T179	PRODH	REF	C	CN
30	ENT6077	PROVG	TVPR	PROVG	REF	C	CN
31	ENT6077	SPARA	TSPA	SPART	REF	C	CN
32	ENT6077	SPART	TSPA	SPART	REF	C	CN
33	ENT6077	VBELN	VBUK	VBELN	KEY	1	CN
34	ENT6077	VGBEL	VBUK	VBELN	REF	1	CN
35	ENT6077	VGPOS	VBUP	POSNR	REF	1	CN
36	ENT6077	VKBUR	TVBUR	VKBUR	REF	C	CN
37	ENT6077	VKGRP	TVKGR	VKGRP	REF	C	CN
38	ENT6077	VOLEH	T006	MSEHI	REF	C	CN
39	ENT6077	VRKME	T006	MSEHI	REF	C	CN
40	ENT6077	VSTEL	TVST	VSTEL	REF	C	CN
41	ENT6077	WERKS	T001W	WERKS	REF	C	CN
42	ENT6077	WKREG	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in