I_HistFinancialStatusCube

@Metadata.allowExtensions:true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_PROVIDER]
@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #CUBE
@Analytics.technicalName: 'IFPCUBEXP'
@AccessControl.authorizationCheck: #CHECK
@Analytics.internalName:#LOCAL
@Metadata.ignorePropagatedAnnotations:true
// TO UPDATE

@Analytics.readClassName: 'CL_FTR_FS_FINPOSCUBE'

@EndUserText.label: 'Financial Status Cube by Period'
define view entity I_HistFinancialStatusCube
  with parameters
    P_KeyDate                : vdm_v_key_date,
    P_TreasuryPositionPeriod : ftr_pos_hist_period

  // the fields are selected from the ABAP exit class and not from the placeholder below

  as select from I_Currency
  association [0..1] to I_CompanyCode               as _CompanyCode               on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_TrsyFinStsCountryGeoPoint as _CountryGeoPoint           on  $projection.Country = _CountryGeoPoint.Country
  association [0..1] to I_SecurityAccount           as _SecurityAccount           on  $projection.SecurityAccount = _SecurityAccount.SecurityAccount
                                                                                  and $projection.CompanyCode     = _SecurityAccount.CompanyCode
  association [0..1] to I_SecurityClass             as _SecurityClass             on  $projection.SecurityClass = _SecurityClass.SecurityClass
  association [0..1] to I_FinancialinstrProductType as _ProductType               on  $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
  association [0..1] to I_Currency                  as _TransactionCurrency       on  $projection.TransactionCurrency = _TransactionCurrency.Currency
  association [0..1] to I_TreasuryValuationClass    as _TreasuryValuationClass    on  $projection.TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass
                                                                                  and $projection.TreasuryValuationArea  = _TreasuryValuationClass.TreasuryValuationArea
  association [0..1] to I_TreasuryValuationArea     as _TreasuryValuationArea     on  $projection.TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea
  association [0..1] to I_Ledger                    as _Ledger                    on  $projection.Ledger = _Ledger.Ledger
  association [0..1] to I_BusinessPartner           as _Issuer                    on  $projection.Issuer = _Issuer.BusinessPartner
  association [0..1] to I_BusinessPartner           as _Counterparty              on  $projection.Counterparty = _Counterparty.BusinessPartner
  association [0..1] to I_BusinessPartner           as _CommitmentBusinessPartner on  $projection.CommitmentBusinessPartner = _CommitmentBusinessPartner.BusinessPartner

  association [0..1] to I_FinancialInstrTransType   as _TransactionType           on  $projection.FinancialInstrumentProductType = _TransactionType.FinancialInstrumentProductType
                                                                                  and $projection.FinancialInstrTransactionType  = _TransactionType.FinancialInstrTransactionType
  association [0..1] to I_TreasuryPositionAccount   as _TreasuryPositionAccount   on  $projection.CompanyCode             = _TreasuryPositionAccount.CompanyCode
                                                                                  and $projection.TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount
  association [0..1] to I_BusinessArea              as _BusinessArea              on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_TreasuryPortfolio         as _Portfolio                 on  $projection.CompanyCode = _Portfolio.CompanyCode
                                                                                  and $projection.Portfolio   = _Portfolio.Portfolio
  association [0..1] to I_FinancialPosition         as _FinancialPosition         on  $projection.FinancialPosition = _FinancialPosition.FinancialPosition
  association [0..1] to I_FinancialPositionGroup    as _FinancialPositionGroup    on  $projection.FinancialPositionGroup = _FinancialPositionGroup.FinancialPositionGroup
  association [0..1] to I_GLAccountInCompanyCode    as _GLAccount                 on  $projection.GLAccount   = _GLAccount.GLAccount
                                                                                  and $projection.CompanyCode = _GLAccount.CompanyCode
  association [0..1] to I_HouseBankBasic            as _HouseBank                 on  $projection.CompanyCode = _HouseBank.CompanyCode
                                                                                  and $projection.HouseBank   = _HouseBank.HouseBank

  association [0..1] to I_AccountingDocumentType    as _AccountingDocumentType    on  $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType

  association [0..1] to I_BusinessPartner           as _BankGroup                 on  $projection.BankGroup = _BankGroup.BusinessPartner
  association [0..1] to I_BusinessPartner           as _BankInBankGroup           on  $projection.BankInBankGroup = _BankInBankGroup.BusinessPartner

  association [0..1] to I_Fund                      as _Fund                      on  $projection.Fund                    = _Fund.Fund
                                                                                  and $projection.FinancialManagementArea = _Fund.FinancialManagementArea
  association [0..1] to I_Grant                     as _Grant                     on  $projection.GrantID = _Grant.GrantID

  association [0..1] to I_GrantType                 as _GrantType                 on  $projection.GrantType = _GrantType.GrantType

  association [0..1] to I_WBSElementBasicData       as _WBSElementBasicData       on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID

  association [0..1] to I_FinancialManagementArea   as _FinancialManagementArea   on  $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea

  association [0..1] to I_FundType                  as _FundType                  on  $projection.FundType                = _FundType.FundType
                                                                                  and $projection.FinancialManagementArea = _FundType.FinancialManagementArea

