I_CentralPurchaseOrderItemTP

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_CentralPurchaseOrderItemTP.
-- 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: ICPURORDITMTP

CREATE VIEW I_CentralPurchaseOrderItemTP 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,
  _PurgDocumentItemCategoryText.PurgDocExternalItemCategory AS PurOrdExternalItemCategory,
  _PurgDocumentItemCategoryText.ItemCategoryName AS PurOrdItemCategoryName,
  Document.ProductType AS ProductType,
  _ProductTypeCodeText.Name AS ProductTypeName,
  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.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.DocumentCurrency AS DocumentCurrency,
  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.PurContractForOverallLimit AS PurContractForOverallLimit,
  Document.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  Document.PurchaseOrderItemStatus AS PurchaseOrderItemStatus,
  Document.HasNote AS HasNote,
  Document.HasAttachment AS HasAttachment,
  Document.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _PurchaseOrderTP.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderTP.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderTP.PurchaseOrderType AS PurchaseOrderType
FROM I_CentralPurchaseOrderItem AS Document
LEFT OUTER JOIN I_CentralPurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderTP.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurOrderPrcgElementTP AS _CntrlPurOrderPrcgElementTP ON _CntrlPurOrderPrcgElementTP.PurchaseOrder = PurchaseOrder AND _CntrlPurOrderPrcgElementTP.PurchaseOrderItem = PurchaseOrderItem AND _CntrlPurOrderPrcgElementTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurOrderAcctAssgmtTP AS _PurOrdAcctAssignmentTP ON _PurOrdAcctAssignmentTP.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignmentTP.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdAcctAssignmentTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurOrderScheduleLineTP AS _PurOrdScheduleLineTP ON _PurOrdScheduleLineTP.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLineTP.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdScheduleLineTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_ProcmtHubPurgDocItmCat AS _PurgDocumentItemCategoryText ON _PurgDocumentItemCategoryText.ProcurementHubSourceSystem = ExtSourceSystem AND _PurgDocumentItemCategoryText.ItemCategory = PurchaseOrderItemCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON _ProductTypeCodeText.ProductTypeCode = ProductType AND _ProductTypeCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CntrlPurOrderDelivAddr AS _PurOrderDelivAddr ON _PurOrderDelivAddr.PurchaseOrder = PurchaseOrder AND _PurOrderDelivAddr.PurchaseOrderItem = PurchaseOrderItem AND _PurOrderDelivAddr.ExtSourceSystem = ExtSourceSystem AND _PurOrderDelivAddr.ItemDeliveryAddressID = ItemDeliveryAddressID  -- association [0..1]
;