I_PurReqnQuickView

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_PurReqnQuickView.
-- 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: IPURREQQV
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW I_PurReqnQuickView AS
SELECT
  preqitm.PurchaseRequisition AS PurchaseRequisition,
  preqitm.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  preqitm.Material AS Material,
  MaterialName,
  MRPPlant,
  MaterialProcurementCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocItemCategoryName AS MaterialProcurementCatName,
  preqitm.SupplyingPlant AS SupplyingPlant,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  preqitm.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _MRPController.InternalContactName AS InternalContactPersonName,
  _MRPController.PhoneNumber AS MRPControllerPhoneNumber,
  _MRPController.EmailAddress AS ContactPersonEmailAddress,
  preqitm.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  preqitm.PurchaseRequisitionType AS PurchaseRequisitionType,
  _DocTypeTxt[ 1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  preqitm.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  preqitm.PurchasingInfoRecord AS PurchasingInfoRecord,
  preqitm.PurchasingOrganization AS PurchasingOrganization,
  preqitm.SupplierMaterialNumber AS SupplierMaterialNumber,
  preqitm.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  preqitm.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  ReleaseDate,
  preqitm.DeliveryDate AS DeliveryDate,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  praccta.SalesOrder AS SalesDocument,
  praccta.SalesOrderItem AS SalesDocumentItem,
  praccta._SalesOrder.SalesOrderType AS SalesDocumentType,
  praccta._SalesOrderItem.Material AS SalesOrderItemMaterial,
  praccta._SalesOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName AS SalesOrderItemMaterialName,
  praccta._SalesOrder.SoldToParty AS Customer,
  praccta.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.WBSDescription AS WBSDescription,
  _WBSElement._WBSElementLangBsdDesc[1: Language = $session.system_language ].WBSElementLangBsdDescription AS WBSElementDescription,
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement._Project.Project AS Project,
  WBSElement._Project.ProjectDescription AS ProjectDescription,
  prmat.FixedLotSizeQuantity AS MaterialFixedLotSizeQuantity,
  prmat.MinimumLotSizeQuantity AS MaterialMinLotSizeQuantity,
  prmat.MaximumLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  prmat.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  prmat.RoundingProfile AS MaterialRoundingProfile,
  _RoundingProfile[1: Language = $session.system_language ].MaterialRoundingProfileName AS MaterialRoundingProfileName,
  TotalQuantity,
  preqitm.OrderedQuantity AS OrderedQuantity,
  OpenQuantity,
  PurchaseRequisitionUnit,
  preqitm.Supplier AS Supplier,
  _Supplier1.BPSupplierName AS BPSupplierName,
  _Supplier1.BPSupplierFullName AS BPSupplierFullName,
  _Supplier1.PhoneNumber1 AS SupplierPhoneNumber,
  _Supplier1._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  preqitm.SupplierIsFixed AS SupplierIsFixed,
  preqitm.PurchasingGroup AS PurchasingGroup,
  preqitm.PurchasingGroupName AS PurchasingGroupName,
  preqitm.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  preqitm.PurchasingGroupEmailAddress AS PurchasingGroupEmailAddress,
  case when preqitm.OrderUnit is null or preqitm.OrderUnit = '' or preqitm.OrderUnit = ' ' then pir.PurgDocOrderQuantityUnit else preqitm.OrderUnit end as PurgDocOrderQuantityUnit AS OrderUnitendasPurgDocOrderQuantityUnit,
  $parameters.P_MRPElementCategory AS MRPElementCategory
FROM P_DDPurchaseRequisition
LEFT OUTER JOIN I_PurReqnAccountAssignment AS praccta ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingInfoRecord AS pir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductSupplyPlanning AS prmat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByInternalKey AS WBSElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _Unit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON MaterialProcurementCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurchaseRequisitionUnit ON PurchaseRequisitionUnit = _PurchaseRequisitionUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier1 ON Supplier = _Supplier1.Supplier  -- association [0..1]
LEFT OUTER JOIN I_RoundingPrfText AS _RoundingProfile ON MaterialRoundingProfile = _RoundingProfile.MaterialRoundingProfile AND MRPPlant = _RoundingProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _DocTypeTxt ON PurchaseRequisitionType = _DocTypeTxt.PurchasingDocumentType AND PurchasingDocumentCategory = _DocTypeTxt.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN P_DDMRPController AS _MRPController ON SupplyingPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
;