What is C_SourcingProjectItemDocVarbl in SAP S/4HANA?

C_SourcingProjectItemDocVarbl is a consumption CDS view in SAP S/4HANA. Doc Varbl for Item in Sourcing Project It contains 52 fields.

Which tables does C_SourcingProjectItemDocVarbl read from?

C_SourcingProjectItemDocVarbl reads data from: R_SourcingProjectItem.

What VDM layer is C_SourcingProjectItemDocVarbl?

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

C_SourcingProjectItemDocVarbl

DDL: C_SOURCINGPROJECTITEMDOCVARBL SQL: CSRCGPROJITMVB Type: view CONSUMPTION

52 Fields 1 Data Sources 9 Associations

Doc Varbl for Item in Sourcing Project

C_SourcingProjectItemDocVarbl is a Consumption CDS View that provides data about "Doc Varbl for Item in Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectItem) and exposes 52 fields with key field SourcingProjectItemUUID. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_SourcingProjectItem	R_SourcingProjectItem	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	R_SourcingProject	_SrcgProj	`$projection.SourcingProjectUUID = _SrcgProj.SourcingProjectUUID`
[0..1]	C_SourcingProjectDocVarbl	_SourcingProject	`$projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID`
[1..1]	I_MaterialGroup	_MaterialGroup	`$projection.MaterialGroup = _MaterialGroup.MaterialGroup`
[0..1]	I_ProductTypeCode	_ProductType	`$projection.ProductType = _ProductType.ProductTypeCode`
[0..1]	I_BackendPlantForPurg	_BackendPlantForPurg	`$projection.Plant = _BackendPlantForPurg.Plant and $projection.CompanyCode = _BackendPlantForPurg.CompanyCode and $projection.ProcurementHubSourceSystem = _BackendPlantForPurg.ProcurementHubSourceSystem`
[1..1]	I_BackendCoCodeForPurg	_BackendCoCodeForPurg	`$projection.ProcurementHubSourceSystem = _BackendCoCodeForPurg.ProcurementHubSourceSystem and $projection.CompanyCode = _BackendCoCodeForPurg.CompanyCode`
[0..1]	I_ProcmtHubPurgOrg	_ProcmtHubPurgOrg	`$projection.PurchasingOrganization = _ProcmtHubPurgOrg.ProcmtHubPurchasingOrg and $projection.ProcurementHubSourceSystem = _ProcmtHubPurgOrg.ProcurementHubSourceSystem`
[0..1]	I_PurgDocumentCategoryText	_PurgDocumentCategoryText	`$projection.SrcgProjFollowOnDocumentCat = _PurgDocumentCategoryText.PurchasingDocumentCategory and _PurgDocumentCategoryText.Language = $session.system_language`
[0..1]	I_PurchasingDocumentTypeText	_PurchasingDocumentTypeText	`$projection.SrcgProjFollowOnDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.SrcgProjFollowOnDocumentCat = _PurchasingDocumentTypeText.PurchasingDocumentCategory and _PurchasingDocumentTypeText.Language = $session.system_language`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CSRCGPROJITMVB	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.representativeKey	SourcingProjectItemUUID	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Doc Varbl for Item in Sourcing Project	view

Fields (52)

Key	Field	Source Table	Source Field	Description
KEY	SourcingProjectItemUUID		SourcingProjectItemUUID	Item UUID
	SourcingProjectItem		SourcingProjectItem	Item
	SourcingProjectUUID		SourcingProjectUUID	Sourcing Project UUID
	SourcingProjectItemType		SourcingProjectItemType	Item Type
	SourcingProjectItemTypeName
	SrcgProjItemClassification		SrcgProjItemClassification	Item Classification
	SrcgProjItemClassificationName
	SourcingProjectItemStableUUID		SourcingProjectItemStableUUID	Stable ID
	SrcgProjItemDescription		SrcgProjItemDescription	Description
	Material		Material	Vehicle Model
	ProductType		ProductType	Product Type Group
	ProductTypeName
	MaterialGroup		MaterialGroup	Product Group
	MaterialGroupName
	MaterialGroupText
	SrcgProjItemTargetAmount		SrcgProjItemTargetAmount	Target Price
	SrcgProjItemTotalTargetAmount		SrcgProjItemTotalTargetAmount	Total Target Amount
	RequestedQuantity		RequestedQuantity	Requested Quantity
	MaximumRequestedQuantity		MaximumRequestedQuantity	Max. Requested Quantity
	RequestedQuantityUnit		RequestedQuantityUnit	Requested Quantity Unit
	UnitOfMeasureLongName
	UnitOfMeasureName
	RequestedDeliveryDate		RequestedDeliveryDate	Requested Delivery Date
	PerformancePeriodStartDate		PerformancePeriodStartDate	Start of Performance Period
	PerformancePeriodEndDate		PerformancePeriodEndDate	End of Performance Period
	OrderItemQtyToBaseQtyNmrtr		OrderItemQtyToBaseQtyNmrtr	Equal To
	OrderItemQtyToBaseQtyDnmntr		OrderItemQtyToBaseQtyDnmntr	Denominator
	Plant		Plant	Valuation Area
	PlantName	_BackendPlantForPurg	PlantName	Plant Name
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_BackendCoCodeForPurg	CompanyCodeName	Company Name
	PurchasingGroup		PurchasingGroup	Purchasing Group
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	ProcmtHubPurgOrgName	_ProcmtHubPurgOrg	ProcmtHubPurgOrgName
	StorageLocation		StorageLocation	StorageLocation
	SourcingProjectItemParent		SourcingProjectItemParent	Item Parent
	HierarchyNodeLevel		HierarchyNodeLevel	Hierarchy Node Level
	AlternativeItemID		AlternativeItemID	Alternative Item ID
	FormattedItemID		FormattedItemID	Item Number
	PurchaseRequisition		PurchaseRequisition	Requisition
	PurchaseRequisitionItem		PurchaseRequisitionItem	Requisn. item
	SrcgProjFollowOnDocumentCat		SrcgProjFollowOnDocumentCat	Follow-On Document Category
	PurchasingDocumentCategoryName	_PurgDocumentCategoryText	PurchasingDocumentCategoryName	Short Description
	SrcgProjFollowOnDocumentType		SrcgProjFollowOnDocumentType	Follow-On Document Type
	PurchasingDocumentTypeName	_PurchasingDocumentTypeText	PurchasingDocumentTypeName	Description
	SrcgProjItemDemandConfCode		SrcgProjItemDemandConfCode	Confirmation Code
	SrcgProjItemUnconfdDemandRsn		SrcgProjItemUnconfdDemandRsn	Rsn for Unconfd Dmnd
	ProcurementHubSourceSystem		ProcurementHubSourceSystem	Connected System ID
	DocumentCurrency	_SrcgProj	DocumentCurrency	Document Currency
	CurrencyName
	CurrencyShortName
	_SourcingProject		_SourcingProject

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_SourcingProjectItemDocVarbl.
-- 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: CSRCGPROJITMVB

