P_VecVersionMapping

DDL: P_VECVERSIONMAPPING SQL: PVECVERSMAP Type: view COMPOSITE Package: FIN_VE

Mapping Between Base Version and Extension Versions

P_VecVersionMapping is a Composite CDS View that provides data about "Mapping Between Base Version and Extension Versions" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnVersionRelation) and exposes 2 fields. Part of development package FIN_VE.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnVersionRelation Relation from

Parameters (1)

NameTypeDefault
P_ConsolidationVersion fc_rvers

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PVECVERSMAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
ConsolidationVersion I_CnsldtnVersionRelation ConsolidationVersion
ConsolidationVersionElement I_CnsldtnVersionRelation ConsolidationVersionElement 
@AbapCatalog.sqlViewName: 'PVECVERSMAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_VecVersionMapping with parameters
    P_ConsolidationVersion : fc_rvers
//  as select from I_CnsldtnVersion as versions_base

////    join         tf200 as versions_base on versions_all.ref_version = versions_base.rvers

//{

//    versions_base.ConsolidationVersion          as Version,

//    // tmp approach, will be replaced by FINCS_REF_VERS_R

//    case when versions_base.CnsldtnReferenceVersion = '' 

//        then  versions_base.ConsolidationVersion

//    else versions_base.CnsldtnReferenceVersion

//    end                                         as DBVersion

//}where versions_base.ConsolidationVersion = :P_ConsolidationVersion

//union

//    select from I_CnsldtnVersion as versions_self

////    join         tf200 as versions_base on versions_all.ref_version = versions_base.rvers

//{

//    versions_self.ConsolidationVersion          as Version,

//    // tmp approach, will be replaced by FINCS_REF_VERS_R

//    'TMP'                                       as DBVersion

//}where versions_self.ConsolidationVersion = :P_ConsolidationVersion and versions_self.CnsldtnReferenceVersion <> ''

    as select from I_CnsldtnVersionRelation as Relation
    {
     Relation.ConsolidationVersion  as ConsolidationVersion,
     Relation.ConsolidationVersionElement as ConsolidationVersionElement
    }where Relation.ConsolidationVersion = :P_ConsolidationVersion

Learn More