SAP ABAP Table CRM_IP_PROFILE_WRK (Profile Data Work Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH (Application Component) Pharmaceuticals
     ⤷ CRM_IP_APPLICATION (Package) Incentive Program Main Application Package

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_IP_PROFILE_WRK	Table Relationship Diagram
Short Description	Profile Data Work Structure

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

History

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