P_FrcElmntOrgAddrPhoneNumber

DDL: P_FRCELMNTORGADDRPHONENUMBER SQL: PFEORGADDRPHNUM Type: view BASIC

P_FrcElmntOrgAddrPhoneNumber is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adr2) and exposes 5 fields with key fields AddressNumber, PersonNumber, FrcElmntOrgAddrFromDate, FrcElmntOrgAddrSequenceNumber.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
adr2 FrcElmntOrgAddrPhoneNumber from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFEORGADDRPHNUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AddressNumber adr2 addrnumber
KEY PersonNumber adr2 persnumber
KEY FrcElmntOrgAddrFromDate adr2 date_from
KEY FrcElmntOrgAddrSequenceNumber adr2 consnumber
PhoneNumberType adr2 r3_user 
@AbapCatalog.sqlViewName: 'PFEORGADDRPHNUM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
    viewType : #BASIC,
    private  : true
}
@ObjectModel : {
    usageType : {
        dataClass       : #MASTER,
        serviceQuality  : #A,
        sizeCategory    : #L
    }
}
define view P_FrcElmntOrgAddrPhoneNumber
  as select from adr2 as FrcElmntOrgAddrPhoneNumber
{
  key FrcElmntOrgAddrPhoneNumber.addrnumber as AddressNumber,
  key FrcElmntOrgAddrPhoneNumber.persnumber as PersonNumber,
  key FrcElmntOrgAddrPhoneNumber.date_from  as FrcElmntOrgAddrFromDate,
  key FrcElmntOrgAddrPhoneNumber.consnumber as FrcElmntOrgAddrSequenceNumber,
      FrcElmntOrgAddrPhoneNumber.r3_user    as PhoneNumberType,
      case FrcElmntOrgAddrPhoneNumber.r3_user
      when '1'
      then FrcElmntOrgAddrPhoneNumber.tel_number
      end                                   as FrcElmntOrgAddrTelephoneNumber,
      case FrcElmntOrgAddrPhoneNumber.r3_user
      when '1'
      then FrcElmntOrgAddrPhoneNumber.tel_extens
      end                                   as FrcElmntOrgAddrTelExtension,
      case FrcElmntOrgAddrPhoneNumber.r3_user
      when '3'
      then FrcElmntOrgAddrPhoneNumber.tel_number
      end                                   as FrcElmntOrgAddrCellPhoneNumber

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADR2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More