SAP ABAP View MGV_CKMLMV001 (Selection CKMLMV001 with material ver. s.: 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_CKMLMV001
Short Description	Selection CKMLMV001 with material ver. s.: http://material ?
Root table	CKMLMV001	Procurement alternatives

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CKMLMV001	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	CKMLMV001	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	*	CKMLMV001	*		☐		☐
2	MANDT	CKMLMV001	MANDT		☐	MANDT	☐	Client
3	KALNR	CKMLMV001	KALNR		☐	CKML_ALPROCNR	☐	Procurement alternative/process
4	OTYP	CKMLMV001	OTYP		☐	CKML_OTYP	☐	Object Type
5	BWKEY	CKMLMV001	BWKEY		☐	BWKEY	☐	Valuation area
6	WERKS	CKMLMV001	WERKS		☐	WERKS_D	☐	Plant
7	MATNR	CKMLMV001	MATNR		☐	MATNR	☐	Material Number
8	BWTAR	CKMLMV001	BWTAR		☐	BWTAR_D	☐	Valuation type
9	SOBKZ	CKMLMV001	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
10	KALNR_MAT	CKMLMV001	KALNR_MAT		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
11	BTYP	CKMLMV001	BTYP		☐	CKML_BTYP	☐	Process Category
12	FLG_PROCEQUAL	CKMLMV001	FLG_PROCEQUAL		☐	CKML_FLG_PROCEQUAL	☐	Procurement Alternative Identical to Process
13	FLG_PLANOBJ	CKMLMV001	FLG_PLANOBJ		☐	CKML_FLG_PLANOBJ	☐	Procurement alternative only for planning
14	PROC_KALNR	CKMLMV001	PROC_KALNR		☐	CKML_N_PROCNR	☐	Procurement Process
15	MAIN_PROCESS	CKMLMV001	MAIN_PROCESS		☐	CKML_N_PROCNR	☐	Procurement Process
16	SORT_NAME	CKMLMV001	SORT_NAME		☐	CKML_SORT_NAME	☐	Sort string for differentiating procurement alternatives
17	NRULE	CKMLMV001	NRULE		☐	CKML_NAME_RULE	☐	Controlling Level Key
18	LOEKZ	CKMLMV001	LOEKZ		☐	CKML_LOEKZ	☐	Deletion indicator
19	PRWRK_ND	CKMLMV001	PRWRK_ND		☐	WERKS_D	☐	Plant
20	PLWRK_ND	CKMLMV001	PLWRK_ND		☐	CO_PWERK	☐	Planning plant for the order
21	PMATN_ND	CKMLMV001	PMATN_ND		☐	MATNR	☐	Material Number
22	VERID_ND	CKMLMV001	VERID_ND		☐	VERID	☐	Production Version
23	STLAN_ND	CKMLMV001	STLAN_ND		☐	STLAN	☐	BOM Usage
24	STLAL_ND	CKMLMV001	STLAL_ND		☐	STALT	☐	Alternative BOM
25	PLNTY_ND	CKMLMV001	PLNTY_ND		☐	PLNTY	☐	Task List Type
26	PLNNR_ND	CKMLMV001	PLNNR_ND		☐	PLNNR	☐	Key for Task List Group
27	PLNAL_ND	CKMLMV001	PLNAL_ND		☐	PLNAL	☐	Group Counter
28	EKORG_ND	CKMLMV001	EKORG_ND		☐	EKORG	☐	Purchasing organization
29	LIFNR_ND	CKMLMV001	LIFNR_ND		☐	ELIFN	☐	Vendor's account number
30	UMLWK_ND	CKMLMV001	UMLWK_ND		☐	CK_SOWRK	☐	Special Procurement Plant - Costing
31	UMLMA_ND	CKMLMV001	UMLMA_ND		☐	MATNR	☐	Material Number
32	KDAUF_ND	CKMLMV001	KDAUF_ND		☐	VBELN	☐	Sales and Distribution Document Number
33	KDPOS_ND	CKMLMV001	KDPOS_ND		☐	KDPOS	☐	Item number in Sales Order
34	KUNDE_ND	CKMLMV001	KUNDE_ND		☐	KUNNR	☐	Customer Number
35	PSPNR_ND	CKMLMV001	PSPNR_ND		☐	PS_POSNR	☐	WBS Element
36	SPEZ_NAME_ND	CKMLMV001	SPEZ_NAME_ND		☐	CKML_SPEZ_NAME	☐	User-defined name for procure.alternatives/consumpt.alternat
37	STLAN_PC	CKMLMV001	STLAN_PC		☐	STLAN	☐	BOM Usage
38	STLAL_PC	CKMLMV001	STLAL_PC		☐	STALT	☐	Alternative BOM
39	LOSGR_PC	CKMLMV001	LOSGR_PC		☐	CK_LOSGR	☐	Costing lot size
40	MEINS_PC	CKMLMV001	MEINS_PC		☐	CK_MEINH_BEW	☐	Valuation Unit of Measure
41	CSPLIT_PC	CKMLMV001	CSPLIT_PC		☐	CSPLIT	☐	Apportionment structure
42	ERNAM	CKMLMV001	ERNAM		☐	CKML_ERNAM	☐	Created by
43	ERDAT	CKMLMV001	ERDAT		☐	CKML_ERDAT	☐	Created on
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	20110901
SAP Release Created in