I_Priceconversion

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_Priceconversion.
-- 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: IPRICECONV

CREATE VIEW I_Priceconversion AS
SELECT
  cat_itm.mandt AS SAPClient,
  cat_itm.price_key AS OpnCtlgPriceID,
  cat_itm.ctlg_itm_key AS OpnCtlgItemID,
  itm_price AS OpnCtlgItemPrice,
  itm_price AS CalculatedPrice,
  itm_currency AS OpnCtlgItemCurrency,
  price_comm_curr AS OpnCtlgPrcAmountInComCurrency,
  common_currency AS OpnCtlgComCurrencyID,
  cat_itm.ws_service_id AS OpnCtlgWebServiceID
FROM mmpur_cat_itm AS cat_itm
LEFT OUTER JOIN mmpur_cat_prconv AS _prConv ON /* join condition not captured in parsed metadata */
;