FACVD_CLRIT_06

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 FACVD_CLRIT_06.
-- 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_Uname : abap.char(12)

CREATE VIEW FACVD_CLRIT_06 AS
SELECT
  regup.bukrs AS bukrs,
  regup.gjahr AS gjahr,
  regup.belnr AS belnr,
  regup.buzei AS buzei,
  cast('K' as koart) AS koart,
  regus.konko AS konko,
  fdc_d_dft_hdr.usera AS processor,
  fdc_d_dft_ac_hdr.root_key AS drft_uuid
FROM regup
LEFT OUTER JOIN regus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fdc_d_accdoc_tmp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fdc_d_dft_ac_hdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fdc_d_dft_hdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t042 ON regup.bukrs = t042.bukrs  -- association [0..1]
;