I_ACMContractCommoditySubitem

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_ACMContractCommoditySubitem.
-- 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: ICMMDTYSUBITM

CREATE VIEW I_ACMContractCommoditySubitem AS
SELECT
  TKONN AS TradingContractNumber,
  TPOSN AS TradingContractItem,
  Side,
  TPOSN_COM AS TrdgContrCommoditySubitem,
  QUANTITY AS ACMPricingCancellationQuantity,
  UNIT AS TrdgContractItemUnitOfMeasure,
  DATE_FROM AS TrdgContrCreditSalesFromDate,
  DATE_TO AS TrdgContractCreditSalesToDate,
  FUTURE AS ACMTrdgContrFutureAttrib,
  COM_GUID AS ACMCommodityUUID,
  CR_NAME AS TradingContractCreatedBy,
  CR_DATE AS ACMTrdgContrCreatedOnDate,
  CR_TIME AS TimeOfCreation,
  CH_NAME AS TradingContractChangedBy,
  CH_DATE AS TradingContractChangedOnDate,
  CH_TIME AS LastChangeTime,
  IT_CLOSED AS ACMCmmdtySubItmClosed,
  COM_CAT AS ACMCmmdtyItmCat,
  Numerator,
  Denominator,
  ASSGMT_REL AS ACMTrdgContrAssgmtRlvt,
  HKPSTP AS TradingContractItemCategory,
  MATNR AS ContractMaterial,
  BASIS_MEINS AS BaseUnitofMeasure,
  VENDOR AS ACMSettlementDocReferenceParty,
  CUSTOMER AS CustomerNum,
  Batch,
  EXT_REF AS ACMCmmdtyItmExtIdfr,
  COM_ITEM_PROP AS ACMCmmdtyItmPrpty,
  PLACE_HOLDER AS ACMDummySubAccountExtn
FROM P_ACMContractCommoditySubitem
;