P_FTR_FS_FIB_DS3

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 P_FTR_FS_FIB_DS3.
-- 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

CREATE VIEW P_FTR_FS_FIB_DS3 AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  cast ('FIB' as ftr_gen_fin_pos_datasource ) AS FinancialPositionDataSource,
  I_GLAccountLineItem.PostingDate AS TransactionDate,
  I_GLAccountLineItem.AmountInTransactionCurrency AS BookValueAmtInPositionCurrency,
  cast ( 0 as ftr_utilamtintranscrcy) AS UtilizedAmountInTransCrcy,
  cast ( 0 as ftr_totamtintranscrcy) AS TotalAmountInTransactionCrcy,
  I_GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.HouseBank AS HouseBank,
  I_GLAccountLineItem.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.TransactionCurrency AS NominalCurrency,
  I_GLAccountLineItem.AmountInTransactionCurrency AS NominalAmountInNominalCurrency,
  FiscalYear.FiscalYearEndDate AS FiscalYearEndDate,
  FiscalYear.FiscalYearStartDate AS FiscalYearStartDate,
  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,
  cast ('' as fti_ldb_risk_counterparty) AS CommitmentBusinessPartner,
  I_GLAccountLineItem.Fund AS Fund,
  I_GLAccountLineItem.GrantID AS GrantID,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea
FROM I_GLAccountLineItem
INNER JOIN I_FiscalYear AS FiscalYear ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_HouseBankWithRiskBP AS _BankLinkage ON CompanyCode = _BankLinkage.CompanyCode AND HouseBank = _BankLinkage.HouseBank  -- association [0..1]
;