SAP ABAP Table FBRC_S_ADDRESS (Address Data)
Hierarchy
EA-FIN (Software Component) EA-FIN
   FI-GL-GL-CL (Application Component) Closing Operations
     FB_RC (Package) Reconciliation Tool
Basic Data
Table Category INTTAB    Structure 
Structure FBRC_S_ADDRESS   Table Relationship Diagram
Short Description Address Data    
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 RCLNT MANDT MANDT CLNT 3   0   Client *
2 APPID FB_RC_APPLID FB_RC_APPLID CHAR 32   0   Application ID *
3 CDBID FB_RC_CDBID FB_RC_CDBID CHAR 4   0   Contact Person Database *
4 DBCAT FB_RC_DBCAT CHAR32 CHAR 32   0   Database Category  
5 CONID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
6 PERS_ID AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
7 UNAME SYUNAME SYCHAR12 CHAR 12   0   User Name  
8 DEFLT FB_RC_FLAG CHAR1_X CHAR 1   0   General Indicator  
9 DESCR FB_RC_OBJDES SO_OBJ_DES CHAR 50   0   Description  
10 .INCLUDE       0   0   Return structure for the address of a person in a company  
11 .INCLUDE       0   0   Selection parameter for the address of a person in a company  
12 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
13 .INCLUDE       0   0   Address selection parameter  
14 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
15 ADDRHANDLE AD_HANDLE TEXT140 CHAR 140   0   Handle for Creating Addresses/Persons (Bus. Addr. Services)  
16 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
17 DATE AD_DATE DATUM DATS 8   0   Date referred to  
18 PERSHANDLE AD_HANDLE TEXT140 CHAR 140   0   Handle for Creating Addresses/Persons (Bus. Addr. Services)  
19 .INCLUDE       0   0   Transfer structure for the address of a person in a company  
20 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
21 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
22 .INCLUDE       0   0   Include structure wit ADCP attributes  
23 SO_KEY AD_SO_KEY AD_SO_KEY CHAR 10   0   SAP-Office key  
24 DEPARTMENT AD_DPRTMNT TEXT40 CHAR 40   0   Department  
25 FUNCTION AD_FNCTN TEXT40 CHAR 40   0   Function  
26 BUILDING_C AD_BLDNG_P TEXT10 CHAR 10   0   Building (number or code)  
27 FLOOR_C AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
28 ROOMNUM_C AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
29 ID_CODE AD_ID_CODE TEXT10 CHAR 10   0   Short name for correspondence  
30 IH_MAIL AD_IH_MAIL TEXT10 CHAR 10   0   Int. mail postal code  
31 SORT1_C AD_SORTOLD CHAR20 CHAR 20   0   (Not Supported) Search Term  
32 SORT2_C AD_SORTOLD CHAR20 CHAR 20   0   (Not Supported) Search Term  
33 SORT_PHN_C AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
34 .INCLUDE       0   0   Include structure with ADRP attributes  
35 TITLE_P AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
36 NAME_FIRST AD_NAMEFIR TEXT40 CHAR 40   0   First name  
37 NAME_LAST AD_NAMELAS TEXT40 CHAR 40   0   Last name  
38 NAME2_P AD_NAME2_P TEXT40 CHAR 40   0   Name of person at birth  
39 NAMEMIDDLE AD_NAMEMID TEXT40 CHAR 40   0   Middle name or second forename of a person  
40 NAME_LAST2 AD_NAMLAS2 TEXT40 CHAR 40   0   Second surname of a person  
41 NAME_TEXT AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
42 CONVERTED AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
43 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
44 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
45 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) *
46 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
47 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) *
48 NICKNAME AD_NICKNAM TEXT40 CHAR 40   0   Nickname or name used  
49 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
50 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
51 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
52 PROFESSION AD_PROFESS TEXT40 CHAR 40   0   Profession  
53 SEX AD_SEX AD_SEX CHAR 1   0   Gender key  
54 LANGU_P SPRAS SPRAS LANG 1   0   Language Key T002
55 SORT1_P AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
56 SORT2_P AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
57 SORT_PHN_P AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
58 PERSORIGIN AD_ORIGINP AD_ORIGIN CHAR 4   0   Personal data source (key) TSAD6
59 LANGU_CR_P AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
60 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
61 ADDR_COMP AD_ADDRCOM AD_ADDRNUM CHAR 10   0   (not used) ADRC
62 AD_COMP_HD AD_COMP_HD TEXT140 CHAR 140   0   First company address: internal ID if DB no. not yet issued  
63 .INCLUDE       0   0   Include structure with name attributes of the ADRC address  
64 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
65 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
66 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
67 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
68 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
69 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
70 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
71 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
72 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
73 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
74 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
75 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
76 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
77 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
78 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
79 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
80 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
81 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
82 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
83 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
84 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
85 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
86 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
87 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
88 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
89 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
90 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
91 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
92 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
93 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
94 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
95 STREET AD_STREET TEXT60 CHAR 60   0   Street  
96 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
97 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
98 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
99 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
100 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
101 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
102 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
103 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
104 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
105 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
106 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
107 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
108 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
109 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
110 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
111 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
112 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
113 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
114 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
115 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
116 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
117 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
118 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
119 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
120 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
121 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
122 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
123 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
124 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
125 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
126 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
127 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
128 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
129 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
130 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
131 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
132 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
133 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
134 TEL_NUMCMP AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
135 TEL_EXTCMP AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
136 FAX_NUMCMP AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
137 FAX_EXTCMP AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
138 PERS_GROUP AD_GROUP_P AD_GROUP_P CHAR 4   0   Person Group (Key) (Business Address Services) *
139 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) *
140 ADTEL ADTEL   STRU 0   0    
141 CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
142 COUNTRY AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number  
143 FLGDEFAULT AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
144 FLG_NOUSE AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
145 HOME_FLAG AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
146 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
147 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
148 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
149 TELNR_CALL AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
150 DFT_RECEIV AD_FLGSMS AD_FLGSMS CHAR 1   0   Indicator: Telephone is SMS-Enabled  
151 R3_USER AD_FLGMOB AD_FLGMOB CHAR 1   0   Indicator: Telephone is a Mobile Telephone  
152 REMARK AD_REMARK2 TEXT50 CHAR 50   0   Communication link notes  
153 VALID_FROM AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
154 VALID_TO AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
155 UPDATEFLAG AD_OP_CODE AD_OP_CODE CHAR 1   0   Change operation code ('I'nsert, 'U'pdate, 'D'elete)  
156 ADSMTP ADSMTP   STRU 0   0    
157 CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
158 FLGDEFAULT AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
159 FLG_NOUSE AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
160 HOME_FLAG AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
161 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
162 SMTP_SRCH AD_SMTPAD2 CHAR20 CHAR 20   0   E-Mail Address Search Field  
163 DFT_RECEIV AD_DFTRCNR XFELD CHAR 1   0   Flag: Recipient is standard recipient for this number  
164 R3_USER AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
165 ENCODE AD_ENCODE AD_ENCODE CHAR 1   0   Desired Data Coding (E-Mail)  
166 TNEF AD_TNEF6 XFELD CHAR 1   0   Flag: Receiver can receive TNEF coding via SMTP  
167 REMARK AD_REMARK2 TEXT50 CHAR 50   0   Communication link notes  
168 VALID_FROM AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
169 VALID_TO AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
170 UPDATEFLAG AD_OP_CODE AD_OP_CODE CHAR 1   0   Change operation code ('I'nsert, 'U'pdate, 'D'elete)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FBRC_S_ADDRESS ADDRORIGIN TSAD6 ORIGIN REF C CN
2 FBRC_S_ADDRESS ADDR_COMP ADRC ADDRNUMBER KEY C CN
3 FBRC_S_ADDRESS CITYH_CODE ADRCITY CITY_CODE REF C CN
4 FBRC_S_ADDRESS CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
5 FBRC_S_ADDRESS CITY_CODE ADRCITY CITY_CODE REF C CN
6 FBRC_S_ADDRESS CITY_CODE2 ADRCITY CITY_CODE REF C CN
7 FBRC_S_ADDRESS COUNTRY T005 LAND1 REF C CN
8 FBRC_S_ADDRESS COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
9 FBRC_S_ADDRESS DEFLT_COMM TSAC COMM_TYPE REF C CN
10 FBRC_S_ADDRESS DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
11 FBRC_S_ADDRESS DONT_USE_P TSAD12 UNDELIVER KEY C CN
12 FBRC_S_ADDRESS DONT_USE_S TSAD12 UNDELIVER REF C CN
13 FBRC_S_ADDRESS LANGU T002 SPRAS REF C CN
14 FBRC_S_ADDRESS LANGU_CREA T002 SPRAS REF C CN
15 FBRC_S_ADDRESS LANGU_CR_P T002 SPRAS REF C CN
16 FBRC_S_ADDRESS LANGU_P T002 SPRAS REF C CN
17 FBRC_S_ADDRESS NAMCOUNTRY T005 LAND1 REF C CN
18 FBRC_S_ADDRESS NAMEFORMAT T005N NAMEFORMAT REF C CN
19 FBRC_S_ADDRESS PERSORIGIN TSAD6 ORIGIN REF C CN
20 FBRC_S_ADDRESS PO_BOX_CTY T005 LAND1 REF C CN
21 FBRC_S_ADDRESS PO_BOX_REG T005S BLAND REF C CN
22 FBRC_S_ADDRESS REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
23 FBRC_S_ADDRESS REGION T005S BLAND REF C CN
24 FBRC_S_ADDRESS STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
25 FBRC_S_ADDRESS STREETCODE ADRSTREET STRT_CODE REF C CN
26 FBRC_S_ADDRESS TIME_ZONE TTZZ TZONE REF C CN
27 FBRC_S_ADDRESS TITLE TSAD3 TITLE REF C CN
28 FBRC_S_ADDRESS TITLE_P TSAD3 TITLE REF C CN
29 FBRC_S_ADDRESS TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
30 FBRC_S_ADDRESS TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 500