Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_CharacteristicValue

DDL: I_CHARACTERISTICVALUE SQL: ICHARVALUE Type: view BASIC
18 Fields 1 Data Sources

Characteristic Value

I_CharacteristicValue is a Basic CDS View that provides data about "Characteristic Value" in SAP S/4HANA. It reads from 1 data source (cawn) and exposes 18 fields with key fields CharacteristicInternalID, CharacteristicValueInternalID, ValidityStartDate.

Data Sources (1)

SourceAliasJoin Type
cawn cawn from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName ICHARVALUE view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Characteristic Value view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CharacteristicInternalID cawn atinn Internal char.
KEY CharacteristicValueInternalID cawn atzhl Int counter
KEY ValidityStartDate cawn datuv Valid-from date
CharacteristicValue cawn atwrt Char. Value
CharacteristicMinimumValue cawn atflv Value from
CharacteristicMaximumValue cawn atflb Value to
CharacteristicValueDpndcyCode cawn atcod Interval limits
CharacteristicMinimumValueUnit cawn atawe Internal UoM
CharacteristicMaximumValueUnit cawn ataw1 Internal UoM
Language cawn spras Off. Language
CharacteristicChangeNumber cawn aennr Change Number
IsDeleted cawn lkenz Deletion Ind.
DocumentType cawn dokar SW Document Type
DocumentVersion cawn dokvr Doc. Version
DocumentPart cawn doktl Document Part
CharcMinToleranceValue cawn attlv Tolerance from
CharcMaxToleranceValue cawn attlb Tolerance to
CharcToleranceIsPercent cawn atprz Percentage

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_CharacteristicValue.
-- 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: ICHARVALUE

CREATE VIEW I_CharacteristicValue AS
SELECT
  cawn.atinn AS CharacteristicInternalID,
  cawn.atzhl AS CharacteristicValueInternalID,
  cawn.datuv AS ValidityStartDate,
  cawn.atwrt AS CharacteristicValue,
  cawn.atflv AS CharacteristicMinimumValue,
  cawn.atflb AS CharacteristicMaximumValue,
  cawn.atcod AS CharacteristicValueDpndcyCode,
  cawn.atawe AS CharacteristicMinimumValueUnit,
  cawn.ataw1 AS CharacteristicMaximumValueUnit,
  cawn.spras AS Language,
  cawn.aennr AS CharacteristicChangeNumber,
  cawn.lkenz AS IsDeleted,
  cawn.dokar AS DocumentType,
  cawn.dokvr AS DocumentVersion,
  cawn.doktl AS DocumentPart,
  cawn.attlv AS CharcMinToleranceValue,
  cawn.attlb AS CharcMaxToleranceValue,
  cawn.atprz AS CharcToleranceIsPercent
FROM cawn
;

Learn More