I_SourcingProjectType

DDL: I_SOURCINGPROJECTTYPE Type: view_entity BASIC
18 Fields 1 Data Sources 5 Associations 1 OData Services

Type of Sourcing Project

I_SourcingProjectType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing Project Type · Sourcing & Procurement

I_SourcingProjectType is a Basic CDS View that provides data about "Type of Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectType) and exposes 18 fields with key field SourcingProjectType. It has 5 associations to related views. It is exposed through 1 OData service (UI_SOURCING_PROJECT_COMPARE).

SAP Help Documentation

CategoryProduct Sourcing
Purpose
This CDS view retrieves the supported sourcing project types. This CDS view provides the data to answer the following business question: What types of sourcing projects exist? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Configuration The view depends on business feature SOURCINGPROJECTREASONCODES . This feature enables the use of reasons in SAP S/4HANA for product sourcing

Structure
Fields Used for Filtering The main filters are as follows: SourcingProjectType : This field is used to specify the supported sourcing project types, for example FS for Forward Sourcing . Further Important Fields Depending on your configuration, some of the fields included in this CDS view may not expose any data. Important fields in this view include the following: Field Name Description SrcgProjContactGroup Contact group used for this sourcing project type SrcgProjFollowOnDocumentGroup Follow-on document group used for this sourcing project type SrcgProjMilestoneGroup Milestone group used for this sourcing project type SrcgProjPhaseGroup Phase group used for this sourcing project type SourcingScenario Supported integration scenario SrcgProjItmConfDmndHasEnabled Indicator if demand confirmation for sourcing project items is enabled

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-SRC-SP
CapabilitiesData Source for Search, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves the supported sourcing project types.</p> <p>This CDS view provides the data to answer the following business question:</p> <ul> <li><p>What types of sourcing projects exist?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectType R_SourcingProjectType from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_SrcgProjPhaseGroupText _SrcgProjPhaseGroupText $projection.SrcgProjPhaseGroup = _SrcgProjPhaseGroupText.SrcgProjPhaseGroup
[0..*] I_SrcgProjMilestoneGroupText _SrcgProjMilestoneGroupText $projection.SrcgProjMilestoneGroup = _SrcgProjMilestoneGroupText.SrcgProjMilestoneGroup
[0..*] I_SrcgProjContactGroupText _SrcgProjContactGroupText $projection.SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup
[0..*] I_SPQtnFollowOnDocGroupText _SPQtnFollowOnDocGroupText $projection.SrcgProjFollowOnDocumentGroup = _SPQtnFollowOnDocGroupText.SrcgProjFollowOnDocumentGroup
[0..*] I_SourcingProjectTypeText _SourcingProjectTypeText

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SourcingProjectType view
ObjectModel.sapObjectNodeType.name SourcingProjectType view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label Type of Sourcing Project view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SOURCING_PROJECT_COMPARE UI_SRCGPROJ_COMPARE V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectType SourcingProjectType Sourcing Project Type
_SourcingProjectTypeText _SourcingProjectTypeText
SrcgProjItemUnconfdDmndRsnGrp SrcgProjItemUnconfdDmndRsnGrp Reason Group used in Sourcing Project
SrcPrjSuplrPartcipnDclnRsnGrp SrcPrjSuplrPartcipnDclnRsnGrp Group of Reasons f. Declined Participation in Sourcing Proj
SrcgProjQtnItemExcludingRsnGrp SrcgProjQtnItemExcludingRsnGrp Group of Reasons for Excluding Item in Supplier Quotation
SrcgProjSuplrUnlockingRsnGroup SrcgProjSuplrUnlockingRsnGroup Group of Reasons for Unlocking Supplier in Sourcing Project
SrcgProjVersioningReasonGroup SrcgProjVersioningReasonGroup Group of Reasons for New Version of Sourcing Project
SrcgProjContactGroup SrcgProjContactGroup Contact Category Group for Supplier Quotation (SP)
_SrcgProjContactGroupText _SrcgProjContactGroupText
SrcgProjFollowOnDocumentGroup SrcgProjFollowOnDocumentGroup Follow-On Document Group for Sourcing Project Quotation
_SPQtnFollowOnDocGroupText _SPQtnFollowOnDocGroupText
SrcgProjMilestoneGroup SrcgProjMilestoneGroup Sourcing Project Milestone Group
_SrcgProjMilestoneGroupText _SrcgProjMilestoneGroupText
SrcgProjPhaseGroup SrcgProjPhaseGroup Sourcing Project Phase Group
_SrcgProjPhaseGroupText _SrcgProjPhaseGroupText
SrcgProjItmConfDmndHasEnabled SrcgProjItmConfDmndHasEnabled Enable Demand Confirmation
SourcingScenario SourcingScenario Sourcing Integration Scenario
SrcgProjCancellationRsnGroup SrcgProjCancellationRsnGroup Group of Reasons for Cancelation of Sourcing Project

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 I_SourcingProjectType.
-- 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 I_SourcingProjectType AS
SELECT
  SourcingProjectType,
  SrcgProjItemUnconfdDmndRsnGrp,
  SrcPrjSuplrPartcipnDclnRsnGrp,
  SrcgProjQtnItemExcludingRsnGrp,
  SrcgProjSuplrUnlockingRsnGroup,
  SrcgProjVersioningReasonGroup,
  SrcgProjContactGroup,
  SrcgProjFollowOnDocumentGroup,
  SrcgProjMilestoneGroup,
  SrcgProjPhaseGroup,
  SrcgProjItmConfDmndHasEnabled,
  SourcingScenario,
  SrcgProjCancellationRsnGroup
FROM R_SourcingProjectType
LEFT OUTER JOIN I_SrcgProjPhaseGroupText AS _SrcgProjPhaseGroupText ON SrcgProjPhaseGroup = _SrcgProjPhaseGroupText.SrcgProjPhaseGroup  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjMilestoneGroupText AS _SrcgProjMilestoneGroupText ON SrcgProjMilestoneGroup = _SrcgProjMilestoneGroupText.SrcgProjMilestoneGroup  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjContactGroupText AS _SrcgProjContactGroupText ON SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup  -- association [0..*]
LEFT OUTER JOIN I_SPQtnFollowOnDocGroupText AS _SPQtnFollowOnDocGroupText ON SrcgProjFollowOnDocumentGroup = _SPQtnFollowOnDocGroupText.SrcgProjFollowOnDocumentGroup  -- association [0..*]
LEFT OUTER JOIN I_SourcingProjectTypeText AS _SourcingProjectTypeText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More