I_ACMTrdgContrPrcgMaster

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_ACMTrdgContrPrcgMaster.
-- 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: ICONTRPRCGMASTER

CREATE VIEW I_ACMTrdgContrPrcgMaster AS
SELECT
  program_id AS ACMPriceMethodProgramID,
  program_name AS ACMPriceMethodProgram,
  external_code AS ACMPriceMethodProgramName,
  program_family AS ACMPriceMethodProgramFamily,
  program_type AS ACMPriceMethodProgramType,
  external_code_pt AS ACMPriceMethodProgramTypeName,
  sign_up_start_date AS ACMPrcMethSignUpStartDate,
  sign_up_end_date AS ACMPrcMethSignUpEndDate,
  pricing_start_date AS PlngDataPricingPeriodStartDate,
  pricing_end_date AS PlngDataPricingPeriodEndDate,
  maturity_code AS DerivativeContractMaturityCode,
  crop_year AS ACMPrcMethCropYear,
  marketing_timing AS ACMPrcMethMarketingTiming,
  price_futures AS ACMPrcMethPriceFutures,
  Currency,
  unit_of_measurement AS ACMPricingUnitOfMeasure,
  per_quantity AS TrdgContrPurgNetPriceQuantity,
  status AS ACMTrdgContrPrcgStatusText,
  status_text AS ACMPricingMethodStatusName,
  created_by AS ACMSettlmtDocPaytSpltCreatedBy,
  created_on AS TradingContrCreatedOnDate,
  created_tstmp AS GrantCreatedOnDateTime,
  changed_by AS ChangedBy,
  /accgo/t_prmt_md.changed_on AS DateFunctionChangedOn,
  changed_tstmp AS GrantChangedOnDateTime
FROM /accgo/t_prmt_md
;