SAP ABAP Table CRMD_ADVS_QTERMS (Query Term Table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-SLS-OR (Application Component) Operative Reporting
     ⤷ CRM_ADV_SEARCH_IL (Package) IL package for advanced search

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_ADVS_QTERMS	Table Relationship Diagram
Short Description	Query Term Table

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	QUERYID	☑	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)	CRMD_ADVS_QHEAD
3	QTERMID	☑	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)
4	FIELDNAME	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	*
5	SIGN	☐	CRMT_BSP_SIGN	CHAR1	CHAR	1	0	RANGES Sign
6	OPERATOR	☐	CRMT_ADVS_OPERATOR		CHAR	2	0	Operator
7	LOW	☐	CRMT_ADVS_SEARCH_VALUE		CHAR	100	0	Low or High Value of a Filterterm
8	HIGH	☐	CRMT_ADVS_SEARCH_VALUE		CHAR	100	0	Low or High Value of a Filterterm

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_ADVS_QTERMS	MANDT	T000	MANDT	KEY	1	CN
2	CRMD_ADVS_QTERMS	QUERYID	CRMD_ADVS_QHEAD	QUERYID

History

Last changed by/on	SAP	20070216
SAP Release Created in	500