P_ProjectVersion01

@AbapCatalog.sqlViewName: 'PPROJVERSION01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true
define view P_ProjectVersion01
 as select from vskopf          left outer join vssteu on vssteu.vsnmr = vskopf.vsnmr and vssteu.vsgruppe = vskopf.vsgruppe and vskopf.vszhl = '00000001'
                                left outer join vsproj_cn on vssteu.objnr = vsproj_cn.objnr  and vssteu.vsnmr = vsproj_cn.vsnmr 
                                left outer join vsprps_cn on vssteu.objnr = vsprps_cn.objnr  and vssteu.vsnmr = vsprps_cn.vsnmr 
                                left outer join vsaufk_cn on vssteu.objnr = vsaufk_cn.objnr  and vssteu.vsnmr = vsaufk_cn.vsnmr
                                left outer join vsafvc_cn on vssteu.objnr = vsafvc_cn.objnr  and vssteu.vsnmr = vsafvc_cn.vsnmr
                                left outer join vsresb_cn on vssteu.objnr = vsresb_cn.objnr  and vssteu.vsnmr = vsresb_cn.vsnmr
                                {
    
    key case when vsproj_cn.pspid is not null or vsproj_cn.pspid <> '' then vsproj_cn.pspid
         when vsprps_cn.posid is not null or vsprps_cn.posid <> '' then vsprps_cn.posid
         when vsaufk_cn.aufnr is not null or vsaufk_cn.aufnr <> '' then vsaufk_cn.aufnr
         when vsafvc_cn.vornr is not null or vsafvc_cn.vornr <> '' then vsafvc_cn.vornr
         when vsresb_cn.rsnum is not null or vsresb_cn.rsnum <> '' then vsresb_cn.rsnum 
         else ''
         end 
    
    as ProjectObjectExternalID,
    
    key case when vsproj_cn.pspid is not null or vsproj_cn.pspid <> '' then 'PD'
         when vsprps_cn.posid is not null or vsprps_cn.posid <> '' then 'PR'
         when vsaufk_cn.aufnr is not null or vsaufk_cn.aufnr <> '' then 'NP'
         when vsafvc_cn.vornr is not null or vsafvc_cn.vornr <> '' then 'NV'
         when vsresb_cn.rsnum is not null or vsresb_cn.rsnum <> '' then 'OK' 
         else ''
         end 
    
    as ObjectType,
    
    key vssteu.vsnmr as Version,
    
    vssteu.vsgruppe as ProjectVersionGroupName,
    
    vskopf.vszhl    as MCount,
    vskopf.vstext   as ProjectVersionDescription,
    case length( vskopf.vstext ) when  0 then 1 else 0 end  as BlankCount,
    vskopf.vstext  as DistinctDescCount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VSAFVC_CN",
"VSAUFK_CN",
"VSKOPF",
"VSPROJ_CN",
"VSPRPS_CN",
"VSRESB_CN",
"VSSTEU"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/