The BUR_ADR3_PRC table in SAP ERP or S/4HANA stores Process Records Of OTC 1405, Table ADR3 data. There are total 25 fields in BUR_ADR3_PRC table. The Process Records Of OTC 1405, Table ADR3 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 BUR_ADR3_PRC table. It is in Master Data Consolidation: BP Relationship Data Model (MDC_BP_REL_MODEL) ABAP package and is part of the Consolidation & Mass Processing. (CA-MDG-CMP) module.
SAP BUR_ADR3_PRC Table Fields
Following is the list of fields that are available in SAP BUR_ADR3_PRC table. The primary key fields of the table are CLIENT (Client), PROCESS_ID (Master Data Change Process Identifier), PROCESS_STEP_NO (Master Data Change Process Step Number), SOURCE_SYSTEM (Source System), SOURCE_ID (Master Data Consolidation: ID of a Source Objects), 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) | |
| PROCESS_ID | Master Data Change Process Identifier | MDC_PROCESS_ID | NUMC (12) | |
| PROCESS_STEP_NO | Master Data Change Process Step Number | MDC_PROCESS_STEP_NO | NUMC (4) | |
| SOURCE_SYSTEM | Source System | MDC_BUSINESS_SYSTEM | CHAR (60) | |
| SOURCE_ID | Master Data Consolidation: ID of a Source Objects | MDC_SOURCE_ID | CHAR (60) | |
| 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) | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | * | CHAR (10) |
| COUNTRY | Country for telephone/fax number | AD_COMCTRY | * | CHAR (3) |
| FLGDEFAULT | Standard Sender Address in this Communication Type | AD_FLGDFNR | 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) | |
| FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR (30) | |
| FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR (10) | |
| FAXNR_LONG | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR (30) | |
| FAXNR_CALL | Fax number for finding sender | AD_FAXNRCL | CHAR (30) | |
| FAX_GROUP | Fax group (G3, G4, …) | AD_FXGRP | CHAR (1) | |
| DFT_RECEIV | Flag: Recipient is standard recipient for this number | AD_DFTRCNR | CHAR (1) | |
| R3_USER | Flag: Connected to an SAP System | AD_R3_USER | CHAR (1) | |
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR (14) | |
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR (14) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) | |
| SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) | |
| SOURCE_MODIFIED | Indicator: Source Record modified | MDC_SOURCE_MODIFIED | CHAR (1) |
