What is C_SourcingProjectItemDEX in SAP S/4HANA?

C_SourcingProjectItemDEX is a consumption CDS view in SAP S/4HANA. Sourcing Project Item Data Extraction It contains 35 fields.

Which tables does C_SourcingProjectItemDEX read from?

C_SourcingProjectItemDEX reads data from: I_SourcingProjectItemDEX.

What VDM layer is C_SourcingProjectItemDEX?

C_SourcingProjectItemDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SourcingProjectItemDEX

DDL: C_SOURCINGPROJECTITEMDEX Type: view_entity CONSUMPTION

35 Fields 1 Data Sources 13 Associations

Sourcing Project Item Data Extraction

C_SourcingProjectItemDEX (Consumption)

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

SourcingProjectItem · Sourcing & Procurement

C_SourcingProjectItemDEX is a Consumption CDS View (Fact) that provides data about "Sourcing Project Item Data Extraction" in SAP S/4HANA. It reads from 1 data source (I_SourcingProjectItemDEX) and exposes 35 fields with key field SourcingProjectItemUUID. It has 13 associations to related views.

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-SRC-SP
Capabilities	Data Source for Data Extraction
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_SourcingProjectItemDEX	SourcingProjectItemDEX	from

Associations (13)

Cardinality	Target	Alias	Condition
[1..1]	C_SourcingProjectDEX	_SourcingProject	`_SourcingProject.SourcingProjectUUID = $projection.SourcingProjectUUID`
[0..*]	C_SrcgProjItmDemandDistrDEX	_SrcgProjDemandDistribution	`$projection.SourcingProjectItemUUID = _SrcgProjDemandDistribution.SourcingProjectItemUUID`
[0..1]	I_Material	_Material	`$projection.Material = _Material.Material`
[0..1]	I_ProductGroup	_ProductGroup	`$projection.MaterialGroup = _ProductGroup.MaterialGroup`
[0..1]	I_Currency	_DocumentCurrency	`$projection.documentcurrency = _DocumentCurrency.Currency`
[0..1]	I_UnitOfMeasure	_RequestedQuantityUnit	`$projection.RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ItemWeightUnit	`$projection.ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ItemVolumeUnit	`$projection.ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure`
[0..1]	I_SourcingProjectItemType	_SourcingProjectItemType	`$projection.SourcingProjectItemType = _SourcingProjectItemType.SourcingProjectItemType`
[0..1]	I_SrcgProjItemClassification	_SrcgProjItemClassification	`$projection.SourcingProjectItemType = _SrcgProjItemClassification.SourcingProjectItemType and $projection.SrcgProjItemClassification = _SrcgProjItemClassification.SrcgProjItemClassification`
[0..1]	I_SrcgProjItemDemandConfCode	_SrcgProjItemDemandConfCode	`$projection.SrcgProjItemDemandConfCode = _SrcgProjItemDemandConfCode.SrcgProjItemDemandConfCode`
[0..1]	I_PurchasingDocumentType	_PurchasingDocumentType	`$projection.SrcgProjFollowOnDocumentCat = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType`
[0..1]	I_PurchasingDocumentCategory	_PurchasingDocumentCategory	`$projection.SrcgProjFollowOnDocumentCat = _PurchasingDocumentCategory.PurchasingDocumentCategory`

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view
Analytics.dataCategory	#FACT	view
ObjectModel.sapObjectNodeType.name	SourcingProjectItem	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#ANALYTICAL_FACT	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Sourcing Project Item Data Extraction	view

Fields (35)

