SAP ABAP Table MGV_MKAL (Generated Table for View MGV_MKAL)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_MKAL	Table Relationship Diagram
Short Description	Generated Table for View MGV_MKAL

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	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	VERID	☑	VERID	VERID	CHAR	4	0	Production Version
5	BDATU	☐	BDATM	DATUM	DATS	8	0	Run-time end: production version
6	ADATU	☐	ADATM	DATUM	DATS	8	0	Valid-from date of production version
7	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
8	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
9	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
10	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
11	ALNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
12	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
13	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
14	LOSGR	☐	CK_LOSGR	MENG13	QUAN	13	3	Costing lot size
15	MDV01	☐	SA_LINE1	ARBPL	CHAR	8	0	Production line for repetitive manufacturing
16	MDV02	☐	MDV	MDVXX	CHAR	8	0	Planning identification	T437P
17	TEXT1	☐	VERS_TEXT	TEXT40	CHAR	40	0	Short text on the production version
18	EWAHR	☐	CK_EWAHR	CK_EWAHR	DEC	3	0	Usage Probability with Version Control
19	VERTO	☐	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	T437V
20	SERKZ	☐	SA_VERSI	XFELD	CHAR	1	0	Repetitive manufacturing allowed for version
21	BSTMI	☐	SA_LOSVN	MENG13	QUAN	13	3	Lower value of the lot-size interval
22	BSTMA	☐	SA_LOSBS	MENG13	QUAN	13	3	Upper value of the lot-size interval
23	RGEKZ	☐	SA_RGEKZ	CO_RGEKZ	CHAR	1	0	Indicator: backflush for RS header
24	ALORT	☐	ALORT	LGORT	CHAR	4	0	Receiving storage location for repetitive manufacturing	T001L
25	PLTYG	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
26	PLNNG	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
27	ALNAG	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
28	PLTYM	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
29	PLNNM	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
30	ALNAM	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
31	CSPLT	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	MAKV
32	MATKO	☐	MKAL_MATKO	MATNR	CHAR	18	0	Other material for which BOM and task list are maintained	MARA
33	ELPRO	☐	SA_ELPRO	LGORT	CHAR	4	0	Proposed issue storage location for components	T001L
34	PRVBE	☐	SA_PRVBE	PRVBE	CHAR	10	0	Default supply area for components
35	PRFG_F	☐	PRFG_F	PRFG	CHAR	1	0	Check status of production version
36	PRDAT	☐	MKPRDAT	DATUM	DATS	8	0	Date of last check of production version
37	MKSP	☐	MKSP	MKSP	CHAR	1	0	Production version is locked
38	PRFG_R	☐	PRFG_R	PRFG	CHAR	1	0	Rate-based planning - Check status of production version
39	PRFG_G	☐	PRFG_G	PRFG	CHAR	1	0	Preliminary planning - Check status of production version
40	PRFG_S	☐	PRFG_S	PRFG	CHAR	1	0	BOM - check status of production version
41	UCMAT	☐	VBOB_OB_RFMAT	MATNR	CHAR	18	0	Reference Material for Original Batches
42	PPEGUID	☐	PVS_GUID	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
43	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
44	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_MKAL	ALORT	T001L	LGORT	REF	C	CN
2	MGV_MKAL	CSPLT	MAKV	CSPLIT	REF	1	CN
3	MGV_MKAL	ELPRO	T001L	LGORT		1	CN
4	MGV_MKAL	MANDT	T000	MANDT	KEY	1	CN
5	MGV_MKAL	MATKO	MARA	MATNR	REF	C	CN
6	MGV_MKAL	MATNR	MARA	MATNR	KEY	1	CN
7	MGV_MKAL	MDV02	T437P	PLAN_ID	KEY	1	CN
8	MGV_MKAL	PLNTY	TCA01	PLNTY	REF	C	CN
9	MGV_MKAL	PLTYG	TCA01	PLNTY	REF	C	CN
10	MGV_MKAL	PLTYM	TCA01	PLNTY	REF	C	CN
11	MGV_MKAL	SOBSL	T460A	SOBSL	REF	C	CN
12	MGV_MKAL	STLAN	T416	STLAN	REF	C	CN
13	MGV_MKAL	VERTO	T437V	VERTL	REF	C	CN
14	MGV_MKAL	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in