P_Ftr_Fs_Tpm_Ds

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_Tpm_Ds.
-- 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_Tpm_Ds AS
SELECT
  I_FinInstrProductGroup.FinInstrProductGroup AS FinInstrProductGroup,
  _FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _FinancialTransaction.BusinessArea AS BusinessArea,
  _SecurityClass.Issuer AS Issuer,
  _FinancialTransaction.Counterparty AS Counterparty,
  Position_Values.TreasuryPosition AS TreasuryPosition,
  Position_Values.TreasuryValuationArea AS TreasuryValuationArea,
  Position_Values.TreasuryValuationClass AS TreasuryValuationClass,
  Position_Values.CompanyCode AS CompanyCode,
  Position_Values.SecurityAccount AS SecurityAccount,
  Position_Values.SecurityClass AS SecurityClass,
  Position_Values.TreasuryPositionAccount AS TreasuryPositionAccount,
  Position_Values.FinancialTransaction AS FinancialTransaction,
  Position_Values.DifferentiationPortfolio AS DifferentiationPortfolio,
  Position_Values.SecurityAccountGroup AS SecurityAccountGroup,
  Position_Values.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  Position_Values.TreasuryPositionLedgerDate AS TransactionDate,
  Position_Values.WBSElementInternalID AS WBSElementInternalID,
  Position_Values.ProfitCenter AS ProfitCenter,
  Position_Values.CostCenter AS CostCenter,
  Position_Values.FunctionalArea AS FunctionalArea,
  Position_Values.Fund AS Fund,
  Position_Values.GrantID AS GrantID,
  cast(Position_Values.TreasuryBusinessTransStatus as ftr_gen_business_trans_status preserving type) AS TreasuryBusinessTransStatus,
  Position_Values.PositionCurrency AS PositionCurrency,
  Position_Values.NominalCurrency AS NominalCurrency,
  Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency
FROM I_Ftr_Position_Values AS Position_Values
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
;