P_FTR_FS_TPM_DS2

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_DS2.
-- 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_DS2 AS
SELECT
  cast ('TPM' as ftr_gen_fin_pos_datasource ) AS FinancialPositionDataSource,
  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,
  cast(Position_Values.TreasuryBusinessTransStatus as ftr_gen_business_trans_status preserving type) AS TreasuryBusinessTransStatus,
  Position_Values.Fund AS Fund,
  Position_Values.GrantID AS GrantID,
  Position_Values.ProfitCenter AS ProfitCenter,
  Position_Values.WBSElementInternalID AS WBSElementInternalID,
  Position_Values.CostCenter AS CostCenter,
  Position_Values.FunctionalArea AS FunctionalArea,
  Position_Values.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  Position_Values.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  Position_Values.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  Position_Values.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  Position_Values.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  Position_Values.PositionCurrency AS TransactionCurrency,
  Position_Values.NominalCurrency AS NominalCurrency,
  Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  cast ( 0 as ftr_utilamtintranscrcy) AS UtilizedAmountInTransCrcy,
  cast ( 0 as ftr_totamtintranscrcy) AS TotalAmountInTransactionCrcy,
  cast ('' as fis_racct) AS GLAccount,
  cast ('' as farp_hbkid) AS HouseBank,
  cast ('' as fac_hktid) AS HouseBankAccount,
  cast ('' as fis_gjahr) AS FiscalYear,
  cast ('' as farp_blart) AS AccountingDocumentType,
  cast ('' as fins_ledger) AS Ledger,
  cast ('' as belnr_d) AS AccountingDocument,
  Position_Values.CommitmentBusinessPartner AS BankInBankGroup
FROM I_Ftr_Position_Values AS Position_Values
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
;