SAP ABAP View V_BW_CAU_TYPES (View to get causal types from TPM type using causal profile.)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-MPL-TPM-CAU (Application Component) Causals
     CRM_MKTPL_CAU_BW (Package) CRM Marketing Planning - Causal BW Extraction
Basic Data
View Type D Database View 
Database View V_BW_CAU_TYPES  
Short Description View to get causal types from TPM type using causal profile.    
Root table CRMC_MKTPL_TPCTL   Marketing Planning and Causal Type Link 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMC_MKTPL_TPCTL CRMC_MKTPL_TPCTL
2 CRMC_MKTPL_CAPRL  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRMC_MKTPL_TPCTL CAUSAL_PROFILE JL EQ 0 0
2 CRMC_MKTPL_CAPRL CAUSAL_PROFILE JR EQ AND 0 0
3 CRMC_MKTPL_TPCTL CLIENT JL EQ 0 0
4 CRMC_MKTPL_CAPRL CLIENT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 TPM_TYPE CRMC_MKTPL_TPCTL TP_TYPE   CRM_MKTPL_CAMPTYPE Type
2 CAUSAL_TYPE CRMC_MKTPL_CAPRL CAUSAL_TYPE   CRM_MKTPL_CAU_TYPE Causal Factor Type
3 SALES_ORG CRMC_MKTPL_TPCTL SALES_ORG   CRMT_SALES_ORG Sales Organization ID
4 DIS_CHANNEL CRMC_MKTPL_TPCTL DIS_CHANNEL   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
5 DIVISION CRMC_MKTPL_TPCTL DIVISION   CRMT_DIVISION Division
                 
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  20130604 
SAP Release Created in 600