P_PriceFixationNonHedgeDetails

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_PriceFixationNonHedgeDetails.
-- 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: PPRCFIXNHDET

CREATE VIEW P_PriceFixationNonHedgeDetails AS
SELECT
  PricingAspect.TrdgContrPrcgAspectSrceLotID AS SourceLotId,
  formula_mm.ACMPricingConditionType AS NonHCondType,
  termgrpout.PricingConditionTerm AS TermNo,
  ConditionNumber.tkonn AS TradingContractNumber,
  ConditionNumber.tposn AS tposn,
  termconvin.ACMPricingFXRate AS NonHedgeableBasisFx,
  terminput.ACMPrcgTermInputCndnPrc AS NonHedgeablePrice,
  terminput.PrcgConditionTermFixedRateCrcy AS NonHedgeableTermCurrency,
  terminput.PrcgConditionTermFixedRateQty AS NonHedgeablePriceUnit,
  terminput.PrcgCndnTermFixedRateQtyUnit AS NonHedgeableUnitofMeasure,
  termgrpout.UnitOfMeasure AS TERMCOMMUOM,
  termgrpout.Quantity AS TERMCOMMQUAN
FROM P_TradingContractConditionNmbr AS ConditionNumber
INNER JOIN I_ACMMappingDocItemData AS guid ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMFormulaGrpgGeneralResult AS formula_mm ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgTrmGrpgGenRslt AS termgrpout ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgTrmInptGenData AS terminput ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContrPrcAspectBridgeDets AS bridge ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingCndnTypeMapping AS ConditionTypeMap ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrPrcAspectDets AS PricingAspect ON /* join condition not captured in parsed metadata */
;