P_PrcFixationOptionBsHndlgPurg

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_PrcFixationOptionBsHndlgPurg.
-- 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: PPRCFIXOPTBHPUR

CREATE VIEW P_PrcFixationOptionBsHndlgPurg AS
SELECT
  ekko.ebeln AS PurchasingDocument,
  ekpo.ebelp AS PurchasingDocumentItem,
  formdoc.cond_type AS ConditionType,
  termextension.termno AS ConditionTermRateFixation,
  term.quotkey AS quotkey_term
FROM cped_formdoc AS formdoc
INNER JOIN cped_extension AS termextension ON /* join condition not captured in parsed metadata */
INNER JOIN cped_prcfix_def AS prcfix_def ON /* join condition not captured in parsed metadata */
INNER JOIN cped_knumvtoguid AS knumvtoguid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cped_termgrpout AS termgrpout ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cped_termout AS termout ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cpec_termgrp AS termgrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cpec_term AS term ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cped_terminput AS terminput ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cpec_quotrule AS quotrule ON /* join condition not captured in parsed metadata */
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
;