P_ACMTradingContractOverview

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_ACMTradingContractOverview.
-- 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: PCONTROVW

CREATE VIEW P_ACMTradingContractOverview AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Header.TradingContractType AS TradingContractType,
  Header.tctyp_descr AS TradingContractTypeName,
  Header.Side AS Side,
  Header.ContractStatus AS ContractStatus,
  Header.bezei AS TrdgContrApplStsName,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.Division AS Division,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.ekotx AS ekotx,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.eknam AS eknam,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.DocumentDate AS DocumentDate,
  Header.PersonResponsible AS PersonResponsible,
  Header.PersonResponsibleName AS PersonResponsibleName,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.TradingContractChangedOnDate AS TradingContractChangedOnDate,
  Header.CreatedBy AS TradingContractCreatedByName,
  Header.ChangedBy AS TradingContractChangedByName,
  Header.DistributionChannelDescr AS DistributionChannelDescr,
  Header.SalesDivisionDescr AS SalesDivisionDescr,
  Header.SalesOrgDescr AS SalesOrgDescr,
  _Side.DomainText AS DocumentSide,
  _Counterparty.Counterparty AS Counterparty,
  _Counterparty.AuthorizationGroup AS AuthorizationGroup,
  _Counterparty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  case Header.Side 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,
  Header.CompanyCode AS CompanyCode,
  PaymentInfo.AlternatePaymentTerm AS AlternatePaymentTerm,
  Header.TradingContractTradeOffice AS TradingContractTradeOffice,
  Header.TradingContractCreditSales AS TradingContractCreditSales,
  Header.ACMSignedStatus AS ACMSignedStatus,
  Header.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  Header.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  Header.ACMTrdgContrQuotesValidDate AS ACMTrdgContrQuotesValidDate,
  Business.ACMSupplyingPlant AS ACMSupplyingPlant,
  Business.ACMCustomerReference AS ACMCustomerReference,
  Business.ACMYourReference AS ACMYourReference
FROM P_ACMTradingContractHeader AS Header
INNER JOIN P_TradingContractBusinessDets AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContractSubItemDet AS PaymentInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMTrdgContrTypeWithSide AS _TargetContractType ON TradingContractType = _TargetContractType.TradingContractType  -- association [0..1]
;