C_CAInvcgClrfctnCaseUserVH

DDL: C_CAINVCGCLRFCTNCASEUSERVH SQL: CCACFCUSRVH Type: view CONSUMPTION

Wertehilfe für Klärungsfall Benutzer

C_CAInvcgClrfctnCaseUserVH is a Consumption CDS View that provides data about "Wertehilfe für Klärungsfall Benutzer" in SAP S/4HANA. It reads from 1 data source (I_UserContactCard) and exposes 5 fields with key field ContactCardID. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_UserContactCard UserContactCard from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CAInvcgClrfctnCase _ProcessedByUser $projection.ContactCardID = _ProcessedByUser.CAClrfctnLastProcessedByUser
[0..*] I_CAInvcgClrfctnCase _CreatedByUser $projection.ContactCardID = _CreatedByUser.CreatedByUser

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CCACFCUSRVH view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Wertehilfe für Klärungsfall Benutzer view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID I_UserContactCard ContactCardID
FirstName I_UserContactCard FirstName
LastName I_UserContactCard LastName
_ProcessedByUser _ProcessedByUser
_CreatedByUser _CreatedByUser 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CCACFCUSRVH'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Wertehilfe für Klärungsfall Benutzer'
define view C_CAInvcgClrfctnCaseUserVH as select from I_UserContactCard as UserContactCard
  association [0..*] to I_CAInvcgClrfctnCase as _ProcessedByUser on $projection.ContactCardID = _ProcessedByUser.CAClrfctnLastProcessedByUser
  association [0..*] to I_CAInvcgClrfctnCase as _CreatedByUser on $projection.ContactCardID = _CreatedByUser.CreatedByUser
{
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key UserContactCard.ContactCardID,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      UserContactCard.FirstName,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      UserContactCard.LastName,


      /* Associations */
      _ProcessedByUser,
      _CreatedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_CAINVCGCLRFCTNCASE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More