P_PriceFixationBasicDetails

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_PriceFixationBasicDetails.
-- 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: PPRCFIXBASDET

CREATE VIEW P_PriceFixationBasicDetails AS
SELECT
  PricingAspect.TrdgContrPrcgAspectSrceLotID AS SourceLotId,
  formula_mm.ACMPricingConditionType AS BasisCondType,
  termgrpout.PricingConditionTerm AS TermNo,
  ConditionNumber.tkonn AS tkonn,
  ConditionNumber.tposn AS tposn,
  termconvin.ACMPricingFXRate AS BasisFx,
  terminput.ACMPrcgTermInputCndnPrc AS basisprice,
  terminput.PrcgConditionTermFixedRateCrcy AS PrcgCndnBasisTermCurrency,
  terminput.DerivativeContrSpecification AS DCSID,
  DCSText.DerivativeContrSpecName AS DerivativeContrSpecsTxt,
  terminput.MarketIdentifierCode AS MIC,
  MICText.MarketIdentifierCodeName AS MarketIdentifierCodeTxt,
  terminput.PrcgConditionTermFixedRateQty AS PriceUnitBasisFixedRate,
  terminput.PrcgCndnTermFixedRateQtyUnit AS FixedRateBasisUnitofMeasure,
  terminput_bas.fetch_price AS BasisFetchPrice,
  terminput_bas.FETCH_PRICE_CURRENCY AS BasisFetchPriceCurrency,
  terminput_bas.FETCH_PRICE_QTY AS BasisFetchPriceQty,
  terminput_bas.FETCH_PRICE_UNIT AS BasisFetchPriceUnit,
  terminput_bas.REASON_CODE AS BasisReasonCode,
  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 P_GetCPETermInputDataBasis 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_ACMTrdgContrPrcAspectDets AS PricingAspect ON /* join condition not captured in parsed metadata */
;