I_AddressContactCard

DDL: I_ADDRESSCONTACTCARD SQL: IADDRESSCC Type: view BASIC Package: VDM_CC_CDS

Address Contact Card

I_AddressContactCard is a Basic CDS View that provides data about "Address Contact Card" in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 11 fields with key field ContactCardID. It has 3 associations to related views. Part of development package VDM_CC_CDS.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
adrc _Address from

Associations (3)

CardinalityTargetAliasCondition
[0..1] adr2 _DefaultPhoneNumber _DefaultPhoneNumber.addrnumber = $projection.AddressID and _DefaultPhoneNumber.persnumber = ' ' and _DefaultPhoneNumber.r3_user = '1'
[0..1] adr2 _DefaultMobilePhoneNumber _DefaultMobilePhoneNumber.addrnumber = $projection.AddressID and _DefaultMobilePhoneNumber.persnumber = ' ' and _DefaultMobilePhoneNumber.r3_user = '3'
[0..1] adr6 _DefaultEmailAddress _DefaultEmailAddress.addrnumber = $projection.AddressID and _DefaultEmailAddress.persnumber = ' ' and _DefaultEmailAddress.flgdefault = 'X'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IADDRESSCC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Address Contact Card view
ObjectModel.representativeKey ContactCardID view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID adrc addrnumber
ContactCardRole
ContactCardType
FullName
AddressID adrc addrnumber
PhoneNumber
MobilePhoneNumber
EmailAddress _DefaultEmailAddress smtp_addr
Country adrc country
ContactCardNavLinkSemanticObj
ContactCardNavLinkQueryPart 
@AbapCatalog.sqlViewName: 'IADDRESSCC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

@EndUserText.label: 'Address Contact Card'
@ObjectModel.representativeKey: 'ContactCardID'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
define view I_AddressContactCard
  as select from adrc as _Address
  association [0..1] to adr2 as _DefaultPhoneNumber       on  _DefaultPhoneNumber.addrnumber = $projection.AddressID
                                                          and _DefaultPhoneNumber.persnumber = '          '
                                                          and _DefaultPhoneNumber.r3_user    = '1'
  association [0..1] to adr2 as _DefaultMobilePhoneNumber on  _DefaultMobilePhoneNumber.addrnumber = $projection.AddressID
                                                          and _DefaultMobilePhoneNumber.persnumber = '          '
                                                          and _DefaultMobilePhoneNumber.r3_user    = '3'
  association [0..1] to adr6 as _DefaultEmailAddress      on  _DefaultEmailAddress.addrnumber = $projection.AddressID
                                                          and _DefaultEmailAddress.persnumber = '          '
                                                          and _DefaultEmailAddress.flgdefault = 'X'
{
  key _Address.addrnumber                                                                         as ContactCardID,
      'Supplier'                                                                                  as ContactCardRole,
      'Address'                                                                                   as ContactCardType,
      @Semantics.text
      cast(substring(replace(concat(name1, concat(' &@', name2)), '&@', ''),1,80) as adfullname ) as FullName,
      _Address.addrnumber                                                                         as AddressID,
      cast(_DefaultPhoneNumber.telnr_long as contactcardphonenumber)                              as PhoneNumber,
      cast(_DefaultMobilePhoneNumber.telnr_long as contactcardmobilephonenumber)                  as MobilePhoneNumber,
      _DefaultEmailAddress.smtp_addr                                                              as EmailAddress,
      _Address.country                                                                            as Country,
      'Address'                                                                                   as ContactCardNavLinkSemanticObj,
      concat('AddressID=', _Address.addrnumber)                                                   as ContactCardNavLinkQueryPart
}
where
  _Address.nation = ' '

Learn More