P_PurReqnOpenQuantCalc

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_PurReqnOpenQuantCalc.
-- 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: PPROPENQUANCALC

CREATE VIEW P_PurReqnOpenQuantCalc AS
SELECT
  _Purchaserequisitionitem.PurchaseRequisition AS PurchaseRequisition,
  _Purchaserequisitionitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchasingCategoryMatlGroup.PurgCatUUID AS PurgCatUUID,
  _Purchaserequisitionitem.MaterialGroup AS MaterialGroup,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _Purchaserequisitionitem.PurchasingOrganization AS PurchasingOrganization,
  _Purchaserequisitionitem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _Purchaserequisitionitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _Purchaserequisitionitem.FixedSupplier AS FixedSupplier,
  _Purchaserequisitionitem.SupplyingPlant AS SupplyingPlant,
  _Purchaserequisitionitem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _Purchaserequisitionitem.Material AS Material,
  _Purchaserequisitionitem.Plant AS Plant,
  _Purchaserequisitionitem.BaseUnit AS BaseUnit,
  _Purchaserequisitionitem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _Purchaserequisitionitem.PurchasingDocument AS PurchasingDocument,
  _Purchaserequisitionitem.PurchasingGroup AS PurchasingGroup,
  _Purchaserequisitionitem.DeliveryDate AS DeliveryDate,
  _Purchaserequisitionitem.RequestedQuantity AS RequestedQuantity,
  _Purchaserequisitionitem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _Purchaserequisitionitem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  _Purchaserequisitionitem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _Purchaserequisitionitem.RequirementTracking AS RequirementTracking,
  _Purchaserequisitionitem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _Purchaserequisitionitem.Supplier AS Supplier,
  _DesiredSupplier.SupplierName AS SupplierName,
  _Purchaserequisitionitem.RequestedQuantity-_Purchaserequisitionitem.OrderedQuantity AS OpenQuantity,
  _Purchaserequisitionitem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _Purchaserequisitionitem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  _Purchaserequisitionitem.PurReqCreationDate AS PurReqCreationDate,
  _Purchaserequisitionitem.ProcessingStatus AS ProcessingStatus,
  _Purchaserequisitionitem.ReleaseCode AS ReleaseCode,
  _ReleaseIndicatorDesc.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  _Purchaserequisitionitem.StorageLocation AS StorageLocation,
  _Purchaserequisitionitem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _Purchaserequisitionitem.PurReqnRequestor AS PurReqnRequestor,
  _Purchaserequisitionitem.RequisitionerName AS RequisitionerName,
  _Purchaserequisitionitem.MRPController AS MRPController,
  _Purchaserequisitionitem.Batch AS Batch,
  _Purchaserequisitionitem.PurReqnOrigin AS PurReqnOrigin,
  _PurchaseReqnOrigin.DomainText AS DomainText,
  _Purchaserequisitionitem.ReleaseStrategy AS ReleaseStrategy,
  _ReleaseStrategyDesc.PurchasingReleaseStrategyDesc AS PurchasingReleaseStrategyDesc,
  _Purchaserequisitionitem.ReleaseGroup AS ReleaseGroup,
  _Purchaserequisitionitem.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS UserDescription,
  _Purchaserequisitionitem.CreationDate AS CreationDate,
  _Purchaserequisitionitem.IsClosed AS IsClosed,
  _Purchaserequisitionitem.IsDeleted AS IsDeleted,
  _Purchaserequisitionitem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _Purchaserequisitionitem.IsPurReqnBlocked AS IsPurReqnBlocked,
  _Purchaserequisitionitem.IsPurReqnCmplt AS IsPurReqnCmplt,
  _Purchaserequisitionitem.CompanyCode AS CompanyCode,
  _Purchaserequisitionitem._PurchaseOrder._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Purchaserequisitionitem.OrderedQuantity AS OrderedQuantity,
  _Purchaserequisitionitem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  _Purchaserequisitionitem.ConsumptionPosting AS ConsumptionPosting,
  _Purchaserequisitionitem._PurchasingDocumentType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _DesiredSupplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  cast(case when (_Purchaserequisitionitem.PurReqnReleaseStatus = '03' and _Purchaserequisitionitem.ProcessingStatus = 'N') or (_Purchaserequisitionitem.PurReqnReleaseStatus = '04' and _Purchaserequisitionitem.ProcessingStatus = 'N') or (_Purchaserequisitionitem.PurReqnReleaseStatus = '02' and _Purchaserequisitionitem.ProcessingStatus = 'N' and _Purchaserequisitionitem.PurReqnCmpltnsCat = 'A') then '1' when (_Purchaserequisitionitem.PurReqnReleaseStatus = '02' and _Purchaserequisitionitem.ProcessingStatus = 'N') or (_Purchaserequisitionitem.PurReqnReleaseStatus = '05' and _Purchaserequisitionitem.ProcessingStatus = 'N') then '2' else '3' end as abap.char( 10 )) as PurchasingDocumentStatus AS char10asPurchasingDocumentStatus,
  ProductType,
  SupplierMaterialNumber,
  MaterialRevisionLevel,
  ServicePerformer,
  MaterialPlannedDeliveryDurn,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseRequisitionIsFixed,
  MaterialGoodsReceiptDuration,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  GoodsReceiptIsNonValuated,
  SourceOfSupplyIsAssigned,
  LastChangedDate,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  dats_add_days(_CalendarDate.FirstDayOfWeekDate,-1,'NULL') AS weekstart,
  dats_add_days(_CalendarDate.FirstDayOfWeekDate,5,'NULL') AS weekend,
  dats_add_days(_CalendarDate.FirstDayOfWeekDate,12,'NULL') AS secweekend,
  cast(cast(_CalendarDate.CalendarWeek as abap.int1( 3 )) - 1 as abap.char( 12 )) AS calweek,
  7-cast(_CalendarDate.WeekDay as abap.int8) AS weekday1,
  14-cast(_CalendarDate.WeekDay as abap.int8) AS weekday2,
  28-cast(_CalendarDate.WeekDay as abap.int8) AS weekday4,
  dats_add_days(_CalendarDate.FirstDayOfWeekDate,-1,'NULL') AS weekday5,
  PFMTransDataFootprintUUID,
  _PurchasingCategoryMatlGroup._PurchasingCategory AS _PurchasingCategory,
  _Purchaserequisitionitem._MaterialGroup AS _MaterialGroup
FROM I_Purchaserequisitionitem AS _Purchaserequisitionitem
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PRReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseStatus = ReleaseCode AND _ReleaseIndicatorDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurReqnCreationInd AS _PurchaseReqnOrigin ON _PurchaseReqnOrigin.DomainValue = PurReqnOrigin  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON _Purchaserequisitionitem.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplier AS _ProcmtBlockedSupplier ON _ProcmtBlockedSupplier.PurchasingIsBlockedForSupplier = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ReleaseStrategyDesc AS _ReleaseStrategyDesc ON _ReleaseStrategyDesc.PurchasingReleaseStrategy = ReleaseStrategy AND _ReleaseStrategyDesc.ReleaseGroup = ReleaseGroup  -- association [0..*]
LEFT OUTER JOIN C_PurchaseReqnSourceType AS _PurchaseReqnSourceType ON _PurchaseReqnSourceType.DomainValue = PurchasingSourceType  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = $session.system_date  -- association [1..1]
;