SAP ABAP Table CRMT_IPM_CONTRACT_DQUERY (Structure for the dynamic contract search in IPM)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IM-IPM-BTX (Application Component) Business Transactions Licensing
     ⤷ CRM_IPM_CONTRACT_GENIL (Package) GenIL for IPM contracts

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IPM_CONTRACT_DQUERY	Table Relationship Diagram
Short Description	Structure for the dynamic contract search in IPM

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	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
2	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
3	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
4	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
5	CHANGED_AT	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
6	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
7	CREATED_AT	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
8	STATUS_I	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
9	SALES_ORG_RESP	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
10	.INCLUDE	☐				0	0	Rights Characteristics Ext.Rights Dimension
11	RGHTDIM01	☐	CRMT_IPM_RIGHTS_DIM1	CRMT_IPM_RIGHTS_DIM1	CHAR	30	0	Rights Dimension 1
12	RGHTDIM02	☐	CRMT_IPM_RIGHTS_DIM2	CRMT_IPM_RIGHTS_DIM2	CHAR	30	0	Rights Dimension 2
13	RGHTDIM03	☐	CRMT_IPM_RIGHTS_DIM3	CRMT_IPM_RIGHTS_DIM3	CHAR	30	0	Rights Dimension 3
14	RGHTDIM04	☐	CRMT_IPM_RIGHTS_DIM4	CRMT_IPM_RIGHTS_DIM4	CHAR	30	0	Rights Dimension 4
15	RGHTDIM05	☐	CRMT_IPM_RIGHTS_DIM5	CRMT_IPM_RIGHTS_DIM5	CHAR	30	0	Rights Dimension 5
16	RGHTDIM06	☐	CRMT_IPM_RIGHTS_DIM6	CRMT_IPM_RIGHTS_DIM6	CHAR	30	0	Rights Dimension 6
17	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
18	SHIP_TO_PARTY_NAME	☐	CRMT_UIU_SHIP_TO_PARTY_NAME	CHAR40	CHAR	40	0	Ship-To Party Name
19	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
20	BILL_TO_PARTY_NAME	☐	CRMT_UIU_BILL_TO_PARTY_NAME	CHAR40	CHAR	40	0	Bill-To Party Name
21	PAYER	☐	CRMT_PAYER_ID	BU_PARTNER	CHAR	10	0	Payer ID	*
22	PAYER_NAME	☐	CRMT_UIU_PAYER_NAME	CHAR40	CHAR	40	0	Payer Name
23	BU_PARTNER_NAME	☐	CRMT_UIU_PARTNER_NAME	CHAR40	CHAR	40	0	Partner Name
24	BILL_TO_PARTY	☐	CRMT_UIU_BILL_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Bill-To Party
25	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
26	PROCESS_TYPE_TEXT	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
27	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
28	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
29	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
30	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
31	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Ship-to Party ID	*
32	EMPLOYEE_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
33	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
34	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
35	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
36	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
37	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
38	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
39	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
40	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
41	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
42	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
43	OBJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
44	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
45	PARTNER_COMB	☐	CRMT_UIU_PARTNER_TO_PARTNERFCT	CHAR40	CHAR	40	0	Partner In Partner Function
46	ARCHIVED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
47	CROSSED	☐	CRMT_IPM_XCONTR_FLG	CRMT_IPM_XCONTR_FLG_DOM	CHAR	1	0	Flag for crossing in IPM contract search
48	CROSSABLE	☐	CRMT_IPM_XCONTR_FLG	CRMT_IPM_XCONTR_FLG_DOM	CHAR	1	0	Flag for crossing in IPM contract search
49	.INCLUDE	☐				0	0	Enhancement of IPM Contract Advanced Search (BTIPMContDQuer
50	CRMT_IPM_CDQ	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	SETTL_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
52	SETTL_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
53	BILL_DATE	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
54	USAGEFLAG	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
55	SETLPRD_BILLED	☐	CRMT_IPM_XCONTR_FLG	CRMT_IPM_XCONTR_FLG_DOM	CHAR	1	0	Flag for crossing in IPM contract search
56	SETLPRD_CONFIRM	☐	CRMT_IPM_BRI_STATUS_FLG	CRMT_IPM_BRI_STATUS_FLG_DOM	CHAR	1	0	Flag for BRI settlement period status
57	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)

History

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