C_SrcgProjItemLinkageDocVarbl

DDL: C_SRCGPROJITEMLINKAGEDOCVARBL SQL: CSPITEMLINKVB Type: view CONSUMPTION Package: APPL_MM_PUR_SRCGPROJ_AI
6 Fields 1 Data Sources 2 Associations

Doc Varbl for Item Linking in Srcg Proj

C_SrcgProjItemLinkageDocVarbl is a Consumption CDS View that provides data about "Doc Varbl for Item Linking in Srcg Proj" in SAP S/4HANA. It reads from 1 data source (I_SourcingProjectItemLinkage) and exposes 6 fields with key field SrcgProjectItemLinkageUUID. It has 2 associations to related views. Part of development package APPL_MM_PUR_SRCGPROJ_AI.

Data Sources (1)

SourceAliasJoin Type
I_SourcingProjectItemLinkage I_SourcingProjectItemLinkage from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjectDocVarbl _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[1..1] C_SourcingProjectItemDocVarbl _SourcingProjectItem $projection.SourcingProjectItemUUID = _SourcingProjectItem.SourcingProjectItemUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSPITEMLINKVB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjectItemLinkageUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
EndUserText.label Doc Varbl for Item Linking in Srcg Proj view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjectItemLinkageUUID SrcgProjectItemLinkageUUID Item Linking UUID
SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
SrcgProjItemLinkedStableUUID SrcgProjItemLinkedStableUUID Stable UUID of Linked Item
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
_SourcingProject _SourcingProject
_SourcingProjectItem _SourcingProjectItem

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_SrcgProjItemLinkageDocVarbl.
-- 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: CSPITEMLINKVB

CREATE VIEW C_SrcgProjItemLinkageDocVarbl AS
SELECT
  SrcgProjectItemLinkageUUID,
  SourcingProjectItemUUID,
  SrcgProjItemLinkedStableUUID,
  SourcingProjectUUID
FROM I_SourcingProjectItemLinkage
LEFT OUTER JOIN C_SourcingProjectDocVarbl AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_SourcingProjectItemDocVarbl AS _SourcingProjectItem ON SourcingProjectItemUUID = _SourcingProjectItem.SourcingProjectItemUUID  -- association [1..1]
;

Learn More