P_ACMTradingContractDetails

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_ACMTradingContractDetails.
-- 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: PTRDGCONTRCTDTLS

CREATE VIEW P_ACMTradingContractDetails 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,
  ContractType.ACMTradingContractCategory AS TrdgContractCategory,
  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 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,
  Counterparty.Counterparty AS Counterparty,
  case Business.DocumentSide when 'M' then Business.ACMPurgIncotermsPart1 else Business.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Business.IncotermsClassificationName AS IncotermsClassificationName,
  company_code AS CompanyCode,
  TradeOffice.TradingContractTradeOffice AS TradingContractTradeOffice,
  TradingContractCreditSales,
  ACMSignedStatus,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference
FROM P_TradingContractHeader AS Header
INNER JOIN I_ACMTrdgContrTypeWithSide AS ContractType ON /* join condition not captured in parsed metadata */
INNER JOIN P_TradingContractBusinessDets AS Business ON /* join condition not captured in parsed metadata */
;