P_PrcFixationOptionCnvrsnSls

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_PrcFixationOptionCnvrsnSls.
-- 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: PPRCFIXOPTCNSLS

CREATE VIEW P_PrcFixationOptionCnvrsnSls AS
SELECT
  vbak.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  formdoc.cond_type AS ConditionType,
  termextension.termno AS ConditionTermNumber,
  termconvout.convplace AS convplace,
  termconvout.usedexchrate AS usedexchrate,
  termconvout.usedcurrfrom AS PrcgCndnTermCnvrsnSourceCrcy,
  termconvout.usedcurrto AS PrcgCndnTermCnvrsnTargetCrcy,
  termconvout.useduomfrom AS useduomfrom,
  termconvout.usedfactorto AS usedfactorto,
  termconvout.useduomto AS useduomto
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 cped_termconvout AS termconvout 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 */
;