SAP ABAP View V_CM_FOLDER_QY (CM: View for folder - Query (about Master/Folder/Container))

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	V_CM_FOLDER_QY
Short Description	CM: View for folder - Query (about Master/Folder/Container)
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

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				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	PM_CREATED_BY	TCM_PMASTER	PM_CREATED_BY		☐	DE_CM_CREATEDBY	☐	User who created the object
5	PM_TEXT_KEY	TCM_PMASTER	PM_TEXT_KEY		☐	DE_CM_KEY	☐	CM: General key field
6	FOLDER_ID	TCM_PFOLDER	FOLDER_ID		☐	DE_CM_FOLDER_ID	☐	Configuration folder
7	LC_PHASE	TCM_PFOLDER	LC_PHASE		☐	DE_CM_LIFE_CYCLE_PHASE	☐	Key for the life cycle phase
8	PF_STRUCTURE_KEY	TCM_PFOLDER	PF_STRUCTURE_KEY		☐	DE_CM_OBJ_KEY	☐	Controlled object
9	PF_CREATED_BY	TCM_PFOLDER	PF_CREATED_BY		☐	DE_CM_CREATEDBY	☐	User who created the object
10	PM_CREATED_AT	TCM_PMASTER	PM_CREATED_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	PM_LAST_CHGD_BY	TCM_PMASTER	PM_LAST_CHGD_BY		☐	DE_CM_CHANGEDBY	☐	User who last changed the object
12	PM_LAST_CHGD_AT	TCM_PMASTER	PM_LAST_CHGD_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	PF_CREATED_AT	TCM_PFOLDER	PF_CREATED_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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