P_ACMContractBusinessDets

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_ACMContractBusinessDets.
-- 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: PACMCTRBUSNDET

CREATE VIEW P_ACMContractBusinessDets AS
SELECT
  Business.TradingContractNumber AS TradingContractNumber,
  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,
  Business.TrdgContrPurgPaymentTerms AS TrdgContrPurgPaymentTerms,
  Business.TrdgContrSalesPaymentTerms AS TrdgContrSalesPaymentTerms,
  Business.ACMSupplyingPlant AS ACMSupplyingPlant,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference,
  PurchasingOrganizationName.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroupName.PurchasingGroupName AS PurchasingGroupName,
  Shadow.DocumentSide AS DocumentSide,
  case Shadow.DocumentSide when 'M' then Business.ACMYourReference else Business.ACMCustomerReference end as ACMReferencePO AS ACMCustomerReferenceendasACMReferencePO
FROM P_ACMContractBusiness AS Business
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescmm ON _IncoDescmm.IncotermsClassification = Business.ACMPurgIncotermsPart1 AND _IncoDescmm.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescsd ON _IncoDescsd.IncotermsClassification = Business.ACMSlsIncotermsPart1 AND _IncoDescsd.Language = $session.system_language  -- association [1..1]
;