I_ClfnClassCharcForKeyDate

DDL: I_CLFNCLASSCHARCFORKEYDATE SQL: INGCCLS8 Type: view COMPOSITE

Charc of Clfn Class for Key Date

I_ClfnClassCharcForKeyDate is a Composite CDS View that provides data about "Charc of Clfn Class for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnClassHierCharcForKeyDate) and exposes 16 fields with key fields ClassInternalID, CharcInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ClfnClassHierCharcForKeyDate I_ClfnClassHierCharcForKeyDate 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 (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLS8 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Charc 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 CharcInternalID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ClassInternalID ClassInternalID
KEY CharcInternalID CharcInternalID
CharcPositionNumber CharcPositionNumber
Characteristic Characteristic
AncestorClassInternalID AncestorClassInternalID
ClassType ClassType
ChangeNumber ChangeNumber
CharcIsPrintRelevant CharcIsPrintRelevant
CharcIsSearchRelevant CharcIsSearchRelevant
CharcIsDisplayRelevant CharcIsDisplayRelevant
CharcIsProposalRelevant CharcIsProposalRelevant
CharcIsPrptnOrProdUnitRelevant CharcIsPrptnOrProdUnitRelevant
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_Class _Class
_Characteristic _Characteristic
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCLS8'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Charc of Clfn Class for Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'CharcInternalID'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_ClfnClassCharcForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnClassHierCharcForKeyDate( P_KeyDate : $parameters.P_KeyDate )      
      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 
{
  //currently no information is returned about overwritten characteristics in this level

  
  //filtering out not valid characteristics happens in I_ClfnClassHierCharcForKeyDate

  //via extending the where condition 

  
      @ObjectModel.foreignKey.association: '_Class'
  key ClassInternalID, 
  key CharcInternalID, 
  CharcPositionNumber, 
  Characteristic,
  AncestorClassInternalID, 
  ClassType,
  ChangeNumber, 
  CharcIsPrintRelevant, 
  CharcIsSearchRelevant, 
  CharcIsDisplayRelevant, 
  CharcIsProposalRelevant,
  CharcIsPrptnOrProdUnitRelevant,
  ValidityStartDate, 
  ValidityEndDate, 
  
  _Class,
  _Characteristic
}

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