P_FinTransAmtForFacility

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_FinTransAmtForFacility.
-- 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.
-- SQL view name: PFINTRANAMTFAC
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_FinTransAmtRptgFrequency : ftr_date_granularity

CREATE VIEW P_FinTransAmtForFacility AS
SELECT
  Facility.CompanyCode AS CompanyCode,
  Facility.FinancialTransaction AS FinancialTransaction,
  Facility.KeyDate AS KeyDate,
  Facility.TransactionCurrency AS TransactionCurrency,
  Facility.PositionAmount AS AmountInTransactionCurrency,
  Trans.Counterparty AS Counterparty,
  cast('FAC' as ftr_productgroup) AS FinTransProductGroup,
  Trans.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  Trans.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  Trans.Portfolio AS Portfolio,
  cast('' as ftr_gen_security_account) AS SecurityAccount
FROM P_Ftr_Asgn_Daily_Fac_Amount
LEFT OUTER JOIN I_FinancialTransaction AS Trans ON Facility.CompanyCode = Trans.CompanyCode AND Facility.FinancialTransaction = Trans.FinancialTransaction  -- association [1..1]
;