I_ACMTrdgContrShadowItem

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_ACMTrdgContrShadowItem.
-- 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: IACMTCSHDITM

CREATE VIEW I_ACMTrdgContrShadowItem AS
SELECT
  cast( document as tkonn ) AS TradingContractNumber,
  item AS ContractItem,
  cast(right(item, 6) as tposn) AS TradingContractItem,
  Side,
  sub_item AS ContractCommodityItem,
  type AS DocumentCategory,
  item_quan AS ACMAssignQuantity,
  item_uom AS ACMOpenItemQuantityUnit,
  matnr AS Material,
  vendor AS PurchaseOrderSupplier,
  customer AS SoldToParty,
  date_from AS ACMValidityFromDate,
  date_to AS RecnclnTransaclDelivToDate,
  has_open_quan AS ACMTrdgContrHasOpenQuantity,
  closed AS ACMCmmdtySubItmClosed,
  cancel_flag AS IsCancelled
FROM wb2_d_shd_item
;