R_CNSLDTNFSITEMBYTIMEVERSIONTP

CDS View

Cnsldtn FS Item by Time and Version - TP

R_CNSLDTNFSITEMBYTIMEVERSIONTP is a CDS View in S/4HANA. Cnsldtn FS Item by Time and Version - TP. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_CnsldtnFSItemByTimeVersion view_entity projection COMPOSITE Cnsldtn FS Item By Time and Version
C_CnsldtnFinStmntItemAssgmtTP view_entity projection CONSUMPTION Financial Statement Item Assignment
I_CnsldtnFSItemByTimeVersionTP view_entity projection TRANSACTIONAL Cnsldtn FS Item By Time and Version - TP 
@AccessControl: {
  authorizationCheck: #MANDATORY
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #M
  }
}
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@EndUserText.label: 'Cnsldtn FS Item by Time and Version - TP'
define view entity R_CnsldtnFSItemByTimeVersionTP
  as select from I_CnsldtnFSItemByTimeVersion as _Source

    inner join   I_CnsldtnVersion             as _Version on _Version.ConsolidationVersion = _Source.ConsolidationVersion

  /* associations for transactional processing */
  association        to parent R_CnsldtnFSItemTP     as _CnsldtnFSItem on  $projection.ConsolidationChartOfAccounts  = _CnsldtnFSItem.ConsolidationChartOfAccounts
                                                                       and $projection.CnsldtnFinancialStatementItem = _CnsldtnFSItem.CnsldtnFinancialStatementItem
  // do not expose this association in the projection list of the view

  association [1..1] to E_CnsldtnFSItemByTimeVersion as _Extension     on  $projection.ConsolidationChartOfAccounts  = _Extension.ConsolidationChartOfAccounts
                                                                       and $projection.CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem
                                                                       and _Version.ConsolidationVersion             = _Extension.CnsldtnFSItemAttributeVersion
                                                                       and $projection.FromFiscalYearPeriod          = _Extension.FromFiscalYearPeriod

{

  key _Source.ConsolidationChartOfAccounts,

  key _Source.CnsldtnFinancialStatementItem,

  key _Source.ConsolidationVersion,

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

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

      _Source.CnsldtnFSItemRole,

      _Source.CnsldtnFSItemDataCollection,

      _Source.CnsldtnFSItemCrcyTranslation,

      _Source.CnsldtnFSItemElimination,

      _Source.CnsldtnFSItemCashFlow,

      _Source.CnsldtnFSItemScope,

      _Source.CnsldtnFSItemCustomerSpecific,

      _Source.CnsldtnEliminationTargetFSItem,

      _Source.CnsldtnNCITargetFSItem,

      _Source.CnsldtnPlanningTargetFSItem,

      _Source.CnsldtnOffsettingTargetFSItem,
      
      @UI.hidden: true
      _CnsldtnFSItem.ETag, // required for etag handling



      /* associations */
      _Source._CnsldtnVersion,
      _Source._CnsldtnFSItemCashFlow,
      _Source._CnsldtnFSItemCrcyTrnsltn,
      _Source._CnsldtnFSItemCustSpcfc,
      _Source._CnsldtnFSItemDataColl,
      _Source._CnsldtnFSItemElimination,
      _Source._CnsldtnFSItemRole,
      _Source._CnsldtnFSItemScope,
      _Source._CnsldtnElimTargetFSItem,
      _Source._CnsldtnNCITargetFSItem,
      _Source._CnsldtnOffsettingTargetFSItem,
      _Source._CnsldtnPlanningTargetFSItem,
      _CnsldtnFSItem

}

Learn More