R_VarConfignCharcGroupAlloc

DDL: R_VARCONFIGNCHARCGROUPALLOC Type: view_entity COMPOSITE

OBSOLETE: Confign Charc Grp Cstic Alloc

R_VarConfignCharcGroupAlloc is a Composite CDS View that provides data about "OBSOLETE: Confign Charc Grp Cstic Alloc" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcBasic, I_ConfignCharcGroupAlloc, I_ConfignCharacteristicGroup) and exposes 11 fields with key fields ConfignCharacteristicGroup, ChangeNumber, CharacteristicInternalID.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcBasic _CsticDef left_outer
I_ConfignCharcGroupAlloc CsticAlloc from
I_ConfignCharacteristicGroup GroupDef inner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label OBSOLETE: Confign Charc Grp Cstic Alloc view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ConfignCharacteristicGroup view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharcGroupAlloc ConfignCharacteristicGroup
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber
KEY CharacteristicInternalID I_ConfignCharcGroupAlloc CharcInternalID
TimeIntervalNumber I_ConfignCharcGroupAlloc TimeIntervalNumber
SortingNumber I_ConfignCharcGroupAlloc SortingNumber
Characteristic I_ClfnCharcBasic Characteristic
CreatedByUser I_ConfignCharcGroupAlloc CreatedByUser
CreationDate I_ConfignCharcGroupAlloc CreationDate
LastChangedByUser I_ConfignCharcGroupAlloc LastChangedByUser
LastChangeDate I_ConfignCharcGroupAlloc LastChangeDate
_GroupDef _GroupDef 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'OBSOLETE: Confign Charc Grp Cstic Alloc'

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@VDM.private:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ConfignCharacteristicGroup'

define view entity R_VarConfignCharcGroupAlloc

  as select from    I_ConfignCharcGroupAlloc     as CsticAlloc

    inner join      I_ConfignCharacteristicGroup as GroupDef  on  GroupDef.ConfignCharacteristicGroup = CsticAlloc.ConfignCharacteristicGroup
                                                              and GroupDef.TimeIntervalNumber         = CsticAlloc.TimeIntervalNumber

    left outer join I_ClfnCharcBasic             as _CsticDef on  CsticAlloc.CharcInternalID =  _CsticDef.CharcInternalID
                                                              and _CsticDef.IsDeleted        <> 'X'

  association to parent R_VarConfignCharcGroupTP as _GroupDef on  $projection.ConfignCharacteristicGroup = _GroupDef.ConfignCharacteristicGroup
                                                              and $projection.ChangeNumber         = _GroupDef.ChangeNumber

{
  key     CsticAlloc.ConfignCharacteristicGroup,

  key     GroupDef.ChangeNumber,

  key     CsticAlloc.CharcInternalID as CharacteristicInternalID,

          CsticAlloc.TimeIntervalNumber,

          CsticAlloc.SortingNumber,

          _CsticDef.Characteristic   as Characteristic,

          @Semantics.user.createdBy
          CsticAlloc.CreatedByUser,

          @Semantics.systemDate.createdAt
          CsticAlloc.CreationDate,

          @Semantics.user.lastChangedBy
          CsticAlloc.LastChangedByUser,

          @Semantics.systemDate.lastChangedAt
          CsticAlloc.LastChangeDate,

          _GroupDef

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCBASIC",
"I_CONFIGNCHARACTERISTICGROUP",
"I_CONFIGNCHARCGROUPALLOC"
],
"ASSOCIATED":
[
"R_VARCONFIGNCHARCGROUPTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More