SAP ABAP Table MA06V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MA06V	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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
5	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
6	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
7	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
8	CUOBJ	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
9	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
10	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
11	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
12	LVORM	☐	LVOWK	XFELD	CHAR	1	0	Flag Material for Deletion at Plant Level
13	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
14	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
15	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	T141
16	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
17	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
18	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
19	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
20	INSMK	☐	INSMK_MAT	QKZ	CHAR	1	0	Post to Inspection Stock
21	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
22	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
23	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
24	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
25	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	T405
26	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
27	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
28	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
29	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
30	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
31	KAUTB	☐	KAUTB	FLAG	CHAR	1	0	Indicator: "automatic purchase order allowed"
32	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
33	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
34	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
35	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
36	QZGTP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
37	QMATV	☐	QMATV	XFELD	CHAR	1	0	Inspection Setup Exists for Material/Plant
38	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
39	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
40	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
41	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
42	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
43	QSSYS	☐	QSSYS_SOLL	QSSYS	CHAR	4	0	Required QM system for vendor	TQ02
44	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
45	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
46	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
47	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
48	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
49	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
50	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
51	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
52	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
53	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	T6WP3
54	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	T6WP4
55	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
56	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
57	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
58	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
59	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
60	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
61	ALTSL	☐	ALTSL	ALTSL	CHAR	1	0	Method for Selecting Alternative Bills of Material
62	STDPD	☐	STDPD	MATNR	CHAR	18	0	Configurable material	MARA
63	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
64	LGFSB	☐	LGFSB	LGORT	CHAR	4	0	Default storage location for external procurement	T001L
65	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
66	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
67	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
68	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
69	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	T439G
70	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
71	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
72	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
73	INDUS	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
74	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
75	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
76	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
77	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	TMPPF
78	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
79	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
80	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
81	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
82	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
83	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
84	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
85	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
86	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
87	LFRHY	☐	LFRHY	MRPPP	CHAR	3	0	Planning cycle
88	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
89	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
90	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
91	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
92	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
93	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
94	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	TWMEG
95	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
96	CONS_PROCG	☐	WRF_CONS_PROCG	WRF_CONS_PROCG	CHAR	1	0	Consignment Control	WRFT_CONS_PROCG
97	GI_PR_TIME	☐	WRF_PSCD_WABAZ	DEC3	DEC	3	0	Goods Issue Processing Time in Days
98	MULTIPLE_EKGRP	☐	WRF_POHF_OTHER_EKGRP_ALLOW	CHAR1_X	CHAR	1	0	Purchasing Across Purchasing Group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MA06V	AUSME	T006	MSEHI	REF	C	CN
2	MA06V	BMATN	MARA	MATNR
3	MA06V	BSTME	T006	MSEHI	REF	C	CN
4	MA06V	BWSCL	TMBW1	BWSCL	REF	1	CN
5	MA06V	BWTTY	T149C	BWTTY	REF	C	CN
6	MA06V	BWVOR	T6WP1	BWVOR	REF
7	MA06V	CONS_PROCG	WRFT_CONS_PROCG	WRF_CONS_PROCG		C	CN
8	MA06V	DISMM	T438A	DISMM	REF	1	CN
9	MA06V	DISPO	T024D	DISPO	REF	C	CN
10	MA06V	EKGRP	T024	EKGRP	REF	C	CN
11	MA06V	EKWSL	T405	EKWSL	REF	C	CN
12	MA06V	ETIAR	T6WP3	ETIAR	REF	C	CN
13	MA06V	ETIFO	T6WP4	ETIFO	REF	C	CN
14	MA06V	GEWEI	T006	MSEHI	REF	C	CN
15	MA06V	HERKL	T005	LAND1	REF	C	CN
16	MA06V	HERKR	T005S	BLAND	REF	C	CN
17	MA06V	LADGR	TLGR	LADGR	REF	C	CN
18	MA06V	LGFSB	T001L	LGORT
19	MA06V	MANDT	T000	MANDT	KEY	1	CN
20	MA06V	MATKL	T023	MATKL	REF	C	CN
21	MA06V	MEGRU	TWMEG	MEGRU	KEY	C	CN
22	MA06V	MEINS	T006	MSEHI	REF	1	CN
23	MA06V	MFRGR	TMFG	MFRGR
24	MA06V	MFRNR	LFA1	LIFNR
25	MA06V	MMSTA	T141	MMSTA	REF	C	CN
26	MA06V	MPROF	TMPPF	MPROF
27	MA06V	MRPPP	T439G	MRPPP	REF	C	CN
28	MA06V	MSTAE	T141	MMSTA
29	MA06V	MTART	T134	MTART	REF	1	CN
30	MA06V	PERIV	T009	PERIV	REF	C	CN
31	MA06V	PLGTP	TWPT	PLGTP
32	MA06V	PRDHA	T179	PRODH	REF	C	CN
33	MA06V	QSSYS	TQ02	QSSYS	REF	C	CN
34	MA06V	QZGTP	TQ05	ZGTYP	REF	C	CN
35	MA06V	RDPRF	RDPR	RDPRF
36	MA06V	SAISO	T6WSP	SAISO	REF	C	CN
37	MA06V	SATNR	MARA	MATNR
38	MA06V	SERNP	T377P	SERAIL	REF	C	CN
39	MA06V	SERVG	TWSG	SERVG
40	MA06V	SOBSL	T460A	SOBSL	REF	C	CN
41	MA06V	SSQSS	TQ08	QM_PUR	REF	C	CN
42	MA06V	STAWN	T604	STAWN	REF	C	CN
43	MA06V	STDPD	MARA	MATNR	REF	C	CN
44	MA06V	STEUC	T604F	STEUC
45	MA06V	TRAGR	TTGR	TRAGR	REF	C	CN
46	MA06V	USEQU	TMQ2	USEQU	REF	C	CN
47	MA06V	VOLEH	T006	MSEHI	REF	C	CN
48	MA06V	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20140122
SAP Release Created in