P_PurOrdMaintainItemAll

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_PurOrdMaintainItemAll.
-- 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: PPOMAINTITEMALL

CREATE VIEW P_PurOrdMaintainItemAll AS
SELECT
  CONCAT(':',CONCAT(REPLACE(REPLACE(PurOrdMaintainItemActive.PurchaseOrder,'~','~~'),':','~:'), CONCAT(':',REPLACE(REPLACE(PurOrdMaintainItemActive.PurchaseOrderItem,'~','~~'),':','~:')))) as ID AS PurchaseOrderItemasID,
  cast( '' as abap.char(32)) AS PurchaseOrderItemDraftUUID,
  cast( '' as abap.char(32)) AS PurchaseOrderHeaderDraftUUID,
  PurOrdMaintainItemActive.PurchaseOrder AS PurchaseOrder,
  PurOrdMaintainItemActive.PurchaseOrderItem AS PurchaseOrderItem,
  cast(CONCAT(':',REPLACE(REPLACE(PurOrdMaintainItemActive.PurchaseOrder,'~','~~'),':','~:')) as abap.char(32)) AS ParentId,
  PurOrdMaintainItemActive.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  PurOrdMaintainItemActive.Material AS Material,
  PurOrdMaintainItemActive.MaterialType AS MaterialType,
  PurOrdMaintainItemActive.ProductType AS ProductType,
  PurOrdMaintainItemActive.MaterialGroup AS MaterialGroup,
  PurOrdMaintainItemActive.Plant AS Plant,
  original_plant.PlantName AS PlantName,
  PurOrdMaintainItemActive.StorageLocation AS StorageLocation,
  original_storagelocation.StorageLocationName AS StorageLocationName,
  PurOrdMaintainItemActive.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurOrdMaintainItemActive.PurchaseOrderQty AS PurchaseOrderQty,
  PurOrdMaintainItemActive.PurchaseOrderNetPriceAmount AS PurchaseOrderNetPriceAmount,
  PurOrdMaintainItemActive.PurchaseOrderNetAmount AS PurchaseOrderNetAmount,
  PurOrdMaintainItemActive.NetPriceIsDerived AS NetPriceIsDerived,
  PurOrdMaintainItemActive.PurOrderEffectiveItemAmount AS PurOrderEffectiveItemAmount,
  PurOrdMaintainItemActive.PurchaseOrderNetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  PurOrdMaintainItemActive.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  PurOrdMaintainItemActive.Customer AS Customer,
  PurOrdMaintainItemActive.ServicePerformer AS ServicePerformer,
  original_servperf.BusinessPartnerName AS ServicePerformerName,
  PurOrdMaintainItemActive.TaxCode AS TaxCode,
  PurOrdMaintainItemActive.TaxJurisdiction AS TaxJurisdiction,
  PurOrdMaintainItemActive.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurOrdMaintainItemActive.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurOrdMaintainItemActive.InvoiceIsExpected AS InvoiceIsExpected,
  PurOrdMaintainItemActive.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurOrdMaintainItemActive.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  PurOrdMaintainItemActive.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  PurOrdMaintainItemActive.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  PurOrdMaintainItemActive.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurOrdMaintainItemActive.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurOrdMaintainItemActive.RefPurOrderInfoRecord AS RefPurOrderInfoRecord,
  PurOrdMaintainItemActive.RefPurchaseOutlineAgreement AS RefPurchaseOutlineAgreement,
  PurOrdMaintainItemActive.RefPurchOutlineAgrmtItem AS RefPurchOutlineAgrmtItem,
  PurOrdMaintainItemActive.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  '' AS PurgDocExternalItemCategory,
  PurOrdMaintainItemActive.AcctAssignmentCategory AS AcctAssignmentCategory,
  PurOrdMaintainItemActive.IsDeleted AS IsDeleted,
  PurOrdMaintainItemActive.ControllingArea AS ControllingArea,
  PurOrdMaintainItemActive.CostCenter AS CostCenter,
  PurOrdMaintainItemActive.ProfitCenter AS ProfitCenter,
  PurOrdMaintainItemActive.WBSElementInternalID AS WBSElementInternalID,
  PurOrdMaintainItemActive.FunctionalArea AS FunctionalArea,
  PurOrdMaintainItemActive.SalesOrder AS SalesOrder,
  PurOrdMaintainItemActive.SalesOrderItem AS SalesOrderItem,
  PurOrdMaintainItemActive.GLAccount AS GLAccount,
  cast( '' as abap.char(40)) AS FreeTextInput,
  PurOrdMaintainItemActive.DeliveryDate AS DeliveryDate,
  PurOrdMaintainItemActive.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  PurOrdMaintainItemActive.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  PurOrdMaintainItemActive.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurOrdMaintainItemActive.DeliveryAddressName AS DeliveryAddressName,
  PurOrdMaintainItemActive.DeliveryAddressStreetName AS DeliveryAddressStreetName,
  PurOrdMaintainItemActive.DeliveryAddressHouseNumber AS DeliveryAddressHouseNumber,
  PurOrdMaintainItemActive.DeliveryAddressPostalCode AS DeliveryAddressPostalCode,
  PurOrdMaintainItemActive.DeliveryAddressCityName AS DeliveryAddressCityName,
  PurOrdMaintainItemActive.DeliveryAddressRegion AS DeliveryAddressRegion,
  PurOrdMaintainItemActive.DeliveryAddressCountry AS DeliveryAddressCountry,
  PurOrdMaintainItemActive.SupplierMaterialNumber AS SupplierMaterialNumber,
  PurOrdMaintainItemActive.IncotermsClassification AS IncotermsClassification,
  PurOrdMaintainItemActive.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurOrdMaintainItemActive.IncotermsVersion AS IncotermsVersion,
  PurOrdMaintainItemActive.IncotermsLocation1 AS IncotermsLocation1,
  PurOrdMaintainItemActive.IncotermsLocation2 AS IncotermsLocation2,
  PurOrdMaintainItemActive.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurOrdMaintainItemActive.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurOrdMaintainItemActive.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurOrdMaintainItemActive.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurOrdMaintainItemActive.TaxCalculationProcedure AS TaxCalculationProcedure,
  PurOrdMaintainItemActive.TaxJurisdictionCalcProcedure AS TaxJurisdictionCalcProcedure,
  PurOrdMaintainItemActive.Currency AS Currency,
  PurOrdMaintainItemActive.PricingProcedure AS PricingProcedure,
  PurOrdMaintainItemActive.PurchasingDocumentType AS PurchasingDocumentType,
  PurOrdMaintainItemActive.PurchasingOrganization AS PurchasingOrganization,
  PurOrdMaintainItemActive.PurchasingGroup AS PurchasingGroup,
  PurOrdMaintainItemActive.Supplier AS Supplier,
  PurOrdMaintainItemActive.EditState AS EditState,
  cast('' as abap.char(1)) AS IsDraft,
  cast('X' as abap.char(1)) AS IsActiveEntity,
  PurOrdMaintainItemActive.HasTwin AS HasTwin,
  PurOrdMaintainItemActive.CreatedByUser AS CreatedByUser,
  PurOrdMaintainItemActive.LastChangeUser AS LastChangeUser,
  PurOrdMaintainItemActive.LastChangeDateTime AS LastChangeDateTime,
  PurOrdMaintainItemDraft.PurchaseOrderItemDraftUUID AS TwinPurchaseOrderItemDraftUUID,
  PurOrdMaintainItemActive.ServicePackage AS ServicePackage,
  PurOrdMaintainItemActive.OverallLimitAmount AS OverallLimitAmount,
  PurOrdMaintainItemActive.OverallLimitAmountIsUnlimited AS OverallLimitAmountIsUnlimited,
  PurOrdMaintainItemActive.ExpectedOverallLimitAmount as ExpectedOverallLimitAmount AS char32asID,
  PurOrdMaintainItemDraft.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount
FROM P_PurOrdMaintainItemActive AS PurOrdMaintainItemActive
LEFT OUTER JOIN I_Plant AS original_plant ON Plant = original_plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS original_servperf ON ServicePerformer = original_servperf.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS original_storagelocation ON Plant = original_storagelocation.Plant AND StorageLocation = original_storagelocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN P_PurOrdMaintainItemDraft AS PurOrdMaintainItemDraft ON PurchaseOrder = PurOrdMaintainItemDraft.PurchaseOrder AND PurchaseOrderItem = PurOrdMaintainItemDraft.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS draft_plant ON Plant = draft_plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS draft_servperf ON ServicePerformer = draft_servperf.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS draft_storagelocation ON Plant = draft_storagelocation.Plant AND StorageLocation = draft_storagelocation.StorageLocation  -- association [0..1]
-- UNION ALL with additional select branch(es): P_PurOrdMaintainItemDraft
;