C_ChmlCmplncReqRequesterCntct

DDL: C_CHMLCMPLNCREQREQUESTERCNTCT Type: view CONSUMPTION Package: EHPMA_CNS_CRQ

Chemical Compliance Request Requester Contact Card

C_ChmlCmplncReqRequesterCntct is a Consumption CDS View that provides data about "Chemical Compliance Request Requester Contact Card" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserBasic) and exposes 16 fields. Part of development package EHPMA_CNS_CRQ.

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserBasic BusinessUser from

Annotations (10)

NameValueLevelField
EndUserText.label Chemical Compliance Request Requester Contact Card view
AbapCatalog.sqlViewName CCREQUSTERCNTCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (16)

KeyFieldSource TableSource FieldDescription
NormalizedPhoneNumber
MobilePhoneNumber
DefaultEmailAddress
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
@EndUserText.label: 'Chemical Compliance Request Requester Contact Card'

@AbapCatalog:
{
  sqlViewName: 'CCREQUSTERCNTCT',
  compiler.compareFilter: true
}

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  // blocking of personal data required because of link to business user

  personalData.blocking: #REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  },
  semanticKey: [ 'BusinessPartner' ]
}

--Search
//@Search.searchable : true


define view C_ChmlCmplncReqRequesterCntct
  --Select data from business user
  as select from I_BusinessUserBasic as BusinessUser

{

      --Business User
      @ObjectModel.readOnly: true
  key cast(BusinessUser.BusinessPartner as ehfnd_crq_bupa_requester preserving type ) as BusinessPartner,      

      --Company Name
      // used via AS_CONTACT in contact popup

      // can not be used for searching because of calculation

      @Semantics.name.fullName: true
      BusinessUser.PersonFullName                                    as ChmlCmplncReqBPRequesterName,

      //      // part of BusinessUserFullName, only needed for searching

      //      @Search:

      //      {

      //        defaultSearchElement: true,

      //        ranking: #HIGH,

      //        fuzzinessThreshold: 0.8

      //      }

      //      BusinessUser.PersonFullName as BusinessUserFullName,



      --Phone Number
      // used via AS_CONTACT in contact popup

      @Semantics.telephone.type:  [ #WORK, #PREF ]
      BusinessUser._WorkplaceAddress.NormalizedPhoneNumber,

      --Mobile Phone Number
      // used via AS_CONTACT in contact popup

      @Semantics.telephone.type:  [ #CELL ]
      BusinessUser._WorkplaceAddress.MobilePhoneNumber,

      --E-Mail adress
      // used via AS_CONTACT in contact popup

      @Semantics.eMail.type:  [ #PREF, #WORK ]
      BusinessUser._WorkplaceAddress.DefaultEmailAddress,

      @Consumption.hidden: true
      AuthorizationGroup,

      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      
       @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
       DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10



}