I_VarConfignTableLineValue

DDL: I_VARCONFIGNTABLELINEVALUE Type: view COMPOSITE
15 Fields 1 Data Sources

Values of a Line in a Var. Conf. table

I_VarConfignTableLineValue is a Composite CDS View that provides data about "Values of a Line in a Var. Conf. table" in SAP S/4HANA. It reads from 1 data source (I_VarConfignTableLine) and exposes 15 fields with key fields VarConfignTblID, VarConfignTblLineNumber, TimeIntervalNumber, CharcInternalID, VarConfignTblValueNumber.

Data Sources (1)

SourceAliasJoin Type
I_VarConfignTableLine Line from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IVARCNFTBLLVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Values of a Line in a Var. Conf. table view
ObjectModel.representativeKey VarConfignTblValueNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY VarConfignTblID I_VarConfignTableLine VarConfignTblID
KEY VarConfignTblLineNumber I_VarConfignTableLine VarConfignTblLineNumber
KEY TimeIntervalNumber I_VarConfignTableLine TimeIntervalNumber Int. counter
KEY CharcInternalID Value CharcInternalID Characteristic Internal ID
KEY VarConfignTblValueNumber Value VarConfignTblValueNumber
VarConfignTblName I_VarConfignTableLine VarConfignTblName
Characteristic
ChangeNumber I_VarConfignTableLine ChangeNumber Change Number
CharcValue Value CharcValue Char. Value
CharcValueIntervalType Value CharcValueIntervalType Code
CharcFromNumericValue Value CharcFromNumericValue Value from
CharcToNumericValue Value CharcToNumericValue Value to
CharcFromNumericValueUnit Value CharcFromNumericValueUnit Internal UoM
CharcToNumericValueUnit Value CharcToNumericValueUnit Internal UoM
_Charc Value _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_VarConfignTableLineValue.
-- 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_VarConfignTableLineValue AS
SELECT
  Line.VarConfignTblID AS VarConfignTblID,
  Line.VarConfignTblLineNumber AS VarConfignTblLineNumber,
  Line.TimeIntervalNumber AS TimeIntervalNumber,
  Value.CharcInternalID AS CharcInternalID,
  Value.VarConfignTblValueNumber AS VarConfignTblValueNumber,
  Line.VarConfignTblName AS VarConfignTblName,
  Value._Charc.Characteristic AS Characteristic,
  Line.ChangeNumber AS ChangeNumber,
  Value.CharcValue AS CharcValue,
  Value.CharcValueIntervalType AS CharcValueIntervalType,
  Value.CharcFromNumericValue AS CharcFromNumericValue,
  Value.CharcToNumericValue AS CharcToNumericValue,
  Value.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  Value.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  Value._Charc AS _Charc
FROM I_VarConfignTableLine AS Line
;

Learn More