R_CnsldtnFSItemByTimeVersionTP

@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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNFSITEMBYTIMEVERSION",
"I_CNSLDTNVERSION",
"R_CNSLDTNFSITEMTP"
],
"ASSOCIATED":
[
"I_CNSLDTNFSITEMCASHFLOW",
"I_CNSLDTNFSITEMCRCYTRNSLTN",
"I_CNSLDTNFSITEMCUSTSPCFC",
"I_CNSLDTNFSITEMDATACOLL",
"I_CNSLDTNFSITEMELIMINATION",
"I_CNSLDTNFSITEMROLE",
"I_CNSLDTNFSITEMSCOPE",
"I_CNSLDTNFSITEM_2",
"I_CNSLDTNVERSION",
"R_CNSLDTNFSITEMTP"
],
"BASE":
[
"I_CNSLDTNFSITEMBYTIMEVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/