SAP ABAP Table CRMST_QUERY_PRVMA_BTIL (BTIL structure for Prov. Master Agreement - Search criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-PRV (Application Component) Provider Transactions in Interaction Center
     ⤷ CRM_PROVIDER_MA_GENIL (Package) GenIL for Provider Master Agreement

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_PRVMA_BTIL	Table Relationship Diagram
Short Description	BTIL structure for Prov. Master Agreement - 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	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
2	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
4	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
5	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
6	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Ship-to Party ID	*
7	EMPLOYEE_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
8	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
9	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
10	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
11	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
12	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
13	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
14	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
15	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
16	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
17	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
18	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
19	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
20	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
21	SHIP_TO_PARTY_NAME	☐	CRMT_UIU_SHIP_TO_PARTY_NAME	CHAR40	CHAR	40	0	Ship-To Party Name
22	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
23	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
24	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
25	CHANNEL_PARTNER_NAME	☐	CRMT_UIU_SALES_PARTNER_NAME	CHAR40	CHAR	40	0	Sales Partner Name
26	RESP_CHAN_PARTNER_FIRSTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_FN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner First Name
27	RESP_CHAN_PARTNER_LASTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_LN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner Last Name
28	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
29	BILL_TO_PARTY_NAME	☐	CRMT_UIU_BILL_TO_PARTY_NAME	CHAR40	CHAR	40	0	Bill-To Party Name
30	CONTACT_FIRSTNAME	☐	CRMT_UIU_CONTACT_FIRSTNAME	CHAR40	CHAR	40	0	Contact First Name
31	CONTACT_LASTNAME	☐	CRMT_UIU_CONTACT_LASTNAME	CHAR40	CHAR	40	0	Contact Last Name
32	PAYER	☐	CRMT_PAYER_ID	BU_PARTNER	CHAR	10	0	Payer ID	*
33	PAYER_NAME	☐	CRMT_UIU_PAYER_NAME	CHAR40	CHAR	40	0	Payer Name
34	BU_PARTNER_NAME	☐	CRMT_UIU_PARTNER_NAME	CHAR40	CHAR	40	0	Partner Name
35	BILL_TO_PARTY	☐	CRMT_UIU_BILL_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Bill-To Party
36	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
37	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
38	PRODUCT_ID_MA	☐	CRMT_ISX_PRVMA_PROD_ID	CRMT_ISX_PRVMA_PROD_ID	CHAR	40	0	Custom Specific ID for Product or Product Range
39	PRP_ID_MA	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
40	.INCLUDE	☐				0	0	EEW Include Provider Master Agreement Search
41	EEW_BUS2000267_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
42	.INCLUDE	☐				0	0
43	INCL_SUB_TERR	☐	CRMT_SUB_TERR_IND	CRM_SUB_TERR_IND	CHAR	1	0	Indicator: Include Subterritories in Territory Search

History

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