I_ClfnObjectCharcForKeyDate

DDL: I_CLFNOBJECTCHARCFORKEYDATE SQL: INGCCLFN16 Type: view COMPOSITE

Clfn Object Characteristic For Key Date

I_ClfnObjectCharcForKeyDate is a Composite CDS View that provides data about "Clfn Object Characteristic For Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharc) and exposes 13 fields with key fields ClfnObjectID, ClfnObjectTable, ClfnObjectType, ClassInternalID, CharcInternalID. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharc ObjectCharc from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnClassForKeyDate _Class $projection.ClassInternalID = _Class.ClassInternalID
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLFN16 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Clfn Object Characteristic For Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectCharc ClfnObjectID
KEY ClfnObjectTable I_ClfnObjectCharc ClfnObjectTable
KEY ClfnObjectType I_ClfnObjectCharc ClfnObjectType
KEY ClassInternalID I_ClfnObjectCharc ClassInternalID
KEY CharcInternalID I_ClfnObjectCharc CharcInternalID
ClfnObjectInternalID I_ClfnObjectCharc ClfnObjectInternalID
ClassType I_ClfnObjectCharc ClassType
ChangeNumber I_ClfnObjectCharc ChangeNumber
ValidityStartDate I_ClfnObjectCharc ValidityStartDate
ValidityEndDate I_ClfnObjectCharc ValidityEndDate
LastChangeDateTime I_ClfnObjectCharc LastChangeDateTime
_Class _Class
_Characteristic _Characteristic 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCLFN16'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Clfn Object Characteristic For Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view I_ClfnObjectCharcForKeyDate 
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnObjectCharc as ObjectCharc 
  
      association [1..1] to I_ClfnClassForKeyDate as _Class 
        on $projection.ClassInternalID = _Class.ClassInternalID 
      association [1..1] to I_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID 
{
  key ObjectCharc.ClfnObjectID,
  key ObjectCharc.ClfnObjectTable,
  key ObjectCharc.ClfnObjectType,
  key ObjectCharc.ClassInternalID,
  key ObjectCharc.CharcInternalID,
      ObjectCharc.ClfnObjectInternalID,      
      ObjectCharc.ClassType,
      ObjectCharc.ChangeNumber,
      @Semantics.businessDate.from: true
      ObjectCharc.ValidityStartDate,
      @Semantics.businessDate.to: true
      ObjectCharc.ValidityEndDate,
      ObjectCharc.LastChangeDateTime,
      
      _Class,
      _Characteristic     
}
  where ValidityStartDate   <= $parameters.P_KeyDate
    and ValidityEndDate     >= $parameters.P_KeyDate
    and IsDeleted           = ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNOBJECTCHARC"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNCLASSFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More