P_ACMTradingContractOvw

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 P_ACMTradingContractOvw.
-- 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: PACMTRDGCTROVW

CREATE VIEW P_ACMTradingContractOvw AS
SELECT
  Header.tkonn AS TradingContractNumber,
  Header.tctyp AS TradingContractType,
  Header.tctyp_descr AS TradingContractTypeName,
  Header.Side AS Side,
  Header.btbsta AS ContractStatus,
  Header.bezei AS TrdgContrApplStsName,
  case Header.Side when 'M' then Header.TradingContractCurrency else Header.sdwrs end as TradingContractCurrency AS sdwrsendasTradingContractCurrency,
  Header.vkorg AS SalesOrganization,
  Header.vtweg AS DistributionChannel,
  Header.spart AS Division,
  Header.PurchasingOrganization AS PurchasingOrganization,
  Header.PurchasingGroup AS PurchasingGroup,
  Header.tkonn_ex AS TradingContractExternalID,
  Header.erdat AS TradingContrCreatedOnDate,
  Header.budat AS DocumentDate,
  Header.erzeit AS timezne,
  Header.tksachb AS PersonResponsible,
  Header.ernam AS TradingContractCreatedBy,
  Header.aenam AS TradingContractChangedBy,
  Header.aedat AS TradingContractChangedOnDate,
  Header.ACMRelevantContractStatus AS ACMRelevantContractStatus,
  Side.DomainText AS DocumentSide,
  case Header.Side when 'M' then Purchase_Counterparty.CustomerName else Sales_Counterparty.CustomerName end as CustomerName AS CustomerNameendasCustomerName,
  case Header.Side when 'M' then Purchase_Counterparty.Counterparty else Sales_Counterparty.Counterparty end as Counterparty AS CounterpartyendasCounterparty,
  case Header.Side when 'M' then Header.ACMPurgIncotermsPart1 else Header.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Header.IncotermsClassificationName AS IncotermsClassificationName,
  Header.IncotermsLocation1 AS IncotermsLocation1,
  Header.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Header.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  company_code AS CompanyCode,
  Header.AlternatePaymentTerm AS AlternatePaymentTerm,
  Header.ACMYourReference AS ACMYourReference,
  Header.ACMCustomerReference AS ACMCustomerReference
FROM P_ACMTrdgContrHdrDetsMntnContr AS Header
;