BUT_ADR2_ACT - Master Data Consolidation: Best Record Table for ADR2
Master Data Consolidation: Best Record Table for ADR2 information is stored in SAP table BUT_ADR2_ACT.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".
Fields for table BUT_ADR2_ACT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | |
PARTNER | Business Partner Number | X | BU_PARTNER | CHAR | 20 | |
SOURCE_ADDRNUMBER | Address Number | X | AD_ADDRNUM | CHAR | 20 | |
DATE_FROM | Valid-from date - in current Release only 00010101 possible | X | AD_DATE_FR | DATS | 16 | |
CONSNUMBER | Sequence Number | X | AD_CONSNUM | NUMC | 6 | |
COUNTRY | Country/Region for Telephone/Fax Number | AD_COMCTRY | CHAR | 6 | ||
FLGDEFAULT | Standard Sender Address in this Communication Type | AD_FLGDFNR | CHAR | 2 | ||
FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 2 | ||
HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 2 | ||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 60 | ||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 20 | ||
TELNR_LONG | Complete Number: Dialling Code+Number+Extension | AD_TELNRLG | CHAR | 60 | ||
TELNR_CALL | Telephone number for determining caller | AD_TELNRCL | CHAR | 60 | ||
DFT_RECEIV | Indicator: Telephone is SMS-Enabled | AD_FLGSMS | CHAR | 2 | ||
R3_USER | Indicator: Telephone is a Mobile Telephone | AD_FLGMOB | CHAR | 2 | ||
VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR | 28 | ||
VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR | 28 | ||
RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC | 8 | ||
SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC | 8 |