ZBPC_DIMAPP.ddls

@AbapCatalog.sqlViewName: 'ZBPCDIMAPP'                                                               
@Analytics: { dataCategory: #DIMENSION,                                                              
              dataExtraction.enabled: true }                                                         
@ObjectModel.representativeKey: 'bpcDimension'                                                       
@ClientDependent: false                                                                              
@AccessControl.authorizationCheck: #NOT_REQUIRED                                                            
@AbapCatalog.compiler.compareFilter: true                                                            
@EndUserText.label: 'Dimensions Used In DUMMYs Models'                                               
define view ZBPC_DIMAPP as select from uja_dimension as D                                            
inner join uja_dim_appl as DA                                                                        
    on D.mandt = DA.mandt                                                                            
    and D.appset_id = DA.appset_id                                                                   
    and D.dimension = DA.dimension                                                                   
inner join uja_dimensiont as TX on D.mandt = TX.mandt                                                
and D.appset_id = TX.appset_id                                                                       
and D.dimension = TX.dimension                                                                       
and TX.langu = 'E'                                                                                   
left outer join dd07v as VD on D.dim_type = VD.domvalue_l and VD.domname='UJ_DIM_TYPE' and VD.ddlanguage = 'E'
inner join uja_appl as MD on MD.mandt = DA.mandt and MD.appset_id = DA.appset_id and DA.application_id = MD.application_id                                                                                           
     {                                                                                               
    key D.appset_id,                                                                                     
    key DA.application_id,
        key substring(D.tech_name,7,12) as technical_name,    
        key D.tech_name,   
    MD.application_type,
    case 
    when MD.application_type = '1' then 'Generic'
    when MD.application_type = '2' then 'Exchange Rates'
    when MD.application_type = '3' then 'Ownership'
    when MD.application_type = '4' then 'Standard'
    when MD.application_type = '5' then 'Finance'
    when MD.application_type = '6' then 'Consolidation'
    else 'Unknown'
    end as app_type_desc,              
    MD.storage_type,                                                                         
    D.dimension,                                                                                     
    TX.description,                                                                                  
    D.ref_dim,                                                                                       
    D.data_table as masterdata_table,                                                                
    D.desc_table as text_tabl,                                                                       
    D.hier_data_table as hier_table,                                                                 
            substring(D.tech_name,1,6) as name_space,                                                
    DA.secure                                                                                        
    ,VD.ddtext as Dim_Type,                                                                          
    DA.rw,                                                                                           
    DA.def_report_mbr,                                                                               
    DA.def_input_mbr,                                                                                
    DA.display_dim,                                                                                  
    DA.display_dim_name,                                                                             
    DA.member_display,                                                                               
    D.dim_type_index,                                                                                
    D.num_hier,                                                                                      
    D.server_version,                                                                                
    D.file_version,                                                                                  
    D.file_lock,                                                                                     
    D.process_state,                                                                                 
    D.locked_by,                                                                                     
    D.caption,                                                                                       
    D.hier_time_dep,                                                                                 
    D.process_date,                                                                                  
    D.process_time,                                                                                  
    D.struc_modif_date,                                                                              
    D.struc_modif_time,                                                                              
    D.mbr_modif_date,                                                                                
    D.mbr_modif_time,                                                                                
    D.tda_table, 
    MD.intercompany,
    MD.fx_trans,
    MD.rate_application,
    MD.ownership_appl,
    MD.journal,
    MD.audit_on,
    MD.bexvcube,
    MD.infocube,                                                                                    
    @DefaultAggregation: #SUM                                                                        
    cast(cast(1 as abap.int4) as rvcounter) as counter                                               
}