I_PrmtHbRpldPurOrderItmEnhcd

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_PrmtHbRpldPurOrderItmEnhcd.
-- 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: IREPPOITMENH

CREATE VIEW I_PrmtHbRpldPurOrderItmEnhcd AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  cast (Document.PurchaseOrderItem as ebelp preserving type) AS PurchaseOrderItem,
  Document.ExtSourceSystem AS ExtSourceSystem,
  Document.ProcmtHubPOItemUniqueID AS ProcmtHubPOItemUniqueID,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  Document.ProductType AS ProductTypeCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.Material AS Material,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  Document.MaterialGroup AS MaterialGroup,
  Document.Plant AS Plant,
  Document.PurchaseOrderItemText AS PurchaseOrderItemText,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.IsReturnsItem AS IsReturnsItem,
  Document.IsStatisticalItem AS IsStatisticalItem,
  Document.IsCompletelyDelivered AS IsCompletelyDelivered,
  Document.IsFinallyInvoiced AS IsFinallyInvoiced,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  Document.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  Document.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  Document.PricingDateControl AS PricingDateControl,
  Document.RequisitionerName AS RequisitionerName,
  Document.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  Document.ConsumptionPosting AS ConsumptionPosting,
  Document.ServicePerformer AS ServicePerformer,
  Document.ServicePackage AS ServicePackage,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.ProfitCenter AS ProfitCenter,
  Document.StorageLocation AS StorageLocation,
  Document.OrderQuantity AS OrderQuantity,
  Document.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.InternationalArticleNumber AS InternationalArticleNumber,
  Document.IntrastatServiceCode AS IntrastatServiceCode,
  Document.CommodityCode AS CommodityCode,
  Document.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  Document.PriceIsToBePrinted AS PriceIsToBePrinted,
  Document.TaxCode AS TaxCode,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TaxCalculationProcedure AS TaxCalculationProcedure,
  Document.ArticleCategory AS ArticleCategory,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Document.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Document.ItemVolumeUnit AS ItemVolumeUnit,
  Document.ItemWeightUnit AS ItemWeightUnit,
  Document.BaseUnit AS BaseUnit,
  Document.NetAmount AS NetAmount,
  Document.EffectiveAmount AS EffectiveAmount,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  Document.Customer AS Customer,
  Document.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  Document.OverallLimitAmount AS OverallLimitAmount,
  Document.PurchaseOrderItemStatus AS PrmtHbRefPurchaseOrderStatus,
  Document.HasNote AS HasNote,
  Document.HasAttachment AS HasAttachment,
  Document.ShippingInstruction AS ShippingInstruction,
  cast (_PurOrdSingleScheduleLine.ScheduleLineDeliveryDate as eindt) AS FirstDeliveryDate,
  cast (_PurOrdSingleScheduleLine.PerformancePeriodStartDate as mmpur_servproc_period_start) AS PerformancePeriodStartDate,
  cast (_PurOrdSingleScheduleLine.PerformancePeriodEndDate as mmpur_servproc_period_end) AS PerformancePeriodEndDate,
  _PurOrdSingleScheduleLine.DelivDateCategory AS DelivDateCategory,
  _PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  Document.ItemDeliveryAddressID AS ItemDeliveryAddressID
FROM I_CentralPurchaseOrderItem AS Document
LEFT OUTER JOIN I_PrmtHbRpldPurOrderEnhcd AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder AND ExtSourceSystem = _PurchaseOrder.ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurOrderAcctAssgmt AS _PurOrdAcctAssignment ON _PurOrdAcctAssignment.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignment.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdAcctAssignment.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurOrderScheduleLine AS _PurOrdScheduleLine ON _PurOrdScheduleLine.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLine.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdScheduleLine.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN P_PrmtHbPOSingleScheduleLine AS _PurOrdSingleScheduleLine ON PurchaseOrder = _PurOrdSingleScheduleLine.PurchaseOrder AND PurchaseOrderItem = _PurOrdSingleScheduleLine.PurchaseOrderItem AND ExtSourceSystem = _PurOrdSingleScheduleLine.ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrderItem AS _ItemExtension ON PurchaseOrder = _ItemExtension.PurchaseOrder AND PurchaseOrderItem = _ItemExtension.PurchaseOrderItem AND ExtSourceSystem = _ItemExtension.ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON PurchaseOrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON ItemVolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON ItemWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurgDocumentCategory ON PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON ProductTypeCode = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ArticleCategory = _ProductCategory.ProductCategory  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
;