C_ChmlCmplncReqRequesterCntct

DDL: C_CHMLCMPLNCREQREQUESTERCNTCT Type: view CONSUMPTION

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 5 fields.

1 data source(s) 5 fields

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 #CHECK 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 (5)

KeyFieldSource TableSource FieldDescription
NormalizedPhoneNumber
MobilePhoneNumber
DefaultEmailAddress
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 
@EndUserText.label: 'Chemical Compliance Request Requester Contact Card'

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

@AccessControl:
{
  authorizationCheck: #CHECK,
  // 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: [ 'BusinessUser' ]
}

--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) as BusinessUser,

      --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



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More