What is C_SupplierEvalScoreHistory in SAP S/4HANA?

C_SupplierEvalScoreHistory is a consumption CDS view in SAP S/4HANA. Supplier Score For Historical Period It contains 28 fields.

Which tables does C_SupplierEvalScoreHistory read from?

C_SupplierEvalScoreHistory reads data from: I_SupplierEvalScoreHistory.

What VDM layer is C_SupplierEvalScoreHistory?

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

C_SupplierEvalScoreHistory

DDL: C_SUPPLIEREVALSCOREHISTORY SQL: CSUPESCHIS Type: view CONSUMPTION

28 Fields 1 Data Sources 3 Associations

Supplier Score For Historical Period

C_SupplierEvalScoreHistory is a Consumption CDS View that provides data about "Supplier Score For Historical Period" in SAP S/4HANA. It reads from 1 data source (I_SupplierEvalScoreHistory) and exposes 28 fields with key fields IdentifierOfScoreHistoryJobRun, Supplier, MaterialGroup, CalendarMonth, CalendarYear. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SupplierEvalScoreHistory	Operational	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_SupplierEvaluationRunInfo	_RunInfo	`_RunInfo.IdentifierOfScoreHistoryJobRun = Operational.IdentifierOfScoreHistoryJobRun`
[1..1]	C_MM_MaterialGroupValueHelp	_MaterialGroup	`$projection.MaterialGroup = _MaterialGroup.MaterialGroup`
[1..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`

Annotations (13)

Name	Value	Level
ObjectModel.usageType.dataClass	#MIXED	view
AbapCatalog.sqlViewName	CSUPESCHIS	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
UI.headerInfo.typeName	Operational Score	view
UI.headerInfo.typeNamePlural	Operational Score	view
EndUserText.label	Supplier Score For Historical Period	view
Search.searchable	true	view

Fields (28)

Key	Field	Source Table	Source Field	Description
KEY	IdentifierOfScoreHistoryJobRun		IdentifierOfScoreHistoryJobRun	Job RunID
KEY	Supplier		Supplier	Supplier
KEY	MaterialGroup		MaterialGroup	Material Group
KEY	CalendarMonth		CalendarMonth	Calendar Month
KEY	CalendarYear		CalendarYear	Calendar Year
	SupplierName	_Supplier	SupplierName	Supplier Name
	MaterialGroupName	_MaterialGroup	MaterialGroupName	prod Grp Desc.
	OperationalScore		OperationalScore	Operational Score
	TimeVarianceScore			Time Variance Score
	PriceVarianceScore			Price Variance Score
	QuantityVarianceScore			Quantity Variance Score
	InspectionLotQualityScore			Inspection Lot Score
	QualityNotificationScoreValue			Quality Notification Score
	CreatedByUser		CreatedByUser	Created By
	ScoreHistoryJobScheduledDate		ScoreHistoryJobScheduledDate	Payt Rcpt Crted Date
	SupplierAccountGroup		SupplierAccountGroup	Account group
	_RunInfo		_RunInfo
	DataController1	_Supplier	DataController1	Data Controller
	DataController2	_Supplier	DataController2	Data Controller
	DataController3	_Supplier	DataController3	Data Controller
	DataController4	_Supplier	DataController4	Data Controller
	DataController5	_Supplier	DataController5	Data Controller
	DataController6	_Supplier	DataController6	Data Controller
	DataController7	_Supplier	DataController7	Data Controller
	DataController8	_Supplier	DataController8	Data Controller
	DataController9	_Supplier	DataController9	Data Controller
	DataController10	_Supplier	DataController10	Data Controller
	DataControllerSet	_Supplier	DataControllerSet	Data Ctrlr. Set

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_SupplierEvalScoreHistory.
-- 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: CSUPESCHIS

CREATE VIEW C_SupplierEvalScoreHistory AS
SELECT
  IdentifierOfScoreHistoryJobRun,
  Supplier,
  MaterialGroup,
  CalendarMonth,
  CalendarYear,
  _Supplier.SupplierName AS SupplierName,
  _MaterialGroup.MaterialGroupName AS MaterialGroupName,
  OperationalScore,
  fltp_to_dec( TimeVarianceScore as abap.dec(6,2) ) AS TimeVarianceScore,
  fltp_to_dec(PriceVarianceScore as abap.dec(6,2) ) AS PriceVarianceScore,
  fltp_to_dec(QuantityVarianceScore as abap.dec(6,2) ) AS QuantityVarianceScore,
  fltp_to_dec(InspectionLotQualityScore as abap.dec(6,2) ) AS InspectionLotQualityScore,
  fltp_to_dec(QualityNotificationScoreValue as abap.dec(6,2) ) AS QualityNotificationScoreValue,
  CreatedByUser,
  ScoreHistoryJobScheduledDate,
  SupplierAccountGroup,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM I_SupplierEvalScoreHistory AS Operational
LEFT OUTER JOIN I_SupplierEvaluationRunInfo AS _RunInfo ON _RunInfo.IdentifierOfScoreHistoryJobRun = Operational.IdentifierOfScoreHistoryJobRun  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Depth:

C_SupplierEvalScoreHistory view

I_SupplierEvalScoreHistory view