SAP ABAP View V_CM_FOLDERTS_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_FOLDERTS_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			AND	0	0
5	TCM_PFOLDER	CLIENT	JL	EQ				0	0
6	TCM_PF_CONT	CLIENT	JR	EQ			AND	0	0
7	TCM_PFOLDER	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				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)
14	TEMPLATE	TCM_PF_CONT	TEMPLATE		☐	OS_BOOLEAN	☐	Boolean
15	PF_LAST_CHGD_BY	TCM_PF_CONT	PF_LAST_CHGD_BY		☐	DE_CM_CHANGEDBY	☐	User who last changed the object
16	PF_LAST_CHGD_AT	TCM_PF_CONT	PF_LAST_CHGD_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	CTRLD_TEXT	TCM_PF_CONT	CTRLD_TEXT		☐	DE_CM_DESCRIPTION	☐	Description of a Configuration Management Object
18	CTRLDOBJECT_KEY	TCM_PF_CONT	CTRLDOBJECT_KEY		☐	DE_CM_OBJ_KEY	☐	Controlled object
19	CTRLDOBJECT_TYPE	TCM_PF_CONT	CTRLDOBJECT_TYPE		☐	DE_CM_OBJ_TYPE	☐	Type of controlled object
20	USED_IN_BASELINE	TCM_PF_CONT	USED_IN_BASELINE		☐	OS_BOOLEAN	☐	Boolean
21	FOLDER_STATE	TCM_PF_CONT	FOLDER_STATE		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
22	.APPEND	V_CM_FOTS_QY_EX2			☐		☐
23	PRJ_DEF	TCM_PF_CONT	PRJ_DEF		☐	PS_PSPID	☐	Project definition
24	SD_ORDER	TCM_PF_CONT	SD_ORDER		☐	VBELN_VA	☐	Sales Document
25	SERV_NOTIFICAT	TCM_PF_CONT	SERV_NOTIFICAT		☐	QMNUM	☐	Message Number
26	OBJNR	TCM_PFOLDER	OBJNR		☐	J_OBJNR	☐	Object 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	20130603
SAP Release Created in