R_CNSLDTNUNITBYTIMEVERSIONTP

CDS View

Consolidation Unit by Time/Version - TP

R_CNSLDTNUNITBYTIMEVERSIONTP is a CDS View in S/4HANA. Consolidation Unit by Time/Version - TP. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_CnsldtnUnitByTimeVersion view_entity projection COMPOSITE Consolidation Unit by Time and Version
C_CnsldtnUnitByTimeVersionTP view_entity projection CONSUMPTION Consolidation Unit by Time and Version
I_CnsldtnUnitByTimeVersionTP view_entity projection TRANSACTIONAL Consolidation Unit by Time and Version 
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #XL
}
@AccessControl.authorizationCheck: #CHECK
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Consolidation Unit by Time/Version - TP'
define view entity R_CnsldtnUnitByTimeVersionTP
  as select from            I_CnsldtnUnitByTimeVersion as _CnsldtnUnitByTimeVersion

  // retrieve all consolidation versions

    left outer to many join I_CnsldtnVersion           as _ConsolidationVersion on _CnsldtnUnitByTimeVersion.CnsldtnUnitAttributeVersion = _ConsolidationVersion.CnsldtnUnitAttributeVersion

  // retrieve restatement version information

  association [0..1] to P_CnsldtnExtnVersAcctgInteg as _CnsldtnExtnVersAcctgInteg on  _ConsolidationVersion.ConsolidationVersion = _CnsldtnExtnVersAcctgInteg.ConsolidationVersion

  // associations for text retrieval -> required due to cast statement

  association [0..1] to I_CnsldtnUnitCurrencySource as _LocalCurrencySource       on  $projection.CnsldtnUnitLocalCrcySource = _LocalCurrencySource.CnsldtnUnitCurrencySource

  association [0..1] to I_CnsldtnUnitCurrencySource as _GroupCurrencySource       on  $projection.CnsldtnUnitGroupCrcySource = _GroupCurrencySource.CnsldtnUnitCurrencySource

  association [1..1] to I_CnsldtnVersion            as _CnsldtnVersion            on  $projection.ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion

  //do not expose this association in the projection list of the view

  association [1..1] to E_CnsldtnUnitByTimeVersion  as _Extension                 on  _CnsldtnUnitByTimeVersion.ConsolidationUnit           = _Extension.ConsolidationUnit
                                                                                  and _CnsldtnUnitByTimeVersion.CnsldtnUnitAttributeVersion = _Extension.CnsldtnUnitAttributeVersion
                                                                                  and _CnsldtnUnitByTimeVersion.FromFiscalYearPeriod        = _Extension.FromFiscalYearPeriod

  // associations for transactional processing

  association        to parent R_CnsldtnUnitTP      as _CnsldtnUnit               on  $projection.ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit

{
  key _CnsldtnUnitByTimeVersion.ConsolidationUnit,

  key _ConsolidationVersion.ConsolidationVersion,

      @Semantics.fiscal.yearPeriod: true
  key _CnsldtnUnitByTimeVersion.FromFiscalYearPeriod,

      @Semantics.fiscal.yearPeriod: true
      _CnsldtnUnitByTimeVersion.ToFiscalYearPeriod,

      _CnsldtnUnitByTimeVersion.ConsolidationUnitIsPartnerOnly,

      _CnsldtnUnitByTimeVersion.CnsldtnCrcyTranslationMethod,

      _CnsldtnUnitByTimeVersion.TaxRate,

      _CnsldtnUnitByTimeVersion.FiscalYearVariant,

      @ObjectModel.foreignKey.association: '_DataTransferMethod'
      _CnsldtnUnitByTimeVersion.CnsldtnDataTransferMethod,

      _CnsldtnUnitByTimeVersion.DocumentEntryIsInGroupCurrency,

      //suppression of source fields in case of integration and plan version or integration and restatement version

      //suppression in case of initial source ledger not possible due to different source ledgers for tight accounting integration

      //in case of tight accounting integration there is no possibility to determine the correct source ledger

      @ObjectModel.foreignKey.association: '_LocalCurrencySource'
      case
        when _CnsldtnUnitByTimeVersion.CnsldtnDataTransferMethod = 'H' and ( _CnsldtnVersion.CnsldtnIsPlanVersion = 'X' or _CnsldtnExtnVersAcctgInteg.CnsldtnUnitAcctgIntegIsDsbld = 'X' )
          then cast( '' as fincs_local_curr_source )
        else
          _CnsldtnUnitByTimeVersion.CnsldtnUnitLocalCrcySource
      end as CnsldtnUnitLocalCrcySource,


      @ObjectModel.foreignKey.association: '_GroupCurrencySource'
      case
        when _CnsldtnUnitByTimeVersion.CnsldtnDataTransferMethod = 'H' and ( _CnsldtnVersion.CnsldtnIsPlanVersion = 'X' or _CnsldtnExtnVersAcctgInteg.CnsldtnUnitAcctgIntegIsDsbld = 'X' )
          then cast( '' as fincs_group_curr_source )
        else
          _CnsldtnUnitByTimeVersion.CnsldtnUnitGroupCrcySource
      end as CnsldtnUnitGroupCrcySource,

      _CnsldtnUnitByTimeVersion.CnsldtnUploadMethod,

      _CnsldtnUnitByTimeVersion.CnsldtnUnitDataCollection,

      _CnsldtnUnitByTimeVersion.ConsolidationUnitPartner,

      _CnsldtnUnitByTimeVersion.ConsolidationUnitPostingRule,

      _CnsldtnUnitByTimeVersion.ConsolidationUnitValidation,


      _CnsldtnUnit.ETag, // required for etag handling



      // associations for transactional processing

      _CnsldtnUnit,


      // associations for text retrieval

      _CnsldtnVersion,
      _LocalCurrencySource,
      _GroupCurrencySource,
      _CnsldtnUnitByTimeVersion._DataTransferMethod,
      _CnsldtnUnitByTimeVersion._FiscalYearVariant,
      _CnsldtnUnitByTimeVersion._CnsldtnCrcyTrnsltnMethod,
      _CnsldtnUnitByTimeVersion._CnsldtnRptdFinDataUpldMeth,
      _CnsldtnUnitByTimeVersion._CnsldtnUnitDataColl,
      _CnsldtnUnitByTimeVersion._CnsldtnUnitPartner,
      _CnsldtnUnitByTimeVersion._CnsldtnUnitPostingRule,
      _CnsldtnUnitByTimeVersion._CnsldtnUnitValidation


}

Learn More