R_ClfnHistlObjectClassTP

DDL: R_CLFNHISTLOBJECTCLASSTP Type: view_entity TRANSACTIONAL

Clfn Historical Object Class - TP

R_ClfnHistlObjectClassTP is a Transactional CDS View that provides data about "Clfn Historical Object Class - TP" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectClass) and exposes 15 fields with key fields ClfnObjectID, ClfnObjectTable, ChangeNumber, ClassInternalID.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectClass ObjectClass from

Annotations (9)

NameValueLevelField
EndUserText.label Clfn Historical Object Class - 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_ClfnObjectClass ClfnObjectID
KEY ClfnObjectTable I_ClfnObjectClass ClfnObjectTable
KEY ChangeNumber I_ClfnObjectClass ChangeNumber
KEY ClassInternalID I_ClfnObjectClass ClassInternalID
ClassType I_ClfnObjectClass ClassType
ClfnObjectInternalID I_ClfnObjectClass ClfnObjectInternalID
ClassPositionNumber I_ClfnObjectClass ClassPositionNumber
ClfnStatus I_ClfnObjectClass ClfnStatus
ClassIsStandardClass I_ClfnObjectClass ClassIsStandardClass
LastChangeDateTime I_ClfnObjectClass LastChangeDateTime
ValidityStartDate I_ClfnObjectClass ValidityStartDate
ValidityEndDate I_ClfnObjectClass ValidityEndDate
IsDeleted I_ClfnObjectClass IsDeleted
_Class I_ClfnObjectClass _Class
_Object _Object
@EndUserText.label: 'Clfn Historical Object Class - 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_ClfnHistlObjectClassTP
as select from I_ClfnObjectClass as ObjectClass
  association to parent R_ClfnObjectTP as _Object on
    $projection.ClfnObjectID    = _Object.ClfnObjectID and
    $projection.ClfnObjectTable = _Object.ClfnObjectTable
{
  key ObjectClass.ClfnObjectID,
  key ObjectClass.ClfnObjectTable,
  key ObjectClass.ChangeNumber,
  key ObjectClass.ClassInternalID,

  ObjectClass.ClassType,
  ObjectClass.ClfnObjectInternalID,
  ObjectClass.ClassPositionNumber,
  ObjectClass.ClfnStatus,
  ObjectClass.ClassIsStandardClass,

  ObjectClass.LastChangeDateTime,

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

  //Need for delete with change number

  ObjectClass.IsDeleted,

  ObjectClass._Class,
  _Object
}
// where IsDeleted <> 'X' Need for delete with change number