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_CmmdtyPrcFixationOptionSales.
-- 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: PPRCFIXOPTSLS
CREATE VIEW P_CmmdtyPrcFixationOptionSales AS
SELECT
vbak.vbeln AS SalesDocument,
vbap.posnr AS SalesDocumentItem,
formdoc.cond_type AS ConditionType,
termextension.termno AS PricingConditionTerm,
case when termgrpout.termrate > 0 then termgrpout.termrate else termout.termrate end as ConditionTermRate AS termrateendasConditionTermRate,
case when termgrpout.termcurr <> '' then termgrpout.termcurr else termout.termcurr end as ConditionTermRateCurrency AS termcurrendasConditionTermRateCurrency,
case when termgrpout.termprun > 0 then termgrpout.termprun else termout.termprun end as ConditionTermRateQuantity AS termprunendasConditionTermRateQuantity,
prcfix_def.prc_fixation_status AS PrcgCndnTermFixationOptnStatus,
prcfix_def.non_fixed_quantity AS CndnTrmFixationOptnNonFixedQty,
prcfix_def.non_fixed_qty_uom AS TrmFixationOptnNonFixedQtyUnit,
PrcgCndnTermCnvrsnSourceCrcy,
PrcgCndnTermCnvrsnTargetCrcy,
vbtyp AS SDDocumentCategory,
kunnr AS Customer,
vkorg AS SalesOrganization,
vtweg AS DistributionChannel,
vbak.spart AS Division,
werks AS Plant,
matnr AS Material,
formdoc.forminput_guid AS PrcgConditionFormulaInputUUID,
upd_tmstmp AS LastChangeDateTime,
vbak.ernam AS CreatedByUser,
vbak.erdat AS DocumentDate,
term.dcsid AS dcsid_term,
_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataControllerSet AS DataControllerSet,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController1 AS DataController1,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController2 AS DataController2,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController3 AS DataController3,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController4 AS DataController4,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController5 AS DataController5,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController6 AS DataController6,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController7 AS DataController7,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController8 AS DataController8,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController9 AS DataController9,
_Customer._CustomerToBusinessPartner._BusinessPartner.DataController10 AS DataController10,
_Customer._CustomerToBusinessPartner._BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
_Customer._CustomerToBusinessPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
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 */
LEFT OUTER JOIN P_PrcFixationOptionBsHndlgSls AS sd_basis ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PrcFixationOptionCnvrsnSls AS sd_fxrel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer -- association [1..1]
;