R_PurOrderHierNodeRltn

@AbapCatalog.sqlViewName: 'RPURORDHIERRLN'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Source view for the parent child relationship PO hierarchies'

define view R_PurOrderHierNodeRltn
  as select from R_PurchaseOrderItem
  association [1..1] to R_PurchaseOrder             as _PurchaseOrder on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

  association [0..1] to R_PurOrderHierNodeRltn as _Parent        on  $projection.PurchasingParentItem = _Parent.PurchaseOrderItem
                                                                      and $projection.PurchaseOrder        = _Parent.PurchaseOrder

{
      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchaseOrder,
  key PurchaseOrderItem,
      R_PurchaseOrderItem.PurchaseOrderItemUniqueID,
      R_PurchaseOrderItem.PurchaseOrderCategory,
      R_PurchaseOrderItem.DocumentCurrency,
      R_PurchaseOrderItem.PurchasingDocumentDeletionCode,
      R_PurchaseOrderItem.MaterialGroup,
      R_PurchaseOrderItem.MaterialGroup as MaterialGroupName,
      R_PurchaseOrderItem.Material,
      R_PurchaseOrderItem.MaterialType,
      R_PurchaseOrderItem.SupplierMaterialNumber,
      R_PurchaseOrderItem.SupplierSubrange,
      R_PurchaseOrderItem.ManufacturerPartNmbr,
      R_PurchaseOrderItem.Manufacturer,
      R_PurchaseOrderItem.ManufacturerMaterial,
      R_PurchaseOrderItem.PurchaseOrderItemText,
      R_PurchaseOrderItem.CompanyCode,
      R_PurchaseOrderItem.Plant,
      R_PurchaseOrderItem.ManualDeliveryAddressID,
      R_PurchaseOrderItem.ReferenceDeliveryAddressID,
      R_PurchaseOrderItem.Customer,
      R_PurchaseOrderItem.Subcontractor,
      R_PurchaseOrderItem.SupplierIsSubcontractor,
      R_PurchaseOrderItem.CrossPlantConfigurableProduct,
      R_PurchaseOrderItem.ArticleCategory,
      R_PurchaseOrderItem.PlndOrderReplnmtElmntType,
      R_PurchaseOrderItem.ProductPurchasePointsQtyUnit,
      R_PurchaseOrderItem.ProductPurchasePointsQty,
      R_PurchaseOrderItem.StorageLocation,
      R_PurchaseOrderItem.PurchaseOrderQuantityUnit,
      R_PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr,
      R_PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr,
      R_PurchaseOrderItem.NetPriceQuantity,
      R_PurchaseOrderItem.IsCompletelyDelivered,
      R_PurchaseOrderItem.IsFinallyInvoiced,
      R_PurchaseOrderItem.GoodsReceiptIsExpected,
      R_PurchaseOrderItem.InvoiceIsExpected,
      R_PurchaseOrderItem.IsOrderAcknRqd,
      R_PurchaseOrderItem.InvoiceIsGoodsReceiptBased,
      R_PurchaseOrderItem.PurchaseContractItem,
      R_PurchaseOrderItem.PurchaseContract,
      R_PurchaseOrderItem.PurchaseRequisition,
      R_PurchaseOrderItem.RequirementTracking,
      R_PurchaseOrderItem.PurchaseRequisitionItem,
      R_PurchaseOrderItem.RequestForQuotation,
      R_PurchaseOrderItem.RequestForQuotationItem,
      R_PurchaseOrderItem.SupplierQuotation,
      R_PurchaseOrderItem.SupplierQuotationItem,
      R_PurchaseOrderItem.EvaldRcptSettlmtIsAllowed,
      R_PurchaseOrderItem.UnlimitedOverdeliveryIsAllowed,
      R_PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct,
      R_PurchaseOrderItem.UnderdelivTolrtdLmtRatioInPct,
      R_PurchaseOrderItem.RequisitionerName,
      R_PurchaseOrderItem.PlannedDeliveryDurationInDays,
      R_PurchaseOrderItem.GoodsReceiptDurationInDays,
      R_PurchaseOrderItem.PartialDeliveryIsAllowed,
      R_PurchaseOrderItem.ConsumptionPosting,
      R_PurchaseOrderItem.ServicePerformer,
      R_PurchaseOrderItem.ServicePackage,
      R_PurchaseOrderItem.BaseUnit,
      R_PurchaseOrderItem.PurchaseOrderItemCategory,
      R_PurchaseOrderItem.ProfitCenter,
      R_PurchaseOrderItem.OrderPriceUnit,
      R_PurchaseOrderItem.ItemVolumeUnit,
      R_PurchaseOrderItem.ItemWeightUnit,
      R_PurchaseOrderItem.MultipleAcctAssgmtDistribution,
      R_PurchaseOrderItem.PartialInvoiceDistribution,
      R_PurchaseOrderItem.PricingDateControl,
      R_PurchaseOrderItem.IsStatisticalItem,
      R_PurchaseOrderItem.PurchasingParentItem,
      R_PurchaseOrderItem.GoodsReceiptLatestCreationDate,
      R_PurchaseOrderItem.IsReturnsItem,
      R_PurchaseOrderItem.PurchasingOrderReason,
      R_PurchaseOrderItem.IncotermsClassification,
      R_PurchaseOrderItem.IncotermsTransferLocation,
      R_PurchaseOrderItem.IncotermsLocation1,
      R_PurchaseOrderItem.IncotermsLocation2,
      R_PurchaseOrderItem.PriorSupplier,
      R_PurchaseOrderItem.InternationalArticleNumber,
      R_PurchaseOrderItem.IntrastatServiceCode,
      R_PurchaseOrderItem.CommodityCode,
      R_PurchaseOrderItem.MaterialFreightGroup,
      R_PurchaseOrderItem.DiscountInKindEligibility,
      R_PurchaseOrderItem.PurgItemIsBlockedForDelivery,
      R_PurchaseOrderItem.PurgDocOrderAcknNumber,
      R_PurchaseOrderItem.PriceIsToBePrinted,
      R_PurchaseOrderItem.AccountAssignmentCategory,
      R_PurchaseOrderItem.AccountAssignmentCategory as AcctAssignmentCategoryName,
      R_PurchaseOrderItem.PurchasingInfoRecord,
      R_PurchaseOrderItem.NetAmount,
      R_PurchaseOrderItem.GrossAmount,
      R_PurchaseOrderItem.EffectiveAmount,
      R_PurchaseOrderItem.Subtotal1Amount,
      R_PurchaseOrderItem.Subtotal2Amount,
      R_PurchaseOrderItem.Subtotal3Amount,
      R_PurchaseOrderItem.Subtotal4Amount,
      R_PurchaseOrderItem.Subtotal5Amount,
      R_PurchaseOrderItem.Subtotal6Amount,
      R_PurchaseOrderItem.OrderQuantity,
      R_PurchaseOrderItem.NetPriceAmount,
      R_PurchaseOrderItem.ItemVolume,
      R_PurchaseOrderItem.ItemGrossWeight,
      R_PurchaseOrderItem.ItemNetWeight,
      R_PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr,
      R_PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr,
      R_PurchaseOrderItem.GoodsReceiptIsNonValuated,
      R_PurchaseOrderItem.TaxCode,
      R_PurchaseOrderItem.TaxJurisdiction,
      R_PurchaseOrderItem.TaxCodeValidFromDate,
      R_PurchaseOrderItem.TaxCountry,
      R_PurchaseOrderItem.TaxDeterminationDate,
      R_PurchaseOrderItem.ShippingInstruction,
      R_PurchaseOrderItem.NonDeductibleInputTaxAmount,
      R_PurchaseOrderItem.StockType,
      R_PurchaseOrderItem.ValuationType,
      R_PurchaseOrderItem.ValuationCategory,
      R_PurchaseOrderItem.ItemIsRejectedBySupplier,
      R_PurchaseOrderItem.PurgDocPriceDate,
      R_PurchaseOrderItem.PurchasingInfoRecordUpdateCode,
      R_PurchaseOrderItem.PurgDocReleaseOrderQuantity,
      R_PurchaseOrderItem.InventorySpecialStockType,
      R_PurchaseOrderItem.DeliveryDocumentType,
      R_PurchaseOrderItem.IssuingStorageLocation,
      R_PurchaseOrderItem.AllocationTable,
      R_PurchaseOrderItem.AllocationTableItem,
      R_PurchaseOrderItem.RetailPromotion,
      R_PurchaseOrderItem.PurgConfigurableItemNumber,
      R_PurchaseOrderItem.PurgDocAggrgdSubitemCategory,
      R_PurchaseOrderItem.PurgDocSubitemCategory,
      R_PurchaseOrderItem.PurgExternalSortNumber,
      R_PurchaseOrderItem.DownPaymentType,
      R_PurchaseOrderItem.DownPaymentPercentageOfTotAmt,
      R_PurchaseOrderItem.DownPaymentAmount,
      R_PurchaseOrderItem.DownPaymentDueDate,
      R_PurchaseOrderItem.ExpectedOverallLimitAmount,
      R_PurchaseOrderItem.OverallLimitAmount,
      R_PurchaseOrderItem.PurContractForOverallLimit,
      R_PurchaseOrderItem.PurgProdCmplncSupplierStatus,
      R_PurchaseOrderItem.PurgProductMarketabilityStatus,
      R_PurchaseOrderItem.PurgSafetyDataSheetStatus,
      R_PurchaseOrderItem.PurgProdCmplncDngrsGoodsStatus,
      R_PurchaseOrderItem.RequirementSegment,
      R_PurchaseOrderItem.Fund,
      R_PurchaseOrderItem.BudgetPeriod,
      R_PurchaseOrderItem.FundsCenter,
      R_PurchaseOrderItem.CommitmentItemShortID,
      R_PurchaseOrderItem.FunctionalArea,
      R_PurchaseOrderItem.GrantID,
      R_PurchaseOrderItem.EarmarkedFundsDocument,
      R_PurchaseOrderItem.EarmarkedFundsDocumentItem,
      R_PurchaseOrderItem.CostCenter,
      R_PurchaseOrderItem.GLAccount,
//      R_PurchaseOrderItem.WBSElementInternalID,

      R_PurchaseOrderItem.BR_MaterialOrigin,
      R_PurchaseOrderItem.BR_MaterialUsage,
      R_PurchaseOrderItem.BR_CFOPCategory,
      R_PurchaseOrderItem.BR_NCM,
      R_PurchaseOrderItem.ConsumptionTaxCtrlCode,
      R_PurchaseOrderItem.BR_IsProducedInHouse,
      R_PurchaseOrderItem.ProductSeasonYear,
      R_PurchaseOrderItem.ProductSeason,
      R_PurchaseOrderItem.ProductCollection,
      R_PurchaseOrderItem.ProductTheme,
      R_PurchaseOrderItem.SeasonCompletenessStatus,
      R_PurchaseOrderItem.ShippingGroupRule,
      R_PurchaseOrderItem.ShippingGroupNumber,
      R_PurchaseOrderItem.ProductCharacteristic1,
      R_PurchaseOrderItem.ProductCharacteristic2,
      R_PurchaseOrderItem.ProductCharacteristic3,
      R_PurchaseOrderItem.DiversionStatus,
      R_PurchaseOrderItem.RefDocNmbrForTrcblyInPO,
      R_PurchaseOrderItem.ReferenceDocumentItem,
      R_PurchaseOrderItem.PurchaseOrderReferenceType,
      R_PurchaseOrderItem.ItemHasValueAddedService,
      R_PurchaseOrderItem.ValAddedSrvcParentItmNumber,
      R_PurchaseOrderItem.StockSegment,
      _PurchaseOrder.Supplier,
      _PurchaseOrder,
      _Parent
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASEORDER",
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"R_PURCHASEORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/