I_ClfnCharcDesc

DDL: I_CLFNCHARCDESC SQL: INGCCHR19 Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Description of Clfn Characteristic

I_ClfnCharcDesc (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

R&D Engineering

I_ClfnCharcDesc is a Basic CDS View that provides data about "Description of Clfn Characteristic" in SAP S/4HANA. It reads from 1 data source (cabnt) and exposes 9 fields with key fields CharcInternalID, Language, TimeIntervalNumber. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentCA-CL
CapabilitiesLanguage-Dependent Text, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
cabnt CharcDesc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName INGCCHR19 view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Description of Clfn Characteristic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID Characteristic Internal ID
KEY Language cabnt spras Off. Language
KEY TimeIntervalNumber cabnt adzhl Internal Counter for Archiving Objects by ECM
CharcDescription Characteristic Description
ChangeNumber cabnt aennr Change Number
ValidityStartDate cabnt datuv Valid-from date
ValidityEndDate cabnt datub Valid-to date
IsDeleted cabnt lkenz Deletion Indicator
_Language _Language

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_ClfnCharcDesc.
-- 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: INGCCHR19

CREATE VIEW I_ClfnCharcDesc AS
SELECT
  cast ( CharcDesc.atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  CharcDesc.spras AS Language,
  CharcDesc.adzhl AS TimeIntervalNumber,
  cast ( CharcDesc.atbez as charcdescription preserving type ) AS CharcDescription,
  CharcDesc.aennr AS ChangeNumber,
  CharcDesc.datuv AS ValidityStartDate,
  CharcDesc.datub AS ValidityEndDate,
  CharcDesc.lkenz AS IsDeleted
FROM cabnt AS CharcDesc
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More