SAP ABAP Table CRMV_TIERLEVEL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMV_TIERLEVEL   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client  
2 TIER_LEVEL_CODE CRMT_MKTPL_LOY_TIERLEVEL_CODE CRM_MKTPL_LOY_TIER_CODE CHAR 10   0   ID of Tier  
3 TIER_GROUP CRMT_MKTPL_LOY_TIERGRP_CODE CRM_MKTPL_LOY_TIER_CODE CHAR 10   0   ID of Tier Group CRMC_TIERGROUP
4 TIER_PROFLILE_ID CRM_MKTPL_LOY_TIER_PROFILE_ID CRM_MKTPL_LOY_TIER_PROFILE_ID CHAR 10   0   ID of Tier Profile CRMC_TIERGROUP
5 CAMP_TYPE CRM_MKTPL_CAMPTYPE CRM_MKTPL_CAMPTYPE CHAR 4   0   Type CRMC_TIERGROUP
6 TIER_LEVEL_NAME CRMT_MKTPL_LOY_TIERLEVEL_NAME CRM_MKTPL_LOY_TIER_NAME CHAR 20   0   Description of Tier  
7 SEQUENCE CRMT_MKTPL_LOY_TIER_SEQUENCE CRM_MKTPL_LOY_TIER_SEQUENCE NUMC 5   0   Tier Sequence  
8 EXPIRE_PROC_ID CRM_MKTPL_LOY_DATE_RULE_CODE CRM_MKTPL_LOY_DATE_RULE_CODE CHAR 10   0   ID of Date Calculation Procedure CRMC_LOY_DTRUL
9 EXPIRE_PROC_DESC CRM_MKTPL_LOY_DATE_DESC CRM_MKTPL_LOY_DESC CHAR 40   0   Description of Date Calculation Procedure  
10 STATUS CRMT_MKTPL_LOY_TIER_STATUS CRM_MKTPL_LOY_TIER_STATUS CHAR 10   0   Status of Tier  
11 CARD_TYPE CRM_LOY_CRD_CARD_CTYPE CRM_LOY_CRD_CARD_CTYPE CHAR 5   0   Card Type  
12 RETAIN_OLD_NO CRM_LOY_CRD_BOOLEAN CRM_LOY_CRD_BOOLEAN CHAR 1   0   Loyalty card boolean  
13 IS_OLD_CRD_VALID CRM_LOY_CRD_BOOLEAN CRM_LOY_CRD_BOOLEAN CHAR 1   0   Loyalty card boolean  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMV_TIERLEVEL CAMP_TYPE CRMC_TIERGROUP CAMP_TYPE KEY    
2 CRMV_TIERLEVEL EXPIRE_PROC_ID CRMC_LOY_DTRUL CODE    
3 CRMV_TIERLEVEL TIER_GROUP CRMC_TIERGROUP TIER_GROUP_CODE KEY    
4 CRMV_TIERLEVEL TIER_PROFLILE_ID CRMC_TIERGROUP PROFILE_ID KEY    
History
Last changed by/on SAP  20140117 
SAP Release Created in