SAP BBP_ADR2_31 Telephone Numbers (Central Address Management), Release 3.1 Table data and field list

BBP_ADR2_31 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Telephone Numbers (Central Address Management), Release 3.1" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BBP_ADR2_31 TYPE BBP_ADR2_31.

The BBP_ADR2_31 table consists of various fields, each holding specific information or linking keys about Telephone Numbers (Central Address Management), Release 3.1 data available in SAP. These include ADDRNUMBER (Address number), PERSNUMBER (Person number), DATE_FROM (Valid-from date - in current Release only 00010101 possible), CONSNUMBER (Sequence Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BBP_ADR2_31 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP BBP_ADR2_31 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBP_ADR2_31 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
ADDRNUMBER	Address number	AD_ADDRNUM	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM	ADR
PERSNUMBER	Person number	AD_PERSNUM	CHAR	10	Assigned to domain	ALPHA	AD_PERSNUM	CDT	ADDRESS
DATE_FROM	Valid-from date - in current Release only 00010101 possible	AD_DATE_FR	DATS	8			DATUM
CONSNUMBER	Sequence Number	AD_CONSNUM	NUMC	3			NUMC3
FLGDEFAULT	Standard Sender Address in this Communication Type	AD_FLGDFNR	CHAR	1			XFELD
TEL_NUMBER	Telephone no.: dialling code+number	AD_TLNMBR	CHAR	30			CHAR30
TEL_EXTENS	Telephone no.: Extension	AD_TLXTNS	CHAR	10			CHAR10
TELNR_LONG	Complete number: dialling code+number+extension	AD_TELNRLG	CHAR	30			CHAR30
DFT_RECEIV	Flag: Recipient is standard recipient for this number	AD_DFTRCNR	CHAR	1			XFELD
R3_USER	Flag: Connected to an SAP System	AD_R3_USER	CHAR	1			XFELD

Key field

Non-key field

< BBP_ADR12_46 - FTP and URL (Central Address Management) Version 4.6 BBP_ADR2_40_45 - Telephone Numbers (Central Address Managemt) Release 4.0/4.5 >

How do I retrieve data from SAP structure BBP_ADR2_31 using ABAP code?

As BBP_ADR2_31 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BBP_ADR2_31 as there is no data to select.

How to access SAP table BBP_ADR2_31

Within an ECC or HANA version of SAP you can also view further information about BBP_ADR2_31 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).