I_ACMTrdgContrPrcFixMeth

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_ACMTrdgContrPrcFixMeth.
-- 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: ITCPRCPRFIXMET

CREATE VIEW I_ACMTrdgContrPrcFixMeth AS
SELECT
  assignment.contract_no AS TradingContractNumber,
  assignment.contract_item_no AS TradingContractItem,
  assignment.term_no AS PricingConditionTerm,
  assignment.program_id AS ACMPriceMethodProgramID,
  masterdata.program_name AS ACMPriceMethodProgram,
  masterdata.external_code AS ACMPriceMethodProgramName,
  masterdata.program_family AS ACMPriceMethodProgramFamily,
  masterdata.program_type AS ACMPriceMethodProgramType,
  masterdata.external_code_pt AS ACMPriceMethodProgramTypeName,
  masterdata.sign_up_start_date AS ACMPrcMethSignUpStartDate,
  masterdata.sign_up_end_date AS ACMPrcMethSignUpEndDate,
  masterdata.pricing_start_date AS StartDate,
  masterdata.pricing_end_date AS EndDate,
  masterdata.maturity_code AS DerivativeContractMaturityCode,
  masterdata.crop_year AS ACMPrcMethCropYear,
  masterdata.marketing_timing AS ACMPrcMethMarketingTiming,
  masterdata.price_futures AS ACMPrcMethPriceFutures,
  cast(masterdata.target_price as abap.curr( 10, 2 )) AS ACMPrcMethTargetAmount,
  masterdata.status AS ACMPricingMethodStatus,
  cast(masterdata.minimum_price as abap.curr( 10, 2 )) AS ACMPricingMethodMinPrice,
  cast(masterdata.maximum_price as abap.curr( 10, 2 )) AS ACMPricingMethodMaxPrice,
  masterdata.currency AS ACMFutureValueUnitCurrency
FROM P_ACCGOMPPRDAT AS assignment
INNER JOIN P_ACCGOPMMD AS masterdata ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMTrdgContrItmDet AS _ContractItem ON TradingContractNumber = _ContractItem.TradingContractNumber AND TradingContractItem = _ContractItem.TradingContractItem  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrHdr AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;