SAP ABAP Table CRMST_QUERY_CSR_BTIL (Bus.Trns. IL Str-re for Claim - 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_CSR_BTIL	Table Relationship Diagram
Short Description	Bus.Trns. IL Str-re for Claim - 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_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
2	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
3	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
4	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
5	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
6	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
7	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
8	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
9	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
10	SOLD_TO_PARTY	☐	CRMT_UIU_SOLD_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Sold-To Party
11	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
12	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
13	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
14	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
15	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
16	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
17	CAMPAIGN_DES	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
18	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
19	CLA_PRIORITY	☐	CRMT_CLA_PRIORITY	CRM_CLA_PRIORITY	CHAR	4	0	Claim Priority	*
20	CLAIM_SUBMISSION_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
21	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
22	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
23	FUND_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
24	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
25	CLAIMED_AMOUNT	☐	CRMT_CLA_CLAIMED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Claimed Amount
26	VALIDATED_AMOUNT	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
27	SETTLED_AMOUNT	☐	CRMT_CLA_SETTLED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Settled Amount
28	REJECTED_AMOUNT	☐	CRMT_CLA_REJECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Rejected Amount
29	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
30	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
31	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
32	CF_SETTLED	☐	CRMT_STATUS_H_SETTLED	CRM_STATUS_H_SETTLED	CHAR	1	0	StatusH: Settled
33	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
34	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
35	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
36	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
37	CF_ITEM_STATUS	☐	CRMT_STATUS_CLA_ITEM_STATUS	CHAR20	CHAR	20	0	Specialized Header Sum Status of Items for MDF Process
38	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
39	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
40	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
41	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
42	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
43	MDF_INITIATIVE_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
44	MDF_PROGRAM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
45	MDF_SPECIAL_PROGRAM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
46	CREATED_AT_RANGE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
47	CHANGED_AT_RANGE	☐	CRMT_REPORT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Change Date for a Document
48	ACCOUNT	☐	CRMT_UIU_PLANNING_ACCOUNT	CRM_PARTNER_NUMBER	CHAR	20	0	Planning Account
49	ACCOUNT_NAME	☐	CRMT_UIU_PLANNING_ACCOUNT_NAME	CHAR40	CHAR	40	0	Planning Account Name
50	PAYER	☐	CRMT_PAYER_ID	BU_PARTNER	CHAR	10	0	Payer ID	*
51	PAYER_NAME	☐	CRMT_UIU_PAYER_NAME	CHAR40	CHAR	40	0	Payer Name
52	IS_CORRECTION	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
53	MY_TRANSACTIONS	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
54	MY_TRANSACTIONS_CP	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
55	TRADE_PROMO_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
56	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
57	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
58	EXT_REF_NUM	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
59	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
60	.INCLUDE	☐				0	0	Extension Include - Claim Search
61	EEW_BUS2000311_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
62	.INCLUDE	☐				0	0

History

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