SAP ADRU Table for Communication Usages Table

Overview

ADRU is a standard SAP S/4HANA table that stores Table for Communication Usages data. There are total 11 fields in the ADRU table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ADRU belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Address Management (SZAD).

In addition, following links provide an overview of foreign key relationships, if any, that link ADRU to other SAP tables and standard CDS views available based on ADRU table in S/4HANA 2020.

Techincal Settings of ADRU

Below are technical details of the table ADRU

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ADRU Fields

The following table gives you an overview of the fields available in ADRU

FieldDescriptionData ElementCheck TableData TypeLength
CLIENTClientMANDTCLNT3
ADDRNUMBERAddress NumberAD_ADDRNUMCHAR10
PERSNUMBERPerson NumberAD_PERSNUMCHAR10
COMM_TYPECommunication Method (Key) (Business Address Services)AD_COMMCHAR3
CONSNUMBERSequence NumberAD_CONSNUMNUMC3
COMM_USAGECommunication Usage: Key FieldAD_CUSAGECHAR10
VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)AD_VALTOCHAR14
VALID_FROMCommunication Data: Valid From (YYYYMMDDHHMMSS)AD_VALFROMCHAR14
DEF_USAGEIndicator: Default for this UsageAD_CDEFUSECHAR1
ADRU_UUIDUUID Used in the AddressAD_UUIDRAW16
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADRU

Other References