SAP ABAP Table FCOMS_CR_DQUERY (Change Request Search)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO (Application Component) Controlling
     ⤷ FCOM_MASTERDATA_CORE (Package) Master data

Basic Data

Table Category	INTTAB	Structure
Structure	FCOMS_CR_DQUERY	Table Relationship Diagram
Short Description	Change Request Search

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Change Request Attributes
2	.INCLUDE	☐				0	0	Change Request
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	REQUESTID	☐	FCOM_CR_REQUESTID		NUMC	12	0	Change Request ID
5	TYPE	☐	FCOM_CR_TYPE		CHAR	10	0	Change Request Type	FCOMC_CR_TYPE
6	STATUS	☐	FCOM_CR_STATUS	FCOM_CR_STATUS	CHAR	2	0	Change Request Status
7	PRIORITY	☐	FCOM_CR_PRIORITY	FCOM_CR_PRIORITY	NUMC	1	0	Priority
8	DESCRIPTION	☐	FCOM_TXTLG	TEXT60	CHAR	60	0	Description (Long Text)
9	CREATED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	CREATED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
11	CHANGED_AT	☐	FCOM_CR_TIMESTAMP	TZNTSTMPS	DEC	15	0	Change Request: UTC Time Stamp in Short Form (YYYY)
12	CHANGED_BY	☐	FCOM_CR_USERNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
13	TYPE_TXT	☐	FCOM_TXTMI	TEXT40	CHAR	40	0	Description (Medium Text)
14	STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
15	PRIORITY_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
16	CHANGED_BY_USER	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
17	CREATED_BY_USER	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
18	LINK2DISPLAY	☐	FCOM_TXTMI	TEXT40	CHAR	40	0	Description (Medium Text)
19	LINK2NEW	☐	FCOM_TXTMI	TEXT40	CHAR	40	0	Description (Medium Text)
20	REQUESTID_TXT	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
21	EVER_CHANGED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FCOMS_CR_DQUERY	TYPE	FCOMC_CR_TYPE	TYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in	606