SAP ABAP View U_16829 (Value-only material)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	U_16829
Short Description	Value-only material
Root table	MARA	General Material Data

Entity Type	DM02L
Short text	Value-only material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MAKT
3	MAW1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ		0		0	0
2	MAKT	MANDT	JR	EQ		0	AND	0	0
3	MARA	MATNR	JL	EQ		0		0	0
4	MAKT	MATNR	JR	EQ		0	AND	0	0
5	MARA	MANDT	JL	EQ		0		0	0
6	MAKT	MANDT	JR	EQ		0	AND	0	0
7	MARA	MATNR	JL	EQ		0		0	0
8	MAKT	MATNR	JR	EQ		0	AND	0	0
9	MARA	MANDT	JL	EQ		0		0	0
10	MAW1	MANDT	JR	EQ		0	AND	0	0
11	MARA	MATNR	JL	EQ		0		0	0
12	MAW1	MATNR	JR	EQ		0	AND	0	0
13	MARA	MANDT	JL	EQ		0		0	0
14	MAKT	MANDT	JR	EQ		0	AND	0	0
15	MARA	MATNR	JL	EQ		0		0	0
16	MAKT	MATNR	JR	EQ		0	AND	0	0
17	MARA	ATTYP		GE	'20'	0	AND	0	0
18	MARA	ATTYP		LE	'22'	0		0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in