C_SrcgProjItemLinkVH

DDL: C_SRCGPROJITEMLINKVH SQL: CSPITEMLINKVH Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Item Linking in Sourcing Project

C_SrcgProjItemLinkVH is a Consumption CDS View that provides data about "Item Linking in Sourcing Project" in SAP S/4HANA. It reads from 1 data source (C_SrcgProjItemLinkItemVH) and exposes 11 fields with key fields SourcingProjectItemUUID, SrcgProjectItemLinkageUUID, SourcingProjectItemStableUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_SrcgProjItemLinkItemVH C_SrcgProjItemLinkItemVH right_outer

Parameters (2)

NameTypeDefault
P_SourcingProjectItemUUID vdm_sourcingprojectitemuuid
P_SourcingProjectUUID vdm_sourcingprojectuuid

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SrcgProjItemDraftHierNode _itemNumber _itemNumber.SourcingProjectUUID = $parameters.P_SourcingProjectUUID and _itemNumber.SourcingProjectItem = _item.SourcingProjectItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSPITEMLINKVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SourcingProjectItemStableUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
Metadata.allowExtensions true view
EndUserText.label Item Linking in Sourcing Project view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectItemUUID _item SourcingProjectItemUUID Item UUID
KEY SrcgProjectItemLinkageUUID _link SrcgProjectItemLinkageUUID Item Linking UUID
KEY SourcingProjectItemStableUUID _item SourcingProjectItemStableUUID Stable ID
SrcgProjItemLinkedStableUUID _link SrcgProjItemLinkedStableUUID Stable UUID of Linked Item
SourcingProjectUUID _item SourcingProjectUUID Sourcing Project UUID
SourcingProjectItem _item SourcingProjectItem Item
FormattedItemID
SrcgProjItemDescription _item SrcgProjItemDescription Description
Material _item Material Vehicle Model
MaterialGroup _item MaterialGroup Product Group
SrcgProjItemHierarchyRank

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_SrcgProjItemLinkVH.
-- 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: CSPITEMLINKVH
-- Parameters: P_SourcingProjectItemUUID : vdm_sourcingprojectitemuuid, P_SourcingProjectUUID : vdm_sourcingprojectuuid

CREATE VIEW C_SrcgProjItemLinkVH AS
SELECT
  _item.SourcingProjectItemUUID AS SourcingProjectItemUUID,
  _link.SrcgProjectItemLinkageUUID AS SrcgProjectItemLinkageUUID,
  _item.SourcingProjectItemStableUUID AS SourcingProjectItemStableUUID,
  _link.SrcgProjItemLinkedStableUUID AS SrcgProjItemLinkedStableUUID,
  _item.SourcingProjectUUID AS SourcingProjectUUID,
  _item.SourcingProjectItem AS SourcingProjectItem,
  _itemNumber(P_SourcingProjectUUID:$parameters.P_SourcingProjectUUID).FormattedItemID AS FormattedItemID,
  _item.SrcgProjItemDescription AS SrcgProjItemDescription,
  _item.Material AS Material,
  _item.MaterialGroup AS MaterialGroup,
  _itemNumber(P_SourcingProjectUUID:$parameters.P_SourcingProjectUUID).SrcgProjItemHierarchyRank AS SrcgProjItemHierarchyRank
RIGHT OUTER JOIN C_SrcgProjItemLinkItemVH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SrcgProjItemDraftHierNode AS _itemNumber ON _itemNumber.SourcingProjectUUID = $parameters.P_SourcingProjectUUID AND _itemNumber.SourcingProjectItem = _item.SourcingProjectItem  -- association [1..1]
;

Learn More