I_ClfnClassKeywordForKeyDate

DDL: I_CLFNCLASSKEYWORDFORKEYDATE SQL: INGCCLS14 Type: view COMPOSITE Package: NGC_CORE_VDM

Keyword of Clfn Class for Key Date

I_ClfnClassKeywordForKeyDate is a Composite CDS View that provides data about "Keyword of Clfn Class for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnClassKeyword) and exposes 6 fields with key fields ClassInternalID, Language, ClassKeywordPositionNumber. It has 1 association to related views. Part of development package NGC_CORE_VDM.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnClassKeyword ClassKeyword from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ClfnClassForKeyDate _Class $projection.ClassInternalID = _Class.ClassInternalID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLS14 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Keyword of Clfn Class for Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ClassKeywordPositionNumber view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ClassInternalID I_ClfnClassKeyword ClassInternalID
KEY Language I_ClfnClassKeyword Language
KEY ClassKeywordPositionNumber I_ClfnClassKeyword ClassKeywordPositionNumber
ClassKeywordText I_ClfnClassKeyword ClassKeywordText
_Language _Language
_Class _Class 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCLS14'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Keyword of Clfn Class for Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'ClassKeywordPositionNumber'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
// Although we know that class keyword is a time independent data,

// this view was introduced to be able to cut time dependent business layer

// completely from time independent one. (Plus P_KeyDate is used in DCL.)

define view I_ClfnClassKeywordForKeyDate 
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate :sydate
  as select from I_ClfnClassKeyword as ClassKeyword
      association [1..1] to I_ClfnClassForKeyDate as _Class 
        on $projection.ClassInternalID = _Class.ClassInternalID         
{
      @ObjectModel.foreignKey.association: '_Class'
  key ClassKeyword.ClassInternalID,
      @Semantics.language: true
  key ClassKeyword.Language,
  key ClassKeyword.ClassKeywordPositionNumber,
      @Semantics.text: true
      ClassKeyword.ClassKeywordText,

      _Language,
      _Class
}

Learn More