C_ChmlCmplncReqRequesterUserVH

DDL: C_CHMLCMPLNCREQREQUESTERUSERVH SQL: CCREQUSTERUSVH Type: view CONSUMPTION

Chemical Compliance Request Requester User Value Help

C_ChmlCmplncReqRequesterUserVH is a Consumption CDS View that provides data about "Chemical Compliance Request Requester User Value Help" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReq) and exposes 2 fields with key field UserID.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq I_ChmlCmplncReq from

Annotations (15)

NameValueLevelField
EndUserText.label Chemical Compliance Request Requester User Value Help view
AbapCatalog.sqlViewName CCREQUSTERUSVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey UserID view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY UserID _RequesterUser UserID
UserDescription _RequesterUser UserDescription Name 
@EndUserText.label: 'Chemical Compliance Request Requester User Value Help'

@AbapCatalog.sqlViewName: 'CCREQUSTERUSVH'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Search.searchable: true  

@VDM: {
  viewType: #CONSUMPTION
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  dataCategory: #VALUE_HELP,
  resultSet.sizeCategory: #XS,

  usageType:
  {
    dataClass: #CUSTOMIZING,
    sizeCategory: #L,
    serviceQuality: #C
  },
  representativeKey: 'UserID'
}

@Metadata.ignorePropagatedAnnotations: true

@UI.presentationVariant:{
    sortOrder: [
        { by: 'UserID', direction: #ASC },
        { by: 'UserDescription', direction: #ASC }]
}
define view C_ChmlCmplncReqRequesterUserVH
  as select from I_ChmlCmplncReq
{

      @ObjectModel.text.element:  [ 'UserDescription' ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key _RequesterUser.UserID,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'Name'
      _RequesterUser.UserDescription
}
group by
  _RequesterUser.UserID,
  _RequesterUser.UserDescription
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCREQ",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More