SAP ABAP Table CRMC_MKTPL_USTAT (Maintains mapping from user status to avc profile)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM-CFI (Application Component) Claims and Funds Integration for TPM
     ⤷ CRM_MKTPL_TPM_FM_CUST (Package) Customizing for TPM Fund Integration

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_MKTPL_USTAT	Table Relationship Diagram
Short Description	Maintains mapping from user status to avc profile

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	PROMOTION_TYPE	☑	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_MKTPL_CTYPE
3	USER_STATUS	☑	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	TJ30
4	STATUS_PROFILE	☑	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
5	VALUE_CATEGORY	☐	CRM_FU_VAL_CATEGORY	FU_VAL_CAT_TYPE	CHAR	5	0	Fund Usage Value Category
6	AVC_PROFILE	☐	CRM_FM_AVC_PROFILE_ID	CRM_FM_AVC_PROFILE_ID	CHAR	4	0	Funds Mgmt: Availability Control Profile ID	CRMC_FM_AVCPROF
7	PRIORITY	☐	CRM_STATUS_PRIORITY		NUMC	3	0	Priority for User and System Status Mapping
8	FUNDS_PLAN_EDIT	☐	CRM_FUND_PLAN_EDIT	BOOLE	CHAR	1	0	Indicator Determining if Funds Plan is Editable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_MKTPL_USTAT	AVC_PROFILE	CRMC_FM_AVCPROF	PROFILE_ID	REF	1	N
2	CRMC_MKTPL_USTAT	PROMOTION_TYPE	CRMC_MKTPL_CTYPE	CAMP_TYPE	KEY	1	N
3	CRMC_MKTPL_USTAT	USER_STATUS	TJ30	ESTAT	KEY	1	N

History

Last changed by/on	SAP	20100421
SAP Release Created in	700