P_PurOrdMaintainItemActive

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_PurOrdMaintainItemActive.
-- 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: PPOMAINTITMACT

CREATE VIEW P_PurOrdMaintainItemActive AS
SELECT
  ekpo.PurchaseOrder AS PurchaseOrder,
  ekpo.PurchaseOrderItem AS PurchaseOrderItem,
  ekpo.PurchaseOrderItemText AS PurchasingDocumentItemText,
  ekpo.Material AS Material,
  ekpo.MaterialType AS MaterialType,
  ekpo.MaterialGroup AS MaterialGroup,
  ekpo.Plant AS Plant,
  ekpo.StorageLocation AS StorageLocation,
  ekpo.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ekpo.OrderQuantity AS PurchaseOrderQty,
  ekpo.NetPriceAmount AS PurchaseOrderNetPriceAmount,
  ekpo.NetAmount AS PurchaseOrderNetAmount,
  '' AS NetPriceIsDerived,
  ekpo.EffectiveAmount AS PurOrderEffectiveItemAmount,
  ekpo.NetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  ekpo.OrderPriceUnit AS PurchaseOrderPriceUnit,
  ekpo.Customer AS Customer,
  ekpo.TaxCode AS TaxCode,
  ekpo.TaxJurisdiction AS TaxJurisdiction,
  ekpo.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  ekpo.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  ekpo.InvoiceIsExpected AS InvoiceIsExpected,
  ekpo.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  ekpo.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  ekpo.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  ekpo.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  ekpo.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  ekpo.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  ekpo.PurchasingInfoRecord AS RefPurOrderInfoRecord,
  ekpo.PurchaseContract AS RefPurchaseOutlineAgreement,
  ekpo.PurchaseContractItem AS RefPurchOutlineAgrmtItem,
  ekpo.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  ekpo.AccountAssignmentCategory AS AcctAssignmentCategory,
  ekpo.PurchasingDocumentDeletionCode AS IsDeleted,
  ekpo.SupplierMaterialNumber AS SupplierMaterialNumber,
  ekpo.IncotermsClassification AS IncotermsClassification,
  ekpo.IncotermsTransferLocation AS IncotermsTransferLocation,
  ekpo.IncotermsLocation1 AS IncotermsLocation1,
  ekpo.IncotermsLocation2 AS IncotermsLocation2,
  ekpo.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  ekpo.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  ekpo.IsCompletelyDelivered AS IsCompletelyDelivered,
  ekpo.IsFinallyInvoiced AS IsFinallyInvoiced,
  ekpo.serviceperformer AS ServicePerformer,
  ekpo.producttype AS ProductType,
  ekpo.ServicePackage AS ServicePackage,
  cast('0' as abap.dec(13,2)) AS OverallLimitAmount,
  cast('' as abap.char(1)) AS OverallLimitAmountIsUnlimited,
  cast('0' as abap.dec(13,2)) AS ExpectedOverallLimitAmount,
  _PurOrdAccountAssignment.CostCenter AS CostCenter,
  _PurOrdAccountAssignment.ControllingArea AS ControllingArea,
  _PurOrdAccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  _PurOrdAccountAssignment.FunctionalArea AS FunctionalArea,
  _PurOrdAccountAssignment.SalesOrder AS SalesOrder,
  _PurOrdAccountAssignment.SalesOrderItem AS SalesOrderItem,
  _PurOrdAccountAssignment.GLAccount AS GLAccount,
  _PurOrdAccountAssignment.ProfitCenter AS ProfitCenter,
  cast( _PurgDocScheduleLine.ScheduleLineDeliveryDate as abap.char(8)) AS DeliveryDate,
  _PurgDocScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _PurgDocScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  item_address.PurchaseOrderItemAddressNumber AS PurchaseOrderItemAddressNumber,
  item_address.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  item_address.DeliveryAddressName AS DeliveryAddressName,
  item_address.DeliveryAddressStreetName AS DeliveryAddressStreetName,
  item_address.DeliveryAddressHouseNumber AS DeliveryAddressHouseNumber,
  item_address.DeliveryAddressPostalCode AS DeliveryAddressPostalCode,
  item_address.DeliveryAddressCityName AS DeliveryAddressCityName,
  item_address.DeliveryAddressRegion AS DeliveryAddressRegion,
  item_address.DeliveryAddressCountry AS DeliveryAddressCountry,
  item_calcproc.TaxCalculationProcedure AS TaxCalculationProcedure,
  item_calcproc.TaxJurisdictionCalcProcedure AS TaxJurisdictionCalcProcedure,
  _PurOrdMaintainHeaderActive.Currency AS Currency,
  _PurOrdMaintainHeaderActive.PricingProcedure AS PricingProcedure,
  _PurOrdMaintainHeaderActive.PurchasingDocumentType AS PurchasingDocumentType,
  _PurOrdMaintainHeaderActive.PurchasingOrganization AS PurchasingOrganization,
  _PurOrdMaintainHeaderActive.PurchasingGroup AS PurchasingGroup,
  _PurOrdMaintainHeaderActive.Supplier AS Supplier,
  _PurOrdMaintainHeaderActive.IncotermsVersion AS IncotermsVersion,
  case when _PurOrdMaintainItemDraft.PurchaseOrderItem is null then cast ('0' as abap.char(1)) else cast ('2' as abap.char(1)) end as EditState AS char1endasEditState,
  case when _PurOrdMaintainItemDraft.PurchaseOrderItem is null then cast('' as abap.char(1)) else cast('X' as abap.char(1)) end as HasTwin AS char1endasHasTwin,
  cast('' as abap.char(12)) AS CreatedByUser,
  cast('' as abap.char(12)) AS LastChangeUser,
  cast('19000101120000' as abap.dec(21,7)) AS LastChangeDateTime
FROM I_PurchaseOrderItem AS ekpo
LEFT OUTER JOIN P_PurOrdMaintainItemActAddr AS item_address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PurOrdMaintainItemActCalcPrc AS item_calcproc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PurOrdMaintainHeaderActive AS _PurOrdMaintainHeaderActive ON ekpo.PurchaseOrder = _PurOrdMaintainHeaderActive.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainPDocAccAssLine AS _PurOrdAccountAssignment ON ekpo.PurchaseOrder = _PurOrdAccountAssignment.PurchasingDocument AND ekpo.PurchaseOrderItem = _PurOrdAccountAssignment.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_PurOrdSingleScheduleLine AS _PurgDocScheduleLine ON ekpo.PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument AND ekpo.PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainItemDraft AS _PurOrdMaintainItemDraft ON ekpo.PurchaseOrder = _PurOrdMaintainItemDraft.PurchaseOrder AND ekpo.PurchaseOrderItem = _PurOrdMaintainItemDraft.PurchaseOrderItem  -- association [0..1]
;