I_GHOCharacteristicName

DDL: I_GHOCHARACTERISTICNAME Type: view_entity BASIC
14 Fields 1 Data Sources 1 Associations

Characteristic Data

I_GHOCharacteristicName is a Basic CDS View that provides data about "Characteristic Data" in SAP S/4HANA. It reads from 1 data source (cabn) and exposes 14 fields with key fields CharcInternalID, TimeIntervalNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cabn cabn from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GHOCharacteristicDescsTxt _CharacteristicTxt _CharacteristicTxt.CharcInternalID = $projection.CharcInternalID and _CharacteristicTxt.Language = $session.system_language and _CharacteristicTxt.TimeIntervalNumber = $projection.TimeIntervalNumber

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Characteristic Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID Internal char.
KEY TimeIntervalNumber adzhl Int. counter
Characteristic atnam Characteristic
CharcIdentificationCode atidn Charact ID
CharcStatus atmst Status
CharcDataType atfor Format
CharcLength anzst Number of Chars
CharcDecimals anzdz Decimal Places
EntryIsRequired aterf Entry Required
ValidityStartDate datuv Valid-from date
ValidityEndDate datub Valid to
ChangeNumber aennr Change Number
IsDeleted lkenz Deletion Ind.
_CharacteristicTxt _CharacteristicTxt

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_GHOCharacteristicName.
-- 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_GHOCharacteristicName AS
SELECT
  cast ( atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  adzhl AS TimeIntervalNumber,
  atnam AS Characteristic,
  atidn AS CharcIdentificationCode,
  atmst AS CharcStatus,
  atfor AS CharcDataType,
  anzst AS CharcLength,
  anzdz AS CharcDecimals,
  aterf AS EntryIsRequired,
  datuv AS ValidityStartDate,
  datub AS ValidityEndDate,
  aennr AS ChangeNumber,
  lkenz AS IsDeleted
FROM cabn
LEFT OUTER JOIN I_GHOCharacteristicDescsTxt AS _CharacteristicTxt ON _CharacteristicTxt.CharcInternalID = CharcInternalID AND _CharacteristicTxt.Language = $session.system_language AND _CharacteristicTxt.TimeIntervalNumber = TimeIntervalNumber  -- association [0..1]
;

Learn More