R_ClfnHistlObjectCharcValTP

DDL: R_CLFNHISTLOBJECTCHARCVALTP Type: view_entity TRANSACTIONAL

Clfn Historical Object Charc Val - TP

R_ClfnHistlObjectCharcValTP is a Transactional CDS View that provides data about "Clfn Historical Object Charc Val - TP" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValue) and exposes 32 fields with key fields ClfnObjectID, ClfnObjectTable, ChangeNumber, ClassType, CharcInternalID. It has 2 associations to related views.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValue ObjectCharcValue from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ClfnObjectTP _Object $projection.ClfnObjectID = _Object.ClfnObjectID and $projection.ClfnObjectTable = _Object.ClfnObjectTable
[1..*] R_ClfnHistlObjectCharcTP _HistlObjectCharc $projection.ClfnObjectID = _HistlObjectCharc.ClfnObjectID and $projection.ClfnObjectTable = _HistlObjectCharc.ClfnObjectTable and $projection.ChangeNumber = _HistlObjectCharc.ChangeNumber and $projection.ClassType = _HistlObjectCharc.ClassType and $projection.CharcInternalID = _HistlObjectCharc.CharcInternalID

Annotations (9)

NameValueLevelField
EndUserText.label Clfn Historical Object Charc Val - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectCharcValue ClfnObjectID
KEY ClfnObjectTable I_ClfnObjectCharcValue ClfnObjectTable
KEY ChangeNumber I_ClfnObjectCharcValue ChangeNumber
KEY ClassType I_ClfnObjectCharcValue ClassType
KEY CharcInternalID I_ClfnObjectCharcValue CharcInternalID
KEY ClfnCharcValuePositionNumber I_ClfnObjectCharcValue CharcValuePositionNumber
KEY TimeIntervalNumber I_ClfnObjectCharcValue TimeIntervalNumber
ClfnObjectInternalID I_ClfnObjectCharcValue ClfnObjectInternalID
CharcValueIntervalType I_ClfnObjectCharcValue CharcValueIntervalType
CharcValue I_ClfnObjectCharcValue CharcValue
CharcFromNumericValue I_ClfnObjectCharcValue CharcFromNumericValue
CharcFromNumericValueUnit I_ClfnObjectCharcValue CharcFromNumericValueUnit
CharcToNumericValue I_ClfnObjectCharcValue CharcToNumericValue
CharcToNumericValueUnit I_ClfnObjectCharcValue CharcToNumericValueUnit
CharcFromDecimalValue I_ClfnObjectCharcValue CharcFromDecimalValue
CharcToDecimalValue I_ClfnObjectCharcValue CharcToDecimalValue
CharcFromAmount I_ClfnObjectCharcValue CharcFromAmount
CharcToAmount I_ClfnObjectCharcValue CharcToAmount
Currency I_ClfnObjectCharcValue Currency
CharcFromDate I_ClfnObjectCharcValue CharcFromDate
CharcToDate I_ClfnObjectCharcValue CharcToDate
CharcFromTime I_ClfnObjectCharcValue CharcFromTime
CharcToTime I_ClfnObjectCharcValue CharcToTime
CharcAuthor I_ClfnObjectCharcValue CharacteristicAuthor
IsDeleted I_ClfnObjectCharcValue IsDeleted
LastChangeDateTime I_ClfnObjectCharcValue LastChangeDateTime
ValidityStartDate I_ClfnObjectCharcValue ValidityStartDate
ValidityEndDate I_ClfnObjectCharcValue ValidityEndDate
_Characteristic I_ClfnObjectCharcValue _Characteristic
_Object _Object
_HistlObjectCharc _HistlObjectCharc
_ObjectCharc _ObjectCharc 
@EndUserText.label: 'Clfn Historical Object Charc Val - TP'

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_ClfnHistlObjectCharcValTP
as select from I_ClfnObjectCharcValue as ObjectCharcValue
  association to parent R_ClfnObjectCharcTP as _ObjectCharc on
    $projection.ClfnObjectID    = _ObjectCharc.ClfnObjectID and
    $projection.ClfnObjectTable = _ObjectCharc.ClfnObjectTable and
    $projection.ClassType       = _ObjectCharc.ClassType and
    $projection.CharcInternalID = _ObjectCharc.CharcInternalID

  association [1..1] to R_ClfnObjectTP as _Object on
    $projection.ClfnObjectID    = _Object.ClfnObjectID and
    $projection.ClfnObjectTable = _Object.ClfnObjectTable

  association [1..*] to R_ClfnHistlObjectCharcTP as _HistlObjectCharc on
    $projection.ClfnObjectID    = _HistlObjectCharc.ClfnObjectID and
    $projection.ClfnObjectTable = _HistlObjectCharc.ClfnObjectTable and
    $projection.ChangeNumber    = _HistlObjectCharc.ChangeNumber and
    $projection.ClassType       = _HistlObjectCharc.ClassType and
    $projection.CharcInternalID = _HistlObjectCharc.CharcInternalID
{
  key ObjectCharcValue.ClfnObjectID,
  key ObjectCharcValue.ClfnObjectTable,
  key ObjectCharcValue.ChangeNumber,
  key ObjectCharcValue.ClassType,
  key ObjectCharcValue.CharcInternalID,
  key ObjectCharcValue.CharcValuePositionNumber as ClfnCharcValuePositionNumber,
  key ObjectCharcValue.TimeIntervalNumber,

  ObjectCharcValue.ClfnObjectInternalID,

  ObjectCharcValue.CharcValueIntervalType,
  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,
  ObjectCharcValue.Currency,
  ObjectCharcValue.CharcFromDate,
  ObjectCharcValue.CharcToDate,
  ObjectCharcValue.CharcFromTime,
  ObjectCharcValue.CharcToTime,
  ObjectCharcValue.CharacteristicAuthor as CharcAuthor,
  ObjectCharcValue.IsDeleted,

  ObjectCharcValue.LastChangeDateTime,

  @Semantics.businessDate.from: true
  ObjectCharcValue.ValidityStartDate,
  @Semantics.businessDate.to: true
  ObjectCharcValue.ValidityEndDate,
  ObjectCharcValue._Characteristic,

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

Learn More