BIADDR2 SAP (BI Structure for Consumers) Structure details

Dictionary Type: Structure
Description: BI Structure for Consumers




ABAP Code to SELECT data from BIADDR2
Related tables to BIADDR2
Access table BIADDR2




Structure field list including key, data, relationships and ABAP select examples

BIADDR2 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 "BI Structure for Consumers" 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_BIADDR2 TYPE BIADDR2.

The BIADDR2 table consists of various fields, each holding specific information or linking keys about BI Structure for Consumers data available in SAP. These include TBNAM (Table Name), TITLE_P (Title text), FIRSTNAME (First name), LASTNAME (Last name).. 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. .

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


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
STYPEBatch Input Interface Record Type STYPE_BICHAR1CHAR1
TBNAMTable Name TABNAMECHAR30Assigned to domainAS4TABDTB
TITLE_PTitle text AD_TITLETXCHAR30TEXT30
FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
LASTNAMELast name AD_NAMELASCHAR40TEXT40
BIRTH_NAMEName of person at birth AD_NAME2_PCHAR40TEXT40
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ACA2Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
PREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
PREFIX2Name prefix AD_PREFIXTCHAR20TEXT20
TITLE_SPPLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
LANGUP_ISO2-Character SAP Language Code LAISOCHAR2LAISO
SORT1_PSearch Term 1 AD_SORT1CHAR20CHAR20
SORT2_PSearch Term 2 AD_SORT2CHAR20CHAR20
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
BUILD_LONGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP

Key field Non-key field



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

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

How to access SAP table BIADDR2

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!