ADRCT is a standard SAP table in SAP ECC (or) S/4HANA which stores Address Texts (Business Address Services) data. There are total 7 fields in ADRCT table.This blog post provides key technical details of SAP table ADRCT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRCT table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | SAP Technology – Business Services: Address Management (SZAD) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRCT Table Fields
The following is the list of fields that are available in SAP ADRCT table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
| ADDRNUMBER | Address Number | AD_ADDRNUM | AD_ADDRNUM | ADRC | CHAR (10) |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATUM | DATS (8) | |
| NATION | Version ID for International Addresses | AD_NATION | AD_NATION | TSADV | CHAR (1) |
| LANGU | Language Key | SPRAS | SPRAS | T002 | LANG (1) |
| REMARK | Address notes | AD_REMARK1 | TEXT50 | CHAR (50) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS (8) |
Availability
The SAP table ADRCT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADRCT table
The following is the list of ADRCT CDS views, which can also be used instead of ADRCT table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_FRCELMNTORGBUSINESSADDRTEXT | BASIC | Interface View for Force Element Org Business Address Text |
| P_FRCELMNTORGBUSINESSADDRTEXT | BASIC | Basic Private View for Force Element Org Business Addr Text |
| I_FRCELMNTORGADDRESS | COMPOSITE | Interface View for Force Element Org Address |
| C_ARCUSTOMER | CONSUMPTION | Customer List |
| C_ARUNIQUECUSTOMER | CONSUMPTION | Customer List |
| C_FRCELMNTORGADDRESSTP | CONSUMPTION | Consumption View for Force Element Org Address |
| C_FRCELMNTORGADDRNUMBERVH | CONSUMPTION | Value Help Consumption View for Address Number |
| C_FRCELMNTORGADDRPARENTADDRESS | CONSUMPTION | Consumption view for Address Parent list |
| C_FRCELMNTORGADDRWHEREUSEDLIST | CONSUMPTION | Consumption view for Address Where used list |
| C_FRCELMNTORGBUSINESSADDRESS | CONSUMPTION | Consumption View for Business Address |
| C_SCHEDAGRMTMASSUPDTREFADDRVH | CONSUMPTION | Reference Address Value Help |
| P_ADDRESSTEXT | CONSUMPTION | Text view for Address |
| P_REFERENCEADDRESSTEXT | CONSUMPTION | Reference Address |
