C_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 C_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.

CREATE VIEW C_CentralPurchaseOrderItemTP AS
SELECT
  PurchaseOrderItemTP.PurchaseOrder AS ProcurementHubPO,
  PurchaseOrderItemTP.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItemTP.ExtSourceSystem AS ExtSourceSystem,
  PurchaseOrderItemTP.ProcmtHubPOItemUniqueID AS ProcmtHubPOItemUniqueID,
  PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItemTP.PurOrdExternalItemCategory AS PurOrdExternalItemCategory,
  _ProcmtHubPurgDocItmCat.ItemCategoryName AS ItemCategoryName,
  PurchaseOrderItemTP.Material AS Material,
  _ProcmtHubProductVH.MaterialName AS MaterialName,
  PurchaseOrderItemTP.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItemTP.MaterialGroup AS MaterialGroup,
  PurchaseOrderItemTP.HasNote AS HasNote,
  PurchaseOrderItemTP.HasAttachment AS HasAttachment,
  PurchaseOrderItemTP.ServicePerformer AS ServicePerformer,
  PurchaseOrderItemTP.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _ProcmtHubProductGroupVH.ProductGroupName AS ProductGroupName,
  PurchaseOrderItemTP.Plant AS Plant,
  _ProcmtHubPlant.ProcmtHubPlantName AS ProcmtHubPlantName,
  PurchaseOrderItemTP.OrderQuantity AS OrderQuantity,
  PurchaseOrderItemTP.NetPriceAmount AS NetPriceAmount,
  PurchaseOrderItemTP.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItemTP.NetAmount AS NetAmount,
  PurchaseOrderItemTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItemTP.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItemTP.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseOrderItemTP.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  PurchaseOrderItemTP.ProductType AS PurgDocProductType,
  PurchaseOrderItemTP.Customer AS Customer,
  PurchaseOrderItemTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  cast (case when PurchasingDocumentDeletionCode = 'L' then 'L' when PurchasingDocumentDeletionCode = 'S' then 'S' else '' end as abap.char(15)) as IsDeleted AS char15asIsDeleted,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrderItemTP.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderItemTP.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseOrderItemTP.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  PurchaseOrderItemTP.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  PurchaseOrderItemTP.StorageLocation AS StorageLocation,
  PurchaseOrderItemTP.IntrastatServiceCode AS IntrastatServiceCode,
  PurchaseOrderItemTP.CommodityCode AS CommodityCode,
  PurchaseOrderItemTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItemTP.IncotermsLocation2 AS IncotermsLocation2,
  _PurOrderDelivAddr.StreetName AS StreetName,
  _PurOrderDelivAddr.HouseNumber AS HouseNumber,
  _PurOrderDelivAddr.PostalCode AS PostalCode,
  _PurOrderDelivAddr.CityName AS CityName,
  _PurOrderDelivAddr.Region AS Region,
  _PurOrderDelivAddr.Country AS Country,
  PurchaseOrderItemTP.PurchaseContract AS PurchaseContract,
  PurchaseOrderItemTP.PurchaseContractItem AS PurchaseContractItem,
  _ProcmtHubAcctAssignmentCat.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  _ProcmtHubTaxCode.TaxCodeName AS TaxCodeName,
  PurchaseOrderItemTP.TaxJurisdiction AS TaxJurisdiction,
  PurchaseOrderItemTP.TaxCalculationProcedure AS TaxCalculationProcedure,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  PurchaseOrderItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseOrderItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItemTP.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseOrderItemTP.ItemVolumeUnit AS ItemVolumeUnit,
  PurchaseOrderItemTP.ItemWeightUnit AS ItemWeightUnit,
  PurchaseOrderItemTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItemTP.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseOrderItemTP.PricingDateControl AS PricingDateControl,
  PurchaseOrderItemTP.IsStatisticalItem AS IsStatisticalItem,
  PurchaseOrderItemTP.IsReturnsItem AS IsReturnsItem,
  PurchaseOrderItemTP.InternationalArticleNumber AS InternationalArticleNumber,
  PurchaseOrderItemTP.PriceIsToBePrinted AS PriceIsToBePrinted,
  PurchaseOrderItemTP.EffectiveAmount AS EffectiveAmount,
  PurchaseOrderItemTP.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseOrderItemTP.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItemTP.BaseUnit AS BaseUnit,
  PurchaseOrderItemTP.RequisitionerName AS RequisitionerName,
  PurchaseOrderItemTP.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  PurchaseOrderItemTP.ConsumptionPosting AS ConsumptionPosting,
  PurchaseOrderItemTP.CompanyCode AS CompanyCode
