P_TradingContractBusinessDets

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_TradingContractBusinessDets.
-- 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: PTRDGCTRVUS

CREATE VIEW P_TradingContractBusinessDets AS
SELECT
  Business.TradingContractNumber AS TradingContractNumber,
  Business.TradingContractItem AS TradingContractItem,
  Business.TrdgContrCommoditySubitem AS TrdgContrCommoditySubitem,
  Business.PurchaseOrderSupplier AS PurchaseOrderSupplier,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.TradingContractCurrency AS TradingContractCurrency,
  Business.TrdgContrSalesIncotermsVersion AS TrdgContrSalesIncotermsVersion,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  Business.TrdgContrSlsIncotermsLoc2Text AS TrdgContrSlsIncotermsLoc2Text,
  Business.TrdgContrPurgIncotermsVersion AS TrdgContrPurgIncotermsVersion,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.PricingDocument AS PricingDocument,
  Business.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Business.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  case Shadow.DocumentSide when 'M' then Business.ACMPurgIncotermsPart1 else Business.ACMSlsIncotermsPart1 end as IncoTerms AS ACMSlsIncotermsPart1endasIncoTerms,
  Shadow.DocumentSide AS DocumentSide,
  Business.ACMSupplyingPlant AS ACMSupplyingPlant,
  Business.TrdgContrPurgPaymentTerms AS TrdgContrPurgPaymentTerms,
  Business.TrdgContrSalesPaymentTerms AS TrdgContrSalesPaymentTerms,
  case Shadow.DocumentSide when 'M' then Business.ACMYourReference else Business.ACMCustomerReference end as ACMReferencePO AS ACMCustomerReferenceendasACMReferencePO,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference,
  PurchasingOrganizationName.PurchasingOrganizationName AS ekotx,
  PurchasingGroupName.PurchasingGroupName AS eknam
FROM I_ContSubItem AS Business
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescmm ON Business.ACMPurgIncotermsPart1 = _IncoDescmm.IncotermsClassification AND _IncoDescmm.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescsd ON Business.ACMSlsIncotermsPart1 = _IncoDescsd.IncotermsClassification AND _IncoDescsd.Language = $session.system_language  -- association [1..1]
;