SAP ABAP View CRMV_MI_CDTCODDB (Database View: Codes to Code Type)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BTX-BF-INV (Application Component) Investigation
     CRM_MI_DT (Package) Investigation - Customizing Objects
Basic Data
View Type D Database View 
Database View CRMV_MI_CDTCODDB  
Short Description Database View: Codes to Code Type    
Root table CRMC_MI_CDTCGR   Assignment of Code Group to Code Type 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMC_MI_CDTCGR CRMC_MI_CDTCGR
2 QPGR  
3 TQ15  
4 QPCD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 QPGR MANDT JL EQ 0 0
2 CRMC_MI_CDTCGR CLIENT JR EQ AND 0 0
3 QPGR KATALOGART JL EQ 0 0
4 CRMC_MI_CDTCGR CAT_ID JR EQ AND 0 0
5 QPGR CODEGRUPPE JL EQ 0 0
6 CRMC_MI_CDTCGR CODEGROUP JR EQ AND 0 0
7 TQ15 MANDT JL EQ 0 0
8 CRMC_MI_CDTCGR CLIENT JR EQ AND 0 0
9 TQ15 KATALOGART JL EQ 0 0
10 CRMC_MI_CDTCGR CAT_ID JR EQ AND 0 0
11 QPGR MANDT JL EQ 0 0
12 QPCD MANDT JR EQ AND 0 0
13 QPGR KATALOGART JL EQ 0 0
14 QPCD KATALOGART JR EQ AND 0 0
15 QPGR CODEGRUPPE JL EQ 0 0
16 QPCD CODEGRUPPE JR EQ AND 0 0
17 QPCD INAKTIV NE 'X' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMC_MI_CDTCGR CLIENT   MANDT Client
2 CODTYP CRMC_MI_CDTCGR CODTYP   CRMT_E_MI_CODTYP Code Type
3 CAT_ID CRMC_MI_CDTCGR CAT_ID   COMT_CATALOG Catalog
4 CODEGROUP CRMC_MI_CDTCGR CODEGROUP   QCODEGRP Code Group
5 CODE QPCD CODE   QCODE Code
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20110908 
SAP Release Created in 500