C_CntrlContractCnsmpn

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 C_CntrlContractCnsmpn.
-- 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: CNTRLCONTRCNSMPN
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : vdm_validitystart, P_EndDate : vdm_validitystart

CREATE VIEW C_CntrlContractCnsmpn AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PurchaseContractType,
  Supplier,
  PurchasingGroup,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  OrderQuantityUnit,
  Material,
  MaterialGroup,
  PurchasingDocumentCategory,
  ProcmtHubPurchasingOrg,
  ProcmtHubPurchasingGroup,
  ProcmtHubPlant,
  ProcmtHubCompanyCode AS CompanyCodeName,
  ProcmtHubCompanyCode,
  _RelevantDates.CalendarYear AS CalendarYear,
  _RelevantDates.CalendarQuarter AS CalendarQuarter,
  _RelevantDates.CalendarMonth AS CalendarMonth,
  _RelevantDates.CalendarWeek AS CalendarWeek,
  _HubPurchasingGroup.ProcmtHubPurchasingGroupName AS ProcmtHubPurchasingGroupName,
  _HubPlant.ProcmtHubPlantName AS ProcmtHubPlantName,
  _HubCompanyCode.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  _HubPurchasingOrg.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  ValidityStartDate,
  ValidityEndDate,
  DisplayCurrency,
  TargetQuantity,
  TargetAmount,
  ReleaseOrderItemNetAmount,
  ReleaseOrderItemOrderQuantity,
  ProcurementHubSourceSystem,
  CentrlContractItems.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus
FROM P_CntrlPurContractItems
LEFT OUTER JOIN I_CalendarDate AS _RelevantDates ON CentrlContractItems.ValidityStartDate = _RelevantDates.CalendarDate association[1..1] to I_ProcmtHubPurgOrgAPI01 as _HubPurchasingOrg on ProcurementHubSourceSystem = _HubPurchasingOrg.ProcurementHubSourceSystem AND ProcmtHubPurchasingOrg = _HubPurchasingOrg.ProcmtHubPurchasingOrg association[1..1] to I_ProcmtHubPurgGroupAPI01 as _HubPurchasingGroup on ProcurementHubSourceSystem = _HubPurchasingGroup.ProcurementHubSourceSystem AND ProcmtHubPurchasingGroup = _HubPurchasingGroup.ProcmtHubPurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier association[1..1] to I_ProcmtHubPlant as _HubPlant on ProcmtHubPlant = _HubPlant.ProcmtHubPlant AND ProcmtHubCompanyCode = _HubPlant.ProcmtHubCompanyCode AND ProcurementHubSourceSystem = _HubPlant.ProcurementHubSourceSystem association[1..1] to I_ProcmtHubPlant as _HubPlant_2 on ProcmtHubPlant = _HubPlant_2.ProcmtHubPlant AND CompanyCodeName = _HubPlant_2.ProcmtHubCompanyCode AND ProcurementHubSourceSystem = _HubPlant_2.ProcurementHubSourceSystem association[1..1] to I_ProcmtHubCompanyCode as _HubCompanyCode on CompanyCodeName = _HubCompanyCode.ProcmtHubCompanyCode AND ProcurementHubSourceSystem = _HubCompanyCode.ProcurementHubSourceSystem association[1..1] to I_ProductGroup_2 as _ProductGroup on MaterialGroup = _ProductGroup.ProductGroup association[1..1] to I_Product as _Product on Material = _Product.Product association[1..1] to I_Plant as _Plant on Plant = _Plant.Plant association[1..1] to I_PurchasingOrganization as _PurchasingOrganization on PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization association[1..1] to I_PurchasingGroup as _PurchasingGroup on PurchasingGroup = _PurchasingGroup.PurchasingGroup association[1..1] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode association[1..1] to I_ProcmtHubBackendSourceSystem as _BackendSourceSystem on ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrChgReqStatus AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
;