I_ACMTrdgContrPrcgVersionDets

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_ACMTrdgContrPrcgVersionDets.
-- 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: ITCPRCVERSDETS

CREATE VIEW I_ACMTrdgContrPrcgVersionDets AS
SELECT
  right( root_doc , 10 ) AS TradingContractNumber,
  root_doc_itm AS TradingContractItem,
  pricing_key AS PricingKey,
  version AS MaximumVersion,
  root_doc_type AS ACMTrdgContrBusinessDocType,
  termno_l AS PricingConditionTerm,
  kschl AS CAConditionType,
  kschl_m AS MarketConditionType,
  commodity_adj_in_termuom AS OpenCommodityQuantity,
  termuom AS OpenQuantityUnit,
  dcsid AS DerivativeContrSpecification,
  mic AS ACMPricingMarketIdentifierCode,
  contract_code AS DerivativeContractMaturityCode,
  term_extension_usage AS ConditionTermExtensionUsage,
  cgroup_cat AS MTMConditionGroupCategory,
  fixation_id AS ACMConditionTermNumber,
  keydate AS MaturityKeyDate,
  waerk AS PrcgCndnTradingContrCurrency,
  termcurr AS PrcgConditionTermRateCrcy,
  termprun AS PrcgConditionTermRateQty,
  termuom AS PrcgConditionTermRateQtyUnit,
  fixed AS PrevVersCndnTrmExchRateIsFixed,
  calc_group AS MTMCalculationGroup,
  basis_id AS BasisID,
  pricetype AS PriceQuotationType,
  quotkey AS PricingConditionQuotationKey,
  formuom AS ACMFormulaUoM
FROM cmm_vlogp
;