I_ACMCmmdtyContrCancln_1

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_ACMCmmdtyContrCancln_1.
-- 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.

CREATE VIEW I_ACMCmmdtyContrCancln_1 AS
SELECT
  tkonn AS TradingContractNumber,
  tposn AS TradingContractItem,
  tposn_com AS ContractSubItem,
  cancl_guid AS ACMPrcgCancellationUUID,
  new_plot_id AS ACMContractPricingLotID,
  cancl_typ AS ACMCancellationType,
  created_by AS CreatedByUser,
  created_on AS CreationDate,
  changed_by AS LastChangedByUser,
  changed_on AS LastChangeDateTime,
  underfill_id AS ACMTrdgContrUnderFillID,
  src_plot_id AS ACMSourcePricingLotID,
  group_id AS CmmdtyPrcgPriceFixationGroupID,
  prcfixgrp_guid AS CmmdtyPrcgPrcFixationGroupUUID,
  absgr AS PurgReasonForDocCancellation,
  ob_linkid AS ACMObligationLinkID,
  settlmt_indi AS FinalSettlementIndicator,
  seq_no AS ACMContrCanclnSqncNmbr,
  Side,
  number_of_vehicles AS ACMNumberOfVehicles,
  prlink_id AS LinkUUID,
  total_cancld_qty AS ACMContractItemTotCancelledQty,
  cancl_unit AS TrdgContractItemUnitOfMeasure,
  cancld_qty AS ACMPricingCancellationQuantity,
  cancld_qty_uom AS BaseUnit,
  cond_type_1 AS CmmdtyPrcgFutureConditionType,
  cond_type_2 AS ACMCmmdtyPrcgPrimBsCndnType,
  assgn_guid AS ACMAssignmentUUID,
  psmguid AS PrcgCndnTrmPrSettingMethodUUID,
  psmstatus AS PriceSettingMethodStatus
FROM /accgo/t_cc_canc
;