SAP ABAP Table CRMS_QUERY_DSM_BTIL (Query Archive Object Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-DSM (Application Component) Demand Side Management
     ⤷ CRM_IU_DSM_BTX_BOL (Package) Utilities DSM (Demand Side management) BTX BOL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_QUERY_DSM_BTIL	Table Relationship Diagram
Short Description	Query Archive Object Structure

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	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
2	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
3	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
4	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
5	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
6	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
7	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
8	EMPLOYEE_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
9	PROGRAM_ID	☐	CRM_IU_DSM_PRG_EXTERNAL_ID	CRM_IU_DSM_PRG_EXTERNAL_ID	CHAR	20	0	DSM Program External Identifier
10	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
11	PREMISE_ID	☐	EUI_VSTELLE_UI		CHAR	10	0	Premise
12	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
13	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
16	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
17	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
18	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS	CRM_OJ_NAME_PROCESS	CHAR	10	0	Leading Business Transaction Category	*
19	MEAS_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
20	INCT_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
21	DSM_FILE_NO	☐	CRM_IU_DSM_FILE_NO	TEXT35	CHAR	35	0	DSM File Number
22	.INCLUDE	☐				0	0	Extensibility structure
23	EEW_QUERY_DSM_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
24	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20140802
SAP Release Created in	702