P_Ftr_Asgn_Utilize

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_Asgn_Utilize.
-- 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: PFTRASGNUTILIZE
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_CrdtLineReportingFrequency : ftr_date_granularity

CREATE VIEW P_Ftr_Asgn_Utilize AS
SELECT
  Facility.CompanyCode AS CompanyCode,
  Facility.FinancialTransaction AS FinancialTransaction,
  Facility.RelatObject AS RelatObject,
  Facility.SyndicatedCounterparty AS SyndicatedCounterparty,
  Facility.KeyDate AS KeyDate,
  Facility.CreditLineReportingPeriod AS CreditLineReportingPeriod,
  Position.PositionObject AS PositionObject,
  Facility.TransactionCurrency AS TransactionCurrency,
  cast(Facility.PositionAmount as ftr_totamtintranscrcy) AS TotalAmount,
  Facility._TransactionCurrency AS _TransactionCurrency
FROM P_Ftr_Asgn_Daily_Fac_Amount
LEFT OUTER JOIN P_Ftr_Asgn_Pos_With_Ratio ON /* join condition not captured in parsed metadata */
;