P_TradingContractOverview

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_TradingContractOverview.
-- 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 P_TradingContractOverview AS
SELECT
  Header.tkonn AS TradingContractNumber,
  Header.tctyp AS TradingContractType,
  Header.tctyp_descr AS TradingContractTypeName,
  Business.DocumentSide AS Side,
  Header.btbsta AS ContractStatus,
  Header.bezei AS TrdgContrApplStsName,
  case Business.DocumentSide when 'M' then Business.TradingContractCurrency else Header.sdwrs end as TradingContractCurrency AS sdwrsendasTradingContractCurrency,
  Header.vkorg AS SalesOrganization,
  Header.vtweg AS DistributionChannel,
  Header.spart AS Division,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.ekotx AS ekotx,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.eknam AS eknam,
  Header.tkonn_ex AS TradingContractExternalID,
  Header.erdat AS TradingContrCreatedOnDate,
  Header.budat AS DocumentDate,
  Header.tksachb AS PersonResponsible,
  Header.PersonResponsible AS PersonResponsibleName,
  Header.ernam AS TradingContractCreatedBy,
  Header.CreatedBy AS TradingContractCreatedByName,
  Header.aenam AS TradingContractChangedBy,
  Header.ChangedBy AS TradingContractChangedByName,
  Header.aedat AS TradingContractChangedOnDate,
  Header.DistributionChannelDescr AS DistributionChannelDescr,
  Header.SalesDivisionDescr AS SalesDivisionDescr,
  Header.SalesOrgDescr AS SalesOrgDescr,
  Side.DomainText AS DocumentSide,
  case Business.DocumentSide when 'M' then Purchase_Counterparty.Counterparty else Sales_Counterparty.Counterparty end as Counterparty AS CounterpartyendasCounterparty,
  case Business.DocumentSide when 'M' then Business.ACMPurgIncotermsPart1 else Business.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Business.IncotermsClassificationName AS IncotermsClassificationName,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  company_code AS CompanyCode,
  Header.TradingContractTradeOffice AS TradingContractTradeOffice,
  Header.TradingContractCreditSales AS TradingContractCreditSales,
  Header.ACMSignedStatus AS ACMSignedStatus,
  Header.ACMTrdgContrIsStatusClosed AS ACMTrdgContrIsStatusClosed,
  Business.ACMSupplyingPlant AS ACMSupplyingPlant,
  Business.ACMReferencePO AS ACMReferencePO,
  Business.ACMCustomerReference AS ACMCustomerReference,
  Business.ACMYourReference AS ACMYourReference
FROM P_TradingContractHeader AS Header
INNER JOIN P_TradingContractBusinessDets AS Business ON /* join condition not captured in parsed metadata */
;