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_CmmdtyPrcFixationOptionPurg.
-- 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: PPRCFIXOPTPUR
CREATE VIEW P_CmmdtyPrcFixationOptionPurg AS
SELECT
ekko.ebeln AS PurchasingDocument,
ekpo.ebelp AS PurchasingDocumentItem,
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,
PrcgCndnTermCnvrsnSourceCrcy,
PrcgCndnTermCnvrsnTargetCrcy,
prcfix_def.non_fixed_quantity AS CndnTrmFixationOptnNonFixedQty,
prcfix_def.non_fixed_qty_uom AS TrmFixationOptnNonFixedQtyUnit,
ekko.bstyp AS PurchasingDocumentCategory,
lifnr AS ActiveSupplier,
ekko.bukrs AS CompanyCode,
ekorg AS PurchasingOrganization,
ekgrp AS PurchasingGroup,
werks AS Plant,
matnr AS Material,
formdoc.forminput_guid AS PrcgConditionFormulaInputUUID,
ekko.lastchangedatetime AS LastChangeDateTime,
ernam AS CreatedByUser,
bedat AS DocumentDate,
term.dcsid AS dcsid_term,
_Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
_Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataControllerSet AS DataControllerSet,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController1 AS DataController1,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController2 AS DataController2,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController3 AS DataController3,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController4 AS DataController4,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController5 AS DataController5,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController6 AS DataController6,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController7 AS DataController7,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController8 AS DataController8,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController9 AS DataController9,
_Supplier._SupplierToBusinessPartner._BusinessPartner.DataController10 AS DataController10,
_Supplier._SupplierToBusinessPartner._BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
_Supplier._SupplierToBusinessPartner._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 ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PrcFixationOptionBsHndlgPurg AS mm_basis ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PrcFixationOptionCnvrsnPurg AS mm_fxrel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON ActiveSupplier = _Supplier.Supplier -- association [1..1]
;