SAP ABAP View V_EINE_MKAL (View for material version and info record combination)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SCM-BAS (Application Component) SCM Basis
     ⤷ CIF (Package) Core Interface

Basic Data

View Type	D	Database View
Database View	V_EINE_MKAL
Short Description	View for material version and info record combination
Root table	EINA	Purchasing Info Record: General Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EINA	EINA
2	EINE
3	MKAL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EINA	INFNR	JL	EQ				0	0
2	EINE	INFNR	JR	EQ			AND	0	0
3	EINA	MANDT	JL	EQ				0	0
4	EINE	MANDT	JR	EQ			AND	0	0
5	MKAL	MANDT	JL	EQ				0	0
6	EINA	MANDT	JR	EQ			AND	0	0
7	MKAL	MATNR	JL	EQ				0	0
8	EINA	MATNR	JR	EQ			AND	0	0
9	MKAL	WERKS	JL	EQ				0	0
10	EINE	WERKS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EINA	MANDT		☐	MANDT	☐	Client
2	INFNR	EINA	INFNR		☐	INFNR	☐	Number of purchasing info record
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

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