SAP ABAP Table /CRMBW/QITEMS (Query items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA (Application Component) CRM Analytics
     ⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/CRMBW/QITEMS	Table Relationship Diagram
Short Description	Query items

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	*
2	DSOURCE	☑	ROOSOURCER	ROOSOURCED	CHAR	30	0	DataSource (OSOA/OSOD)
3	UNAME	☑	SYUNAME	SYCHAR12	CHAR	12	0	User Name
4	QUERYID	☑	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)
5	QTERMID	☑	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)
6	FIELDNAME	☑	FIELDNAME	FDNAME	CHAR	30	0	Field Name	*
7	SIGN	☐	CRMT_BSP_SIGN	CHAR1	CHAR	1	0	RANGES Sign
8	OPERATOR	☐	CRMT_ADVS_OPERATOR		CHAR	2	0	Operator
9	LOW	☐	CRMT_BSP_LOW	CRM_BSP_LOW	STRG	0	0	Low value for Value Range Table
10	HIGH	☐	CRMT_BSP_HIGH	CRM_BSP_HIGH	STRG	0	0	High value for Value Range Table

History

Last changed by/on	SAP	20130604
SAP Release Created in	520