I_JITOutbCommunicationGroupSts

DDL: I_JITOUTBCOMMUNICATIONGROUPSTS SQL: IJITCOMMSTS Type: view BASIC

Basic view for comunication group status

I_JITOutbCommunicationGroupSts is a Basic CDS View that provides data about "Basic view for comunication group status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field JITOutbCommGrpStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_JITOutbCommGrpStsTxt _Text _Text.JITOutbCommGrpStatus = $projection.JITOutbCommGrpStatus

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IJITCOMMSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Basic view for comunication group status view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #SWITCHED_OFF view
AbapCatalog.buffering.type #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey JITOutbCommGrpStatus view
ObjectModel.dataCategory #TEXT view
ObjectModel.resultSet.sizeCategory #XS view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY JITOutbCommGrpStatus
_Text _Text
@AbapCatalog.sqlViewName: 'IJITCOMMSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Basic view for comunication group status'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #SWITCHED_OFF
@AbapCatalog.buffering.type: #NONE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.representativeKey: 'JITOutbCommGrpStatus'
@ObjectModel.dataCategory: #TEXT
@ObjectModel.resultSet.sizeCategory: #XS
define view I_JITOutbCommunicationGroupSts as select from dd07l 
 association [0..*] to I_JITOutbCommGrpStsTxt as _Text on _Text.JITOutbCommGrpStatus = $projection.JITOutbCommGrpStatus
{


      @ObjectModel.text.association: '_Text'
  key cast ( substring( domvalue_l, 1, 1 ) as comm_grp_status )  as  JITOutbCommGrpStatus,
      //_Text.Language

      _Text
}
where
      dd07l.domname  = 'COMM_GRP_STATUS'
  and dd07l.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_JITOUTBCOMMGRPSTSTXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/