I_Relstartcharinclass

DDL: I_RELSTARTCHARINCLASS SQL: IRELCHARINCLASS Type: view BASIC

Characteristic of Class

I_Relstartcharinclass is a Basic CDS View that provides data about "Characteristic of Class" in SAP S/4HANA. It reads from 1 data source (ksml) and exposes 14 fields with key fields InternalClassNumber, CharacteristicInternalID, RelStrgyClassPositionNumber, ArchivingObject. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
ksml ksml from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Relstratclass _Relstratclass $projection.InternalClassNumber = _Relstratclass.InternalClassNumber
[1..1] I_Relstartchar _Relstartchar $projection.CharacteristicInternalID = _Relstartchar.CharacteristicInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRELCHARINCLASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic of Class view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InternalClassNumber clint
KEY CharacteristicInternalID imerk
KEY RelStrgyClassPositionNumber posnr
KEY ArchivingObject adzhl
DatabaseTable _Relstartchar DatabaseTable
DatabaseTableFieldName _Relstartchar DatabaseTableFieldName
ValidityStartDate _Relstartchar ValidFrom
CreatedByUser _Relstartchar CreatedByUser
LastChangedByUser _Relstartchar LastChangedByUser
OriginalStatusText _Relstartchar OriginalStatusText
CharacteristicDescription _Relstartchar CharacteristicDescription
CharacteristicValueDescription _Relstartchar CharacteristicValueDescription
RelStrgyClAuthorizationGroup _Relstratclass RelStrgyClAuthorizationGroup
_Relstratclass _Relstratclass 
@AbapCatalog.sqlViewName: 'IRELCHARINCLASS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Characteristic of Class'
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory:#M
@ObjectModel.usageType.dataClass:#MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API


define view I_Relstartcharinclass
  as select from ksml

  association [1..1] to I_Relstratclass as _Relstratclass on $projection.InternalClassNumber = _Relstratclass.InternalClassNumber

  association [1..1] to I_Relstartchar  as _Relstartchar  on $projection.CharacteristicInternalID = _Relstartchar.CharacteristicInternalID

{

  key  clint as  InternalClassNumber,
  key  imerk as  CharacteristicInternalID,
  //key cast(imerk as atinn_no_conv preserving type)         as    CharacteristicInternalID,

  key  posnr as  RelStrgyClassPositionNumber,
  key  adzhl as  ArchivingObject,
       _Relstartchar.DatabaseTable,
       _Relstartchar.DatabaseTableFieldName,
      // _Relstartchar.ValidityStartDate,

       _Relstartchar.ValidFrom as ValidityStartDate,      
       _Relstartchar.CreatedByUser,
       _Relstartchar.LastChangedByUser,
       _Relstartchar.OriginalStatusText,      
       _Relstartchar.CharacteristicDescription,
       _Relstartchar.CharacteristicValueDescription,
       _Relstratclass.RelStrgyClAuthorizationGroup,
       @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT , #TO_COMPOSITION_ROOT ]
       _Relstratclass

}

where
  clint = _Relstratclass.InternalClassNumber

Learn More