C_ChmlCmplncReqRequesterCntct
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessUserBasic | BusinessUser | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA