SAP ABAP Table U_16054 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_16054	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	LFREL	☐	LFREL_AP	XFELD	CHAR	1	0	Item is relevant for delivery
18	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
19	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
20	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
21	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
22	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
23	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
24	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
27	ABLFZ	☐	ABLFZ	ABLFZ	QUAN	13	3	Rounding quantity for delivery
28	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
29	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
30	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
31	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
32	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
33	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
34	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
35	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	TVFS
36	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
37	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
38	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
39	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
40	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
41	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
42	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
43	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
44	LSMENG	☐	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
45	KBMENG	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
46	KLMENG	☐	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
47	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
48	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
49	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
50	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
51	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
52	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
53	VOLUM	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
54	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
55	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
56	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
57	VOREF	☐	VOREF	XFELD	CHAR	1	0	Complete reference indicator
58	UPFLU	☐	UPFLV	UPFLV	CHAR	1	0	Update indicator for sales document document flow
59	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
60	STKEY	☐	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
61	STDAT	☐	STDAT	DATUM	DATS	8	0	Date of Bill of Material
62	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
63	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
64	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
65	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
66	TAXM1	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
67	TAXM2	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
68	TAXM3	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
69	TAXM4	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
70	TAXM5	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
71	TAXM6	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
72	TAXM7	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
73	TAXM8	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
74	TAXM9	☐	TAXMT	TAXKD	CHAR	1	0	Tax classification material
75	VBEAF	☐	VBEAF	DEC3_2	DEC	5	2	Fixed shipping processing time in days (= setup time)
76	VBEAV	☐	VBEAV	DEC3_2	DEC	5	2	Variable shipping processing time in days
77	VGREF	☐	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
78	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
79	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
80	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
81	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
82	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
83	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	TMVF
84	SUMBD	☐	SUMBD	SUMBD	CHAR	1	0	Summing up of requirements
85	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
86	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
87	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
88	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
89	PRSOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
90	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
91	BWTEX	☐	BWTEX	XFELD	CHAR	1	0	Indicator: Separate valuation
92	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
93	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
94	LFMNG	☐	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
95	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
96	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
97	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
98	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
99	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
100	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
101	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
102	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
103	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
104	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
105	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
106	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
107	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
108	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
109	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
110	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
111	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
112	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
113	KMPMG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
114	SUGRD	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	TVSU
115	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
116	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
117	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
118	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
119	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
120	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
121	OBJNR	☐	OBJPO	J_OBJNR	CHAR	22	0	Object number at item level	ONR00
122	ABGRS	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
123	BEDAE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	T459A
124	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
125	CMTFG	☐	CMTFG	XFELD	CHAR	1	0	ID for partial release of order item, credit block
126	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
127	CMKUA	☐	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
128	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
129	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
130	CEPOK	☐	CEPOK	CEPOK	CHAR	1	0	Status expected price
131	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
132	SERAIL	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
133	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
134	NACHL	☐	NACHL	XFELD	CHAR	1	0	Customer has not posted goods receipt
135	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
136	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
137	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
138	PROSA	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
139	UEPVW	☐	UEPVW	UEPVW	CHAR	1	0	ID for higher-level item usage
140	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
141	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant
142	SPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
143	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
144	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
145	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
146	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
147	KNUMH	☐	KNUMH_CH	KNUMB	CHAR	10	0	Number of condition record from batch determination
148	CLINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	KLAH
149	CHMVS	☐	CHMVS	NUM3	NUMC	3	0	Batches: Exit to quantity proposal
150	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
151	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
152	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
153	STMAN	☐	CUINK	XFELD	CHAR	1	0	Inconsistent configuration
154	ZSCHL_K	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
155	KALSM_K	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
156	KALVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	TCK03
157	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
158	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
159	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
160	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
161	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
162	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
163	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
164	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
165	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
166	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
167	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
168	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
169	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
170	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
171	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
172	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
173	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
174	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
175	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
176	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
177	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
178	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
179	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
180	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
181	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_16054	ABGRS	TKKAA	ABGSL	REF	C	CN
2	U_16054	AUFNR	AUFK	AUFNR	REF	C	CN
3	U_16054	BEDAE	T459A	BEDAE	REF	C	CN
4	U_16054	BONUS	TVBO	BONUS	REF	C	CN
5	U_16054	BWTAR	T149D	BWTAR	REF	C	CN
6	U_16054	BZIRK	T171	BZIRK	REF	C	CN
7	U_16054	CHARG	MCHA	CHARG	REF	C	CN
8	U_16054	CLINT	KLAH	CLINT	KEY	1	CN
9	U_16054	EXART	T605	EXART	REF	1	CN
10	U_16054	FAKSP	TVFS	FAKSP	REF	C	CN
11	U_16054	FPLNR	FPLA	FPLNR	REF	C	CN
12	U_16054	GEWEI	T006	MSEHI	REF	C	CN
13	U_16054	GSBER	TGSB	GSBER	REF	C	CN
14	U_16054	INCO1	TINC	INCO1	REF	C	CN
15	U_16054	KALSM_K	T683	KALSM		1	CN
16	U_16054	KALVAR	TCK03	KLVAR	REF	1	CN
17	U_16054	KDGRP	T151	KDGRP	REF	C	CN
18	U_16054	KMEIN	T006	MSEHI	REF	C	CN
19	U_16054	KONDA	T188	KONDA	REF	C	CN
20	U_16054	KONDM	T178	KONDM	REF	C	CN
21	U_16054	KTGRD	TVKT	KTGRD	REF	C	CN
22	U_16054	KTGRM	TVKM	KTGRM	REF	C	CN
23	U_16054	LGORT	T001L	LGORT	REF	C	CN
24	U_16054	LPRIO	TPRIO	LPRIO	REF	C	CN
25	U_16054	MAGRV	TVEGR	MAGRV	REF	C	CN
26	U_16054	MANDT	T000	MANDT	KEY	1	CN
27	U_16054	MANSP	T040S	MANSP	REF	C	CN
28	U_16054	MATKL	T023	MATKL	REF	C	CN
29	U_16054	MATNR	MARA	MATNR	REF	C	CN
30	U_16054	MATWA	MARA	MATNR	REF	C	CN
31	U_16054	MEINS	T006	MSEHI	REF	C	CN
32	U_16054	MSCHL	T040	MSCHL	REF	C	CN
33	U_16054	MTVFP	TMVF	MTVFP	REF	C	CN
34	U_16054	MVGR1	TVM1	MVGR1	REF	C	CN
35	U_16054	MVGR2	TVM2	MVGR2	REF	C	CN
36	U_16054	MVGR3	TVM3	MVGR3	REF	C	CN
37	U_16054	MVGR4	TVM4	MVGR4	REF	C	CN
38	U_16054	MVGR5	TVM5	MVGR5	REF	C	CN
39	U_16054	OBJNR	ONR00	OBJNR	REF	C	CN
40	U_16054	PERFK	TFACD	IDENT	REF	C	CN
41	U_16054	PERRL	TFACD	IDENT	REF	C	CN
42	U_16054	PLTYP	T189	PLTYP	REF	C	CN
43	U_16054	PMATN	MARA	MATNR	REF	C	CN
44	U_16054	POSNR	VBUP	POSNR	KEY	1	CN
45	U_16054	PRODH	T179	PRODH	REF	C	CN
46	U_16054	PROVG	TVPR	PROVG	REF	C	CN
47	U_16054	PSTYV	TVPT	PSTYV	REF	1	CN
48	U_16054	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
49	U_16054	ROUTE	TVRO	ROUTE	REF	C	CN
50	U_16054	SERAIL	T377P	SERAIL
51	U_16054	SERNR	SNUM	SERNR	REF	C	CN
52	U_16054	SOBKZ	T148	SOBKZ	REF	C	CN
53	U_16054	SPART	TSPA	SPART	REF	C	CN
54	U_16054	SUGRD	TVSU	SUGRD	REF	C	CN
55	U_16054	VBELN	VBUK	VBELN	KEY	1	CN
56	U_16054	VGBEL	VBUK	VBELN	REF	C	CN
57	U_16054	VGPOS	VBUP	POSNR	REF	C	CN
58	U_16054	VOLEH	T006	MSEHI	REF	C	CN
59	U_16054	VRKME	T006	MSEHI	REF	C	CN
60	U_16054	VSTEL	TVST	VSTEL	REF	C	CN
61	U_16054	WAERK	TCURC	WAERS	REF	C	CN
62	U_16054	ZIEME	T006	MSEHI	REF	C	CN
63	U_16054	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in