R_VarCnfCharcGroupTP_2

DDL: R_VARCNFCHARCGROUPTP_2 Type: view_entity TRANSACTIONAL

Variant Confign Characteristic Group

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

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharacteristicGroup Grp from

Associations (5)

CardinalityTargetAliasCondition
[0..1] R_VarCnfUIExtensionTP _VarCnfUIExtension $projection.VarCnfUIExtensionUUID = _VarCnfUIExtension.VarCnfUIExtensionUUID
[0..1] R_VarCnfCharcGroupTextTP_2 _ConfignCharcGroupDescSysLang $projection.ConfignCharacteristicGroup = _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroup and $projection.ChangeNumber = _ConfignCharcGroupDescSysLang.ChangeNumber and _ConfignCharcGroupDescSysLang.Language = $session.system_language
[0..1] I_ConfignCharcGrpAllocCount _CsticCount $projection.ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup and $projection.ChangeNumber = _CsticCount.ChangeNumber
[0..*] R_VarCnfCharcGroupTextTP_2 _Text
[0..*] R_VarCnfCharcGroupAllocTP_2 _CharcAllocation

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
VDM.private false view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ConfignCharacteristicGroup view
ObjectModel.sapObjectNodeType.name VarConfignCharacteristicGroup view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Variant Confign Characteristic Group view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharacteristicGroup ConfignCharacteristicGroup
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber
TimeIntervalNumber I_ConfignCharacteristicGroup TimeIntervalNumber
ConfignCharcGroupIsDefault I_ConfignCharacteristicGroup ConfignCharcGroupIsDefault
VarCnfUIExtensionUUID I_ConfignCharacteristicGroup VarCnfUIExtensionUUID
ConfignCharacteristicGroupDesc _ConfignCharcGroupDescSysLang ConfignCharacteristicGroupDesc
NumberOfCharacteristics _CsticCount NumberOfCharacteristics
ValidityStartDate I_ConfignCharacteristicGroup ValidityStartDate
ValidityEndDate I_ConfignCharacteristicGroup ValidityEndDate
CreatedByUser I_ConfignCharacteristicGroup CreatedByUser
CreationDateTime I_ConfignCharacteristicGroup CreationDateTime
LastChangedByUser I_ConfignCharacteristicGroup LastChangedByUser
LastChangeDateTime I_ConfignCharacteristicGroup LastChangeDateTime
_Text _Text
_CharcAllocation _CharcAllocation
_VarCnfUIExtension _VarCnfUIExtension 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL,
  private: false
}

@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel: {
  semanticKey: ['ConfignCharacteristicGroup'],
  representativeKey: 'ConfignCharacteristicGroup',
  sapObjectNodeType.name: 'VarConfignCharacteristicGroup',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #M
  }
}

@EndUserText.label: 'Variant Confign Characteristic Group'

define root view entity R_VarCnfCharcGroupTP_2
  as select from I_ConfignCharacteristicGroup as Grp

  composition [0..*] of R_VarCnfCharcGroupTextTP_2  as _Text
  composition [0..*] of R_VarCnfCharcGroupAllocTP_2 as _CharcAllocation
  
  association [0..1] to R_VarCnfUIExtensionTP       as _VarCnfUIExtension            on $projection.VarCnfUIExtensionUUID = _VarCnfUIExtension.VarCnfUIExtensionUUID

  association [0..1] to R_VarCnfCharcGroupTextTP_2  as _ConfignCharcGroupDescSysLang on  $projection.ConfignCharacteristicGroup = _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroup
                                                                                     and $projection.ChangeNumber               = _ConfignCharcGroupDescSysLang.ChangeNumber
                                                                                     and _ConfignCharcGroupDescSysLang.Language = $session.system_language
                                                                                     
  association [0..1] to I_ConfignCharcGrpAllocCount as _CsticCount                   on  $projection.ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup
                                                                                     and $projection.ChangeNumber               = _CsticCount.ChangeNumber  

{
  key Grp.ConfignCharacteristicGroup,
  key Grp.ChangeNumber,
      Grp.TimeIntervalNumber,
      Grp.ConfignCharcGroupIsDefault,
      Grp.VarCnfUIExtensionUUID,

      _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroupDesc as ConfignCharacteristicGroupDesc,
      _CsticCount.NumberOfCharacteristics as NumberOfCharacteristics,

      @Semantics.businessDate.from
      Grp.ValidityStartDate,
      @Semantics.businessDate.to
      Grp.ValidityEndDate,

      @Semantics.user.createdBy
      Grp.CreatedByUser,
      @Semantics.systemDateTime.createdAt
      Grp.CreationDateTime,
      @Semantics.user.lastChangedBy
      Grp.LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt
      Grp.LastChangeDateTime,
      
      _Text,
      _CharcAllocation,
      _VarCnfUIExtension
            
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONFIGNCHARACTERISTICGROUP",
"I_CONFIGNCHARCGRPALLOCCOUNT",
"R_VARCNFCHARCGROUPTEXTTP_2"
],
"ASSOCIATED":
[
"R_VARCNFCHARCGROUPALLOCTP_2",
"R_VARCNFCHARCGROUPTEXTTP_2",
"R_VARCNFUIEXTENSIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More