P_FTR_FS_FIB_DS3

@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_FTR_FS_FIB_DS3
  with parameters
    P_KeyDate : vdm_v_key_date
 
  as select from I_GLAccountLineItem
    inner join   I_FiscalYear as FiscalYear on  I_GLAccountLineItem.FiscalYearVariant =  FiscalYear.FiscalYearVariant
                                            and I_GLAccountLineItem.FiscalYear        =  FiscalYear.FiscalYear
                                            
//  association [1] to P_HouseBankToRiskBP    as _BankLinkage on  $projection.CompanyCode                 =  _BankLinkage.CompanyCode

//                                                                and  $projection.HouseBank              =  _BankLinkage.HouseBank

//                                                                

  association [0..1] to I_HouseBankWithRiskBP  as _BankLinkage on  $projection.CompanyCode                 =  _BankLinkage.CompanyCode
                                                                and  $projection.HouseBank              =  _BankLinkage.HouseBank                                                                         
                                                                
                                                                                                            
{
  key I_GLAccountLineItem.SourceLedger,
  key I_GLAccountLineItem.CompanyCode,
  key I_GLAccountLineItem.FiscalYear,
  key I_GLAccountLineItem.AccountingDocument,
  key I_GLAccountLineItem.LedgerGLLineItem,
  key I_GLAccountLineItem.Ledger, 
  cast ('FIB' as ftr_gen_fin_pos_datasource  )                      as FinancialPositionDataSource, 
  I_GLAccountLineItem.PostingDate as TransactionDate,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  I_GLAccountLineItem.AmountInTransactionCurrency as BookValueAmtInPositionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  cast ( 0 as ftr_utilamtintranscrcy)                              as UtilizedAmountInTransCrcy,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  cast ( 0 as ftr_totamtintranscrcy)                               as TotalAmountInTransactionCrcy,
  I_GLAccountLineItem.TransactionCurrency,
  I_GLAccountLineItem.GLAccount,
  I_GLAccountLineItem.ChartOfAccounts,
  I_GLAccountLineItem.HouseBank,
  I_GLAccountLineItem.HouseBankAccount,
  I_GLAccountLineItem.AccountingDocumentType,
  I_GLAccountLineItem.BusinessArea,
  I_GLAccountLineItem.TransactionCurrency                        as NominalCurrency,  
  @Semantics.amount.currencyCode: 'NominalCurrency'
  I_GLAccountLineItem.AmountInTransactionCurrency                as NominalAmountInNominalCurrency,  
  FiscalYear.FiscalYearEndDate,
  FiscalYear.FiscalYearStartDate, 
   
// Fields which are not provided by FIB datasource  

  //TPM fields

  cast('' as tpm_val_area)                                      as TreasuryValuationArea,
  cast('' as vvsart)                                            as FinancialInstrumentProductType,
  cast('' as tb_sfhaart)                                        as FinancialInstrTransactionType,
  cast('' as tpm_val_class)                                     as TreasuryValuationClass,
  cast('' as rportb)                                            as Portfolio,
  cast('' as ftr_gen_security_account)                          as SecurityAccount,
  cast('' as ftr_gen_security_class)                            as SecurityClass,
  cast('' as tpm_pos_account_fut)                               as TreasuryPositionAccount,  
  cast ('' as tb_rfha)                                          as FinancialTransaction, 
  cast ('' as repke_new)                                        as Issuer,
  cast ('' as rkontrah_new)                                     as Counterparty,
  // ==> SecurityClass, Issuer AND Counterparty initial in principle ==> following statement could be valid!!  

  cast ('' as fti_ldb_risk_counterparty)                           as CommitmentBusinessPartner,  
  cast( _BankLinkage[1:RiskPartnerValidFromDate <= $parameters.P_KeyDate and RiskPartnerValidToDate >= $parameters.P_KeyDate].RiskPartnerNo
            as fclm_bank_in_bnkgrp preserving type ) as BankInBankGroup,
            
 // PSM fields

 I_GLAccountLineItem.Fund as Fund,
 I_GLAccountLineItem.GrantID as GrantID,
 I_GLAccountLineItem.ProfitCenter as ProfitCenter,
 I_GLAccountLineItem.CostCenter as CostCenter,
 I_GLAccountLineItem.WBSElementInternalID,
 I_GLAccountLineItem.FunctionalArea   
 
}
where
  I_GLAccountLineItem.PostingDate <= $parameters.P_KeyDate