{
       @ObjectModel.foreignKey.association: '_FinancialPosition'
  key  cast('ZFP001' as ftr_gen_fin_pos)                                           as FinancialPosition,
       @ObjectModel.foreignKey.association: '_FinancialPositionGroup'
  key  cast('ZFPG1' as  ftr_gen_fin_pos_grp)                                       as FinancialPositionGroup,
  key  cast ('FQM' as ftr_gen_fin_pos_datasource )                                 as FinancialPositionDataSource,
  key  cast('Z' as ftr_gen_fin_pos_asset_liab)                                     as FinPositionAssetLiabilityCode,
       @ObjectModel.foreignKey.association: '_CompanyCode'
  key  cast ('ZZZZ' as bukrs)                                                      as CompanyCode,
       @ObjectModel.foreignKey.association: '_GLAccount'
  key  cast ('12341234' as fis_racct)                                              as GLAccount,
       @ObjectModel.foreignKey.association: '_HouseBank'
  key  cast ('ZB' as farp_hbkid)                                                   as HouseBank,
       @ObjectModel.foreignKey.association: '_BusinessArea'
  key  cast ('ZBU' as fis_rbusa)                                                   as BusinessArea,
       @ObjectModel.foreignKey.association: '_Issuer'
  key  cast ('ZBP' as repke_new)                                                   as Issuer,
       @ObjectModel.foreignKey.association: '_Counterparty'
  key  cast ('ZCP' as rkontrah_new)                                                as Counterparty,
       @ObjectModel.foreignKey.association: '_ProductType'
  key  cast ('ZZZ' as vvsart)                                                      as FinancialInstrumentProductType,
  key  cast ('1234' as tb_rfha)                                                    as FinancialTransaction,
       @ObjectModel.foreignKey.association: '_TreasuryValuationClass'
  key  cast ('ZGV' as tpm_val_class)                                               as TreasuryValuationClass,
       @ObjectModel.foreignKey.association: '_SecurityAccount'
  key  cast ('ZSAC' as ftr_gen_security_account)                                   as SecurityAccount,
       @ObjectModel.foreignKey.association: '_SecurityClass'
  key  cast ('ZSEC' as ftr_gen_security_class)                                     as SecurityClass,
       @ObjectModel.foreignKey.association: '_TreasuryPositionAccount'
  key  cast ('ZFUT' as tpm_pos_account_fut)                                        as TreasuryPositionAccount,
       @ObjectModel.foreignKey.association: '_TreasuryValuationArea'
  key  cast ('999' as tpm_val_area)                                                as TreasuryValuationArea,
       @ObjectModel.foreignKey.association: '_Ledger'
  key  cast ('' as fins_ledger)                                                    as Ledger,
  key  cast ('9999' as fis_gjahr)                                                  as FiscalYear,
       @ObjectModel.foreignKey.association: '_AccountingDocumentType'
  key  cast ('' as farp_blart)                                                     as AccountingDocumentType,
  key  cast ('999' as belnr_d)                                                     as AccountingDocument,

  key  cast ('JPY' as ftr_gen_nominal_currency)                                    as NominalCurrency,
       @ObjectModel.foreignKey.association: '_TransactionCurrency'
  key  cast ('EUR' as fis_rwcur)                                                   as TransactionCurrency,

       @Semantics.amount.currencyCode: 'NominalCurrency'
       @DefaultAggregation: #SUM
       cast ('999' as ftr_gen_fin_pos_amt_tc)                                      as NominalAmountInNominalCurrency,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       @DefaultAggregation: #SUM
       cast ('999' as ftr_gen_fin_pos_amt_tc)                                      as BookValueAmtInPositionCurrency,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       @DefaultAggregation: #SUM
       cast ('998' as ftr_utilamtintranscrcy)                                      as UtilizedAmountInTransCrcy,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       @DefaultAggregation: #SUM
       cast ('998' as ftr_totamtintranscrcy)                                       as TotalAmountInTransactionCrcy,

       @ObjectModel.foreignKey.association: '_CommitmentBusinessPartner'
       cast ('XYZ' as fti_ldb_risk_counterparty)                                   as CommitmentBusinessPartner,

       cast ('ZZ' as fac_hktid)                                                    as HouseBankAccount,
       @ObjectModel.foreignKey.association: '_Portfolio'
       cast ('XXX' as rportb)                                                      as Portfolio,

       @ObjectModel.foreignKey.association: '_TransactionType'
       cast ('999' as tb_sfhaart)                                                  as FinancialInstrTransactionType,

       cast ('2' as ftr_trsy_center_sort_order )                                   as TreasuryCenterSortSequenceVal,
       cast ('X' as ftr_treasury_center_ind )                                      as CompanyCodeIsTreasuryCenter,

       @ObjectModel.foreignKey.association: '_CountryGeoPoint'
       cast ('GZ' as land1 )                                                       as Country,

       @ObjectModel.foreignKey.association: '_BankInBankGroup'
       cast( 'ABC' as fclm_bank_in_bnkgrp )                                        as BankInBankGroup,
       @ObjectModel.foreignKey.association: '_BankGroup'
       cast( 'ABC' as fclm_bank_group )                                            as BankGroup,

       @ObjectModel.foreignKey.association: '_FinancialManagementArea'
       cast ('JKLO' as fikrs preserving type )                                     as FinancialManagementArea,
       // No foreign key association. Determining the text by the query framework

       // needs financial management area. Since we are not exposing this field in the views

       // above, the association causes problems, since the fields are automatically

       // filled with the complete key (eg. FMA1/FUND1).

       cast( 'ABCDEFGHIJ' as bp_geber preserving type )                            as Fund,
       // Also no foreign key association. Same reason as for fund

       cast( 'ABCDEF' as fm_fundtype preserving type )                             as FundType,
       @ObjectModel.foreignKey.association: '_Grant'
       cast( 'ABCDEFGHIJKLMNOPQRST' as gm_grant_nbr preserving type )              as GrantID,
       @ObjectModel.foreignKey.association: '_GrantType'
       cast( 'AC' as gm_grant_type preserving type )                               as GrantType,
       cast( 'ABCDEFGHIJ' as fis_prctr preserving type )                           as ProfitCenter,
       cast( 'ABCDEFGHIJ' as fis_kostl preserving type )                           as CostCenter,
       cast( '12345678' as ps_s4_pspnr  preserving type )                          as WBSElementInternalID,
       cast( 'ABCDEFGHIJABCDEFGHIJabcd' as ps_posid_edit  preserving type )        as WBSElementExternalID,
       cast( 'ABCDEFGHIJABCDEF' as fkber preserving type)                          as FunctionalArea,
       cast( 'ABCDEFGHIJABCDEFGHIJ' as tpm_cust_diff_term_1_value preserving type) as TrsyPosCustomDiffntnTerm1,
       cast( 'ABCDEFGHIJABCDEFGHIJ' as tpm_cust_diff_term_2_value preserving type) as TrsyPosCustomDiffntnTerm2,
       cast( 'ABCDEFGHIJABCDEFGHIJ' as tpm_cust_diff_term_3_value preserving type) as TrsyPosCustomDiffntnTerm3,
       cast( 'ABCDEFGHIJABCDEFGHIJ' as tpm_cust_diff_term_4_value preserving type) as TrsyPosCustomDiffntnTerm4,
       cast( 'ABCDEFGHIJABCDEFGHIJ' as tpm_cust_diff_term_5_value preserving type) as TrsyPosCustomDiffntnTerm5,

       cast('20200101' as ftr_gen_fin_pos_keydate)                                 as KeyDate,

       // only for syntactic reasons

       _CompanyCode,
       _CountryGeoPoint,
       _FinancialPosition,
       _FinancialPositionGroup,
       _TreasuryValuationArea,
       _TreasuryValuationClass,
       _SecurityAccount,
       _SecurityClass,
       _ProductType,
       _Issuer,
       _Counterparty,
       _CommitmentBusinessPartner,
       _TreasuryPositionAccount,
       _TransactionType,
       _GLAccount,
       _BusinessArea,
       _TransactionCurrency,
       _HouseBank,
       _BankInBankGroup,
       _BankGroup,
       _AccountingDocumentType,
       _Ledger,
       _Portfolio,
       _Grant,
       _Fund,
       _WBSElementBasicData,
       _FinancialManagementArea,
       _FundType,
       _GrantType

}

// This CDS view does not suport SQL select, therefore, not delivering results,

// we avoid ATC errors related to uniqueness of the result list

where
  1 = 2
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CURRENCY"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_BUSINESSAREA",
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_CURRENCY",
"I_FINANCIALINSTRPRODUCTTYPE",
"I_FINANCIALINSTRTRANSTYPE",
"I_FINANCIALMANAGEMENTAREA",
"I_FINANCIALPOSITION",
"I_FINANCIALPOSITIONGROUP",
"I_FUND",
"I_FUNDTYPE",
"I_GLACCOUNTINCOMPANYCODE",
"I_GRANT",
"I_GRANTTYPE",
"I_HOUSEBANKBASIC",
"I_LEDGER",
"I_SECURITYACCOUNT",
"I_SECURITYCLASS",
"I_TREASURYPORTFOLIO",
"I_TREASURYPOSITIONACCOUNT",
"I_TREASURYVALUATIONAREA",
"I_TREASURYVALUATIONCLASS",
"I_TRSYFINSTSCOUNTRYGEOPOINT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/