I_CNSLDTNVERSIONRELATION

CDS View

Consolidation Version Relation

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

Used by 12 CDS view(s) 2 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
FINCS_CNSLDTNBALVALDTNUNITLVL view_entity from Balance Validation Cons. Unit
P_CnsldtnGrpJrnlEntrItmConVers view inner COMPOSITE Group Journal Entry Item
P_Matrix_CnsldtnFoundation_2 view inner COMPOSITE Matrix Consolidation: Foundation View
P_Matrix_CnsldtnFoundationPER view inner COMPOSITE Matrix Consolidation: Foundation View
P_Matrix_CnsldtnFoundationYTD view inner COMPOSITE Matrix Consolidation: Foundation View
P_Matrix_PCCData view inner COMPOSITE Matrix Consolidation: PCC Data PL = 02, 12, 22
P_MJEL_ElimData view inner COMPOSITE Matrix Consolidation: Elimination Data (PL=20, 22)
P_MJEL_ElimDataEnhncd view inner COMPOSITE Matrix Consolidation: Elimination Data (PL=20, 22)
P_MJEL_PreparedElimCGDeriv view inner COMPOSITE Matrix Consolidation: Prepared Elim. Data for Grp Derivation
P_MJEL_PreparedSFDForCGDeriv view inner COMPOSITE Matrix Consolidation: Prepared SFD for Group Derivation
P_StandardizedDataEnhC view inner COMPOSITE Consolidation: Standardized Data
P_VecVersionMapping view from COMPOSITE Mapping Between Base Version and Extension Versions

Fields (2)

KeyField CDS FieldsUsed in Views
ConsolidationVersion ConsolidationVersion,rvers 7
ConsolidationVersionElement ConsolidationVersionElement 2 
@AbapCatalog: {
  sqlViewName: 'ICSVERSREL',
  compiler.compareFilter: 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],
  sapObjectNodeType.name: 'ConsolidationVersionRelation'
}
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
  }
@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
}

Learn More