SAP ABAP Table U_16200 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_16200	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_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
9	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
10	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
11	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
12	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
15	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
16	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
17	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
18	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
19	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
20	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
21	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
22	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
23	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
24	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
25	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
26	ABLFZ	☐	ABLFZ	ABLFZ	QUAN	13	3	Rounding quantity for delivery
27	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
28	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
29	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
30	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
31	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
32	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
33	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
34	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
35	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
36	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
37	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
38	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
39	LSMENG	☐	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
40	KBMENG	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
41	KLMENG	☐	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
42	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
43	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
44	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
45	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
46	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
47	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
48	VOLUM	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
49	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
50	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
51	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
52	VOREF	☐	VOREF	XFELD	CHAR	1	0	Complete reference indicator
53	UPFLU	☐	UPFLV	UPFLV	CHAR	1	0	Update indicator for sales document document flow
54	ERLRE	☐	ERLRE	ERLRE	CHAR	1	0	Completion rule for quotation / contract
55	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
56	STKEY	☐	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
57	STDAT	☐	STDAT	DATUM	DATS	8	0	Date of Bill of Material
58	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
59	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
60	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
61	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
62	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
63	TAXM1	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
64	TAXM2	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
65	TAXM3	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
66	TAXM4	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
67	TAXM5	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
68	TAXM6	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
69	TAXM7	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
70	TAXM8	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
71	TAXM9	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
72	VBEAF	☐	VBEAF	DEC3_2	DEC	5	2	Fixed shipping processing time in days (= setup time)
73	VBEAV	☐	VBEAV	DEC3_2	DEC	5	2	Variable shipping processing time in days
74	VGREF	☐	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
75	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
76	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
77	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
78	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
79	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	TMVF
80	SUMBD	☐	SUMBD	SUMBD	CHAR	1	0	Summing up of requirements
81	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
82	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
83	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
84	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
85	PRSOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
86	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
87	BWTEX	☐	BWTEX	XFELD	CHAR	1	0	Indicator: Separate valuation
88	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
89	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
90	LFMNG	☐	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
91	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
92	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
93	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
94	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
95	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
96	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
97	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
98	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
99	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
100	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
101	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
102	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
103	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
104	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
105	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
106	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
107	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
108	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
109	KMPMG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
110	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
111	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
112	OBJNR	☐	OBJPO	J_OBJNR	CHAR	22	0	Object number at item level	ONR00
113	ABGRS	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
114	BEDAE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	T459A
115	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
116	CMTFG	☐	CMTFG	XFELD	CHAR	1	0	ID for partial release of order item, credit block
117	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
118	CMKUA	☐	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
119	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
120	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
121	CEPOK	☐	CEPOK	CEPOK	CHAR	1	0	Status expected price
122	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
123	SERAIL	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
124	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
125	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
126	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
127	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
128	PROSA	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
129	SPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
130	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
131	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
132	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
133	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
134	KNUMH	☐	KNUMH_CH	KNUMB	CHAR	10	0	Number of condition record from batch determination
135	CLINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	KLAH
136	CHMVS	☐	CHMVS	NUM3	NUMC	3	0	Batches: Exit to quantity proposal
137	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
138	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
139	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
140	STMAN	☐	CUINK	XFELD	CHAR	1	0	Inconsistent configuration
141	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
142	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
143	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
144	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
145	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
146	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
147	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
148	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
149	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
150	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
151	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
152	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
153	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
154	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
155	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
156	POPER	☐	POPER	POPER	NUMC	3	0	Posting period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_16200	ABGRS	TKKAA	ABGSL	REF	C	CN
2	U_16200	ABGRU	TVAG	ABGRU	REF	C	CN
3	U_16200	BEDAE	T459A	BEDAE	REF	C	CN
4	U_16200	BONUS	TVBO	BONUS	REF	C	CN
5	U_16200	BWTAR	T149D	BWTAR	REF	C	CN
6	U_16200	BZIRK	T171	BZIRK	REF	C	CN
7	U_16200	CHARG	MCHA	CHARG	REF	C	CN
8	U_16200	CLINT	KLAH	CLINT	KEY	1	CN
9	U_16200	EXART	T605	EXART	REF	1	CN
10	U_16200	GEWEI	T006	MSEHI	REF	C	CN
11	U_16200	GSBER	TGSB	GSBER	REF	C	CN
12	U_16200	INCO1	TINC	INCO1	REF	C	CN
13	U_16200	KDGRP	T151	KDGRP	REF	C	CN
14	U_16200	KMEIN	T006	MSEHI	REF	C	CN
15	U_16200	KONDA	T188	KONDA	REF	C	CN
16	U_16200	KONDM	T178	KONDM	REF	C	CN
17	U_16200	KTGRD	TVKT	KTGRD	REF	C	CN
18	U_16200	KTGRM	TVKM	KTGRM	REF	C	CN
19	U_16200	LGORT	T001L	LGORT	REF	C	CN
20	U_16200	LPRIO	TPRIO	LPRIO	REF	C	CN
21	U_16200	MAGRV	TVEGR	MAGRV	REF	C	CN
22	U_16200	MANDT	T000	MANDT	KEY	1	CN
23	U_16200	MATKL	T023	MATKL	REF	C	CN
24	U_16200	MATNR	MARA	MATNR	REF	C	CN
25	U_16200	MATWA	MARA	MATNR	REF	C	CN
26	U_16200	MEINS	T006	MSEHI	REF	C	CN
27	U_16200	MTVFP	TMVF	MTVFP	REF	C	CN
28	U_16200	MVGR1	TVM1	MVGR1	REF	C	CN
29	U_16200	MVGR2	TVM2	MVGR2	REF	C	CN
30	U_16200	MVGR3	TVM3	MVGR3	REF	C	CN
31	U_16200	MVGR4	TVM4	MVGR4	REF	C	CN
32	U_16200	MVGR5	TVM5	MVGR5	REF	C	CN
33	U_16200	OBJNR	ONR00	OBJNR	REF	C	CN
34	U_16200	PLTYP	T189	PLTYP	REF	C	CN
35	U_16200	PMATN	MARA	MATNR	REF	C	CN
36	U_16200	POSNR	VBUP	POSNR	KEY	1	CN
37	U_16200	PRODH	T179	PRODH	REF	C	CN
38	U_16200	PROVG	TVPR	PROVG	REF	C	CN
39	U_16200	PSTYV	TVPT	PSTYV	REF	1	CN
40	U_16200	ROUTE	TVRO	ROUTE	REF	C	CN
41	U_16200	SERAIL	T377P	SERAIL
42	U_16200	SERNR	SNUM	SERNR	REF	C	CN
43	U_16200	SPART	TSPA	SPART	REF	C	CN
44	U_16200	VBELN	VBUK	VBELN	KEY	1	CN
45	U_16200	VGBEL	VBUK	VBELN	REF	C	CN
46	U_16200	VGPOS	VBUP	POSNR	REF	C	CN
47	U_16200	VOLEH	T006	MSEHI	REF	C	CN
48	U_16200	VRKME	T006	MSEHI	REF	C	CN
49	U_16200	VSTEL	TVST	VSTEL	REF	C	CN
50	U_16200	WAERK	TCURC	WAERS	REF	C	CN
51	U_16200	ZIEME	T006	MSEHI	REF	C	CN
52	U_16200	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in