SAP ABAP Table U_16827 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_16827	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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
5	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
7	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
8	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
9	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
14	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
15	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
16	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
17	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
18	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
19	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
20	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
21	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
22	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
23	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
24	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
25	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
26	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
27	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
28	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
29	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
30	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
31	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
32	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
33	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
34	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
35	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
36	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	T190S
37	MAKTG	☐	MAKTG	CHAR40	CHAR	40	0	Material description in upper case for matchcodes
38	BBTYP	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type	TWBB
39	SERVV	☐	W_SERVV	W_SERVV	CHAR	2	0	Service agreement for a retail material	TWSV
40	WMAAB	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	TMABC
41	WEKGR	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
42	WVRKM	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
43	WAUSM	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
44	WHERL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
45	WHERR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
46	WLADG	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
47	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS
48	PFLKS	☐	PFLKS	PFLKS	CHAR	1	0	External assortment priority	TWSP
49	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
50	LSTVZ	☐	LSTVZ	LSTFL	CHAR	2	0	Listing procedure for distr. center assortment categories	TWLV
51	LSTAK	☐	LSTAK	LSTAK	CHAR	1	0	Listing functions (assortments) are active
52	LDVFL	☐	LDVFL	DATS	DATS	8	0	Date from which listed in the store
53	LDBFL	☐	LDBFL	DATS	DATS	8	0	Date to which listed in the store
54	LDVZL	☐	LDVZL	DATS	DATS	8	0	Date from which listed in the distribution center
55	LDBZL	☐	LDBZL	DATS	DATS	8	0	Date to which listed in the central warehouse/distr. center
56	VDVFL	☐	VDVFL	DATS	DATS	8	0	Date from which sold in the store
57	VDBFL	☐	VDBFL	DATS	DATS	8	0	Date to which sold in the store
58	VDVZL	☐	VDVZL	DATS	DATS	8	0	Date from which sold in the distribution center
59	VDBZL	☐	VDBZL	DATS	DATS	8	0	Date to which sold in the distribution center
60	WBKLA	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
61	WSTAW	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
62	WPSTA	☐	RPSTA	PSTAT	CHAR	15	0	Retail maintenance status
63	WBWSP	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
64	WEXPM	☐	EXPME	MEINS	UNIT	3	0	Unit of measure for commodity code (foreign trade)	T006
65	KWDHT	☐	KWDHT	KWDHT	CHAR	1	0	No repeat key
66	PRERF	☐	PRERF	XFELD	CHAR	1	0	Price required
67	RBZUL	☐	RBZUL	XFELD	CHAR	1	0	Discount allowed
68	SCAGR	☐	SCAGR	SCAGR	CHAR	4	0	Scales group	TWWAG
69	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
70	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
71	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_16827	BBTYP	TWBB	BBTYP
2	U_16827	BWSCL	TMBW1	BWSCL	REF	1	CN
3	U_16827	BWVOR	T6WP1	BWVOR	REF
4	U_16827	EXTWG	TWEW	EXTWG
5	U_16827	GEWEI	T006	MSEHI	REF	C	CN
6	U_16827	KOSCH	T190S	KOSCH
7	U_16827	LABOR	T024L	LABOR	REF	C	CN
8	U_16827	LSTFL	TWLV	LSTFL
9	U_16827	LSTVZ	TWLV	LSTFL
10	U_16827	MANDT	T000	MANDT	KEY	1	CN
11	U_16827	MATKL	T023	MATKL	REF	C	CN
12	U_16827	MBRSH	T137	MBRSH	REF	C	CN
13	U_16827	MEABM	T006	MSEHI	REF	C	CN
14	U_16827	MEINS	T006	MSEHI	REF	1	CN
15	U_16827	MSTAE	T141	MMSTA
16	U_16827	MTART	T134	MTART	REF	1	CN
17	U_16827	NUMTP	TNTP	NUMTP	REF	C	CN
18	U_16827	PFLKS	TWSP	PFLKS
19	U_16827	PLGTP	TWPT	PLGTP
20	U_16827	PRDHA	T179	PRODH	REF	C	CN
21	U_16827	SCAGR	TWWAG	SCAGR
22	U_16827	SERVV	TWSV	SERVV
23	U_16827	SPART	TSPA	SPART	REF	C	CN
24	U_16827	SPRAS	T002	SPRAS	KEY	1	CN
25	U_16827	SSTUF	TWSS	SSTUF
26	U_16827	VOLEH	T006	MSEHI	REF	C	CN
27	U_16827	WAUSM	T006	MSEHI
28	U_16827	WBKLA	T025	BKLAS
29	U_16827	WEKGR	T024	EKGRP
30	U_16827	WEXPM	T006	MSEHI
31	U_16827	WHERL	T005	LAND1
32	U_16827	WHERR	T005S	BLAND
33	U_16827	WLADG	TLGR	LADGR
34	U_16827	WMAAB	TMABC	MAABC
35	U_16827	WSTAW	T604	STAWN
36	U_16827	WVRKM	T006	MSEHI

History

Last changed by/on	SAP	20140121
SAP Release Created in