C_BusEvtLogUserCntctCardVH

DDL: C_BUSEVTLOGUSERCNTCTCARDVH Type: view CONSUMPTION

Business Event Log User

C_BusEvtLogUserCntctCardVH is a Consumption CDS View that provides data about "Business Event Log User" in SAP S/4HANA. It reads from 2 data sources (I_AddressPersonName, I_User) and exposes 5 fields with key field ContactCardID. It has 1 association to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_AddressPersonName _AddressPersonName inner
I_User I_User from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusinessEventLogEvent _BusinessEvent I_User.UserID = _BusinessEvent.CreatedByUser

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CBELUSERCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey ContactCardID view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Event Log User view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID I_User UserID
FirstName I_AddressPersonName GivenName
LastName I_AddressPersonName FamilyName
FullName
_BusinessEvent _BusinessEvent 
@AbapCatalog: { sqlViewName: 'CBELUSERCVH',
                         compiler.compareFilter: true }
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType: { dataClass: #TRANSACTIONAL,
                                         serviceQuality: #C,
                                         sizeCategory: #XL }
@ObjectModel: { representativeKey: 'ContactCardID',
                        dataCategory: #VALUE_HELP }
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Business Event Log User'
define view C_BusEvtLogUserCntctCardVH
  as select from I_User
    inner join   I_AddressPersonName as _AddressPersonName on I_User.AddressPersonID = _AddressPersonName.AddressPersonID
  association [0..*] to I_BusinessEventLogEvent as _BusinessEvent on I_User.UserID = _BusinessEvent.CreatedByUser
{
      @ObjectModel.text.element:  [ 'FullName' ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      @Search.ranking: #HIGH
  key I_User.UserID                     as ContactCardID,
      _AddressPersonName.GivenName      as FirstName,
      _AddressPersonName.FamilyName     as LastName,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      cast(I_User.UserDescription as ad_namtext preserving type) as FullName,

      // For Access control

      _BusinessEvent
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSPERSONNAME",
"I_USER"
],
"ASSOCIATED":
[
"I_BUSINESSEVENTLOGEVENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More