P_Ldcmpcurr

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_Ldcmpcurr.
-- 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: PFILDCMPCURR

CREATE VIEW P_Ldcmpcurr AS
SELECT
  finsc_ld_cmp.rldnr AS rldnr,
  finsc_ld_cmp.bukrs AS bukrs,
  finsc_ld_cmp.curtph AS curtp_cc,
  cast(t001.waers as fins_currh ) AS crcy_cc,
  finsc_ld_cmp.curtpk AS curtp_gc,
  finsc_ld_cmp.curtpo AS curtp_fdc1,
  finsc_ld_cmp.curtpv AS curtp_fdc2,
  finsc_ld_cmp.curtpb AS curtp_fdc3,
  finsc_ld_cmp.curtpc AS curtp_fdc4,
  finsc_ld_cmp.curtpd AS curtp_fdc5,
  finsc_ld_cmp.curtpe AS curtp_fdc6,
  finsc_ld_cmp.curtpf AS curtp_fdc7,
  finsc_ld_cmp.curtpg AS curtp_fdc8
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
INNER JOIN t000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t880 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tka02 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tka01 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_osl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_vsl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_bsl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_csl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_dsl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_esl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_fsl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_001a AS finsc_001a_gsl ON /* join condition not captured in parsed metadata */
;