SAP ABAP View CRMV_TIERPOINT (View for Point expiration override)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing
⤷
CRM_MKTPL_LOY (Package) CRM Marketing: Loyalty Program Backend
BBPCRM (Software Component) BBPCRM⤷
CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing⤷
CRM_MKTPL_LOY (Package) CRM Marketing: Loyalty Program Backend
Basic Data
| View Type | C | Maintenance View |
| Maintenance View | CRMV_TIERPOINT | |
| Short Description | View for Point expiration override | |
| Root table | CRMC_TIERPOINT | Loyalty Mgmt Point Expiration Procedure Override |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | CRMC_TIERPOINT |
CRMC_TIERPOINT | ||
| 2 | CRMC_LOY_DTRUL |
CRMC_TIERPOINT | EXPIRE_PROC_ID | E |
| 3 | CRMC_LOY_POINT |
CRMC_TIERPOINT | POINT_ID | E |
| 4 | CRMC_TIERLEVEL |
CRMC_TIERPOINT | TIER_ID | E |
| 5 | CRMC_LOY_DTRUL_T |
CRMC_LOY_DTRUL | CODE | I |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  CLIENT |
CRMC_TIERPOINT |
CLIENT | MANDT | Client | |||
| 2 | CAMP_TYPE |
CRMC_TIERPOINT |
CAMP_TYPE | S | CRM_MKTPL_CAMPTYPE | Type | ||
| 3 | PROFILE_ID |
CRMC_TIERPOINT |
PROFILE_ID | S | CRM_MKTPL_LOY_PT_EXPIR_PROF_ID | Point Expiration Override Profile ID | ||
| 4 | POINT_ID |
CRMC_TIERPOINT |
POINT_ID | CRMT_MKTPL_LOY_POINT_CODE | ID of Point Type | |||
| 5 | TIER_ID |
CRMC_TIERPOINT |
TIER_ID | CRMT_MKTPL_LOY_TIERLEVEL_CODE | ID of Tier | |||
| 6 | SEQUENCE |
CRMC_TIERPOINT |
SEQUENCE | CRMT_MKTPL_LOY_TIER_SEQUENCE | Tier Sequence | |||
| 7 | EXPIRE_PROC_ID |
CRMC_TIERPOINT |
EXPIRE_PROC_ID | CRM_MKTPL_LOY_DATE_RULE_CODE | ID of Date Calculation Procedure | |||
| 8 | EXPIRE_PROC_DESC |
CRMC_LOY_DTRUL_T |
DESCRIPTION | CRM_MKTPL_LOY_DATE_DESC | Description of Date Calculation Procedure | |||
| 9 | STATUS |
CRMC_TIERPOINT |
STATUS | CRMT_MKTPL_LOY_TIER_STATUS | Status of Tier | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
| Last changed by/on | SAP | 20100421 |
| SAP Release Created in | 700 |
