I_ACMTrdgContrItmCancEventDets

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_ACMTrdgContrItmCancEventDets.
-- 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: IITMCANCEVENTDET

CREATE VIEW I_ACMTrdgContrItmCancEventDets AS
SELECT
  cancelEvent.tkonn AS TradingContractNumber,
  cancelEvent.tposn AS TradingContractItem,
  cancelEvent.cancl_guid AS ContractQtyCancellationUUID,
  cancelEvent.seq_no AS ACMContrCanclnSqncNmbr,
  eventDetail.obligation_id AS ACMObligationID,
  eventDetail.cancl_qty AS ACMPricingCancellationQuantity,
  eventDetail.tradeqty AS ACMCancelTradeQuantity,
  eventDetail.cancl_unit AS BaseUnit,
  eventDetail.tradeuom AS ACMContrTrdUoM,
  eventDetail.src_plot_id AS ACMSourcePricingLotID,
  eventDetail.cancl_fee AS ACMLumpSumFee,
  eventDetail.currency AS SettlementCurrency,
  eventDetail.cancl_prc_unit AS ConditionQuantity,
  cast( eventDetail.psmguid as cmmfdor_ordreqdocexternalid ) AS CmmdtyOrdReqDocExternalID,
  eventDetail.equity_amount AS ACMPrcgCancellationEquityAmt,
  eventDetail.equity_currency AS ACMPrcgCancellationEquityCrcy,
  eventDetail.psmstatus AS CmmdtyOrderRequestStatus,
  cancelEvent.cancl_typ AS ACMCancellationType,
  cancelEvent.absgr AS PurgReasonForDocCancellation,
  cancelEvent.cancl_date AS ACMCancellationDate,
  cancelEvent./accgo/rate_type AS RateType,
  cancelEvent.reversed AS ACMCancellationReversalStatus,
  cancelEvent./accgo/effdate AS EffectiveDate,
  eventDetail.underfill_id AS ACMTrdgContrUnderFillID
FROM /accgo/t_canc_cc AS cancelEvent
INNER JOIN /accgo/t_canc_pl AS eventDetail ON /* join condition not captured in parsed metadata */
;