I_ClfnObjectCharcValueDEX

DDL: I_CLFNOBJECTCHARCVALUEDEX Type: view_entity BASIC
30 Fields 2 Data Sources 1 Associations

Clfn Characteristic Value of Object DEX

I_ClfnObjectCharcValueDEX (Basic)

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

ClfnObjectCharacteristicValue · R&D Engineering

I_ClfnObjectCharcValueDEX is a Basic CDS View (Fact) that provides data about "Clfn Characteristic Value of Object DEX" in SAP S/4HANA. It reads from 2 data sources (P_ClfnObjectHeader, I_ClfnObjectCharcValueBasic) and exposes 30 fields with key fields ClfnObjectID, CharcInternalID, ClfnCharcValuePositionNumber, ClfnObjectType, ClassType. 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, Data Source for Data Extraction, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
P_ClfnObjectHeader ObjectHeader inner
I_ClfnObjectCharcValueBasic Valuation from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ClfnCharacteristic _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID and $projection.ValidityStartDate <= _Characteristic.ValidityEndDate and $projection.ValidityEndDate >= _Characteristic.ValidityStartDate

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
EndUserText.label Clfn Characteristic Value of Object DEX view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name ClfnObjectCharacteristicValue view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID P_ClfnObjectHeader ClfnObjectID Key of Object to be Classified
KEY CharcInternalID I_ClfnObjectCharcValueBasic CharcInternalID Characteristic Internal ID
KEY ClfnCharcValuePositionNumber I_ClfnObjectCharcValueBasic CharcValuePositionNumber Characteristic value counter
KEY ClfnObjectType I_ClfnObjectCharcValueBasic ClfnObjectType Indicator: Object/Class
KEY ClassType I_ClfnObjectCharcValueBasic ClassType Class Type
KEY TimeIntervalNumber I_ClfnObjectCharcValueBasic TimeIntervalNumber Internal Counter for Archiving Objects by ECM
ClfnObjectTable P_ClfnObjectHeader ClfnObjectTable Classifcation Object
CharcValueIntervalType I_ClfnObjectCharcValueBasic CharcValueIntervalType Code for value dependency
CharcValue I_ClfnObjectCharcValueBasic CharcValue Characteristic Value
CharcFromNumericValue I_ClfnObjectCharcValueBasic CharcFromNumericValue Internal floating point from
CharcFromNumericValueUnit I_ClfnObjectCharcValueBasic CharcFromNumericValueUnit Unit of Measurement
CharcToNumericValue I_ClfnObjectCharcValueBasic CharcToNumericValue Internal floating point value to
CharcToNumericValueUnit I_ClfnObjectCharcValueBasic CharcToNumericValueUnit Unit of Measurement
CharcFromDecimalValue I_ClfnObjectCharcValueBasic CharcFromDecimalValue Lower Boundary for Numeric Field
CharcToDecimalValue I_ClfnObjectCharcValueBasic CharcToDecimalValue Upper Boundary for Numeric Field
CharcFromAmount I_ClfnObjectCharcValueBasic CharcFromAmount Lower Boundary for Currency Field
CharcToAmount I_ClfnObjectCharcValueBasic CharcToAmount Upper Boundary for Currency Field
Currency I_ClfnObjectCharcValueBasic Currency Valuation Crcy
CharcFromDate I_ClfnObjectCharcValueBasic CharcFromDate Lower Boundary for Date-Interval
CharcToDate I_ClfnObjectCharcValueBasic CharcToDate Upper Boundary for Date-Interval
CharcFromTime I_ClfnObjectCharcValueBasic CharcFromTime Lower Boundary for Time-Interval
CharcToTime I_ClfnObjectCharcValueBasic CharcToTime Upper Boundary for Time-Interval
CharcAuthor I_ClfnObjectCharcValueBasic CharacteristicAuthor Classification: Author
IsDeleted I_ClfnObjectCharcValueBasic IsDeleted Deletion Indicator
ChangeNumber I_ClfnObjectCharcValueBasic ChangeNumber Change Number
CharcValueSortPosition I_ClfnObjectCharcValueBasic CharcValueSortPosition Sort field for AUSP char. values
ValidityStartDate I_ClfnObjectCharcValueBasic ValidityStartDate Validity Start Date
ValidityEndDate I_ClfnObjectCharcValueBasic ValidityEndDate Valid-to date
LastChangeDateTime P_ClfnObjectHeader LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
_Characteristic _Characteristic

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_ClfnObjectCharcValueDEX.
-- 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_ClfnObjectCharcValueDEX AS
SELECT
  ObjectHeader.ClfnObjectID AS ClfnObjectID,
  Valuation.CharcInternalID AS CharcInternalID,
  Valuation.CharcValuePositionNumber AS ClfnCharcValuePositionNumber,
  Valuation.ClfnObjectType AS ClfnObjectType,
  Valuation.ClassType AS ClassType,
  Valuation.TimeIntervalNumber AS TimeIntervalNumber,
  ObjectHeader.ClfnObjectTable AS ClfnObjectTable,
  Valuation.CharcValueIntervalType AS CharcValueIntervalType,
  Valuation.CharcValue AS CharcValue,
  Valuation.CharcFromNumericValue AS CharcFromNumericValue,
  Valuation.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  Valuation.CharcToNumericValue AS CharcToNumericValue,
  Valuation.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  Valuation.CharcFromDecimalValue AS CharcFromDecimalValue,
  Valuation.CharcToDecimalValue AS CharcToDecimalValue,
  Valuation.CharcFromAmount AS CharcFromAmount,
  Valuation.CharcToAmount AS CharcToAmount,
  Valuation.Currency AS Currency,
  Valuation.CharcFromDate AS CharcFromDate,
  Valuation.CharcToDate AS CharcToDate,
  Valuation.CharcFromTime AS CharcFromTime,
  Valuation.CharcToTime AS CharcToTime,
  Valuation.CharacteristicAuthor AS CharcAuthor,
  Valuation.IsDeleted AS IsDeleted,
  Valuation.ChangeNumber AS ChangeNumber,
  Valuation.CharcValueSortPosition AS CharcValueSortPosition,
  Valuation.ValidityStartDate AS ValidityStartDate,
  Valuation.ValidityEndDate AS ValidityEndDate,
  ObjectHeader.LastChangeDateTime AS LastChangeDateTime
FROM I_ClfnObjectCharcValueBasic AS Valuation
INNER JOIN P_ClfnObjectHeader AS ObjectHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnCharacteristic AS _Characteristic ON CharcInternalID = _Characteristic.CharcInternalID AND ValidityStartDate <= _Characteristic.ValidityEndDate AND ValidityEndDate >= _Characteristic.ValidityStartDate  -- association [1..*]
;

Learn More