P_Trrsobaseplan

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_Trrsobaseplan.
-- 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: PTRRSOBASEPLAN

CREATE VIEW P_Trrsobaseplan AS
SELECT
  vbap.vbeln AS vbeln,
  vbap.posnr AS posnr,
  cust.rldnr AS rldnr,
  sum( case when cskb.katyp <> '11' and cskb.katyp <> '12' then acdocp.hsl else 0 end ) AS PlannedCosAmtInCCCrcy,
  sum( case when cskb.katyp = '11' or cskb.katyp = '12' then -1 * acdocp.hsl else 0 end) AS PlannedRevenueAmtInCCCrcy
FROM vbap
INNER JOIN Kkag_Werk_Bukrs_Kokrs AS werk ON /* join condition not captured in parsed metadata */
INNER JOIN P_Trrmonaccprin AS cust ON /* join condition not captured in parsed metadata */
INNER JOIN fins_trr_acp AS acp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acdocp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cskb ON /* join condition not captured in parsed metadata */
;