SAP ABAP Table CRMST_QUERY_SDP_BTIL (IL Structure for Deduction Plan - Search Criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS-BTX-SSP (Application Component) Social Service Plan
     ⤷ CRM_UIU_4S (Package) Social Services - User Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_SDP_BTIL	Table Relationship Diagram
Short Description	IL Structure for Deduction Plan - 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	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
4	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
5	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
6	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	SOLD_TO_PARTY	☐	CRMT_UIU_SOLD_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Sold-To Party
8	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
9	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
10	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
11	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
12	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
13	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
14	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
15	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
16	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
17	ITEM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
18	DEDUCT_FROM	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
19	DEDUCT_TO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
20	.INCLUDE	☐				0	0	EEW Include Deduction Plan Search
21	EEW_BUS2000290_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
22	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	701