C_PurchaseOrderItemHierarchyTP

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_PurchaseOrderItemHierarchyTP.
-- 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_PurchaseOrderItemHierarchyTP AS
SELECT
  PurchaseOrderItemUniqueID,
  cast ( '' as abap.char(2)) AS PurchaseOrderItemStatus,
  cast ( '' as abap.sstring(260)) AS PurchaseOrderItemStatusName,
  cast (PurchaseOrderItemTP.PurchaseOrderQuantityUnit as bstme_ll preserving type) AS PurchaseOrderQuantityUnit,
  cast(PurchaseOrderItemTP.GoodsReceiptIsNonValuated as weunb_ll preserving type) AS GoodsReceiptIsNonValuated,
  cast (PurchaseOrderItemTP.InvoiceIsExpected as repos_ll preserving type) AS InvoiceIsExpected,
  cast(PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased as webre_ll preserving type) AS InvoiceIsGoodsReceiptBased,
  cast (PurchaseOrderItemTP.UnderdelivTolrtdLmtRatioInPct as untto_ll preserving type) AS UnderdelivTolrtdLmtRatioInPct,
  cast (PurchaseOrderItemTP.UnlimitedOverdeliveryIsAllowed as uebtk preserving type) AS UnlimitedOverdeliveryIsAllowed,
  cast (PurchaseOrderItemTP.IntrastatServiceCode as mm_isvco_ll preserving type) AS IntrastatServiceCode,
  cast (PurchaseOrderItemTP.PurchaseContract as konnr_ll preserving type) AS PurchaseContract,
  cast (PurchaseOrderItemTP.PurchaseContractItem as ktpnr_ll preserving type) AS PurchaseContractItem,
  cast ( EarmarkedFundsDocument as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( EarmarkedFundsDocumentItem as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  TaxJurisdiction,
  TaxCountry,
  TaxDeterminationDate,
  cast (PurchaseOrderItemTP.BR_MaterialOrigin as logbr_matorg preserving type) AS BR_MaterialOrigin,
  cast (PurchaseOrderItemTP.BR_MaterialUsage as logbr_matuse preserving type) AS BR_MaterialUsage,
  cast (PurchaseOrderItemTP.BR_CFOPCategory as logbr_cfopcategory preserving type) AS BR_CFOPCategory,
  cast (PurchaseOrderItemTP.BR_IsProducedInHouse as logbr_ownpro preserving type) AS BR_IsProducedInHouse,
  cast(IsOrderAcknRqd as kzabs_ll preserving type ) AS IsOrderAcknRqd,
  ItemIsRejectedBySupplier,
  _Plant._Address._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  PurchaseOrderItemTP.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItemTP.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItemTP.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  PurchaseOrderItemTP.PurOrdExternalItemCategory AS PurOrdExternalItemCategory,
  PurchaseOrderItemTP.PurchasingIsItemSet AS PurchasingIsItemSet,
  PurchaseOrderItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseOrderItemTP.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItemTP.MaterialGroup AS MaterialGroup,
  PurchaseOrderItemTP.Plant AS Plant,
  PurchaseOrderItemTP.OrderQuantity AS OrderQuantity,
  PurchaseOrderItemTP.NetPriceAmount AS NetPriceAmount,
  PurchaseOrderItemTP.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItemTP.ServicePerformer AS ServicePerformer,
  PurchaseOrderItemTP.ProductTypeName AS ProductTypeName,
  PurchaseOrderItemTP.Customer AS Customer,
  PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItemTP.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  PurchaseOrderItemTP.PurchasingParentItem AS PurchasingParentItem,
  PurchaseOrderItemTP.PurgDocSubitemCategory AS PurgDocSubitemCategory,
  PurchaseOrderItemTP.IsStatisticalItem AS IsStatisticalItem,
  PurchaseOrderItemTP.PurgExternalSortNumber AS PurgExternalSortNumber,
  PurchaseOrderItemTP.PurOrdItemCategoryName AS PurOrdItemCategoryName,
  PurchaseOrderItemTP.Material AS Material,
  PurchaseOrderItemTP.PurchasingHierarchyNode AS PurchasingHierarchyNode,
  PurchaseOrderItemTP.HierarchyParentNode AS HierarchyParentNode,
  PurchaseOrderItemTP.HierarchyLevel AS HierarchyLevel,
  PurchaseOrderItemTP.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  PurchaseOrderItemTP.HierarchyDrillState AS HierarchyDrillState,
  PurchaseOrderItemTP.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  PurchaseOrderItemTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItemTP.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItemTP.NetAmount AS NetAmount,
  PurchaseOrderItemTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderItemTP.PurchaseOrderItemStatus AS PurchaseOrderItemStatus_H,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrderItemTP.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchaseOrderItemTP.StorageLocation AS StorageLocation,
  PurchaseOrderItemTP.CommodityCode AS CommodityCode,
  PurchaseOrderItemTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderItemTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItemTP.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrderItemTP.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseOrderItemTP.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  PurchaseOrderItemTP.InfoRecordIsToBeUpdated AS InfoRecordIsToBeUpdated,
  PurchaseOrderItemTP.GLAccount AS GLAccount,
  PurchaseOrderItemTP.WBSDescription AS WBSDescription,
  PurchaseOrderItemTP.Fund AS Fund,
  PurchaseOrderItemTP.BudgetPeriod AS BudgetPeriod,
  PurchaseOrderItemTP.FundsCenter AS FundsCenter,
  PurchaseOrderItemTP.FunctionalArea AS FunctionalArea,
  PurchaseOrderItemTP.GrantID AS GrantID,
  PurchaseOrderItemTP.BR_NCM AS BR_NCM,
  PurchaseOrderItemTP.IN_GSTControlCode AS IN_GSTControlCode,
  PurchaseOrderItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseOrderItemTP.CompanyCode AS CompanyCode,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurchaseOrderItemTP.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItemTP.ItemVolumeUnit AS ItemVolumeUnit,
  PurchaseOrderItemTP.ItemWeightUnit AS ItemWeightUnit,
  PurchaseOrderItemTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItemTP.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseOrderItemTP.PricingDateControl AS PricingDateControl,
  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.HighestMessageSeverityLevel AS HighestMessageSeverityLevel,
  PurchaseOrderItemTP._OrderPriceUnit AS _OrderPriceUnit,
  PurchaseOrderItemTP._OrderQuantityUnit AS _OrderQuantityUnit,
  PurchaseOrderItemTP._IncotermsVersion AS _IncotermsVersion,
  _AccountAssignmentCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  _PurchaseOrderTP.Supplier AS Supplier,
  _PurOrdDeliveryAddressTP.Country AS Country,
  _PurOrdDeliveryAddressTP.CountryName AS CountryName,
  _PurOrdDeliveryAddressTP.RegionName AS RegionName,
  _PurOrdDeliveryAddressTP.PostalCode AS PostalCode,
  _PurOrdDeliveryAddressTP.CityName AS CityName
FROM I_PurchaseOrderItemTP AS PurchaseOrderItemTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemSet AS _PurchaseOrderItemSetTP ON _PurchaseOrderItemSetTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemSetTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_TaxJurisdictionVH AS _TaxJurisdiction ON _TaxJurisdiction.TaxJurisdiction = TaxJurisdiction  -- association [0..1]
LEFT OUTER JOIN C_MM_ServicePerformerValueHelp AS _MM_ServicePerformerValueHelp ON _MM_ServicePerformerValueHelp.ServicePerformer = ServicePerformer AND _MM_ServicePerformerValueHelp.Supplier = supplier  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = ManufacturerMaterial AND _MaterialValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_PurOrdPricingElementTP AS _PurOrdPricingElementTP ON _PurOrdPricingElementTP.PurchaseOrder = PurchaseOrder AND _PurOrdPricingElementTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_PurOrdActACatValHelp AS _PurOrdActACatValHelp ON _PurOrdActACatValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccountAssignmentCategory ON _AccountAssignmentCategory.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_PurOrdDeliveryAddressTP AS _PurOrdDeliveryAddressTP ON _PurOrdDeliveryAddressTP.PurchaseOrder = PurchaseOrder AND _PurOrdDeliveryAddressTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PurOrdScheduleLineTP AS _PurOrdScheduleLineTP ON _PurOrdScheduleLineTP.PurchaseOrder = PurchaseOrder  -- association [1..*]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant AND _PlantValueHelp.PurchasingOrganization = purchasingorganization  -- association [0..1]
LEFT OUTER JOIN C_PurOrdItemCO2eqFootprint AS _PurOrdItemCO2eqFootprint ON _PurOrdItemCO2eqFootprint.PurchaseOrder = PurchaseOrder AND _PurOrdItemCO2eqFootprint.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
;