I_CNSLDTNVERSIONRELATION

CDS View

Consolidation Version Relation

I_CNSLDTNVERSIONRELATION is a CDS View in S/4HANA. Consolidation Version Relation. It contains 2 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 2 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
P_CnsldtnGrpJrnlEntrItmConVers view inner COMPOSITE
P_Matrix_CnsldtnFoundation_2 view inner COMPOSITE
P_Matrix_CnsldtnFoundationPER view inner COMPOSITE
P_Matrix_CnsldtnFoundationYTD view inner COMPOSITE
P_Matrix_PCCData view inner COMPOSITE
P_MJEL_ElimData view inner COMPOSITE
P_MJEL_ElimDataEnhncd view inner COMPOSITE
P_MJEL_PreparedElimCGDeriv view inner COMPOSITE
P_MJEL_PreparedSFDForCGDeriv view inner COMPOSITE
P_StandardizedDataEnhC view inner COMPOSITE
P_VecVersionMapping view from COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
ConsolidationVersion ConsolidationVersion,rvers 6
ConsolidationVersionElement ConsolidationVersionElement 2 
@AbapCatalog: {
  sqlViewName: 'ICSVERSREL',
  compiler.compareFilter: true,
  preserveKey: true
}
@Analytics: {
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture: {
      automatic: false,
      mapping: [{
                  table: 'FINCS_REF_VERS_R',
                  role: #MAIN,
                  viewElement: ['ConsolidationVersion', 'ConsolidationVersionElement'],
                  tableElement: ['VERSION', 'VERSIONELEMENT']
                }]
    }
  }
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S
  },
  modelingPattern: #ANALYTICAL_FACT,
  supportedCapabilities: [#SQL_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
}
@VDM: {
  viewType: #BASIC
}
@EndUserText: {
  label: 'Consolidation Version Relation'
}

define view I_CnsldtnVersionRelation
  as select from fincs_ref_vers_r

{
      @Consumption.valueHelpDefinition: [{entity: {
                                          name: 'I_CnsldtnVersionVH',
                                          element: 'ConsolidationVersion'
                                        }}]
  key cast( version as fincs_consolidationversion preserving type ) as ConsolidationVersion,

      @Consumption.valueHelpDefinition: [{entity: {
                                          name: 'I_CnsldtnVersionVH',
                                          element: 'ConsolidationVersion'
                                        }}]
  key versionelement                                                as ConsolidationVersionElement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_REF_VERS_R"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More