C_ChmlCmplncReqRequesterVH

DDL: C_CHMLCMPLNCREQREQUESTERVH SQL: CCREQUSTERVH Type: view CONSUMPTION

Value Help for Requester of a Chemical Compliance Request

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

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq I_ChmlCmplncReq from

Annotations (14)

NameValueLevelField
EndUserText.label Value Help for Requester of a Chemical Compliance Request view
AbapCatalog.sqlViewName CCREQUSTERVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION 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 ChmlCmplncReqBPRequester view
Metadata.ignorePropagatedAnnotations true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncReqBPRequester ChmlCmplncReqBPRequester 
@EndUserText.label: 'Value Help for Requester of a Chemical Compliance Request'

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

@AccessControl:
{
  authorizationCheck: #CHECK,
  // blocking of personal data not required (user data can not be blocked and no business partner data exposed from user)

  personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

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

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

@Metadata.ignorePropagatedAnnotations: true

define view C_ChmlCmplncReqRequesterVH
  as select from I_ChmlCmplncReq
{
      @ObjectModel.text.element:  [ 'ChmlCmplncReqBPRequesterName' ]
  key ChmlCmplncReqBPRequester,

      @Semantics.text: true --- (D054696)
      _BusinessUserRequester.PersonFullName as ChmlCmplncReqBPRequesterName

}
group by
  ChmlCmplncReqBPRequester,
  _BusinessUserRequester.PersonFullName
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"I_CHMLCMPLNCREQ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More