R_ClfnClassTP

DDL: R_CLFNCLASSTP Type: view_entity TRANSACTIONAL Package: NGC_CORE_VDM

Classification Class - TP

R_ClfnClassTP is a Transactional CDS View that provides data about "Classification Class - TP" in SAP S/4HANA. It reads from 1 data source (I_ClfnClass) and exposes 37 fields with key fields Class, ClassType. It has 8 associations to related views. Part of development package NGC_CORE_VDM.

Data Sources (1)

SourceAliasJoin Type
I_ClfnClass Class from

Associations (8)

CardinalityTargetAliasCondition
[0..*] R_ClfnHistlClCharcOvrwrtnTP _HistlClassCharcOvrwrtn $projection.Class = _HistlClassCharcOvrwrtn.Class and $projection.ClassType = _HistlClassCharcOvrwrtn.ClassType
[0..*] R_ClfnHistlClCharcValOvrwrtnTP _HistlClassCharcValOverwritten $projection.Class = _HistlClassCharcValOverwritten.Class and $projection.ClassType = _HistlClassCharcValOverwritten.ClassType
[0..*] R_ClfnHistlClChVlDscOvrwrtnTP _HistClCharcValDescOverwritten $projection.Class = _HistClCharcValDescOverwritten.Class and $projection.ClassType = _HistClCharcValDescOverwritten.ClassType
[1..*] R_ClfnClassDescriptionTP _ClassDescription
[0..*] R_ClfnClassKeywordTP _ClassKeyword
[0..*] R_ClfnClassCharcTP _ClassCharacteristic
[0..*] R_ClfnHistlClassCharcTP _HistlClassCharacteristic
[0..*] R_ClfnClassOrglAreaTP _ClassOrglArea

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Classification Class - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ClassificationClass 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 (37)

KeyFieldSource TableSource FieldDescription
KEY Class I_ClfnClass Class
KEY ClassType I_ClfnClass ClassType
ClassInternalID I_ClfnClass ClassInternalID
ClassStatus I_ClfnClass ClassStatus
ClassGroup I_ClfnClass ClassGroup
ClassSearchAuthGrp I_ClfnClass ClassSearchAuthGrp
ClassClassfctnAuthGrp I_ClfnClass ClassClassfctnAuthGrp
ClassMaintAuthGrp I_ClfnClass ClassMaintAuthGrp
SameClassfctnReaction I_ClfnClass SameClassfctnReaction
ClassIsLocal I_ClfnClass ClassIsLocal
DocumentInfoRecordDocNumber I_ClfnClass DocumentInfoRecordDocNumber
DocumentInfoRecordDocType I_ClfnClass DocumentInfoRecordDocType
DocumentInfoRecordDocPart I_ClfnClass DocumentInfoRecordDocPart
DocumentInfoRecordDocVersion I_ClfnClass DocumentInfoRecordDocVersion
ClassStandardOrgName I_ClfnClass ClassStandardOrgName
ClassStandardNumber I_ClfnClass ClassStandardNumber
ClassStandardStartDate I_ClfnClass ClassStandardStartDate
ClassStandardVersionStartDate I_ClfnClass ClassStandardVersionStartDate
ClassStandardVersion I_ClfnClass ClassStandardVersion
ClassStandardCharcTable I_ClfnClass ClassStandardCharcTable
ClassBaseUnit I_ClfnClass ClassBaseUnit
ClassIsUsableInBOM I_ClfnClass ClassIsUsableInBOM
CreatedByUser I_ClfnClass CreatedByUser
LastChangedByUser I_ClfnClass LastChangedByUser
CreationDate I_ClfnClass CreationDate
LastChangeDate I_ClfnClass LastChangeDate
LastChangeDateTime I_ClfnClass ClassLastChangedDateTime
ValidityStartDate I_ClfnClass ValidityStartDate
ValidityEndDate I_ClfnClass ValidityEndDate
_ClassDescription _ClassDescription
_ClassKeyword _ClassKeyword
_ClassCharacteristic _ClassCharacteristic
_HistlClassCharacteristic _HistlClassCharacteristic
_ClassOrglArea _ClassOrglArea
_HistlClassCharcOvrwrtn _HistlClassCharcOvrwrtn
_HistlClassCharcValOverwritten _HistlClassCharcValOverwritten
_HistClCharcValDescOverwritten _HistClCharcValDescOverwritten
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Classification Class - TP'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.sapObjectNodeType.name: 'ClassificationClass'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }

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

define root view entity R_ClfnClassTP
  as select from I_ClfnClass as Class

  composition [1..*] of R_ClfnClassDescriptionTP as _ClassDescription
  composition [0..*] of R_ClfnClassKeywordTP as _ClassKeyword
  composition [0..*] of R_ClfnClassCharcTP as _ClassCharacteristic
  composition [0..*] of R_ClfnHistlClassCharcTP as _HistlClassCharacteristic
  composition [0..*] of R_ClfnClassOrglAreaTP as _ClassOrglArea

  association [0..*] to R_ClfnHistlClCharcOvrwrtnTP as _HistlClassCharcOvrwrtn
    on  $projection.Class     = _HistlClassCharcOvrwrtn.Class
    and $projection.ClassType = _HistlClassCharcOvrwrtn.ClassType
    
  association [0..*] to R_ClfnHistlClCharcValOvrwrtnTP as _HistlClassCharcValOverwritten
    on  $projection.Class     = _HistlClassCharcValOverwritten.Class
    and $projection.ClassType = _HistlClassCharcValOverwritten.ClassType
    
  association [0..*] to R_ClfnHistlClChVlDscOvrwrtnTP as _HistClCharcValDescOverwritten
    on  $projection.Class     = _HistClCharcValDescOverwritten.Class
    and $projection.ClassType = _HistClCharcValDescOverwritten.ClassType

{
  key Class.Class,
  key Class.ClassType,

      Class.ClassInternalID,

      Class.ClassStatus,
      Class.ClassGroup,
      Class.ClassSearchAuthGrp,
      Class.ClassClassfctnAuthGrp,
      Class.ClassMaintAuthGrp,
      Class.SameClassfctnReaction,
      Class.ClassIsLocal,
      Class.DocumentInfoRecordDocNumber,
      Class.DocumentInfoRecordDocType,
      Class.DocumentInfoRecordDocPart,
      Class.DocumentInfoRecordDocVersion,
      Class.ClassStandardOrgName,
      Class.ClassStandardNumber,
      Class.ClassStandardStartDate,
      Class.ClassStandardVersionStartDate,
      Class.ClassStandardVersion,
      Class.ClassStandardCharcTable,
      Class.ClassBaseUnit,
      Class.ClassIsUsableInBOM,
      Class.CreatedByUser,
      Class.LastChangedByUser,
      Class.CreationDate,
      Class.LastChangeDate,
      Class.ClassLastChangedDateTime       as LastChangeDateTime,

      @Semantics.businessDate.from: true
      Class.ValidityStartDate,

      @Semantics.businessDate.to: true
      Class.ValidityEndDate,

      _ClassDescription,
      _ClassKeyword,
      _ClassCharacteristic,
      _HistlClassCharacteristic,
      _ClassOrglArea,
      _HistlClassCharcOvrwrtn,
      _HistlClassCharcValOverwritten,
      _HistClCharcValDescOverwritten
}