SAP ABAP View MA07V (Material Master: DB View for Inventory Management)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

View Type	D	Database View
Database View	MA07V
Short Description	Material Master: DB View for Inventory Management
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MARC

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
2	MARC	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MARC	MATNR	JR	EQ				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	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
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	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
9	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
10	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
11	DISST	MARA	DISST		☐	DISST	☐	Low-level code
12	WESCH	MARA	WESCH		☐	WESCH	☐	Quantity: Number of GR/GI slips to be printed
13	ETIFO	MARA	ETIFO		☐	ETIFO	☐	Label form
14	ETIAR	MARA	ETIAR		☐	ETIAR	☐	Label type
15	PSTAT	MARC	PSTAT		☐	PSTAT_D	☐	Maintenance status
16	LVORM	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
17	BWTTY	MARC	BWTTY		☐	BWTTY_D	☐	Valuation Category
18	XCHAR	MARC	XCHAR		☐	XCHAR	☐	Batch management indicator (internal)
19	AUSME	MARC	AUSME		☐	AUSME	☐	Unit of issue
20	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
21	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
22	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
23	PLIFZ	MARC	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
24	WEBAZ	MARC	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
25	EISBE	MARC	EISBE		☐	EISBE	☐	Safety stock
26	MINBE	MARC	MINBE		☐	MINBE	☐	Reorder point
27	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
28	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
29	PERKZ	MARC	PERKZ		☐	PERKZ	☐	Period indicator
30	SSQSS	MARC	SSQSS		☐	QSSPUR	☐	Control Key for Quality Management in Procurement
31	UMLMC	MARC	UMLMC		☐	UMLME	☐	Stock in transfer (plant to plant)
32	TRAME	MARC	TRAME		☐	TRAME	☐	Stock in transit
33	PERIM	MARC	PERIV		☐	PERIV	☐	Fiscal Year Variant
34	SPART	MARA	SPART		☐	SPART	☐	Division
35	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
36	MMSTD	MARC	MMSTD		☐	MMSTD	☐	Date from which the plant-specific material status is valid
37	MISKZ	MARC	MISKZ		☐	MISKZ	☐	Mixed MRP indicator
38	WZEIT	MARC	WZEIT		☐	WZEIT	☐	Total replenishment lead time (in workdays)
39	VRMOD	MARC	VRMOD		☐	VRMOD	☐	Consumption mode
40	VINT1	MARC	VINT1		☐	VINT1	☐	Consumption period: backward
41	VINT2	MARC	VINT2		☐	VINT2	☐	Consumption period: forward
42	MTVFP	MARC	MTVFP		☐	MTVFP	☐	Checking Group for Availability Check
43	DISGR	MARC	DISGR		☐	DISGR	☐	MRP Group
44	APOKZ	MARC	APOKZ		☐	APOKZ	☐	Indicator: Is material relevant for APO
45	ABCIN	MARC	ABCIN		☐	ABCIN	☐	Physical inventory indicator for cycle counting
46	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
47	XMCNG	MARC	XMCNG		☐	XMCNG	☐	Negative stocks allowed in plant
48	SERNP	MARC	SERNP		☐	SERAIL	☐	Serial Number Profile
49	EKWSL	MARA	EKWSL		☐	EKWSL	☐	Purchasing Value Key
50	MHDRZ	MARA	MHDRZ		☐	MHDRZ	☐	Minimum Remaining Shelf Life
51	MHDHB	MARA	MHDHB		☐	MHDHB	☐	Total shelf life
52	MHDLP	MARA	MHDLP		☐	MHDLP	☐	Storage percentage
53	CCFIX	MARC	CCFIX		☐	CCFIX	☐	CC indicator is fixed
54	EPRIO	MARC	EPRIO		☐	BF_GROUP	☐	Stock determination group
55	DZEIT	MARC	DZEIT		☐	DZEIT	☐	In-house production time
56	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
57	SATNR	MARA	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
58	PLGTP	MARA	PLGTP		☐	PLGTP	☐	Price band category
59	SAISO	MARA	SAISO		☐	SAISO	☐	Season Category
60	BWVOR	MARA	BWVOR		☐	BWVOR	☐	Procurement rule
61	BWSCL	MARA	BWSCL		☐	BWSCL	☐	Source of Supply
62	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
63	SERVG	MARC	SERVG		☐	W_SERVGRD	☐	IS-R service level
64	STRGR	MARC	STRGR		☐	STRGR	☐	Planning strategy group
65	PRFRQ	MARC	PRFRQ		☐	PRFRQ	☐	Interval until next recurring inspection
66	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
67	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
68	MLGUT	MARA	MLGUT		☐	W_MITLEERG	☐	Empties Bill of Material
69	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
70	SAISJ	MARA	SAISJ		☐	SAISJ	☐	Season Year
71	VKUMC	MARC	VKUMC		☐	VKUMC	☐	Stock transfer sales value (plant to plant) for VO material
72	VKTRW	MARC	VKTRW		☐	VKTRW	☐	Transit value at sales price for value-only material
73	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
74	CUOBF	MARA	CUOBF		☐	CUOBM	☐	Internal object number
75	SERLV	MARA	SERLV		☐	SERLV	☐	Level of Explicitness for Serial Number
76	GLGMG	MARC	GLGMG		☐	GLGMG	☐	Tied empties stock
77	VKGLG	MARC	VKGLG		☐	VKGLG	☐	Sales value of tied empties stock
78	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
79	IPRKZ	MARA	IPRKZ		☐	DATTP	☐	Period Indicator for Shelf Life Expiration Date
80	RDMHD	MARA	RDMHD		☐	RDMHD	☐	Rounding rule for calculation of SLED
81	MCRUE	MARC	MCRUE		☐	MCRUE	☐	MARDH rec. already exists for per. before last of MARD per.
82	LADGR	MARC	LADGR		☐	LADGR	☐	Loading Group
83	BFLME	MARA	BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
84	DIBER	MARC	DIBER		☐	DIBER	☐	Indicator: MRP area exists
85	UCHKZ	MARC	UCHKZ		☐	UCHKZ	☐	Indicator for Original Batch Management
86	BWESB	MARC	BWESB		☐	BWESB	☐	Valuated Goods Receipt Blocked Stock

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