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
  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.ProductType AS ProductType,
  PurchaseOrderItemTP.ProductTypeName AS ProductTypeName,
  PurchaseOrderItemTP.SupplierMaterialNumber AS SupplierMaterialNumber,
  PurchaseOrderItemTP.MaterialRevisionLevel AS MaterialRevisionLevel,
  PurchaseOrderItemTP.Customer AS Customer,
  PurchaseOrderItemUniqueID,
  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,
  cast ( '' as abap.char(2)) AS PurchaseOrderItemStatus,
  cast ( '' as abap.sstring(260)) AS PurchaseOrderItemStatusName,
  PurchaseOrderItemTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemTP.OrderPriceUnit AS OrderPriceUnit,
  cast (PurchaseOrderItemTP.PurchaseOrderQuantityUnit as bstme_ll preserving type) AS PurchaseOrderQuantityUnit,
  PurchaseOrderItemTP.SupplierIsSubcontractor AS SupplierIsSubcontractor,
  cast(PurchaseOrderItemTP.GoodsReceiptIsNonValuated as weunb_ll preserving type) AS GoodsReceiptIsNonValuated,
  PurchaseOrderItemTP.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  cast (PurchaseOrderItemTP.InvoiceIsExpected as repos_ll preserving type) AS InvoiceIsExpected,
  cast(PurchaseOrderItemTP.InvoiceIsGoodsReceiptBased as webre_ll preserving type) AS InvoiceIsGoodsReceiptBased,
  PurchaseOrderItemTP.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItemTP.IsFinallyInvoiced AS IsFinallyInvoiced,
  cast (PurchaseOrderItemTP.UnderdelivTolrtdLmtRatioInPct as untto_ll preserving type) AS UnderdelivTolrtdLmtRatioInPct,
  cast (PurchaseOrderItemTP.UnlimitedOverdeliveryIsAllowed as uebtk preserving type) AS UnlimitedOverdeliveryIsAllowed,
  PurchaseOrderItemTP.StorageLocation AS StorageLocation,
  cast (PurchaseOrderItemTP.IntrastatServiceCode as mm_isvco_ll preserving type) AS IntrastatServiceCode,
  PurchaseOrderItemTP.CommodityCode AS CommodityCode,
  PurchaseOrderItemTP.InventoryUsabilityCode AS InventoryUsabilityCode,
  PurchaseOrderItemTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderItemTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItemTP.IncotermsLocation2 AS IncotermsLocation2,
  cast (PurchaseOrderItemTP.PurchaseContract as konnr_ll preserving type) AS PurchaseContract,
  PurchaseOrderItemTP.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseOrderItemTP.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  cast (PurchaseOrderItemTP.PurchaseContractItem as ktpnr_ll preserving type) AS PurchaseContractItem,
  PurchaseOrderItemTP.InfoRecordIsToBeUpdated AS InfoRecordIsToBeUpdated,
  _AccountAssignmentCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  PurchaseOrderItemTP.GLAccount AS GLAccount,
  PurchaseOrderItemTP.WBSDescription AS WBSDescription,
  PurchaseOrderItemTP.Fund AS Fund,
  PurchaseOrderItemTP.BudgetPeriod AS BudgetPeriod,
  PurchaseOrderItemTP.FundsCenter AS FundsCenter,
  cast ( EarmarkedFundsDocument as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( EarmarkedFundsDocumentItem as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  PurchaseOrderItemTP.FunctionalArea AS FunctionalArea,
  PurchaseOrderItemTP.GrantID AS GrantID,
  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,
  PurchaseOrderItemTP.BR_NCM AS BR_NCM,
  cast (PurchaseOrderItemTP.BR_IsProducedInHouse as logbr_ownpro preserving type) AS BR_IsProducedInHouse,
  PurchaseOrderItemTP.IN_GSTControlCode AS IN_GSTControlCode,
  cast(IsOrderAcknRqd as kzabs_ll preserving type ) AS IsOrderAcknRqd,
  ItemIsRejectedBySupplier,
  PFMTransDataFootprintUUID,
  _PurOrdItemCO2eqFootprint.PFMFootprintQuantity AS PFMFootprintQuantity,
  _PurOrdItemCO2eqFootprint.PFMFootprintUnit AS PFMFootprintUnit,
  _Plant._Address._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  _PurOrdDeliveryAddressTP.Country AS Country,
  _PurOrdDeliveryAddressTP.CountryName AS CountryName,
  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,
  _PurOrdDeliveryAddressTP.RegionName AS RegionName,
  _PurOrdDeliveryAddressTP.PostalCode AS PostalCode,
  _PurOrdDeliveryAddressTP.CityName AS CityName,
  _PurchaseOrderTP.Supplier AS Supplier,
  PurchaseOrderItemTP._OrderPriceUnit AS _OrderPriceUnit,
  PurchaseOrderItemTP._OrderQuantityUnit AS _OrderQuantityUnit,
  PurchaseOrderItemTP._IncotermsVersion AS _IncotermsVersion
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_PurOrdAcctAssignmentTP AS _PurOrdAcctAssignmentTP ON _PurOrdAcctAssignmentTP.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignmentTP.PurchaseOrderItem = PurchaseOrderItem  -- association [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]
LEFT OUTER JOIN C_MM_RevisionLvlValueHelp AS _RevisionLvlVH ON Material = _RevisionLvlVH.ObjectType AND MaterialRevisionLevel = _RevisionLvlVH.MaterialRevisionLevel  -- association [0..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SubcontractorVH ON Subcontractor = _SubcontractorVH.Supplier  -- association [0..*]
LEFT OUTER JOIN I_InventoryUsabilityCode AS _StockTypeVH ON InventoryUsabilityCode = _StockTypeVH.InventoryUsabilityCode  -- association [0..1]
;