I_CntrlPurContrWthPriceHist

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_CntrlPurContrWthPriceHist.
-- 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: ICNTRTPRICHST

CREATE VIEW I_CntrlPurContrWthPriceHist AS
SELECT
  cast (active_doc_number as vdm_centralpurchasecontract preserving type) AS ActivePurchasingDocument,
  document_version AS PurchasingDocumentVersion,
  cast (item as vdm_cntrlpurchasecontractitem preserving type) AS CentralPurchaseContractItem,
  plant_unique_id AS ProcmtHubPlantUniqueID,
  validity_uuid AS ProcmtHubContrValidityUUID,
  is_current_version AS ProcmtHubContrIsCurrentVersion,
  document_number AS CentralPurchaseContract,
  contract_type AS PurchaseContractType,
  price_validity_start_date AS ConditionValidityStartDate,
  price_validity_end_date AS ConditionValidityEndDate,
  net_price_doc_curr AS NetPriceAmount,
  net_price_rep_currency1 AS NetPriceInReportingCurrency,
  net_price_rep_currency2 AS NetPriceInReportingCurrency2,
  effective_price_doc_curr AS NetAmount,
  effective_price_rep_curr1 AS NetAmountInReportingCurrency,
  effective_price_rep_curr2 AS NetAmountInReportingCurrency2,
  base_price_doc_curr AS ProcmtHubContrBasePrDocCrcyAmt,
  base_price_rep_currency1 AS ProcmtHubContrBasePrCrcy1Amt,
  base_price_rep_currency2 AS ProcmtHubContrBasePrCrcy2Amt,
  document_currency AS DocumentCurrency,
  reporting_currency1 AS AnalyticalReportingCurrency,
  reporting_currency2 AS AnalyticalReportingCurrency2,
  version_creation_date AS CreationDate,
  Supplier,
  company_code AS CompanyCode,
  purchasing_group AS PurchasingGroup,
  purchasing_org AS PurchasingOrganization,
  extmaterialforpurg AS Material,
  material_group AS MaterialGroup,
  change_reason_indicator AS ChangeReasonIsRelevantForVers,
  unit_of_measure AS OrderQuantityUnit,
  changed_by AS CreatedByUser,
  incoterms1 AS ProcmtHubIncotermsClassfctn,
  incoterms2 AS ProcmtHubIncoterms2Classfctn,
  payment_terms AS PaymentTerms,
  shipping_instructions AS ShippingCondition,
  company_code_group AS ProcmtHubCompanyCodeGroupingID
FROM mmpur_ana_cenctr
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON MaterialGroup = _MaterialGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AnalyticalReportingCurrency ON AnalyticalReportingCurrency = _AnalyticalReportingCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AnalyticalReportingCurrency2 ON AnalyticalReportingCurrency2 = _AnalyticalReportingCurrency2.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
;