What is I_VarConfignTableValue in SAP S/4HANA?

I_VarConfignTableValue is a composite CDS view in SAP S/4HANA. Combination of values in a Variant Table It contains 21 fields.

What VDM layer is I_VarConfignTableValue?

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

I_VarConfignTableValue

Q: Which tables does I_VarConfignTableValue read from?

I_VarConfignTableValue reads data from: I_VarConfignTableBasic, I_VarConfignTableBasic, I_VarConfignTableTextValue, I_VarConfignTableNumericValue.

DDL: I_VARCONFIGNTABLEVALUE Type: view COMPOSITE Package: VCH_VDM_MD_VT

21 Fields 4 Data Sources 1 Associations

Combination of values in a Variant Table

I_VarConfignTableValue is a Composite CDS View that provides data about "Combination of values in a Variant Table" in SAP S/4HANA. It reads from 4 data sources (I_VarConfignTableBasic, I_VarConfignTableBasic, I_VarConfignTableTextValue, I_VarConfignTableNumericValue) and exposes 21 fields with key fields VarConfignTblID, VarConfignTblValCombinationID, CharcInternalID, VarConfignTblValueNumber, VarConfignTblValCombinationID. It has 1 association to related views. Part of development package VCH_VDM_MD_VT.

Data Sources (4)

Source	Alias	Join Type
I_VarConfignTableBasic	Table	inner
I_VarConfignTableBasic	Table	inner
I_VarConfignTableTextValue	Value	from
I_VarConfignTableNumericValue	Value	union_all

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_ClfnCharcTimeIndep	_Charc	`$projection.CharcInternalID = _Charc.CharcInternalID`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IVARCNFTBLVALUE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Combination of values in a Variant Table	view
ObjectModel.representativeKey	VarConfignTblValueNumber	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#M	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (21)

Key	Field	Source Table	Source Field	Description
KEY	VarConfignTblID	I_VarConfignTableNumericValue	VarConfignTblID	Int. table no.
KEY	VarConfignTblValCombinationID	I_VarConfignTableNumericValue	VarConfignTblValCombinationID	Comb. no.
KEY	CharcInternalID	I_VarConfignTableNumericValue	CharcInternalID	Characteristic Internal ID
KEY	VarConfignTblValueNumber	I_VarConfignTableNumericValue	VarConfignTblValueNumber	Int counter
	CharcValue	I_VarConfignTableNumericValue	CharcValue	Char. Value
	CharcValueIntervalType			Code
	CharcFromNumericValue			Value from
	CharcToNumericValue			Value to
	CharcFromNumericValueUnit			Internal UoM
	CharcToNumericValueUnit			Internal UoM
	VarConfignTblID			Int. table no.
KEY	VarConfignTblValCombinationID	I_VarConfignTableNumericValue	VarConfignTblValCombinationID	Comb. no.
KEY	CharcInternalID	I_VarConfignTableNumericValue	CharcInternalID	Characteristic Internal ID
KEY	VarConfignTblValueNumber	I_VarConfignTableNumericValue	VarConfignTblValueNumber	Int counter
	CharcValue			Char. Value
	CharcValueIntervalType	I_VarConfignTableNumericValue	CharcValueIntervalType	Code
	CharcFromNumericValue	I_VarConfignTableNumericValue	CharcFromNumericValue	Value from
	CharcToNumericValue	I_VarConfignTableNumericValue	CharcToNumericValue	Value to
	CharcFromNumericValueUnit	I_VarConfignTableNumericValue	CharcFromNumericValueUnit	Internal UoM
	CharcToNumericValueUnit	I_VarConfignTableNumericValue	CharcToNumericValueUnit	Internal UoM
	_Charc		_Charc

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_VarConfignTableValue.
-- 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_VarConfignTableValue AS
SELECT
  Value.VarConfignTblID AS VarConfignTblID,
  Value.VarConfignTblValCombinationID AS VarConfignTblValCombinationID,
  Value.CharcInternalID AS CharcInternalID,
  Value.VarConfignTblValueNumber AS VarConfignTblValueNumber,
  Value.CharcValue AS CharcValue,
  '' AS CharcValueIntervalType,
  cast( 0 as atflv ) AS CharcFromNumericValue,
  cast( 0 as atflb ) AS CharcToNumericValue,
  cast( '' as msehi ) AS CharcFromNumericValueUnit,
  cast( '' as msehi ) AS CharcToNumericValueUnit
FROM I_VarConfignTableTextValue AS Value
INNER JOIN I_VarConfignTableBasic AS Table ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnCharcTimeIndep AS _Charc ON CharcInternalID = _Charc.CharcInternalID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_VarConfignTableNumericValue
;

Depth:

I_VarConfignTableValue view