I_ACMTrdgContrPrcDetail

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_ACMTrdgContrPrcDetail.
-- 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.

CREATE VIEW I_ACMTrdgContrPrcDetail AS
SELECT
  PricingAspect.TradingContractNumber AS TradingContractNumber,
  PricingAspect.TradingContractItem AS TradingContractItem,
  PricingAspect.ACMPricingAspect AS ACMPricingAspect,
  PricingAspect.ACMPricingAspectValue AS ACMPricingAspectValue,
  TrdgContrPrcgAspectSrceLotID,
  cast( ' ' as /accgo/e_dummy_source_lot_id ) AS TrdgContrPrcgAspectDummyLotID,
  cast( ContractTradeQuantity as cds_cmmdtyqty_in_termuom ) AS ContractTradeQuantity,
  ContractTradeUnit,
  PricingAspect.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  ACMPrcgFixationStatus,
  PricingConditionTermKey,
  PricingConditionTerm,
  PricingAspect.ACMIsOverfill AS ACMIsOverfill,
  cast ( ' ' as tba_dcsid ) AS DerivativeContrSpecification,
  cast ( ' ' as tba_mic ) AS ACMPricingMarketIdentifierCode,
  cast ( ' ' as tba_contract_code ) AS ContrDrvtvContrMaturityCode,
  cast ( ' ' as cpet_fixcurr ) AS ACMPriceFixationCurrency,
  PricingAspect.RecordCreatedDate AS RecordCreatedDate,
  PricingAspect.RecordCreatedByUser AS RecordCreatedByUser,
  PricingAspect.LastChangeByUser AS LastChangeByUser,
  PricingAspect.LastChangedDate AS LastChangedDate,
  PricingAspect.ACMContrPrcgCumltvBsAmt AS ACMContrPrcgCumltvBsAmt,
  PricingAspect.ACMPrcgCndnCumltvBasisCrcy AS ACMPrcgCndnCumltvBasisCrcy,
  PricingAspect.ACMPrcgCumltvPerUnitQuantity AS ACMPrcgCumltvPerUnitQuantity,
  PricingAspect.ACMPrcgCndnCumltvBasisPrUoM AS ACMPrcgCndnCumltvBasisPrUoM,
  PricingAspect.ACMPrcgCndnFlatPrice AS ACMPrcgCndnFlatPrice,
  PricingAspect.ACMContrPrcgTotAmtCrcy AS ACMContrPrcgTotAmtCrcy,
  PricingAspect.ACMPrcgConditionPerUnitQty AS ACMPrcgConditionPerUnitQty,
  PricingAspect.ACMPrcgTotAmtUnit AS ACMPrcgTotAmtUnit,
  PricingAspect.ACMPrcgPrimaryBasisPrice AS ACMPrcgPrimaryBasisPrice,
  PricingAspect.ACMPrcgPrimBsCrcy AS ACMPrcgPrimBsCrcy,
  PricingAspect.ACMBasisPricingQuantity AS ACMBasisPricingQuantity,
  PricingAspect.ACMPrcgPrimBasisPriceUnit AS ACMPrcgPrimBasisPriceUnit,
  PricingAspect.ACMPrcgFuturesPrice AS ACMPrcgFuturesPrice,
  PricingAspect.ACMFuturesPriceCurrency AS ACMFuturesPriceCurrency,
  PricingAspect.ACMFuturePricingQuantity AS ACMFuturePricingQuantity,
  PricingAspects.ACMPrcgFuturesPriceUnit AS ACMPrcgFuturesPriceUnit
FROM I_ACMTrdgContrPricingAspects AS PricingAspect
-- UNION with additional select branch(es): I_ACMContrNonPrcdTmpLotDets
;