P_ProjectVersion01

DDL: P_PROJECTVERSION01 SQL: PPROJVERSION01 Type: view BASIC Package: VDM_PS_ST

Project Version Helper

P_ProjectVersion01 is a Basic CDS View that provides data about "Project Version Helper" in SAP S/4HANA. It reads from 7 data sources and exposes 8 fields with key fields rsnumelseendasProjectObjectExternalID, rsnumthenOKelseendasObjectType, Version. Part of development package VDM_PS_ST.

7 data source(s) 8 fields

Data Sources (7)

SourceAliasJoin Type
vsafvc_cn vsafvc_cn left_outer
vsaufk_cn vsaufk_cn left_outer
vskopf vskopf from
vsproj_cn vsproj_cn left_outer
vsprps_cn vsprps_cn left_outer
vsresb_cn vsresb_cn left_outer
vssteu vssteu left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJVERSION01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY rsnumelseendasProjectObjectExternalID
KEY rsnumthenOKelseendasObjectType
KEY Version vssteu vsnmr
ProjectVersionGroupName vssteu vsgruppe
MCount vskopf vszhl
ProjectVersionDescription vskopf vstext
BlankCount
DistinctDescCount vskopf vstext 
@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
}

Learn More