What is I_CharcValueForKeyDate in SAP S/4HANA?

I_CharcValueForKeyDate is a composite CDS view in SAP S/4HANA. Characteristic Value for Key Date It contains 0 fields.

Which tables does I_CharcValueForKeyDate read from?

I_CharcValueForKeyDate reads data from: I_CharacteristicValue.

What VDM layer is I_CharcValueForKeyDate?

I_CharcValueForKeyDate is classified as a Composite view that combines data from multiple basic views.

I_CharcValueForKeyDate

DDL: I_CHARCVALUEFORKEYDATE SQL: ICHARVALUEDATE Type: view COMPOSITE

1 Data Sources 1 Associations

Characteristic Value for Key Date

I_CharcValueForKeyDate is a Composite CDS View that provides data about "Characteristic Value for Key Date" in SAP S/4HANA. It reads from 1 data source (I_CharacteristicValue). It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_CharacteristicValue	cawn	inner

Parameters (1)

Name	Type	Default
P_KeyDate	key_date_cl_cds

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_CharacteristicValue	_CharacteristicValue	`Cawn_Current.CharacteristicInternalID = _CharacteristicValue.CharacteristicInternalID and Cawn_Current.CharacteristicValueInternalID = _CharacteristicValue.CharacteristicValueInternalID and Cawn_Current.ValidityStartDate = _CharacteristicValue.ValidityStartDate`

Annotations (9)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
AbapCatalog.sqlViewName	ICHARVALUEDATE	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.status	#DEPRECATED	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Characteristic Value for Key Date	view

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_CharcValueForKeyDate.
-- 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: ICHARVALUEDATE
-- Parameters: P_KeyDate : key_date_cl_cds

CREATE VIEW I_CharcValueForKeyDate AS
SELECT *  -- field list not available in parsed metadata
INNER JOIN I_CharacteristicValue AS cawn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CharacteristicValue AS _CharacteristicValue ON Cawn_Current.CharacteristicInternalID = _CharacteristicValue.CharacteristicInternalID AND Cawn_Current.CharacteristicValueInternalID = _CharacteristicValue.CharacteristicValueInternalID AND Cawn_Current.ValidityStartDate = _CharacteristicValue.ValidityStartDate  -- association [1..1]
;

Depth:

I_CharcValueForKeyDate view

I_CharacteristicValue view