P_FrcElmntOrgEmailAddress

DDL: P_FRCELMNTORGEMAILADDRESS SQL: PFEORGEMAILADDR Type: view BASIC

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

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
adr6 FrcElmntOrgEmailAddress from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFEORGEMAILADDR 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 adr6 addrnumber
KEY PersonNumber adr6 persnumber
KEY FrcElmntOrgAddrFromDate adr6 date_from
KEY FrcElmntOrgAddrSequenceNumber adr6 consnumber
EmailAddress adr6 smtp_addr 
@AbapCatalog.sqlViewName: 'PFEORGEMAILADDR'
@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_FrcElmntOrgEmailAddress
  as select from adr6 as FrcElmntOrgEmailAddress
{

  key FrcElmntOrgEmailAddress.addrnumber as AddressNumber,
  key FrcElmntOrgEmailAddress.persnumber as PersonNumber,
  key FrcElmntOrgEmailAddress.date_from  as FrcElmntOrgAddrFromDate,
  key FrcElmntOrgEmailAddress.consnumber as FrcElmntOrgAddrSequenceNumber,
      FrcElmntOrgEmailAddress.smtp_addr  as EmailAddress

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

Learn More