C_ChFiExCharacteristic

DDL: C_CHFIEXCHARACTERISTIC SQL: CCHFIEXCHAR Type: view CONSUMPTION
9 Fields 1 Data Sources

Consumption View for Characteristic Information

C_ChFiExCharacteristic is a Consumption CDS View that provides data about "Consumption View for Characteristic Information" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharacteristicForKeyDate) and exposes 9 fields with key field CharcInternalID.

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharacteristicForKeyDate I_ClfnCharacteristicForKeyDate from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCHFIEXCHAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consumption View for Characteristic Information view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharcInternalID Characteristic Internal ID
Characteristic Characteristic Field Name
CharcDataType CharcDataType Format
CharcLength CharcLength Number of Chars
CharcDecimals CharcDecimals Decimal Places
CharcValueUnit CharcValueUnit Internal UoM
CharcMaintAuthGrp CharcMaintAuthGrp
_CharacteristicDesc _CharacteristicDesc
_CharacteristicValue _CharacteristicValue

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 C_ChFiExCharacteristic.
-- 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: CCHFIEXCHAR

CREATE VIEW C_ChFiExCharacteristic AS
SELECT
  CharcInternalID,
  Characteristic,
  CharcDataType,
  CharcLength,
  CharcDecimals,
  CharcValueUnit,
  CharcMaintAuthGrp
FROM I_ClfnCharacteristicForKeyDate
;

Learn More