I_AddressCommunicationUsage

DDL: I_ADDRESSCOMMUNICATIONUSAGE Type: view_entity BASIC

Usage of Communication Data

I_AddressCommunicationUsage is a Basic CDS View that provides data about "Usage of Communication Data" in SAP S/4HANA. It reads from 1 data source (adru) and exposes 7 fields with key fields AddressID, AddressPersonID, CommunicationMediumType, CommMediumSequenceNumber, CommunicationMediumTypeUsage.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
adru adru from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Usage of Communication Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AddressID addrnumber
KEY AddressPersonID persnumber
KEY CommunicationMediumType comm_type
KEY CommMediumSequenceNumber consnumber
KEY CommunicationMediumTypeUsage comm_usage
datsendasValidityStartDate
datsendasValidityEndDate 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Usage of Communication Data'
//@Metadata.allowExtensions: true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel.representativeKey: 'AddressID'

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

define view entity I_AddressCommunicationUsage as select from adru
{
  key addrnumber as AddressID,
  key persnumber as AddressPersonID,
  key comm_type  as CommunicationMediumType,
  key consnumber as CommMediumSequenceNumber,
  key comm_usage as CommunicationMediumTypeUsage,
      case valid_from
          when '' then '00010101'
          else cast( substring( valid_from,1,8) as abap.dats)
      end as ValidityStartDate,
      case valid_to
         when '' then '99991231'
         else cast( substring( valid_to,1,8) as abap.dats)
      end as ValidityEndDate
}

Learn More