P_InfoRecordManageSOSAll

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_InfoRecordManageSOSAll.
-- 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: PIRMNGSOSALL

CREATE VIEW P_InfoRecordManageSOSAll AS
SELECT
  original.Guid AS Guid,
  original.PurchasingInfoRecord AS PurchasingInfoRecord,
  original.PurchasingOrganization AS PurchasingOrganization,
  original.Plant AS Plant,
  original.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  original.Supplier AS Supplier,
  original._Supplier.SupplierName AS SupplierName,
  original.Material AS Material,
  original._Plant.PlantName AS PlantName,
  original.Entitystate AS Entitystate,
  original.MaterialGroup AS MaterialGroup,
  original.GeneralDataDeleted AS GeneralDataDeleted,
  original.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  original.OrderUnit AS OrderUnit,
  original.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  original.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  original.SupplierMaterialNumber AS SupplierMaterialNumber,
  original.SalesPerson AS SalesPerson,
  original.SupplierPhoneNumber AS SupplierPhoneNumber,
  original.BaseUnit AS BaseUnit,
  original.SupplierMaterialGroup AS SupplierMaterialGroup,
  original.PriorSupplier AS PriorSupplier,
  original.AvailableFromDate AS AvailableFromDate,
  original.AvailableToDate AS AvailableToDate,
  original.vabme AS vabme,
  original.relif AS relif,
  original.isMarkedForDeletion AS IsMarkedForDeletion,
  original.PurchasingGroup AS PurchasingGroup,
  original.Currency AS Currency,
  original.MinimumPurchaseOrderQuantity AS MinimumPurchaseOrderQuantity,
  original.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  original.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  original.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  original.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  original.uebtk AS uebtk,
  original.ebeln AS ebeln,
  original.ebelp AS ebelp,
  original.NetPriceAmount AS NetPriceAmount,
  original.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  original.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  original.PriceValidityEndDate AS PriceValidityEndDate,
  original.bpumz AS bpumz,
  original.bpumn AS bpumn,
  original.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  original.TaxCode AS TaxCode,
  original.IncotermsClassification AS IncotermsClassification,
  original.IncotermsTransferLocation AS IncotermsTransferLocation,
  original.MaximumOrderQuantity AS MaximumOrderQuantity,
  original.IsRelevantForAutomSrcg AS IsRelevantForAutomSrcg,
  original.DraftCreator AS DraftCreator,
  original.DraftCreatorName AS DraftCreatorName,
  original.DraftCreationDate AS DraftCreationDate,
  original.DraftChangeDate AS DraftChangeDate,
  cast('X' as abap.char(1)) as IsActiveEntity AS GuidasGuid,
  cast(' ' as abap.char(1)) AS IsActiveEntity
FROM P_Inforecordmanagesos AS original
-- UNION ALL with additional select branch(es): P_Inforecordmanagesosdraft
;