SAP BBP_ADR2_47 Telephone Numbers (Business Address Servicess) Status 4.7 Table data and field list

BBP_ADR2_47 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 (Business Address Servicess) Status 4.7" 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_47 TYPE BBP_ADR2_47.

The BBP_ADR2_47 table consists of various fields, each holding specific information or linking keys about Telephone Numbers (Business Address Servicess) Status 4.7 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_47 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP BBP_ADR2_47 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_47 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
COUNTRY	Country for telephone/fax number	AD_COMCTRY	CHAR	3	Assigned to domain		LAND1	LND
FLGDEFAULT	Standard Sender Address in this Communication Type	AD_FLGDFNR	CHAR	1			XFELD
FLG_NOUSE	Flag: This Communication Number is Not Used	AD_FLNOUSE	CHAR	1			XFELD
HOME_FLAG	Recipient address in this communication type (mail sys.grp)	AD_FLGHOME	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
TELNR_CALL	Telephone number for determining caller	AD_TELNRCL	CHAR	30			CHAR30
DFT_RECEIV	Indicator: Telephone is SMS-Enabled	AD_FLGSMS	CHAR	1			AD_FLGSMS
R3_USER	Indicator: Telephone is a Mobile Telephone	AD_FLGMOB	CHAR	1			AD_FLGMOB

Key field

Non-key field

< BBP_ADR2_46 - Telephone Numbers (Central Address Management) Version 4.6 BBP_ADR3_31 - Fax Numbers (Central Address Management), Release 3.1 >

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

As BBP_ADR2_47 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_47 as there is no data to select.

How to access SAP table BBP_ADR2_47

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

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