R_ClfnHistlObjectCharcTP

DDL: R_CLFNHISTLOBJECTCHARCTP Type: view_entity TRANSACTIONAL

Clfn Historical Object Charc - TP

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

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharc ObjectCharc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ClfnObjectTP _Object $projection.ClfnObjectID = _Object.ClfnObjectID and $projection.ClfnObjectTable = _Object.ClfnObjectTable
[1..1] I_ClfnClass _Class $projection.ClassInternalID = _Class.ClassInternalID

Annotations (9)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectCharc ClfnObjectID
KEY ClfnObjectTable I_ClfnObjectCharc ClfnObjectTable
KEY ChangeNumber I_ClfnObjectCharc ChangeNumber
KEY ClassType I_ClfnObjectCharc ClassType
KEY CharcInternalID I_ClfnObjectCharc CharcInternalID
KEY ClassInternalID I_ClfnObjectCharc ClassInternalID
ClfnObjectInternalID I_ClfnObjectCharc ClfnObjectInternalID
LastChangeDateTime I_ClfnObjectCharc LastChangeDateTime
ValidityStartDate I_ClfnObjectCharc ValidityStartDate
ValidityEndDate I_ClfnObjectCharc ValidityEndDate
_Characteristic I_ClfnObjectCharc _Characteristic
IsDeleted I_ClfnObjectCharc IsDeleted
_Object _Object
_Class _Class
_ObjectCharc _ObjectCharc 
@EndUserText.label: 'Clfn Historical Object Charc - TP'

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

@Metadata.ignorePropagatedAnnotations: true

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

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

define view entity R_ClfnHistlObjectCharcTP
as select from I_ClfnObjectCharc as ObjectCharc
  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..1] to I_ClfnClass as _Class on 
    $projection.ClassInternalID = _Class.ClassInternalID 
{
  key ObjectCharc.ClfnObjectID,
  key ObjectCharc.ClfnObjectTable,
  key ObjectCharc.ChangeNumber,
  key ObjectCharc.ClassType,
  key ObjectCharc.CharcInternalID,
  key ObjectCharc.ClassInternalID,

  ObjectCharc.ClfnObjectInternalID,

  ObjectCharc.LastChangeDateTime,

  @Semantics.businessDate.from: true
  ObjectCharc.ValidityStartDate,
  @Semantics.businessDate.to: true
  ObjectCharc.ValidityEndDate,

  ObjectCharc._Characteristic,
  ObjectCharc.IsDeleted,

  _Object,
  _Class,
  _ObjectCharc
}
where
  ObjectCharc.ClfnObjectType  = 'O' 
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNOBJECTCHARC"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTIC",
"I_CLFNCLASS",
"R_CLFNOBJECTCHARCTP",
"R_CLFNOBJECTTP"
],
"BASE":
[
"I_CLFNOBJECTCHARC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More