I_ConfignCharcGroupForKeyDate

DDL: I_CONFIGNCHARCGROUPFORKEYDATE SQL: IVCHHLGRPKEYDATE Type: view COMPOSITE

OBSOLETE: Conf Charc Group for Key Date

I_ConfignCharcGroupForKeyDate is a Composite CDS View that provides data about "OBSOLETE: Conf Charc Group for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ConfignCharacteristicGroup) and exposes 13 fields with key field ConfignCharacteristicGroup. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharacteristicGroup Grp from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ConfignCharcGrpDescForKeyDte _Description _Description.ConfignCharacteristicGroup = $projection.ConfignCharacteristicGroup and _Description.Language = $session.system_language
[0..*] I_ConfignCharcGrpAllocForDate _Characteristic _Characteristic.ConfignCharacteristicGroup = $projection.ConfignCharacteristicGroup

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IVCHHLGRPKEYDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.compositionRoot true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label OBSOLETE: Conf Charc Group for Key Date view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup ConfignCharacteristicGroup
ChangeNumber ChangeNumber
TimeIntervalNumber TimeIntervalNumber
KeyDate
ConfignCharcGroupIsDefault ConfignCharcGroupIsDefault
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
_Description _Description
_Characteristic _Characteristic 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IVCHHLGRPKEYDATE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.compositionRoot: true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'OBSOLETE: Conf Charc Group for Key Date'
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */

define view I_ConfignCharcGroupForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date
  as select from I_ConfignCharacteristicGroup as Grp
  association [0..1] to I_ConfignCharcGrpDescForKeyDte as _Description    on  _Description.ConfignCharacteristicGroup = $projection.ConfignCharacteristicGroup
                                                                          and _Description.Language                   = $session.system_language
  association [0..*] to I_ConfignCharcGrpAllocForDate  as _Characteristic on  _Characteristic.ConfignCharacteristicGroup = $projection.ConfignCharacteristicGroup

{
  key ConfignCharacteristicGroup,

      ChangeNumber,
      TimeIntervalNumber,
      $parameters.P_KeyDate as KeyDate,
      ConfignCharcGroupIsDefault,
      ValidityStartDate,
      ValidityEndDate,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Description,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Characteristic
}
where
      Grp.ValidityStartDate <= $parameters.P_KeyDate
  and Grp.ValidityEndDate   >= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONFIGNCHARACTERISTICGROUP"
],
"ASSOCIATED":
[
"I_CONFIGNCHARCGRPALLOCFORDATE",
"I_CONFIGNCHARCGRPDESCFORKEYDTE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More