R_SrcgProjItemHierNodeRelation

DDL: R_SRCGPROJITEMHIERNODERELATION SQL: RSPITMHIERRLTN Type: view COMPOSITE
21 Fields 1 Data Sources 2 Associations

Hierarchy Node Relation of Scrg Proj Itm

R_SrcgProjItemHierNodeRelation is a Composite CDS View that provides data about "Hierarchy Node Relation of Scrg Proj Itm" in SAP S/4HANA. It reads from 1 data source (I_SourcingProjectItem) and exposes 21 fields with key fields SourcingProjectUUID, SourcingProjectItemUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SourcingProjectItem I_SourcingProjectItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_SrcgProjItemHierNodeRelation _Parent $projection.SourcingProjectItemParent = _Parent.SourcingProjectItem and $projection.SourcingProjectUUID = _Parent.SourcingProjectUUID
[0..1] R_SourcingProject _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName RSPITMHIERRLTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Hierarchy Node Relation of Scrg Proj Itm view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SourcingProjectItemUUID view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
KEY SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
SourcingProjectItem SourcingProjectItem Item
SourcingProjectItemParent SourcingProjectItemParent Item Parent
AlternativeItemID AlternativeItemID Alternative Item ID
SourcingProjectItemType SourcingProjectItemType Item Type
SrcgProjItemClassification SrcgProjItemClassification Item Classification
SourcingProjectItemStableUUID SourcingProjectItemStableUUID Stable ID
FormattedItemID FormattedItemID Item Number
SrcgProjItemDescription SrcgProjItemDescription Description
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ProductType ProductType Product Type Group
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario
SrcgProjItemDemandConfCode SrcgProjItemDemandConfCode Confirmation Code
_Parent _Parent
_SourcingProject _SourcingProject

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 R_SrcgProjItemHierNodeRelation.
-- 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: RSPITMHIERRLTN

CREATE VIEW R_SrcgProjItemHierNodeRelation AS
SELECT
  SourcingProjectUUID,
  SourcingProjectItemUUID,
  SourcingProjectItem,
  SourcingProjectItemParent,
  AlternativeItemID,
  SourcingProjectItemType,
  SrcgProjItemClassification,
  SourcingProjectItemStableUUID,
  FormattedItemID,
  SrcgProjItemDescription,
  Material,
  MaterialGroup,
  Plant,
  ProductType,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SourcingOrigin,
  SourcingScenario,
  SrcgProjItemDemandConfCode
FROM I_SourcingProjectItem
LEFT OUTER JOIN R_SrcgProjItemHierNodeRelation AS _Parent ON SourcingProjectItemParent = _Parent.SourcingProjectItem AND SourcingProjectUUID = _Parent.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN R_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [0..1]
;

Learn More