SAP ABAP Table U_16076 (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20131127
SAP Release Created in