I_PurchaseOrderQuickView

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_PurchaseOrderQuickView.
-- 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: IPOQV
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW I_PurchaseOrderQuickView AS
SELECT
  Item.PurchasingDocument AS PurchasingDocument,
  Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  ScheduleLine,
  Material,
  MaterialName,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  PurchasingDocumentItemCategory AS MaterialProcurementCategory,
  SupplierMaterialNumber,
  InventorySpecialStockType,
  MRPPlant,
  SupplyingPlant,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  Item.PurchasingInfoRecord AS PurchasingInfoRecord,
  Item.PurchasingOrganization AS PurchasingOrganization,
  Item.PurchasingGroup AS PurchasingGroup,
  PurchasingGroupName,
  PurchasingGroupPhoneNumber,
  PurchasingGroupEmailAddress,
  Item.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  GoodsReceiptDurationInDays,
  DeliveryDate,
  ProductAvailabilityDate,
  ScheduleLineOrderDate,
  PartialDeliveryIsAllowed,
  PurchaseContract,
  PurchaseContractItem,
  Item.OrderQuantityUnit AS PurchaseOrderItemQuantityUnit,
  OrderQuantity,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  ScheduleLineOpenQuantity,
  cast(0 as dabmg) AS MRPRelevantQuantity,
  cast(0 as mng01) AS StockInTransitQuantity,
  cast(0 as mng01) AS MRPElementOpenQuantity,
  Item.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Item.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Prod.MRPResponsible AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _MRPController.InternalContactName AS InternalContactPersonName,
  _MRPController.PhoneNumber AS MRPControllerPhoneNumber,
  _MRPController.EmailAddress AS ContactPersonEmailAddress,
  Item.Supplier AS Supplier,
  _Supplier.BPSupplierName AS BPSupplierName,
  _Supplier.BPSupplierFullName AS BPSupplierFullName,
  _Supplier.PhoneNumber1 AS SupplierPhoneNumber,
  _Supplier._StandardAddress._DefaultEmailAddress.EmailAddress AS InternalContactEmailAddress,
  Acct.SalesOrder AS SalesDocument,
  Acct.SalesOrderItem AS SalesDocumentItem,
  Acct._SalesOrder.SalesOrderType AS SalesDocumentType,
  Acct._SalesOrderItem.Material AS SalesOrderItemMaterial,
  Acct._SalesOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName AS SalesOrderItemMaterialName,
  Acct._SalesOrder.SoldToParty AS Customer,
  Acct._SalesOrder._SoldToParty.BPCustomerName AS BPCustomerName,
  Acct._SalesOrder._SoldToParty.BPCustomerFullName AS BPCustomerFullName,
  Acct._SalesOrder._SoldToParty._StandardAddress.PhoneNumber AS PhoneNumber,
  Acct._SalesOrder._SoldToParty._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  Acct.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,
  PIR.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  PIR.MaximumOrderQuantity AS MaximumOrderQuantity,
  PIR.MinimumPurchaseOrderQuantity AS MinimumPurchaseOrderQuantity,
  PIR.MaterialStagingTime AS MaterialStagingTime,
  Prod.FixedLotSizeQuantity AS MaterialFixedLotSizeQuantity,
  Prod.MinimumLotSizeQuantity AS MaterialMinLotSizeQuantity,
  Prod.MaximumLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  Prod.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  Prod.RoundingProfile AS MaterialRoundingProfile,
  _RoundingProfile[1: Language = $session.system_language].MaterialRoundingProfileName AS MaterialRoundingProfileName,
  $parameters.P_MRPElementCategory AS MRPElementCategory
FROM P_DDPurchaseOrder
LEFT OUTER JOIN I_PurgDocAccountAssignment AS Acct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS PIR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductSupplyPlanning AS Prod 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_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 _BaseUnit ON PurchaseOrderItemQuantityUnit = _BaseUnit.UnitOfMeasure  -- 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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- 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]
;