I_ClfnClassCharacteristicDEX

DDL: I_CLFNCLASSCHARACTERISTICDEX Type: view_entity BASIC
18 Fields 1 Data Sources 1 Associations

Characteristic of Clfn Class DEX

I_ClfnClassCharacteristicDEX (Basic)

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

ClfnClassCharacteristic · R&D Engineering

I_ClfnClassCharacteristicDEX is a Basic CDS View (Dimension) that provides data about "Characteristic of Clfn Class DEX" in SAP S/4HANA. It reads from 1 data source (I_ClfnClassCharcBasic) and exposes 18 fields with key fields ClassInternalID, CharcPositionNumber, ValidityEndDate. It has 1 association to related views.

SAP API Hub

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

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ClfnClassCharcBasic ClassCharc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ClfnClassDEX _Class $projection.ClassInternalID = _Class.ClassInternalID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
EndUserText.label Characteristic of Clfn Class DEX view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CharcPositionNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name ClfnClassCharacteristic view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ClassInternalID I_ClfnClassCharcBasic ClassInternalID Internal Class Number
KEY CharcPositionNumber I_ClfnClassCharcBasic CharcPositionNumber WBS Element
KEY ValidityEndDate I_ClfnClassCharcBasic ValidityEndDate Valid-to date
TimeIntervalNumber I_ClfnClassCharcBasic TimeIntervalNumber Internal Counter for Archiving Objects by ECM
CharcInternalID I_ClfnClassCharcBasic CharcInternalID Characteristic Internal ID
OverwrittenCharcInternalID I_ClfnClassCharcBasic OverwrittenCharcInternalID Characteristic Internal ID
ClfnOrganizationalArea I_ClfnClassCharcBasic ClfnOrganizationalArea Organizational Area
ClassType I_ClfnClassCharcBasic ClassType Class Type
ChangeNumber I_ClfnClassCharcBasic ChangeNumber Change Number
ValidityStartDate I_ClfnClassCharcBasic ValidityStartDate Validity Start Date
IsDeleted I_ClfnClassCharcBasic IsDeleted Deletion Indicator
CharcOriginText I_ClfnClassCharcBasic CharcOriginText Characteristic origin
CharcIsProposalRelevant I_ClfnClassCharcBasic CharcIsProposalRelevant Proposal Relevant
CharcIsPrptnOrProdUnitRelevant I_ClfnClassCharcBasic CharcIsPrptnOrProdUnitRelevant Proportion/Product Unit Relevant
CharcIsPrintRelevant I_ClfnClassCharcBasic CharcIsPrintRelevant Characteristic Is Print Relevant Indicator
CharcIsSearchRelevant I_ClfnClassCharcBasic CharcIsSearchRelevant Characteristic Is Search Relevant Indicator
CharcIsDisplayRelevant I_ClfnClassCharcBasic CharcIsDisplayRelevant Characteristic Is Display Relevant Indicator
_Class _Class

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_ClfnClassCharacteristicDEX.
-- 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_ClfnClassCharacteristicDEX AS
SELECT
  ClassCharc.ClassInternalID AS ClassInternalID,
  ClassCharc.CharcPositionNumber AS CharcPositionNumber,
  ClassCharc.ValidityEndDate AS ValidityEndDate,
  ClassCharc.TimeIntervalNumber AS TimeIntervalNumber,
  ClassCharc.CharcInternalID AS CharcInternalID,
  ClassCharc.OverwrittenCharcInternalID AS OverwrittenCharcInternalID,
  ClassCharc.ClfnOrganizationalArea AS ClfnOrganizationalArea,
  ClassCharc.ClassType AS ClassType,
  ClassCharc.ChangeNumber AS ChangeNumber,
  ClassCharc.ValidityStartDate AS ValidityStartDate,
  ClassCharc.IsDeleted AS IsDeleted,
  ClassCharc.CharcOriginText AS CharcOriginText,
  ClassCharc.CharcIsProposalRelevant AS CharcIsProposalRelevant,
  ClassCharc.CharcIsPrptnOrProdUnitRelevant AS CharcIsPrptnOrProdUnitRelevant,
  ClassCharc.CharcIsPrintRelevant AS CharcIsPrintRelevant,
  ClassCharc.CharcIsSearchRelevant AS CharcIsSearchRelevant,
  ClassCharc.CharcIsDisplayRelevant AS CharcIsDisplayRelevant
FROM I_ClfnClassCharcBasic AS ClassCharc
LEFT OUTER JOIN I_ClfnClassDEX AS _Class ON ClassInternalID = _Class.ClassInternalID  -- association [0..1]
;

Learn More