I_ClfnObjectCharcValForKeyDate

DDL: I_CLFNOBJECTCHARCVALFORKEYDATE SQL: INGCCLFN8 Type: view COMPOSITE
29 Fields 1 Data Sources 2 Associations

Clfn Charc Val of Obj for Key Date

I_ClfnObjectCharcValForKeyDate (Composite)

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_ClfnObjectCharcValForKeyDate is a Composite CDS View that provides data about "Clfn Charc Val of Obj for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValue) and exposes 29 fields with key fields ClfnObjectID, ClfnObjectTable, CharcInternalID, CharcValuePositionNumber, ClfnObjectType. It has 2 associations 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 in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValue Valuation from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID
[0..*] I_ClfnCharcValueForKeyDate _CharacteristicValue _CharacteristicValue.CharcInternalID = $projection.CharcInternalID and _CharacteristicValue.CharcValue = $projection.CharcValue

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLFN8 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Clfn Charc Val of Obj for Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectCharcValue ClfnObjectID Key of Object to be Classified
KEY ClfnObjectTable I_ClfnObjectCharcValue ClfnObjectTable Classifcation Object
KEY CharcInternalID I_ClfnObjectCharcValue CharcInternalID Characteristic Internal ID
KEY CharcValuePositionNumber I_ClfnObjectCharcValue CharcValuePositionNumber Characteristic value counter
KEY ClfnObjectType I_ClfnObjectCharcValue ClfnObjectType Indicator: Object/Class
KEY ClassType I_ClfnObjectCharcValue ClassType Class Type
ClfnObjectInternalID I_ClfnObjectCharcValue ClfnObjectInternalID Internal Object Number
CharcValueDependency I_ClfnObjectCharcValue CharcValueIntervalType Code for value dependency
CharcValue I_ClfnObjectCharcValue CharcValue Characteristic Value
CharcFromNumericValue I_ClfnObjectCharcValue CharcFromNumericValue Internal floating point from
CharcFromNumericValueUnit I_ClfnObjectCharcValue CharcFromNumericValueUnit Unit of Measurement
CharcToNumericValue I_ClfnObjectCharcValue CharcToNumericValue Internal floating point value to
CharcToNumericValueUnit I_ClfnObjectCharcValue CharcToNumericValueUnit Unit of Measurement
CharcFromDecimalValue I_ClfnObjectCharcValue CharcFromDecimalValue Lower Boundary for Numeric Field
CharcToDecimalValue I_ClfnObjectCharcValue CharcToDecimalValue Upper Boundary for Numeric Field
CharcFromAmount I_ClfnObjectCharcValue CharcFromAmount Lower Boundary for Currency Field
CharcToAmount I_ClfnObjectCharcValue CharcToAmount Upper Boundary for Currency Field
Currency I_ClfnObjectCharcValue Currency Valuation Crcy
CharcFromDate I_ClfnObjectCharcValue CharcFromDate Lower Boundary for Date-Interval
CharcToDate I_ClfnObjectCharcValue CharcToDate Upper Boundary for Date-Interval
CharcFromTime I_ClfnObjectCharcValue CharcFromTime Lower Boundary for Time-Interval
CharcToTime I_ClfnObjectCharcValue CharcToTime Upper Boundary for Time-Interval
CharacteristicAuthor I_ClfnObjectCharcValue CharacteristicAuthor Classification: Author
ChangeNumber I_ClfnObjectCharcValue ChangeNumber Change Number
ValidityStartDate I_ClfnObjectCharcValue ValidityStartDate Validity Start Date
ValidityEndDate I_ClfnObjectCharcValue ValidityEndDate Valid-to date
LastChangeDateTime I_ClfnObjectCharcValue LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
_Characteristic _Characteristic
_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 I_ClfnObjectCharcValForKeyDate.
-- 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: INGCCLFN8
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnObjectCharcValForKeyDate AS
SELECT
  Valuation.ClfnObjectID AS ClfnObjectID,
  Valuation.ClfnObjectTable AS ClfnObjectTable,
  Valuation.CharcInternalID AS CharcInternalID,
  Valuation.CharcValuePositionNumber AS CharcValuePositionNumber,
  Valuation.ClfnObjectType AS ClfnObjectType,
  Valuation.ClassType AS ClassType,
  Valuation.ClfnObjectInternalID AS ClfnObjectInternalID,
  Valuation.CharcValueIntervalType AS CharcValueDependency,
  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 CharacteristicAuthor,
  Valuation.ChangeNumber AS ChangeNumber,
  Valuation.ValidityStartDate AS ValidityStartDate,
  Valuation.ValidityEndDate AS ValidityEndDate,
  Valuation.LastChangeDateTime AS LastChangeDateTime
FROM I_ClfnObjectCharcValue AS Valuation
LEFT OUTER JOIN I_ClfnCharacteristicForKeyDate AS _Characteristic ON CharcInternalID = _Characteristic.CharcInternalID  -- association [1..1]
LEFT OUTER JOIN I_ClfnCharcValueForKeyDate AS _CharacteristicValue ON _CharacteristicValue.CharcInternalID = CharcInternalID AND _CharacteristicValue.CharcValue = CharcValue  -- association [0..*]
;

Learn More