SAP ABAP View MGV_MKAL (Selection MKAL with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_MKAL
Short Description	Selection MKAL with material version, see: http://material
Root table	MKAL	Production Versions of Material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MKAL	MKAL
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MKAL	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	MKAL	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

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

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	20050301
SAP Release Created in