I_ACMTrdgContrMnlSelection

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_ACMTrdgContrMnlSelection.
-- 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: ITCMANUALSEL

CREATE VIEW I_ACMTrdgContrMnlSelection AS
SELECT
  ContractHeader.ContractNum AS TradingContractNumber,
  CommoditySubitem.TradingContractItem AS TradingContractItem,
  CommoditySubitem.TrdgContrCommoditySubitem AS TrdgContrCommoditySubitem,
  ContractHeader.ContractStatus AS ContractStatus,
  ContractStatus.TrdgContrApplStsName AS TrdgContrApplStsName,
  ContractHeader.TradingContractType AS TradingContractType,
  ContractHeader.TradingContractCreatedBy AS TradingContractCreatedBy,
  ContractHeader.SalesOrganization AS SalesOrganization,
  ContractHeader.DistributionChannel AS DistributionChannel,
  ContractHeader.Division AS Division,
  CommoditySubitem.Side AS Side,
  case CommoditySubitem.Side when 'M' then CommoditySubitem.ACMSettlementDocReferenceParty when 'V' then CommoditySubitem.CustomerNum else CommoditySubitem.CustomerNum end as Counterparty AS CustomerNumendasCounterparty,
  Counterparty.CustomerName AS CustomerName,
  sidetext.DomainText AS ACMTradingContractSideText,
  case when CommoditySubitem.ContractMaterial is initial then ContractItem.ContractMaterial else CommoditySubitem.ContractMaterial end as ContractMaterial AS ContractMaterialendasContractMaterial,
  ContractItem.ContractPlant AS ContractPlant,
  ContractItem.ContractStorageLocation AS ContractStorageLocation,
  ContractItem.TrdgContrSalesQuantity AS TrdgContrSalesQuantity,
  case when CommoditySubitem.BaseUnitofMeasure is initial then ContractItem.BaseUnit else CommoditySubitem.BaseUnitofMeasure end as BaseUnit AS BaseUnitofMeasureendasBaseUnit,
  CommoditySubitem.ACMPricingCancellationQuantity AS TradingContractItemQuantity,
  CommoditySubitem.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  CommoditySubitem.TrdgContrCreditSalesFromDate AS ActualStartDateFrom,
  CommoditySubitem.TrdgContractCreditSalesToDate AS ActualStartDateTo
FROM I_ACMTradingContractData AS ContractHeader
INNER JOIN I_ACMTradingContractStatus AS ContractStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTradingContractItemData AS ContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContractCommoditySubitem AS CommoditySubitem ON /* join condition not captured in parsed metadata */
INNER JOIN P_TradingContractCounterparty AS Counterparty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;