R_VarConfignCharcGroupTP

DDL: R_VARCONFIGNCHARCGROUPTP Type: view_entity TRANSACTIONAL

OBSOLETE: Variant Confign Charc Group

R_VarConfignCharcGroupTP is a Transactional CDS View that provides data about "OBSOLETE: Variant Confign Charc Group" in SAP S/4HANA. It reads from 1 data source (I_ConfignCharacteristicGroup) and exposes 13 fields with key fields ConfignCharacteristicGroup, ChangeNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharacteristicGroup GroupDef from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ConfignCharcGrpAllocCount _CsticCount $projection.ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup and $projection.ChangeNumber = _CsticCount.ChangeNumber
[0..*] R_VarConfignCharcGroupText _GroupTxt
[0..*] R_VarConfignCharcGroupAlloc _CharcAlloc

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label OBSOLETE: Variant Confign Charc Group view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name VarConfignCharacteristicGroup view
VDM.viewType #TRANSACTIONAL view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
Search.searchable true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharacteristicGroup ConfignCharacteristicGroup
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber
TimeIntervalNumber I_ConfignCharacteristicGroup TimeIntervalNumber
ConfignCharcGroupIsDefault I_ConfignCharacteristicGroup ConfignCharcGroupIsDefault
ValidityStartDate I_ConfignCharacteristicGroup ValidityStartDate
ValidityEndDate I_ConfignCharacteristicGroup ValidityEndDate
CreatedByUser I_ConfignCharacteristicGroup CreatedByUser
CreationDate I_ConfignCharacteristicGroup CreationDate
LastChangedByUser I_ConfignCharacteristicGroup LastChangedByUser
LastChangeDate I_ConfignCharacteristicGroup LastChangeDate
NumberOfCharacteristics _CsticCount NumberOfCharacteristics
_GroupTxt _GroupTxt
_CharcAlloc _CharcAlloc
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'OBSOLETE: Variant Confign Charc Group'

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.sapObjectNodeType.name: 'VarConfignCharacteristicGroup'
@VDM.viewType: #TRANSACTIONAL
@VDM.private:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.modelCategory: #BUSINESS_OBJECT
@Search.searchable: true

define root view entity R_VarConfignCharcGroupTP

  as select from I_ConfignCharacteristicGroup as GroupDef

  composition [0..*] of R_VarConfignCharcGroupText  as _GroupTxt
  composition [0..*] of R_VarConfignCharcGroupAlloc as _CharcAlloc

  association [0..1] to I_ConfignCharcGrpAllocCount as _CsticCount on  $projection.ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup
                                                                   and $projection.ChangeNumber               = _CsticCount.ChangeNumber

{
      @Search.defaultSearchElement: true
  key GroupDef.ConfignCharacteristicGroup,

  key GroupDef.ChangeNumber,

      GroupDef.TimeIntervalNumber,

      GroupDef.ConfignCharcGroupIsDefault,

      @Semantics.businessDate.from
      GroupDef.ValidityStartDate,

      @Semantics.businessDate.to
      GroupDef.ValidityEndDate,

      @Semantics.user.createdBy
      GroupDef.CreatedByUser,

      @Semantics.systemDate.createdAt
      GroupDef.CreationDate,

      @Semantics.user.lastChangedBy
      GroupDef.LastChangedByUser,

      @Semantics.systemDate.lastChangedAt
      GroupDef.LastChangeDate,

      _CsticCount.NumberOfCharacteristics as NumberOfCharacteristics,

      _GroupTxt,
      _CharcAlloc

}