CREATE VIEW C_SourcingProjectItemDocVarbl AS
SELECT
  SourcingProjectItemUUID,
  SourcingProjectItem,
  SourcingProjectUUID,
  SourcingProjectItemType,
  _SourcingProjectItemType._SourcingProjectItemTypeText[1: Language = $session.system_language ].SourcingProjectItemTypeName AS SourcingProjectItemTypeName,
  SrcgProjItemClassification,
  _SrcgProjItemClassification._SrcgProjItemClassfctnText[1: Language = $session.system_language ].SrcgProjItemClassificationName AS SrcgProjItemClassificationName,
  SourcingProjectItemStableUUID,
  SrcgProjItemDescription,
  Material,
  ProductType,
  _ProductType._Text[1: Language = $session.system_language ].Name AS ProductTypeName,
  MaterialGroup,
  _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
  _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupText AS MaterialGroupText,
  SrcgProjItemTargetAmount,
  SrcgProjItemTotalTargetAmount,
  RequestedQuantity,
  MaximumRequestedQuantity,
  RequestedQuantityUnit,
  _RequestedQuantityUnit._Text[1: Language = $session.system_language ].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  _RequestedQuantityUnit._Text[1: Language = $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
  RequestedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  Plant,
  _BackendPlantForPurg.PlantName AS PlantName,
  CompanyCode,
  _BackendCoCodeForPurg.CompanyCodeName AS CompanyCodeName,
  PurchasingGroup,
  PurchasingOrganization,
  _ProcmtHubPurgOrg.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  StorageLocation,
  SourcingProjectItemParent,
  HierarchyNodeLevel,
  AlternativeItemID,
  FormattedItemID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SrcgProjFollowOnDocumentCat,
  _PurgDocumentCategoryText.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  SrcgProjFollowOnDocumentType,
  _PurchasingDocumentTypeText.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  SrcgProjItemDemandConfCode,
  SrcgProjItemUnconfdDemandRsn,
  ProcurementHubSourceSystem,
  _SrcgProj.DocumentCurrency AS DocumentCurrency,
  _ItemDocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  _ItemDocumentCurrency._Text[1: Language = $session.system_language ].CurrencyShortName AS CurrencyShortName
FROM R_SourcingProjectItem
LEFT OUTER JOIN R_SourcingProject AS _SrcgProj ON SourcingProjectUUID = _SrcgProj.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_SourcingProjectDocVarbl AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON ProductType = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_BackendPlantForPurg AS _BackendPlantForPurg ON Plant = _BackendPlantForPurg.Plant AND CompanyCode = _BackendPlantForPurg.CompanyCode AND ProcurementHubSourceSystem = _BackendPlantForPurg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_BackendCoCodeForPurg AS _BackendCoCodeForPurg ON ProcurementHubSourceSystem = _BackendCoCodeForPurg.ProcurementHubSourceSystem AND CompanyCode = _BackendCoCodeForPurg.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubPurgOrg AS _ProcmtHubPurgOrg ON PurchasingOrganization = _ProcmtHubPurgOrg.ProcmtHubPurchasingOrg AND ProcurementHubSourceSystem = _ProcmtHubPurgOrg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON SrcgProjFollowOnDocumentCat = _PurgDocumentCategoryText.PurchasingDocumentCategory AND _PurgDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON SrcgProjFollowOnDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND SrcgProjFollowOnDocumentCat = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND _PurchasingDocumentTypeText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_SourcingProjectItemDocVarbl view

R_SourcingProjectItem view