SAP ABAP Table CRMT_IP_FIELDCAT (Total Field Catalogue for IP)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH (Application Component) Pharmaceuticals
     ⤷ CRMC_IP (Package) Incentive Program Customizing

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IP_FIELDCAT	Table Relationship Diagram
Short Description	Total Field Catalogue for IP

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PROJECT_GUID	☐	CRM_PROJECT_GUID	CRM_PROJECT_GUID	RAW	16	0	Project Guid
3	PROFILE_GUID	☐	CRM_PROFILE_GUID	CRM_PROFILE_GUID	RAW	16	0	Profile Guid
4	PROFILE_ID	☐	CRM_PROFILE_ID	CRM_PROFILE_ID	CHAR	10	0	CRM Profile ID
5	PROFILE_DESC	☐	CRM_FIELD_DESC	CRM_PROCESS_DESC	CHAR	30	0	IP Field Description
6	PROFILE_TYPE	☐	CRM_PROFILE_TYPE	CRM_PROFILE_TYPE	CHAR	1	0	IP Profile Type
7	EVALUATION_TYP	☐	CRMT_EVALUATION_TYPE	CRMT_TYPE	CHAR	3	0	Evaluation type
8	SCALE_BASE_TYP	☐	CRMT_IP_SCALE_BASE_TYPE	CRM_IP_SCALE_BASE_TYPE	CHAR	3	0	Tier Base Type	*
9	EVAL_PERIOD_FR	☐	CMST_VALIDITY_FROM	DATUM	DATS	8	0	Validity date from
10	EVAL_PERIOD_TO	☐	CMST_VALIDITY_TO	DATUM	DATS	8	0	Date valid to
11	PRICE_METHOD	☐	CRMT_PRICE_METHOD	CRMT_TYPE	CHAR	3	0	Price Method Type
12	GROWTH_TYPE	☐	CRMT_GROWTH_TYPE	CRMT_TYPE	CHAR	3	0	IP Growth type
13	BASELINE_AMT	☐	CMST_BASELINE_AMOUNT	WERTV8	CURR	15	2	Baseline Amount
14	BASELINE_CURR	☐	CMST_BASELINE_CURRENCY	WAERS	CUKY	5	0	Baseline Currency	*
15	BASELINE_QTY	☐	CMST_BASELINE_QUANTITY	MENGV15_3	QUAN	15	3	Baseline Quantity
16	BASELINE_UOM	☐	CMST_BASELINE_UOM	MEINS	UNIT	3	0	Baseline Unit of Measure	*
17	GRW_BL_MKTSH	☐	CRMT_BASELINE_MKTSHARE	LST_ID	CHAR	40	0	Baseline Market Share
18	GRW_MEAS_PER	☐	CRMT_GROWTH_PERIOD	CRMT_TYPE	CHAR	3	0	Growth Period
19	PERFORMANCE_TYP	☐	CRMT_PERFORMANCE_TYPE	CRMT_TYPE	CHAR	3	0	CRM IP Performance Type
20	EVAL_PRODUCT	☐	CRMT_EVAL_PROD	LST_ID	CHAR	40	0	Evaluation Product
21	MARKET_BASKET	☐	CRMT_MKT_BASKET	LST_ID	CHAR	40	0	Market basket
22	BP_AGGR_LEVEL	☐	CMST_BPAGGR_LEVEL	CMST_BPAGGR_LEVEL	CHAR	3	0	Account Hierarchie Level
23	REQ_RULE	☐	CRMT_REQUIREMENT_RULE	CRMT_RULES	CHAR	20	0	Requirement Rule
24	BASE_FORMULA	☐	CRMT_BASE_FORMULA	CRMT_RULES	CHAR	20	0	Base Formula
25	CALC_FORMULA	☐	CRMT_CALC_FORMULA	CRMT_RULES	CHAR	20	0	Calculation Formula
26	CALC_TYPE	☐	CRMT_IP_CALCULATION_TYPE	CRM_IP_CALCULATION_TYPE	CHAR	3	0	Calculation Type of Calculation Profile	*
27	PAYMENT_RULE	☐	CMST_PAYMENT_RULE	CRMT_RULES	CHAR	20	0	Payment Rule
28	PRICE_TYPE	☐	CRMT_PRICE_TYPE	CRMT_TYPE	CHAR	3	0	Price Type
29	DAYSDELAY	☐	CRMT_DELAY_DAYS	NUMC3	NUMC	3	0	Delay Days
30	BASIS_COND	☐	CMST_PRICE_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	IP: Price Basis Type	*
31	PRICE_DATE	☐	CMST_DATETYPE	CMST_DATETYPE	CHAR	3	0	IP: Date Type
32	PRICE_COND	☐	CRMT_IP_PRICE_COND	/SAPCND/COND_TYPE	CHAR	4	0	IP: Price Condition	*
33	ADMIN_FEE_IND	☐	CRMT_ADMIN_FEEIND	CRMT_TYPE	CHAR	3	0	Admin Fee Indicator
34	RECIPIENT	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
35	CAP_TYPE	☐	CRMT_CAP_TYPE	CRMT_TYPE	CHAR	3	0	Cap Type
36	CAP_PERCENT	☐	CRMT_CAP_PERC	NUMC3	NUMC	3	0	Cap Percentage
37	CAP_VALUE	☐	CRMT_CAP_VALUE	NUMC3	NUMC	3	0	Cap Value
38	CAP_RULE	☐	CMST_EVAL_ROUTINE	CMST_ROUTINE	CHAR	20	0	Evaluation Routine
39	FLD_NAME	☐	CMST_FIELDNAME	CMST_FIELDNAME	CHAR	30	0	Fieldname	*
40	ROUTINE_NAME	☐	CRM_ROUTINE	CRM_ROUTINE	CHAR	30	0	CRM Routine Name
41	SCHEMA_ID	☐	CMST_SCHEMA	CMST_SCHEMA	CHAR	10	0	Schema	*
42	CALC_UOM	☐	CRMT_IP_PRICING_UOM	MEINS	UNIT	3	0	Pricing UOM	*
43	SCALE_UOM	☐	CRMT_IP_SCALE_UOM	MEINS	UNIT	3	0	Tier UOM	*
44	SCALE_CURR	☐	CRMT_IP_SCALE_CURR	WAERS	CUKY	5	0	Tier Currency	*
45	SCALE_TYPE	☐	CRMT_IP_SCALE_TYPE	CRM_IP_SCALE_TYPE	CHAR	1	0	Tier Type
46	CALC_UNIT	☐	CRMT_IP_PRICING_UNIT	CRM_IP_PRICING_UNIT	DEC	5	0	Pricing Unit
47	PRICE_RATE	☐	CRMT_PRICE_RATE	CRMT_PRICE_RATE	DEC	15	2	Price Rate
48	PRICE_CURR	☐	CMST_COND_CURR	WAERS	CUKY	5	0	Currency	*
49	SCALE_EXIST	☐	SCALE_EXIST	CHAR1	CHAR	1	0	IP Scale Exist Flag

History

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