I_PrcSttgMethExecAnlys

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 I_PrcSttgMethExecAnlys.
-- 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: IPCMM_PSMPC01

CREATE VIEW I_PrcSttgMethExecAnlys AS
SELECT
  PricingDocument,
  PricingDocumentItem,
  ConditionType,
  ConditionTermRateFixation,
  NumberOfCommodityContracts,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  PriceQuotationType,
  MaturityKeyDate,
  ConditionTermQuantity,
  ConditionTermUnit,
  PurchasingDocumentCategory,
  PurchasingDocument,
  SDDocumentCategory,
  SalesDocument,
  ContractNum,
  TradingContractItem,
  Material,
  QuantityInBaseUnit,
  BaseUnit,
  CmmdtyOrderFillPrcgUpdtStatus,
  CmmdtyOrdReqDocPricingLot,
  CmmdtyOrdReqDocApplication,
  CmmdtyOrdReqDocPricingStatus,
  CmmdtyOrdRequestDocumentType,
  CommodityOrderRequestDocument,
  CmmdtyOrdReqDocToFillQty,
  CmmdtyOrdReqDocToFillQtyUnit,
  CommodityOrderRequest,
  CommoditySubAccount,
  CmmdtyOrderRequestStatus,
  CmmdtyOrderRequestType,
  CmmdtyOrdReqCntrPtySubAcct,
  CreationDateTime,
  LastChangeDateTime,
  CmmdtyOrderFillPacketStatus,
  CommodityOrderFill,
  CmmdtyOrdFillFinancialTransID,
  CmmdtyOrderFillQuantityInLots,
  CmmdtyOrdFillUoMPerLot,
  CmmdtyOrdFillQuantityPerLot,
  CmmdtyOrderFillPrice,
  CmmdtyOrderFillPriceCrcy
FROM P_PrcSttgMethExecutionAnalysis
LEFT OUTER JOIN I_PriceSettingMethod AS _PriceSettingMethod ON PriceSettingMethod = _PriceSettingMethod.PriceSettingMethod  -- association [1..1]
LEFT OUTER JOIN I_PriceSettingMethodStatus AS _PriceSettingMethodStatus ON PriceSettingMethod = _PriceSettingMethodStatus.PriceSettingMethod AND PriceSettingMethodStatus = _PriceSettingMethodStatus.PriceSettingMethodStatus  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [1..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode  -- association [1..1]
LEFT OUTER JOIN I_PriceQuotationType AS _PriceQuotationType ON PriceQuotationType = _PriceQuotationType.PriceQuotationType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionTermUnit ON ConditionTermUnit = _ConditionTermUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CmmdtyOrdReqDocToFillQtyUnit ON CmmdtyOrdReqDocToFillQtyUnit = _CmmdtyOrdReqDocToFillQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CmmdtyOrdFillUoMPerLot ON CmmdtyOrdFillUoMPerLot = _CmmdtyOrdFillUoMPerLot.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CmmdtyOrderFillPriceCrcy ON CmmdtyOrderFillPriceCrcy = _CmmdtyOrderFillPriceCrcy.Currency  -- association [1..1]
LEFT OUTER JOIN I_CommodityOrderRequest AS _CommodityOrderRequest ON CommodityOrderRequest = _CommodityOrderRequest.CommodityOrderRequest  -- association [1..1]
;