I_ConfignCharcGrpDescForKeyDte

DDL: I_CONFIGNCHARCGRPDESCFORKEYDTE SQL: IVCHHLGRPTKEYDAT Type: view COMPOSITE

OBSOLETE: Conf Charc Grp Desc for KeyDte

I_ConfignCharcGrpDescForKeyDte is a Composite CDS View that provides data about "OBSOLETE: Conf Charc Grp Desc for KeyDte" in SAP S/4HANA. It reads from 2 data sources (I_ConfignCharcGroupDesc, I_ConfignCharacteristicGroup) and exposes 4 fields with key fields ConfignCharacteristicGroup, Language.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_ConfignCharcGroupDesc Desc from
I_ConfignCharacteristicGroup Grp inner

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IVCHHLGRPTKEYDAT 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.dataCategory #TEXT view
ObjectModel.representativeKey ConfignCharacteristicGroup view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label OBSOLETE: Conf Charc Grp Desc for KeyDte view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharcGroupDesc ConfignCharacteristicGroup
KEY Language I_ConfignCharcGroupDesc Language
ConfignCharacteristicGroupDesc I_ConfignCharcGroupDesc ConfignCharacteristicGroupDesc
TimeIntervalNumber I_ConfignCharcGroupDesc TimeIntervalNumber 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IVCHHLGRPTKEYDAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ConfignCharacteristicGroup'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'OBSOLETE: Conf Charc Grp Desc for KeyDte'
define view I_ConfignCharcGrpDescForKeyDte
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date

  as select from I_ConfignCharcGroupDesc      as Desc
    inner join   I_ConfignCharacteristicGroup as Grp on  Grp.ConfignCharacteristicGroup = Desc.ConfignCharacteristicGroup
                                                     and Grp.TimeIntervalNumber         = Desc.TimeIntervalNumber
                                                     and Grp.ValidityStartDate          <= $parameters.P_KeyDate
                                                     and Grp.ValidityEndDate            >= $parameters.P_KeyDate
{
  key Desc.ConfignCharacteristicGroup,
      @Semantics.language: true
  key Desc.Language,

      @Semantics.text: true
      Desc.ConfignCharacteristicGroupDesc as ConfignCharacteristicGroupDesc,
      
      Desc.TimeIntervalNumber as TimeIntervalNumber
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONFIGNCHARACTERISTICGROUP",
"I_CONFIGNCHARCGROUPDESC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More