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
⤷ 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 |