P_APFlexibleAging9

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_APFlexibleAging9.
-- 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: PAPFLXBLAGING9
-- Parameters: P_KeyDate : abap.dats, P_AgingGridMeasureInDays : abap.int4, P_NumberOfAgingGridColumns : abap.int4, P_DisplayCurrency : abap.cuky

CREATE VIEW P_APFlexibleAging9 AS
SELECT
  AgingGrid.CompanyCode AS CompanyCode,
  AgingGrid.TransactionCurrency AS TransactionCurrency,
  AgingGrid.BusinessArea AS BusinessArea,
  AgingGrid.ReconciliationAccount AS ReconciliationAccount,
  AgingGrid.SpecialGLCode AS SpecialGLCode,
  AgingGrid.Supplier AS Supplier,
  AgingGrid.PaymentMethod AS PaymentMethod,
  AgingGrid.PaymentTerms AS PaymentTerms,
  AgingGrid.AccountingDocumentCategory AS AccountingDocumentCategory,
  AgingGrid.AgingGridColumnSequence AS AgingGridColumnSequence,
  AgingGrid.AgingGridText AS AgingGridText,
  AgingGrid.KeyDate AS KeyDate,
  cast(DisplayCurrency as displaycurrency) AS DisplayCurrency,
  cast(AgingGridMeasureInDays as farp_aging_grid_measure ) AS AgingGridMeasureInDays,
  cast(NumberOfAgingGridColumns as farp_number_of_grid_columns) AS NumberOfAgingGridColumns,
  AgingData.CompanyCodeCurrency AS CompanyCodeCurrency,
  Country,
  ChartOfAccounts,
  cast(AgingData.AmountInCompanyCodeCurrency as dmshb_farp) AS AmountInCompanyCodeCurrency,
  cast(AgingData.NumberOfOpenItems as farp_number_of_open_items ) AS NumberOfOpenItems
FROM P_APFlexibleAging8
LEFT OUTER JOIN P_APFlexibleAging6 ON /* join condition not captured in parsed metadata */
;