P_ProjectVersionHeader

DDL: P_PROJECTVERSIONHEADER SQL: PPROJVERSHEADER Type: view BASIC

P_ProjectVersionHeader is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (vskopf, vsproj_cn, vssteu) and exposes 7 fields with key fields Project, Version.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
vskopf vskopf left_outer
vsproj_cn vsproj_cn from
vssteu vssteu inner

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PPROJVERSHEADER view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Project vsproj_cn pspid_edit
KEY Version vskopf vsnmr
MCount
ProjectVersionGroupName vssteu vsgruppe
ProjectVersionDescription
BlankCount
DistinctDescCount 
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PPROJVERSHEADER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true

define view P_ProjectVersionHeader
 as select from vsproj_cn left outer join vskopf on vsproj_cn.vsnmr = vskopf.vsnmr
                                     and  vsproj_cn.objnr = vskopf.objnr_pd      
                          inner join vssteu on vskopf.vsnmr = vssteu.vsnmr and vsproj_cn.objnr = vssteu.objnr and vskopf.vsgruppe = vssteu.vsgruppe
{

    key vsproj_cn.pspid_edit as Project,
    key vskopf.vsnmr as Version,
        max( vskopf.vszhl )   as MCount,
        vssteu.vsgruppe as ProjectVersionGroupName,
        max( vskopf.vstext )  as ProjectVersionDescription,
        sum ( case length( vskopf.vstext ) when  0 then 1 else 0 end ) as BlankCount,
        count( distinct vskopf.vstext ) as DistinctDescCount
}
group by vsproj_cn.pspid_edit, vskopf.vsnmr, vssteu.vsgruppe

Learn More