Key	Field	Source Table	Source Field	Description
KEY	SourcingProjectItemUUID	I_SourcingProjectItemDEX	SourcingProjectItemUUID	Sourcing Project Item UUID
	SourcingProjectUUID	I_SourcingProjectItemDEX	SourcingProjectUUID	Sourcing Project UUID
	SourcingProjectItem	I_SourcingProjectItemDEX	SourcingProjectItem	Sourcing Project Item
	SourcingProjectItemType	I_SourcingProjectItemDEX	SourcingProjectItemType	Sourcing Project Item Type
	SrcgProjItemClassification	I_SourcingProjectItemDEX	SrcgProjItemClassification	Classification of Sourcing Project Item
	SrcgProjItemDescription	I_SourcingProjectItemDEX	SrcgProjItemDescription	Sourcing Project Item Description
	Material	I_SourcingProjectItemDEX	Material	Material Number
	MaterialGroup	I_SourcingProjectItemDEX	MaterialGroup	Material Group
	RequestedQuantityUnit	I_SourcingProjectItemDEX	RequestedQuantityUnit	Requested Quantity Unit
	RequestedQuantity	I_SourcingProjectItemDEX	RequestedQuantity	Requested Quantity
	SrcgProjItmTgtAmtQuantity	I_SourcingProjectItemDEX	SrcgProjItmTgtAmtQuantity	Price Unit for Target Price for Sourcing Project Item
	MaximumRequestedQuantity	I_SourcingProjectItemDEX	MaximumRequestedQuantity	Maximum Annually Requested Quantity
	ItemWeightUnit	I_SourcingProjectItemDEX	ItemWeightUnit	Unit of Weight
	ItemVolumeUnit	I_SourcingProjectItemDEX	ItemVolumeUnit	Volume Unit
	DocumentCurrency	_SourcingProject	DocumentCurrency	Document Currency
	SrcgProjItemTotalTargetAmount	I_SourcingProjectItemDEX	SrcgProjItemTotalTargetAmount	Total Target Amount for Item in Sourcing Project
	SrcgProjItemTargetAmount	I_SourcingProjectItemDEX	SrcgProjItemTargetAmount	Target Price for Item in Sourcing Project
	RequestedDeliveryDate	I_SourcingProjectItemDEX	RequestedDeliveryDate	Requested Delivery Date
	ProcurementHubSourceSystem	I_SourcingProjectItemDEX	ProcurementHubSourceSystem	Connected System ID
	SrcgProjFollowOnDocumentCat	I_SourcingProjectItemDEX	SrcgProjFollowOnDocumentCat	Follow-On Purchasing Document Category
	SrcgProjFollowOnDocumentType	I_SourcingProjectItemDEX	SrcgProjFollowOnDocumentType	Follow-On Purchasing Document Type
	SrcgProjItemDemandConfCode	I_SourcingProjectItemDEX	SrcgProjItemDemandConfCode	Demand is Confirmed
	_SourcingProject		_SourcingProject
	_Material		_Material
	_ProductGroup		_ProductGroup
	_DocumentCurrency		_DocumentCurrency
	_RequestedQuantityUnit		_RequestedQuantityUnit
	_SourcingProjectItemType		_SourcingProjectItemType
	_SrcgProjItemClassification		_SrcgProjItemClassification
	_ItemWeightUnit		_ItemWeightUnit
	_ItemVolumeUnit		_ItemVolumeUnit
	_SrcgProjItemDemandConfCode		_SrcgProjItemDemandConfCode
	_PurchasingDocumentType		_PurchasingDocumentType
	_PurchasingDocumentCategory		_PurchasingDocumentCategory
	_SrcgProjDemandDistribution		_SrcgProjDemandDistribution

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_SourcingProjectItemDEX.
-- 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_SourcingProjectItemDEX AS
SELECT
  SourcingProjectItemDEX.SourcingProjectItemUUID AS SourcingProjectItemUUID,
  SourcingProjectItemDEX.SourcingProjectUUID AS SourcingProjectUUID,
  SourcingProjectItemDEX.SourcingProjectItem AS SourcingProjectItem,
  SourcingProjectItemDEX.SourcingProjectItemType AS SourcingProjectItemType,
  SourcingProjectItemDEX.SrcgProjItemClassification AS SrcgProjItemClassification,
  SourcingProjectItemDEX.SrcgProjItemDescription AS SrcgProjItemDescription,
  SourcingProjectItemDEX.Material AS Material,
  SourcingProjectItemDEX.MaterialGroup AS MaterialGroup,
  SourcingProjectItemDEX.RequestedQuantityUnit AS RequestedQuantityUnit,
  SourcingProjectItemDEX.RequestedQuantity AS RequestedQuantity,
  SourcingProjectItemDEX.SrcgProjItmTgtAmtQuantity AS SrcgProjItmTgtAmtQuantity,
  SourcingProjectItemDEX.MaximumRequestedQuantity AS MaximumRequestedQuantity,
  SourcingProjectItemDEX.ItemWeightUnit AS ItemWeightUnit,
  SourcingProjectItemDEX.ItemVolumeUnit AS ItemVolumeUnit,
  _SourcingProject.DocumentCurrency AS DocumentCurrency,
  SourcingProjectItemDEX.SrcgProjItemTotalTargetAmount AS SrcgProjItemTotalTargetAmount,
  SourcingProjectItemDEX.SrcgProjItemTargetAmount AS SrcgProjItemTargetAmount,
  SourcingProjectItemDEX.RequestedDeliveryDate AS RequestedDeliveryDate,
  SourcingProjectItemDEX.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  SourcingProjectItemDEX.SrcgProjFollowOnDocumentCat AS SrcgProjFollowOnDocumentCat,
  SourcingProjectItemDEX.SrcgProjFollowOnDocumentType AS SrcgProjFollowOnDocumentType,
  SourcingProjectItemDEX.SrcgProjItemDemandConfCode AS SrcgProjItemDemandConfCode
FROM I_SourcingProjectItemDEX AS SourcingProjectItemDEX
LEFT OUTER JOIN C_SourcingProjectDEX AS _SourcingProject ON _SourcingProject.SourcingProjectUUID = SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_SrcgProjItmDemandDistrDEX AS _SrcgProjDemandDistribution ON SourcingProjectItemUUID = _SrcgProjDemandDistribution.SourcingProjectItemUUID  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON MaterialGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON documentcurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemWeightUnit ON ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemVolumeUnit ON ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectItemType AS _SourcingProjectItemType ON SourcingProjectItemType = _SourcingProjectItemType.SourcingProjectItemType  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjItemClassification AS _SrcgProjItemClassification ON SourcingProjectItemType = _SrcgProjItemClassification.SourcingProjectItemType AND SrcgProjItemClassification = _SrcgProjItemClassification.SrcgProjItemClassification  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjItemDemandConfCode AS _SrcgProjItemDemandConfCode ON SrcgProjItemDemandConfCode = _SrcgProjItemDemandConfCode.SrcgProjItemDemandConfCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON SrcgProjFollowOnDocumentCat = _PurchasingDocumentType.PurchasingDocumentCategory AND SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON SrcgProjFollowOnDocumentCat = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
;

Depth:

C_SourcingProjectItemDEX view_entity

I_SourcingProjectItemDEX view_entity