P_PrcFixationOptionBsHndlgSls

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_PrcFixationOptionBsHndlgSls.
-- 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: PPRCFIXOPTBHSLS

CREATE VIEW P_PrcFixationOptionBsHndlgSls AS
SELECT
  vbak.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  formdoc.cond_type AS ConditionType,
  termextension.termno AS ConditionTermNumber,
  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 vbak ON /* join condition not captured in parsed metadata */
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
;