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_PrcSttgMethExecutionAnalysis.
-- 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: PCMM_PSMPC01
CREATE VIEW P_PrcSttgMethExecutionAnalysis AS
SELECT
knumvtoguid.knumv AS PricingDocument,
knumvtoguid.kposn AS PricingDocumentItem,
formdoc.cond_type AS ConditionType,
termgrpout.termno AS ConditionTermRateFixation,
cast ( terminput.number_of_lots as astueck ) AS NumberOfCommodityContracts,
terminput.psmethod AS PriceSettingMethod,
terminput.psmstatus AS PriceSettingMethodStatus,
terminput.dcsid AS DerivativeContrSpecification,
terminput.mic AS MarketIdentifierCode,
terminput.pricetype AS PriceQuotationType,
terminput.keydate AS MaturityKeyDate,
termgrpout.termcommquan AS ConditionTermQuantity,
termgrpout.termcommuom AS ConditionTermUnit,
ekko.bstyp AS PurchasingDocumentCategory,
cast ( ekko.ebeln as fis_ebeln ) AS PurchasingDocument,
case when (vbak.vbtyp is null ) then ' #' else vbak.vbtyp end as SDDocumentCategory AS vbtypendasSDDocumentCategory,
vbak.vbeln AS SalesDocument,
case when ( GTMHeaderPurchase.tkonn is null ) then GTMHeaderSales.tkonn else GTMHeaderPurchase.tkonn end as ContractNum AS tkonnendasContractNum,
case when ( GTMItemPurchase.tposn is null ) then GTMItemSales.tposn else GTMItemPurchase.tposn end as TradingContractItem AS tposnendasTradingContractItem,
case when ( ekpo.matnr is not null ) then ekpo.matnr when ( GTMItemPurchase.matnr is not null ) then GTMItemPurchase.matnr when ( GTMItemSales.matnr is not null ) then GTMItemSales.matnr else vbap.matnr end as Material AS matnrendasMaterial,
cast ( case when ( ekpo.menge is not null ) then ekpo.menge when ( GTMItemPurchase.menge is not null ) then GTMItemPurchase.menge when ( GTMItemSales.menge is not null ) then GTMItemSales.menge else vbap.kwmeng end as menge_d ) as QuantityInBaseUnit AS kwmengendasmenge_dasQuantityInBaseUnit,
case when ( ekpo.meins is not null ) then ekpo.meins when ( GTMItemPurchase.meins is not null ) then GTMItemPurchase.meins when ( GTMItemSales.meins is not null ) then GTMItemSales.meins else vbap.meins end as BaseUnit AS meinsendasBaseUnit,
orderdoc.cmmdtyorderfillprcgupdtstatus AS CmmdtyOrderFillPrcgUpdtStatus,
orderdoc.cmmdtyordreqdocpricinglot AS CmmdtyOrdReqDocPricingLot,
orderdoc.cmmdtyordreqdocapplication AS CmmdtyOrdReqDocApplication,
orderdoc.cmmdtyordreqdocpricingstatus AS CmmdtyOrdReqDocPricingStatus,
orderdoc.cmmdtyordrequestdocumenttype AS CmmdtyOrdRequestDocumentType,
orderdoc.commodityorderrequestdocument AS CommodityOrderRequestDocument,
orderdoc.cmmdtyordreqdoctofillqty AS CmmdtyOrdReqDocToFillQty,
orderdoc.cmmdtyordreqdoctofillqtyunit AS CmmdtyOrdReqDocToFillQtyUnit,
orderreq.commodityorderrequest AS CommodityOrderRequest,
orderreq.commoditysubaccount AS CommoditySubAccount,
orderreq.cmmdtyorderrequeststatus AS CmmdtyOrderRequestStatus,
orderreq.cmmdtyorderrequesttype AS CmmdtyOrderRequestType,
orderreq.cmmdtyordreqcntrptysubacct AS CmmdtyOrdReqCntrPtySubAcct,
orderreq.creationdatetime AS CreationDateTime,
orderreq.lastchangedatetime AS LastChangeDateTime,
fillpacket.cmmdtyorderfillpacketstatus AS CmmdtyOrderFillPacketStatus,
fill.commodityorderfill AS CommodityOrderFill,
fill.cmmdtyordfillfinancialtransid AS CmmdtyOrdFillFinancialTransID,
fill.cmmdtyorderfillquantityinlots AS CmmdtyOrderFillQuantityInLots,
fill.cmmdtyordfilluomperlot AS CmmdtyOrdFillUoMPerLot,
fill.cmmdtyordfillquantityperlot AS CmmdtyOrdFillQuantityPerLot,
fill.cmmdtyorderfillprice AS CmmdtyOrderFillPrice,
fill.cmmdtyorderfillpricecrcy AS CmmdtyOrderFillPriceCrcy
FROM cped_terminput AS terminput
LEFT OUTER JOIN cped_termgrpout AS termgrpout ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cped_formdoc AS formdoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cped_knumvtoguid AS knumvtoguid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbak ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN wbhk AS GTMHeaderSales ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN wbhi AS GTMItemSales ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN wbhd AS GTMHeaderPurchase ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN wbhi AS GTMItemPurchase ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdor_d_doc AS orderdoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdor_d_order AS orderreq ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdof_d_flpkt AS fillpacket ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdof_d_fill AS fill ON /* join condition not captured in parsed metadata */
;