FROM I_CentralPurchaseOrderItemTP AS PurchaseOrderItemTP
LEFT OUTER JOIN C_CentralPurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.ProcurementHubPO = ProcurementHubPO AND _PurchaseOrderTP.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurOrderScheduleLineTP AS _PurOrdScheduleLineTP ON _PurOrdScheduleLineTP.ProcurementHubPO = ProcurementHubPO AND _PurOrdScheduleLineTP.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdScheduleLineTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurOrderAcctAssgmtTP AS _PurOrdAcctAssignmentTP ON _PurOrdAcctAssignmentTP.ProcurementHubPO = ProcurementHubPO AND _PurOrdAcctAssignmentTP.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdAcctAssignmentTP.ExtSourceSystem = ExtSourceSystem  -- association [0..*]
LEFT OUTER JOIN C_PrmtHbRpldPOSuplrConf AS _PurOrdSupplierConfirmation ON _PurOrdSupplierConfirmation.PurchaseOrder = ProcurementHubPO AND _PurOrdSupplierConfirmation.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdSupplierConfirmation.ExtSourceSystem = ExtSourceSystem  -- association [0..*]
LEFT OUTER JOIN I_SupplierConfControlKey AS _SupplierConfControlKey ON _SupplierConfControlKey.SupplierConfirmationControlKey = SupplierConfirmationControlKey  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurOrderPrcgElementTP AS _CntrlPurOrderPrcgElementTP ON _CntrlPurOrderPrcgElementTP.ProcurementHubPO = ProcurementHubPO AND _CntrlPurOrderPrcgElementTP.PurchaseOrderItem = PurchaseOrderItem AND _CntrlPurOrderPrcgElementTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurOrderDelivAddr AS _PurOrderDelivAddr ON _PurOrderDelivAddr.PurchaseOrder = ProcurementHubPO AND _PurOrderDelivAddr.PurchaseOrderItem = PurchaseOrderItem AND _PurOrderDelivAddr.ExtSourceSystem = ExtSourceSystem AND _PurOrderDelivAddr.ItemDeliveryAddressID = ItemDeliveryAddressID  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlant ON _ProcmtHubPlant.ProcmtHubPlant = Plant AND _ProcmtHubPlant.ProcurementHubSourceSystem = ExtSourceSystem AND _ProcmtHubPlant.ProcmtHubCompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubAcctAssignmentCatVH AS _ProcmtHubAcctAssignmentCat ON _ProcmtHubAcctAssignmentCat.AccountAssignmentCategory = AccountAssignmentCategory AND _ProcmtHubAcctAssignmentCat.ProcurementHubSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgDocItmCatVH AS _ProcmtHubPurgDocItmCat ON _ProcmtHubPurgDocItmCat.ItemCategory = PurchaseOrderItemCategory AND _ProcmtHubPurgDocItmCat.ProcurementHubSourceSystem = ExtSourceSystem AND _ProcmtHubPurgDocItmCat.PurgDocExternalItemCategory = PurOrdExternalItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubTaxCode AS _ProcmtHubTaxCode ON _ProcmtHubTaxCode.TaxCode = TaxCode AND _ProcmtHubTaxCode.TaxCalculationProcedure = TaxCalculationProcedure AND _ProcmtHubTaxCode.ExtSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubProductVH AS _ProcmtHubProductVH ON _ProcmtHubProductVH.ProcmtHubProduct = Material AND _ProcmtHubProductVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubProductGroupVH AS _ProcmtHubProductGroupVH ON _ProcmtHubProductGroupVH.ProcmtHubProductGroup = MaterialGroup AND _ProcmtHubProductGroupVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_PurchaseContractValHelp AS _PurchaseContractValueHelp ON _PurchaseContractValueHelp.PurchaseContract = PurchaseContract  -- association [0..1]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrderItem AS _PrmtHbRpldPurchaseOrderItem ON _PrmtHbRpldPurchaseOrderItem.PurchaseOrder = ProcurementHubPO AND _PrmtHbRpldPurchaseOrderItem.PurchaseOrderItem = PurchaseOrderItem AND _PrmtHbRpldPurchaseOrderItem.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
;