SAP ABAP Table CRMT_BSP_COND_MAINT_SEARCH (Working set structure for conditions in CRM BSP UI.)

Hierarchy

☛ LOCAL (Software Component)
   ⤷ $TMP (Package) Temporary Objects (never transported!)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_COND_MAINT_SEARCH	Table Relationship Diagram
Short Description	Working set structure for conditions in CRM BSP UI.

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	AFFF0010	☐	CRMT_FSL_FUEL_TYPE	CRMT_FSL_FUEL_TYPE	CHAR	12	0	Fuel Type
3	AFFF0011	☐	CRMT_FSL_FUEL_CLEAN	CRMT_FSL_FUEL_CLEAN	CHAR	1	0	Interior/Exterior Cleaning
4	AFFF0012	☐	CRMT_FSL_FUEL_SHOP	CRMT_FSL_FUEL_SHOP	CHAR	1	0	Option to Buy
5	AFFF0013	☐	CRMT_FSL_FUEL_INTER	CRMT_FSL_FUEL_INTER	CHAR	1	0	International
6	ALFF0010	☐	CRMT_FSL_TIRE_STORGE	CRMT_FSL_TIRE_STORGE	CHAR	1	0	Tire Storage
7	ALFF0011	☐	CRMT_FSL_TIRE_SUMMER	CRMT_FSL_TIRE_SUMMER	CHAR	30	0	Summer Tires
8	ALFF0012	☐	CRMT_FSL_TIRE_WINTER	CRMT_FSL_TIRE_WINTER	CHAR	30	0	Winter Tires
9	ALFF0013	☐	CRMT_FSL_TIRE_CAP	CRMT_FSL_TIRE_CAP	CHAR	1	0	Hubcap (Winter)
10	AP_ACT_PROFILE	☐	PPFDCNTXT	PPFDCNTXT	CHAR	30	0	PPF: Name of Action Profile	*
11	BILL_ORG	☐	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
12	BILL_TO_PARTY_ID	☐	CRMT_BILL_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Bill-To Party ID	*
13	CPE_CONDTYPE_PR	☐	CPET_CONDTYPE_PR	KSCHL	CHAR	4	0	CPE: Condition Type of Pricing	*
14	CPE_F_FORMID	☐	CPET_FORMID	CPE_FORMID	CHAR	10	0	CPE Formula - Key
15	CPE_T_TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
16	CREATED_BY	☐	/SAPCND/CREATED_BY	XUBNAME	CHAR	12	0	Name of User that Created the Condition Record	*
17	CREATED_ON	☐	/SAPCND/CREATED_ON	SYDATS	DATS	8	0	Date on which Condition Record was Created
18	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
19	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
20	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
21	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
22	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
23	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
24	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
25	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
26	DB_MODE	☐	CRMT_DB_MODE	CRM_DB_MODE	CHAR	1	0	Processing Mode: Create / Change
27	DISTRICT	☐	CRMT_DISTRICT	CRM_DISTRICT	CHAR	6	0	District	*
28	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
29	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
30	ENT_STRATEGY	☐	/CEM/ENT_STRATEGY	/CEM/ENT_STRATEGY	CHAR	2	0	Entitlement Program Scheme	*
31	ETAX_DEPART_CTY	☐	CRMT_ETAX_DEPART_CTY	LAND1	CHAR	3	0	Departure Country of Excise Tax	*
32	ETAX_DEPART_REG	☐	CRMT_ETAX_DEPART_REG	REGIO	CHAR	3	0	Departure Region of Excise Tax	*
33	ETAX_DEST_CTY	☐	CRMT_ETAX_DEST_CTY	LAND1	CHAR	3	0	Destination Country of Excise Tax	*
34	ETAX_DEST_REG	☐	CRMT_ETAX_DEST_REG	REGIO	CHAR	3	0	Destination Region of Excise Tax	*
35	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	*
36	ETAX_PROD_TAXGRP	☐	CRMT_ETAX_PROD_TAXGRP	CRM_TAX_GROUP	CHAR	20	0	Excise Duty Group for Product
37	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	*
38	FINPROD_TYPE	☐	CRMT_FINPROD_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type (Financing Product)	*
39	FIN_PRODUCT_ID	☐	CRMT_FINPROD_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID of Financing Product
40	INVENT_LOC_ID	☐	INVENT_LOC_BUPA	BU_PARTNER	CHAR	10	0	Delivering Location	*
41	IST_MAIN_PROD_ID	☐	CRMT_IST_MAIN_PROD_ID	COM_PRODUCT_ID	CHAR	40	0	IS-T: Product ID for Higher-Level Main Product
42	IST_MAIN_PROD_TYPE	☐	CRMT_IST_MAIN_PROD_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	IS-T: Product Type for Main Product	*
43	IST_SLS_BDL_PROD_TYPE	☐	CRMT_IST_SALES_BDL_PROD_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	IS-T: Product Type (Sales Bundle)	*
44	IST_SLS_BUNDLE_PROD_ID	☐	CRMT_IST_SALES_BUNDLE_PROD_ID	COM_PRODUCT_ID	CHAR	40	0	IS-T: Product ID for a Sales Bundle
45	KOTABNR	☐	/SAPCND/COND_TABLE_ID	/SAPCND/COND_TABLE_ID	CHAR	8	0	Condition Table	*
46	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
47	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
48	LOC_PR	☐	CRMT_LOC_PR	TXJCD	CHAR	15	0	Tax Jurisdiction Code for Location of Service Provider	*
49	LOC_SE	☐	CRMT_LOC_SE	TXJCD	CHAR	15	0	Tax Jurisdiction Code of Location Where Service Is Provided	*
50	LOC_SR	☐	CRMT_LOC_SR	TXJCD	CHAR	15	0	Tax Jurisdiction Code of Location of Service Recipient	*
51	LOC_TAXCAT	☐	LOC_TAXCAT	LOC_TAXCAT	CHAR	2	0	Tax Category	*
52	LOC_TAXGROUP	☐	CRM_TAX_GRP_BR	CRM_TAX_GRP_BR	NUMC	2	0	Tax Group for Dynamic Tax Exceptions Brazil	*
53	LOC_TAX_CITYCODE	☐	LOC_TAX_CITY_CODE	CITYC	CHAR	4	0	Localisation: Tax City code	*
54	LOC_TAX_REGION	☐	LOC_TAX_REGION	REGIO	CHAR	3	0	Localisation: Tax region	*
55	LOC_TXRELCLAS	☐	LOC_TXRELCLAS	LOC_TXRELCLAS	CHAR	10	0	Tax Relevance Classification	*
56	LOC_ZEROVAT	☐	LOC_ZEROVAT	LOC_ZEROVAT	CHAR	1	0	Reason for Zero-Rated VAT	*
57	LST_ID	☐	LSTT_ID	LST_ID	CHAR	40	0	Listing ID
58	MAINT_STATUS	☐	/SAPCND/MAINT_STATUS	/SAPCND/MAINT_STATUS	CHAR	2	0	Editing status
59	MDF_EXP_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
60	MDF_INI_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
61	MDF_PARTNER_PRG	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
62	MDF_PARTNER_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
63	MDF_PGM_TYPE	☐	CRM_MKTPL_PGM_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	CRM Marketing Planning - Type	*
64	MDF_SPG_TYPE	☐	CRM_MKTPL_SPG_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	CRM Marketing Planning - Type	*
65	PARENT_PRC_PRODUCT_ID	☐	CRMT_PARENT_PRC_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID: Pricing Reference Product of Main Item
66	PARENT_PRC_PRODUCT_TYPE	☐	CRMT_PARENT_PRC_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type: Pricing Reference Product of Main Item	*
67	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
68	PAR_PAR_PRC_PROD_ID	☐	CRMT_PAR_PARENT_PRC_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID: Parent Product ID for Higher-Level Item
69	PAR_PAR_PRC_PROD_TYPE	☐	CRMT_PAR_PAR_PRC_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type: Parent Price Product Higher-level item	*
70	PAYER_IC	☐	BEA_PAYER_IC	BU_PARTNER	CHAR	10	0	Intercompany Billing Payer	*
71	PDD_ENT_PRODUCT_ID	☐	PDD_ENT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product Determ.: Entered Product (ID)
72	PDD_ENT_PRODUCT_TYPE	☐	PDD_ENT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Determination: Entered Product Category	*
73	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
74	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
75	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
76	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
77	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
78	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
79	PROD_SEG_DESCR	☐	CRMT_MKTTG_PRSEG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	Product Segment Description
80	PROV_DURATION	☐	CRMT_PROV_DURATION	CRM_PROV_DURATION	NUMC	13	0	Numerical Value of Duration
81	PROV_DURAT_UNIT	☐	CRMT_PROV_DURATION_UNIT	TIMEUNITNA	CHAR	12	0	IS-T: Unit of Duration for a Telco Contract	*
82	PROV_PRICE_LEVEL	☐	CRMT_PROV_LEVEL	CRM_PROV_LEVEL	NUMC	11	0	Valuation of Process
83	REFOBJ_PROD_ID	☐	COMT_REFERENCE_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
84	RELEASE_STATUS	☐	/SAPCND/RELEASE_STATUS	/SAPCND/RELEASE_STATUS	CHAR	1	0	Release Status
85	RESID_PROD_GRP	☐	CRMT_RESID_PROD_GRP		CHAR	3	0	Residual Value Product Group
86	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
87	SHIP_TO_PARTY_ID	☐	CRMT_SHIP_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Ship-to Party ID	*
88	SOLD_FROM_PARTY_ID	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
89	SOLD_TO_PARTY_ID	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
90	SRVPRDL_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
91	TAX_DEPART_CTY	☐	CRMT_TAX_DEPART_CTY	LAND1	CHAR	3	0	Tax Departure Country	*
92	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	*
93	TAX_GROUP_P	☐	CRMT_TAX_GROUP	CRM_TAX_GROUP	CHAR	20	0	Product Tax Group
94	TG_BP_DESCR	☐	CRM_MKTPL_TARGETGRP_DESC	CRM_MARKETING_DESC	CHAR	72	0	Description of Target Group
95	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	*
96	TOOLTIP	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
97	KSCHL_UI	☐	CRM_BSP_COND_KSCHL_UI		NUMC	3	0	Condition Type
98	CONDITION_GROUP	☐	/SAPCND/MAINT_GROUP	/SAPCND/MAINT_GROUP	CHAR	10	0	Condition Maintenance Group	*

History

Last changed by/on	SAP	20130604
SAP Release Created in