Fac_Ppv_Cds_T001b

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 Fac_Ppv_Cds_T001b.
-- 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: FACPPVV_T001B

CREATE VIEW Fac_Ppv_Cds_T001b AS
SELECT
  t001b.rrcty AS rrcty,
  t001b.bukrs AS opvar,
  t001b.mkoar AS mkoar,
  t001b.bkont AS bkont,
  t001b.vkont AS vkont,
  t010p.opvtx AS opvar_descr,
  dd07t.ddtext AS mkoar_descr,
  t001b.frye1 AS frye1,
  t001b.frpe1 AS frpe1,
  t001b.toye1 AS toye1,
  t001b.tope1 AS tope1,
  t001b.frye2 AS frye2,
  t001b.frpe2 AS frpe2,
  t001b.toye2 AS toye2,
  t001b.tope2 AS tope2,
  t001b.brgru AS brgru,
  t001b.frye3 AS frye3,
  t001b.frpe3 AS frpe3,
  t001b.toye3 AS toye3,
  t001b.tope3 AS tope3
FROM t001b
LEFT OUTER JOIN t010p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
;