I_CntrlPurchaseContractPartner

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 I_CntrlPurchaseContractPartner.
-- 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: ICPCPARTNER

CREATE VIEW I_CntrlPurchaseContractPartner AS
SELECT
  purchasingdocument AS CentralPurchaseContract,
  purchasingdocumentitem AS CentralPurchaseContractItem,
  distributionnumber AS DistributionKey,
  PartnerCounter,
  cast( partnerfunction as parvw_unv ) AS PartnerFunction,
  ExtPlantForPurg,
  Supplier,
  SupplierSubrange,
  coalesce( _CntrlPurContrDistrInternal.PurchasingOrganization , purchasingorganization ) AS PurchasingOrganization
FROM P_CntrlPurchaseContractPartner
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurchaseContractItem AS _CntrlPurchaseContractItem ON _CntrlPurchaseContractItem.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurchaseContractItem.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrDistribution AS _CntrlPurContrDistribution ON _CntrlPurContrDistribution.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrDistribution.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrDistribution.DistributionKey = DistributionKey  -- association [1..1]
LEFT OUTER JOIN P_CntrlPurContrDistribution AS _CntrlPurContrDistrInternal ON _CntrlPurContrDistrInternal.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrDistrInternal.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrDistrInternal.DistributionKey = DistributionKey  -- association [1..1]
;