I_ClfnObjectCharcValueTP

DDL: I_CLFNOBJECTCHARCVALUETP SQL: INGCCLFN04TP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 1 Associations

TP for Clfn Obj Charc With Value

I_ClfnObjectCharcValueTP is a Transactional CDS View that provides data about "TP for Clfn Obj Charc With Value" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 26 fields with key fields ClfnObjectID, ClfnObjectTable, CharcInternalID, CharcValuePositionNumber, ClassType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ClfnObjectTP _Object $projection.ClfnObjectID = _Object.ClfnObjectID and $projection.ClfnObjectTable = _Object.ClfnObjectTable

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label TP for Clfn Obj Charc With Value view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID ObjectCharcValue ClfnObjectID
KEY ClfnObjectTable ObjectCharcValue ClfnObjectTable
KEY CharcInternalID ObjectCharcValue CharcInternalID Characteristic Internal ID
KEY CharcValuePositionNumber ObjectCharcValue CharcValuePositionNumber
KEY ClassType ObjectCharcValue ClassType X Flag
ClfnObjectInternalID ObjectCharcValue ClfnObjectInternalID
CharcValueDependency ObjectCharcValue CharcValueDependency Code
CharcValue ObjectCharcValue CharcValue Char. Value
CharcFromNumericValue ObjectCharcValue CharcFromNumericValue Value from
CharcFromNumericValueUnit ObjectCharcValue CharcFromNumericValueUnit Internal UoM
CharcToNumericValue ObjectCharcValue CharcToNumericValue Value to
CharcToNumericValueUnit ObjectCharcValue CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue ObjectCharcValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue ObjectCharcValue CharcToDecimalValue UprBndry Nmrc
CharcFromAmount ObjectCharcValue CharcFromAmount LowrBndry Crcy
CharcToAmount ObjectCharcValue CharcToAmount UprBndry Crcy
Currency ObjectCharcValue Currency Valuation Crcy
CharcFromDate ObjectCharcValue CharcFromDate LowrBndry Date
CharcToDate ObjectCharcValue CharcToDate UprBndry Date
CharcFromTime ObjectCharcValue CharcFromTime LowrBndry Time
CharcToTime ObjectCharcValue CharcToTime UprBndry Time
CharacteristicAuthor ObjectCharcValue CharacteristicAuthor
LastChangeDateTime ObjectCharcValue LastChangeDateTime Timestamp
_Characteristic ObjectCharcValue _Characteristic
_ObjectCharc _ObjectCharc
_Object _Object

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_ClfnObjectCharcValueTP.
-- 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: INGCCLFN04TP
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnObjectCharcValueTP AS
SELECT
  ObjectCharcValue.ClfnObjectID AS ClfnObjectID,
  ObjectCharcValue.ClfnObjectTable AS ClfnObjectTable,
  ObjectCharcValue.CharcInternalID AS CharcInternalID,
  ObjectCharcValue.CharcValuePositionNumber AS CharcValuePositionNumber,
  ObjectCharcValue.ClassType AS ClassType,
  ObjectCharcValue.ClfnObjectInternalID AS ClfnObjectInternalID,
  ObjectCharcValue.CharcValueDependency AS CharcValueDependency,
  ObjectCharcValue.CharcValue AS CharcValue,
  ObjectCharcValue.CharcFromNumericValue AS CharcFromNumericValue,
  ObjectCharcValue.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  ObjectCharcValue.CharcToNumericValue AS CharcToNumericValue,
  ObjectCharcValue.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  ObjectCharcValue.CharcFromDecimalValue AS CharcFromDecimalValue,
  ObjectCharcValue.CharcToDecimalValue AS CharcToDecimalValue,
  ObjectCharcValue.CharcFromAmount AS CharcFromAmount,
  ObjectCharcValue.CharcToAmount AS CharcToAmount,
  ObjectCharcValue.Currency AS Currency,
  ObjectCharcValue.CharcFromDate AS CharcFromDate,
  ObjectCharcValue.CharcToDate AS CharcToDate,
  ObjectCharcValue.CharcFromTime AS CharcFromTime,
  ObjectCharcValue.CharcToTime AS CharcToTime,
  ObjectCharcValue.CharacteristicAuthor AS CharacteristicAuthor,
  ObjectCharcValue.LastChangeDateTime AS LastChangeDateTime,
  ObjectCharcValue._Characteristic AS _Characteristic
FROM I_ClfnObjectCharcValForKeyDate
LEFT OUTER JOIN I_ClfnObjectTP AS _Object ON ClfnObjectID = _Object.ClfnObjectID AND ClfnObjectTable = _Object.ClfnObjectTable  -- association [1..1]
;

Learn More