P_PurOrdMaintainRefDocumentAll

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_PurOrdMaintainRefDocumentAll.
-- 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: PPOMAINTREFDOCAL

CREATE VIEW P_PurOrdMaintainRefDocumentAll AS
SELECT
  po_item.PurchaseOrder AS PurchaseOrder,
  po_item.PurchaseOrderItem AS PurchaseOrderItem,
  cast('' as abap.char(10)) AS PurchasingInfoRecord,
  po_header.PurchasingOrganization AS PurchasingOrganization,
  cast('' as abap.char(1)) AS PurchasingInfoRecordCategory,
  po_item.Plant AS Plant,
  'F' AS PurchasingDocumentCategory,
  po_item.StorageLocation AS StorageLocation,
  po_item.Material AS Material,
  po_item.MaterialType AS MaterialType,
  po_item.MaterialGroup AS MaterialGroup,
  po_header.Supplier AS Supplier,
  po_header.PurchasingDocumentType AS PurchasingDocumentType,
  po_item.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  po_item.PurchaseOrderQty AS PurchaseOrderQty,
  po_item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  po_item.PurchaseOrderNetPriceAmount AS PurchaseOrderNetPriceAmount,
  po_item.TaxCode AS TaxCode,
  po_item.TaxJurisdiction AS TaxJurisdiction,
  po_header.Currency AS Currency,
  po_item.PurchaseOrderNetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  po_item.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  po_header.PurchasingGroup AS PurchasingGroup,
  po_header.CompanyCode AS CompanyCode,
  cast('' as abap.char(25)) AS CompanyCodeName,
  po_header.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  po_header.PricingProcedure AS PricingProcedure,
  po_header.ValidityEndDate AS ValidityEndDate,
  po_item.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  po_item.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  po_item.InvoiceIsExpected AS InvoiceIsExpected,
  po_item.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  po_item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  po_item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  po_item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  po_item.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  po_item.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  po_item.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  po_item.AcctAssignmentCategory AS AcctAssignmentCategory,
  po_item.IsDeleted AS IsDeleted,
  po_item.ServicePerformer AS ServicePerformer,
  po_item.ProductType AS ProductType,
  po_item.RefPurchaseOutlineAgreement AS RefPurchaseOutlineAgreement,
  po_item.RefPurchOutlineAgrmtItem AS RefPurchOutlineAgrmtItem,
  po_item.SupplierMaterialNumber AS SupplierMaterialNumber,
  po_header.IncotermsVersion AS IncotermsVersion,
  po_header.IncotermsClassification AS HeaderIncotermsClassification,
  po_header.IncotermsTransferLocation AS HeaderIncotermsTransferLoc,
  po_header.IncotermsLocation1 AS HeaderIncotermsLocation1,
  po_header.IncotermsLocation2 AS HeaderIncotermsLocation2,
  po_item.IncotermsClassification AS IncotermsClassification,
  po_item.IncotermsTransferLocation AS IncotermsTransferLocation,
  po_item.IncotermsLocation1 AS IncotermsLocation1,
  po_item.IncotermsLocation2 AS IncotermsLocation2,
  po_item.DeliveryDate AS DeliveryDate,
  po_item.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  po_item.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  po_item.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  po_item.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  AccAssLine.ProfitCenter AS ProfitCenter,
  AccAssLine.WBSElementInternalID AS WBSElementInternalID,
  AccAssLine.FunctionalArea AS FunctionalArea,
  AccAssLine.GLAccount AS GLAccount,
  AccAssLine.CostCenter AS CostCenter,
  AccAssLine.ControllingArea AS ControllingArea,
  AccAssLine.SalesOrder AS SalesOrder,
  AccAssLine.SalesOrderItem AS SalesOrderItem,
  so_item.CreatedByUser AS SalesOrderCreatedByUser,
  so_item._SalesOrder.SoldToParty AS SalesOrderSoldToParty,
  so_item._SalesOrder.SalesOrganization AS SalesOrderSalesOrganization,
  so_item._SalesOrder.DistributionChannel AS SalesOrderDistributionChannel,
  so_item._SalesOrder.OrganizationDivision as SalesOrderOrganizationDivision AS PurchaseContractasPurchaseOrder,
  '' as SalesOrderOrganizationDivision AS MaterialkeyasPurchaseOrder,
  case eina.MaterialGroup when '' then eina._Material.MaterialGroup else eina.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  '' AS SalesOrderOrganizationDivision
FROM P_PurOrdMaintainItemActive AS po_item
LEFT OUTER JOIN P_PurOrdMaintainHeaderActive AS po_header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrderItem AS so_item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PurOrdMaintainPDocWAccAsLine AS AccAssLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseContract AS ctr_header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingInfoRecord AS eina ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS material ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PurchaseContractItem, I_PurgInfoRecdOrgPlantData
;