@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNVERSIONRELATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/