SAP ABAP Table BIADDR2 (BI Structure for Consumers)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VS (Package) Application development R/3 sales master data

Basic Data

Table Category	INTTAB	Structure
Structure	BIADDR2	Table Relationship Diagram
Short Description	BI Structure for Consumers

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	STYPE	☐	STYPE_BI	CHAR1	CHAR	1	0	Batch Input Interface Record Type
2	TBNAM	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	*
3	TITLE_P	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
4	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
5	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
6	BIRTH_NAME	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
7	TITLE_ACA1	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
8	TITLE_ACA2	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
9	PREFIX1	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
10	PREFIX2	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
11	TITLE_SPPL	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
12	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
13	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
14	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
15	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
16	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
17	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
18	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
19	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
20	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
22	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
24	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
25	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
26	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
27	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
28	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
29	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
30	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
31	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
32	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
33	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
34	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
35	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
36	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
37	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
38	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
39	ADR_NOTES	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
40	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
41	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
42	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
43	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
44	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
45	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
46	BUILD_LONG	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
47	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIADDR2	COMM_TYPE	TSAC	COMM_TYPE
2	BIADDR2	COUNTRY	T005	LAND1
3	BIADDR2	NAMCOUNTRY	T005	LAND1
4	BIADDR2	NAMEFORMAT	T005N	NAMEFORMAT
5	BIADDR2	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
6	BIADDR2	REGION	T005S	BLAND
7	BIADDR2	TIME_ZONE	TTZZ	TZONE
8	BIADDR2	TRANSPZONE	TZONE	ZONE1

History

Last changed by/on	SAP	20140121
SAP Release Created in