I_HistFinancialStatusCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HistFinancialStatusCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_KeyDate : vdm_v_key_date, P_TreasuryPositionPeriod : ftr_pos_hist_period

CREATE VIEW I_HistFinancialStatusCube AS
SELECT
  cast('ZFP001' as ftr_gen_fin_pos) AS FinancialPosition,
  cast('ZFPG1' as ftr_gen_fin_pos_grp) AS FinancialPositionGroup,
  cast ('FQM' as ftr_gen_fin_pos_datasource ) AS FinancialPositionDataSource,
  cast('Z' as ftr_gen_fin_pos_asset_liab) AS FinPositionAssetLiabilityCode,
  cast ('ZZZZ' as bukrs) AS CompanyCode,
  cast ('12341234' as fis_racct) AS GLAccount,
  cast ('ZB' as farp_hbkid) AS HouseBank,
  cast ('ZBU' as fis_rbusa) AS BusinessArea,
  cast ('ZBP' as repke_new) AS Issuer,
  cast ('ZCP' as rkontrah_new) AS Counterparty,
  cast ('ZZZ' as vvsart) AS FinancialInstrumentProductType,
  cast ('1234' as tb_rfha) AS FinancialTransaction,
  cast ('ZGV' as tpm_val_class) AS TreasuryValuationClass,
  cast ('ZSAC' as ftr_gen_security_account) AS SecurityAccount,
  cast ('ZSEC' as ftr_gen_security_class) AS SecurityClass,
  cast ('ZFUT' as tpm_pos_account_fut) AS TreasuryPositionAccount,
  cast ('999' as tpm_val_area) AS TreasuryValuationArea,
  cast ('' as fins_ledger) AS Ledger,
  cast ('9999' as fis_gjahr) AS FiscalYear,
  cast ('' as farp_blart) AS AccountingDocumentType,
  cast ('999' as belnr_d) AS AccountingDocument,
  cast ('JPY' as ftr_gen_nominal_currency) AS NominalCurrency,
  cast ('EUR' as fis_rwcur) AS TransactionCurrency,
  cast ('999' as ftr_gen_fin_pos_amt_tc) AS NominalAmountInNominalCurrency,
  cast ('999' as ftr_gen_fin_pos_amt_tc) AS BookValueAmtInPositionCurrency,
  cast ('998' as ftr_utilamtintranscrcy) AS UtilizedAmountInTransCrcy,
  cast ('998' as ftr_totamtintranscrcy) AS TotalAmountInTransactionCrcy,
  cast ('XYZ' as fti_ldb_risk_counterparty) AS CommitmentBusinessPartner,
  cast ('ZZ' as fac_hktid) AS HouseBankAccount,
  cast ('XXX' as rportb) AS Portfolio,
  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,
  cast ('GZ' as land1 ) AS Country,
  cast( 'ABC' as fclm_bank_in_bnkgrp ) AS BankInBankGroup,
  cast( 'ABC' as fclm_bank_group ) AS BankGroup,
  cast ('JKLO' as fikrs preserving type ) AS FinancialManagementArea,
  cast( 'ABCDEFGHIJ' as bp_geber preserving type ) AS Fund,
  cast( 'ABCDEF' as fm_fundtype preserving type ) AS FundType,
  cast( 'ABCDEFGHIJKLMNOPQRST' as gm_grant_nbr preserving type ) AS GrantID,
  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
FROM I_Currency
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TrsyFinStsCountryGeoPoint AS _CountryGeoPoint ON Country = _CountryGeoPoint.Country  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClass AS _TreasuryValuationClass ON TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClass.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Issuer ON Issuer = _Issuer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CommitmentBusinessPartner ON CommitmentBusinessPartner = _CommitmentBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _TransactionType ON FinancialInstrumentProductType = _TransactionType.FinancialInstrumentProductType AND FinancialInstrTransactionType = _TransactionType.FinancialInstrTransactionType  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON CompanyCode = _TreasuryPositionAccount.CompanyCode AND TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND Portfolio = _Portfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_FinancialPosition AS _FinancialPosition ON FinancialPosition = _FinancialPosition.FinancialPosition  -- association [0..1]
LEFT OUTER JOIN I_FinancialPositionGroup AS _FinancialPositionGroup ON FinancialPositionGroup = _FinancialPositionGroup.FinancialPositionGroup  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankBasic AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BankGroup ON BankGroup = _BankGroup.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BankInBankGroup ON BankInBankGroup = _BankInBankGroup.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund AND FinancialManagementArea = _Fund.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantType AS _GrantType ON GrantType = _GrantType.GrantType  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FundType AS _FundType ON FundType = _FundType.FundType AND FinancialManagementArea = _FundType.FinancialManagementArea  -- association [0..1]
;