SAP ABAP View VCM_DATA (CM: View of tcm_pmaster/tcm_pfolder/tcm_pf_cont)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ CMT (Package) Configuration Management - Core Development

Basic Data

View Type	D	Database View
Database View	VCM_DATA
Short Description	CM: View of tcm_pmaster/tcm_pfolder/tcm_pf_cont
Root table	TCM_PMASTER	CM: Header data for product

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TCM_PMASTER	TCM_PMASTER
2	TCM_PFOLDER
3	TCM_PF_CONT
4	TCM_LIFECYCLE
5	TCM_LIFECYCLET
6	TCM_LC_PHASET
7	TCM_LC_PHASE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TCM_PMASTER	CLIENT	JL	EQ				0	0
2	TCM_PFOLDER	CLIENT	JR	EQ			AND	0	0
3	TCM_PMASTER	PRODUCT_ID	JL	EQ				0	0
4	TCM_PFOLDER	PRODUCT_ID	JR	EQ			AND	0	0
5	TCM_PMASTER	CLIENT	JL	EQ				0	0
6	TCM_PF_CONT	CLIENT	JR	EQ			AND	0	0
7	TCM_PMASTER	PRODUCT_ID	JL	EQ				0	0
8	TCM_PF_CONT	PRODUCT_ID	JR	EQ			AND	0	0
9	TCM_PFOLDER	FOLDER_ID	JL	EQ				0	0
10	TCM_PF_CONT	FOLDER_ID	JR	EQ			AND	0	0
11	TCM_PFOLDER	LC_PHASE	JL	EQ				0	0
12	TCM_PF_CONT	LC_PHASE	JR	EQ			AND	0	0
13	TCM_PMASTER	LIFE_CYCLE	JL	EQ				0	0
14	TCM_LIFECYCLE	LIFE_CYCLE	JR	EQ			AND	0	0
15	TCM_LIFECYCLE	CLIENT	JL	EQ				0	0
16	TCM_LIFECYCLET	MANDT	JR	EQ			AND	0	0
17	TCM_LIFECYCLE	LIFE_CYCLE	JL	EQ				0	0
18	TCM_LIFECYCLET	LIFE_CYCLE	JR	EQ			AND	0	0
19	TCM_LIFECYCLE	CLIENT	JL	EQ				0	0
20	TCM_PMASTER	CLIENT	JR	EQ			AND	0	0
21	TCM_PFOLDER	LC_PHASE	JL	EQ				0	0
22	TCM_LC_PHASE	LC_PHASE	JR	EQ			AND	0	0
23	TCM_LC_PHASE	CLIENT	JL	EQ				0	0
24	TCM_LC_PHASET	MANDT	JR	EQ			AND	0	0
25	TCM_PFOLDER	CLIENT	JL	EQ				0	0
26	TCM_LC_PHASE	CLIENT	JR	EQ			AND	0	0
27	TCM_LC_PHASE	LC_PHASE	JL	EQ				0	0
28	TCM_LC_PHASET	LC_PHASE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	TCM_PMASTER	CLIENT		☐	SYMANDT	☐	Client ID
2	PRODUCT_ID	TCM_PMASTER	PRODUCT_ID		☐	DE_CM_PRODUCT_ID	☐	Configuration definition
3	LIFE_CYCLE	TCM_PMASTER	LIFE_CYCLE		☐	DE_CM_LIFE_CYCLE	☐	Key for the life cycle profile
4	FOLDER_ID	TCM_PFOLDER	FOLDER_ID		☐	DE_CM_FOLDER_ID	☐	Configuration folder
5	LC_PHASE	TCM_PFOLDER	LC_PHASE		☐	DE_CM_LIFE_CYCLE_PHASE	☐	Key for the life cycle phase
6	PM_CREATED_BY	TCM_PMASTER	PM_CREATED_BY		☐	DE_CM_CREATEDBY	☐	User who created the object
7	PF_CREATED_BY	TCM_PFOLDER	PF_CREATED_BY		☐	DE_CM_CREATEDBY	☐	User who created the object
8	FOLDER_STATE	TCM_PF_CONT	FOLDER_STATE		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	CTRLDOBJECT_TYPE	TCM_PF_CONT	CTRLDOBJECT_TYPE		☐	DE_CM_OBJ_TYPE	☐	Type of controlled object
10	LC_TEXT	TCM_LIFECYCLET	LC_TEXT		☐	DE_CM_LIFE_CYCLE_TXT	☐	Life cycle profile
11	LC_SPRAS	TCM_LIFECYCLET	LC_SPRAS		☐	SPRAS	☐	Language Key
12	LC_PH_TEXT	TCM_LC_PHASET	LC_PH_TEXT		☐	DE_CM_LC_PHASE_TXT	☐	Life cycle phase
13	LC_PH_SPRAS	TCM_LC_PHASET	LC_PH_SPRAS		☐	SPRAS	☐	Language Key

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