C_SourcingProjectItemVH

DDL: C_SOURCINGPROJECTITEMVH Type: view_entity CONSUMPTION
14 Fields 1 Data Sources

Sourcing Project Item - VH

C_SourcingProjectItemVH is a Consumption CDS View that provides data about "Sourcing Project Item - VH" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectItem) and exposes 14 fields with key field SourcingProjectItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectItem R_SourcingProjectItem from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SourcingProjectItemUUID view
EndUserText.label Sourcing Project Item - VH view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
SourcingProject _SourcingProject SourcingProject Sourcing Project
SourcingProjectVersion _SourcingProject SourcingProjectVersion Sourcing Project Version
FormattedItemID FormattedItemID Item Number
SourcingProjectName _SourcingProject SourcingProjectName Name
SourcingProjectItem SourcingProjectItem Item
SrcgProjItemDescription SrcgProjItemDescription Description
SrcgProjItemClassification SrcgProjItemClassification Item Classification
SourcingProjectIsTemplate _SourcingProject SourcingProjectIsTemplate
PurchasingOrganization _SourcingProject PurchasingOrganization Purchasing Organization
PurchasingGroup _SourcingProject PurchasingGroup Purchasing Group
SourcingProjectType _SourcingProject SourcingProjectType Sourcing Project Type
CompanyCode _SourcingProject CompanyCode Receiver Company Code
MaterialGroup _SourcingProject MaterialGroup Product Group

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_SourcingProjectItemVH.
-- 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_SourcingProjectItemVH AS
SELECT
  SourcingProjectItemUUID,
  _SourcingProject.SourcingProject AS SourcingProject,
  _SourcingProject.SourcingProjectVersion AS SourcingProjectVersion,
  FormattedItemID,
  _SourcingProject.SourcingProjectName AS SourcingProjectName,
  SourcingProjectItem,
  SrcgProjItemDescription,
  SrcgProjItemClassification,
  _SourcingProject.SourcingProjectIsTemplate AS SourcingProjectIsTemplate,
  _SourcingProject.PurchasingOrganization AS PurchasingOrganization,
  _SourcingProject.PurchasingGroup AS PurchasingGroup,
  _SourcingProject.SourcingProjectType AS SourcingProjectType,
  _SourcingProject.CompanyCode AS CompanyCode,
  _SourcingProject.MaterialGroup AS MaterialGroup
FROM R_SourcingProjectItem
;

Learn More