I_ClfnObjectCharcValueTP

DDL: I_CLFNOBJECTCHARCVALUETP SQL: INGCCLFN04TP Type: view_entity TRANSACTIONAL Package: NGC_CORE_VDM

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. Part of development package NGC_CORE_VDM.

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
KEY CharcValuePositionNumber ObjectCharcValue CharcValuePositionNumber
KEY ClassType ObjectCharcValue ClassType
ClfnObjectInternalID ObjectCharcValue ClfnObjectInternalID
CharcValueDependency ObjectCharcValue CharcValueDependency
CharcValue ObjectCharcValue CharcValue
CharcFromNumericValue ObjectCharcValue CharcFromNumericValue
CharcFromNumericValueUnit ObjectCharcValue CharcFromNumericValueUnit
CharcToNumericValue ObjectCharcValue CharcToNumericValue
CharcToNumericValueUnit ObjectCharcValue CharcToNumericValueUnit
CharcFromDecimalValue ObjectCharcValue CharcFromDecimalValue
CharcToDecimalValue ObjectCharcValue CharcToDecimalValue
CharcFromAmount ObjectCharcValue CharcFromAmount
CharcToAmount ObjectCharcValue CharcToAmount
Currency ObjectCharcValue Currency
CharcFromDate ObjectCharcValue CharcFromDate
CharcToDate ObjectCharcValue CharcToDate
CharcFromTime ObjectCharcValue CharcFromTime
CharcToTime ObjectCharcValue CharcToTime
CharacteristicAuthor ObjectCharcValue CharacteristicAuthor
LastChangeDateTime ObjectCharcValue LastChangeDateTime
_Characteristic ObjectCharcValue _Characteristic
_ObjectCharc _ObjectCharc
_Object _Object
//@AbapCatalog.sqlViewName: 'INGCCLFN04TP'

//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
//@VDM.viewType: #COMPOSITE

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'TP for Clfn Obj Charc With Value'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

//@AbapCatalog.preserveKey: true

define view entity I_ClfnObjectCharcValueTP
   with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
   as select from I_ClfnObjectCharcValForKeyDate(P_KeyDate: $parameters.P_KeyDate) as ObjectCharcValue

    association to parent I_ClfnObjectCharcTP as _ObjectCharc on
      $projection.ClfnObjectID    = _ObjectCharc.ClfnObjectID and
      $projection.ClfnObjectTable = _ObjectCharc.ClfnObjectTable and
      $projection.CharcInternalID = _ObjectCharc.CharcInternalID and
      $projection.ClassType       = _ObjectCharc.ClassType

    association [1..1] to I_ClfnObjectTP as _Object on
      $projection.ClfnObjectID    = _Object.ClfnObjectID and
      $projection.ClfnObjectTable = _Object.ClfnObjectTable
  {
    key ObjectCharcValue.ClfnObjectID,
    key ObjectCharcValue.ClfnObjectTable,
    key ObjectCharcValue.CharcInternalID,
    key ObjectCharcValue.CharcValuePositionNumber,
    key ObjectCharcValue.ClassType,

    ObjectCharcValue.ClfnObjectInternalID,

    ObjectCharcValue.CharcValueDependency,
    ObjectCharcValue.CharcValue,
    ObjectCharcValue.CharcFromNumericValue,
    ObjectCharcValue.CharcFromNumericValueUnit,
    ObjectCharcValue.CharcToNumericValue,
    ObjectCharcValue.CharcToNumericValueUnit,
    ObjectCharcValue.CharcFromDecimalValue,
    ObjectCharcValue.CharcToDecimalValue,
//    @Semantics.amount.currencyCode: 'Currency'

    ObjectCharcValue.CharcFromAmount,
//    @Semantics.amount.currencyCode: 'Currency'

    ObjectCharcValue.CharcToAmount,
//    @Semantics.currencyCode: true

    ObjectCharcValue.Currency,
    ObjectCharcValue.CharcFromDate,
    ObjectCharcValue.CharcToDate,
    ObjectCharcValue.CharcFromTime,
    ObjectCharcValue.CharcToTime,
    ObjectCharcValue.CharacteristicAuthor,
    
    ObjectCharcValue.LastChangeDateTime,
    ObjectCharcValue._Characteristic,

    _ObjectCharc,
    _Object
  }
  where
    ObjectCharcValue.ClfnObjectType  = 'O'