P_MobileNumbers

DDL: P_MOBILENUMBERS SQL: PMOBILENUMBERS Type: view BASIC

P_MobileNumbers is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adr2).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
adr2 adr2 from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PMOBILENUMBERS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view 
@VDM.private: true
@VDM.viewType: #BASIC 
@AbapCatalog.sqlViewName: 'PMOBILENUMBERS'
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE 

define view P_MobileNumbers as select from adr2 // Telephone Numbers (Business Address Services)

{
    *    
} where ( adr2.r3_user = '2' or adr2.r3_user = '3' ) and adr2.flg_nouse = '' and adr2.flgdefault = 'X'  // Telephone is Default Mobile Telephone

// and adr2.home_flag = 'X'

Learn More