SAP ABAP View CRMV_TIERLEVEL (View for Tier level)
Hierarchy
☛ 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_TIERLEVEL  
Short Description View for Tier level    
Root table CRMC_TIERLEVEL   Loyalty Mgmt Tier Level Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMC_TIERLEVEL CRMC_TIERLEVEL
2 CRMC_LOY_DTRUL CRMC_TIERLEVEL EXPIRE_PROC_ID E
3 CRMC_TIERLEVEL_T CRMC_TIERLEVEL TIER_LEVEL_CODE I
4 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_TIERLEVEL CLIENT   MANDT Client
2 TIER_LEVEL_CODE CRMC_TIERLEVEL TIER_LEVEL_CODE   CRMT_MKTPL_LOY_TIERLEVEL_CODE ID of Tier
3 TIER_GROUP CRMC_TIERLEVEL TIER_GROUP S CRMT_MKTPL_LOY_TIERGRP_CODE ID of Tier Group
4 TIER_PROFLILE_ID CRMC_TIERLEVEL TIER_PROFLILE_ID S CRM_MKTPL_LOY_TIER_PROFILE_ID ID of Tier Profile
5 CAMP_TYPE CRMC_TIERLEVEL CAMP_TYPE S CRM_MKTPL_CAMPTYPE Type
6 TIER_LEVEL_NAME CRMC_TIERLEVEL_T TIER_LEVEL_NAME   CRMT_MKTPL_LOY_TIERLEVEL_NAME Description of Tier
7 SEQUENCE CRMC_TIERLEVEL SEQUENCE   CRMT_MKTPL_LOY_TIER_SEQUENCE Tier Sequence
8 EXPIRE_PROC_ID CRMC_TIERLEVEL EXPIRE_PROC_ID   CRM_MKTPL_LOY_DATE_RULE_CODE ID of Date Calculation Procedure
9 EXPIRE_PROC_DESC CRMC_LOY_DTRUL_T DESCRIPTION   CRM_MKTPL_LOY_DATE_DESC Description of Date Calculation Procedure
10 STATUS CRMC_TIERLEVEL STATUS   CRMT_MKTPL_LOY_TIER_STATUS Status of Tier
11 CARD_TYPE CRMC_TIERLEVEL CARD_TYPE   CRM_LOY_CRD_CARD_CTYPE Card Type
12 RETAIN_OLD_NO CRMC_TIERLEVEL RETAIN_OLD_NO   CRM_LOY_CRD_BOOLEAN Loyalty card boolean
13 IS_OLD_CRD_VALID CRMC_TIERLEVEL IS_OLD_CRD_VALID   CRM_LOY_CRD_BOOLEAN Loyalty card boolean
                 
Maintenance Status
Access
  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  20140117 
SAP Release Created in 700