SAP ABAP Table CRMST_QUERY_RES_BTIL (Bus.Trns. IL Str-re for Budget Reservation - Search Criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_RES_BTIL	Table Relationship Diagram
Short Description	Bus.Trns. IL Str-re for Budget Reservation - Search Criteria

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_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
5	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
6	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
7	CONTACT_PERSON	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
8	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
9	CAMPAIGN_DES	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
10	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
11	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
12	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
13	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
14	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
15	FUND_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
16	FUND_TYPE	☐	CRM_FM_FND_FUND_TYPE	CHAR4	CHAR	4	0	Fund Type
17	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
18	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
19	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
20	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
21	SOLD_TO_PARTY	☐	CRMT_UIU_SOLD_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Sold-To Party
22	SHIP_TO_PARTY	☐	CRMT_UIU_SHIP_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Ship-To Party
23	SHIP_TO_PARTY_NAME	☐	CRMT_UIU_SHIP_TO_PARTY_NAME	CHAR40	CHAR	40	0	Ship-To Party Name
24	BILL_TO_PARTY	☐	CRMT_UIU_BILL_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Bill-To Party
25	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
26	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
27	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
28	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
29	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
30	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
31	CF_WRITTEN_OFF	☐	CRMT_STATUS_H_WRITTEN_OFF	CRM_STATUS_H_WRITTEN_OFF	CHAR	1	0	StatusH: Written-Off
32	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
33	CF_ITEM_STATUS	☐	CRMT_STATUS_CLA_ITEM_STATUS	CHAR20	CHAR	20	0	Specialized Header Sum Status of Items for MDF Process
34	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
35	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
36	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
37	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
38	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
39	MDF_INITIATIVE_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
40	MDF_PROGRAM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
41	MDF_SPECIAL_PROGRAM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
42	VALIDATED_AMOUNT	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
43	REQUESTED_AMOUNT	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
44	CHANGED_AT_RANGE	☐	CRMT_REPORT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Change Date for a Document
45	CREATED_AT_RANGE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
46	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
47	MY_TRANSACTIONS	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
48	MY_TRANSACTIONS_CP	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
49	.INCLUDE	☐				0	0	EEW Include
50	EEW_BUS2000313_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	.INCLUDE	☐				0	0

History

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