P_CO_DIANStRpSuplrCustOpnItmLg

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_CO_DIANStRpSuplrCustOpnItmLg.
-- 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_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_CO_DIANReportFormat : ficodian_report_format

CREATE VIEW P_CO_DIANStRpSuplrCustOpnItmLg AS
SELECT
  OperationalView.CompanyCode AS CompanyCode,
  cast( OperationalView.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  OperationalView.AccountingDocument AS AccountingDocument,
  DIAN_GLAccount.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIAN_GLAccount.CO_DIANReportItemType AS CO_DIANReportItemType,
  OperationalView.BusinessPlace AS BusinessPlace,
  cast( 'COP' as ficodian_reporting_currency ) AS ReportingCurrency,
  OperationalView._CompanyCode AS _CompanyCode,
  OperationalView._FiscalYear AS _FiscalYear,
  OperationalView._JournalEntry AS _JournalEntry
INNER JOIN I_CO_DIANGeneralLedgerAccount AS DIAN_GLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_CO_DIANItemType AS DIAN_ItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON _ReportingCurrency.Currency = ReportingCurrency  -- association [0..1]
;