The BUT_ADR12_ACT table in SAP ERP or S/4HANA stores Master Data Consolidation: Best Record Table for ADR12 data. There are total 14 fields in BUT_ADR12_ACT table. The Master Data Consolidation: Best Record Table for ADR12 table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT_ADR12_ACT table. It is in Master Data Consolidation: Business Partner Data Model (MDC_BP_MODEL) ABAP package and is part of the Business Partner. (CA-MDG-CMP-BP) module.
SAP BUT_ADR12_ACT Table Fields
Following is the list of fields that are available in SAP BUT_ADR12_ACT table. The primary key fields of the table are CLIENT (Client), PARTNER (Business Partner Number), SOURCE_ADDRNUMBER (Address Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| SOURCE_ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR (10) | |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATS (8) | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC (3) | |
| FLGDEFAULT | Flag: this address is the default address | AD_FLGDFAD | CHAR (1) | |
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR (1) | |
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR (1) | |
| URI_TYPE | URI type flag | AD_URITYPE | CHAR (3) | |
| URI_SRCH | URI address search field | AD_URI2 | CHAR (50) | |
| DFT_RECEIV | Flag: Recipient is standard recipient for this address | AD_DFTRCAD | CHAR (1) | |
| RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) | |
| SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) | |
| URI_LENGTH | URI field length | AD_URILNG | INT2 (5) |
