C_ChmlCmplncReqRequesterVH

DDL: C_CHMLCMPLNCREQREQUESTERVH SQL: CCREQUSTERVH Type: view CONSUMPTION Package: EHPMA_CNS_CRQ

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. Part of development package EHPMA_CNS_CRQ.

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.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ChmlCmplncReqBPRequester view
Search.searchable true 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,

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

@Search.searchable: true

@Metadata.ignorePropagatedAnnotations: true

define view C_ChmlCmplncReqRequesterVH
  as select from I_ChmlCmplncReq
{
      @Consumption.filter.hidden: true
      @UI.textArrangement:#TEXT_ONLY
      @ObjectModel.text.element:  [ 'ChmlCmplncReqBPRequesterName' ]
  key ChmlCmplncReqBPRequester,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @Semantics.text: true --- (D054696)
//      _BusinessUserRequester.PersonFullName as ChmlCmplncReqBPRequesterName

cast ( _BusinessUserRequester.PersonFullName as ehfnd_crq_bupa_requester_name ) as ChmlCmplncReqBPRequesterName

      //      @UI.hidden: true

      //      @Search.defaultSearchElement: true

      //      @Search.fuzzinessThreshold: 0.8

      //      @Search.ranking: #HIGH

      //      @Semantics.text: true --- (D054696)

      //      _BusinessUserRequester.PersonFullName,

      //

      //      case ChmlCmplncReqBPRequester

      //            when '' then '-'

      //            else

      //              _BusinessUserRequester.PersonFullName

      //         end as ChmlCmplncReqBPRequesterName

}
group by
  ChmlCmplncReqBPRequester,
  _BusinessUserRequester.PersonFullName

Learn More