SAP ABAP Table BSB_ADR (R3A BP: BAPI Structure for Address Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CBC1 (Package) CRM BP Data Exchange

Basic Data

Table Category	INTTAB	Structure
Structure	BSB_ADR	Table Relationship Diagram
Short Description	R3A BP: BAPI Structure for 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	STAND_ARD	☐	GB_XDFADR	CHAR1	CHAR	1	0	R3A BP: Selection: Address is Standard Address
2	C_O_NAME	☐	GB_NAME_CO	CHAR40	CHAR	40	0	R3A BP: c/o Name
3	CITY	☐	GB_CITY1	CHAR40	CHAR	40	0	R3A BP: City
4	DISTRICT	☐	GB_CITY2	CHAR40	CHAR	40	0	R3A BP: District
5	REGIOGROUP	☐	GB_REG_GRP	CHAR8	CHAR	8	0	R3A BP: Regional Structure Grouping
6	POSTL_COD1	☐	GB_PSTCD1	CHAR10	CHAR	10	0	R3A BP: Postal Code of City
7	POSTL_COD2	☐	GB_PSTCD2	CHAR10	CHAR	10	0	R3A BP: Postal Code of P.O. Box
8	POSTL_COD3	☐	GB_PSTCD3	CHAR10	CHAR	10	0	R3A BP: Postal Code of Company (for Major Customers)
9	PCODE1_EXT	☐	GB_PST1XT	CHAR10	CHAR	10	0	R3A BP: Extended Postal Code for City
10	PCODE2_EXT	☐	GB_PST2XT	CHAR10	CHAR	10	0	R3A BP: Extended Postal Code for P.O. Box
11	PCODE3_EXT	☐	GB_PST3XT	CHAR10	CHAR	10	0	R3A BP: Extended Major Customer Postal Code
12	PO_BOX	☐	GB_POBX	CHAR10	CHAR	10	0	R3A GP: P.O. Box
13	PO_W_O_NO	☐	GB_POBXNUM	CHAR1	CHAR	1	0	R3A GP: Indicator: P.O. Box Without Number
14	PO_BOX_CIT	☐	GB_POBXLOC	CHAR40	CHAR	40	0	R3A GP: P.O. Box City
15	PO_BOX_REG	☐	GB_POBXREG	CHAR3	CHAR	3	0	R3A GP: P.O. Box Region (State, County, Province)
16	POBOX_CTRY	☐	GB_POBXCTY	CHAR3	CHAR	3	0	R3A GP: P.O. Box Country
17	PO_CTRYISO	☐	GB_INTCA	CHAR2	CHAR	2	0	R3A BP: ISO Code of Country
18	STREET	☐	GB_STREET	CHAR60	CHAR	60	0	R3A BP: Street
19	STR_ABBR	☐	GB_STRABBR	CHAR2	CHAR	2	0	R3A BP: Abbreviation of Street Name (in Spain)
20	HOUSE_NO	☐	GB_HSNM1	CHAR10	CHAR	10	0	R3A BP: House Number
21	HOUSE_NO2	☐	GB_HSNM2	CHAR10	CHAR	10	0	R3A BP: House Number Supplement
22	HOUSE_NO3	☐	GB_HSNM3	CHAR10	CHAR	10	0	R3A BP: House Number Range
23	STR_SUPPL1	☐	GB_STRSPP1	CHAR40	CHAR	40	0	R3A BP: Street 2
24	STR_SUPPL2	☐	GB_STRSPP2	CHAR40	CHAR	40	0	R3A BP: Street 3
25	STR_SUPPL3	☐	GB_STRSPP3	CHAR40	CHAR	40	0	R3A BP: Street 4
26	LOCATION	☐	GB_LCTN	CHAR40	CHAR	40	0	R3A BP: Street 5
27	BUILDING	☐	GB_BLDNG	CHAR20	CHAR	20	0	R3A BP: Building (Number or ID)
28	FLOOR	☐	GB_FLOOR	CHAR10	CHAR	10	0	R3A BP: Floor in Building
29	ROOM_NO	☐	GB_ROOMNUM	CHAR10	CHAR	10	0	R3A BP: Room or Apartment Number
30	COUNTRY	☐	GB_LAND1	CHAR3	CHAR	3	0	R3A BP: Country Key
31	COUNTRYISO	☐	GB_INTCA	CHAR2	CHAR	2	0	R3A BP: ISO Code of Country
32	REGION	☐	GB_REGIO	CHAR3	CHAR	3	0	R3A BP: Region (State, County, Province, etc.)
33	TIME_ZONE	☐	GB_TZONE	CHAR6	CHAR	6	0	R3A BP: Time Zone of Address
34	TAXJURCODE	☐	GB_TXJCD	CHAR15	CHAR	15	0	R3A BP: Tax Jurisdiction Code - Location for Tax Calculation
35	HOME_CITY	☐	GB_CITY3	CHAR40	CHAR	40	0	R3A BP: Place of Residence (Different to Postal City)
36	TRANSPZONE	☐	GB_LZONE	CHAR10	CHAR	10	0	R3A BP:Transportation Zone to/from Which Goods are Delivered
37	LANGU	☐	GB_SPRAS	LANG	LANG	1	0	R3A BP: Language Key
38	LANGUISO	☐	GB_LAISO	CHAR2	CHAR	2	0	R3A BP: Language per ISO 639
39	COMM_TYPE	☐	GB_COMM	CHAR3	CHAR	3	0	R3A BP: Communication Method (Key) (Business Addr. Services)
40	EX_ADR_NUM	☐	GB_ADEXT	CHAR20	CHAR	20	0	R3A-BP: Address Number in External System
41	DONT_USE_P	☐	GB_NO_USEP	CHAR4	CHAR	4	0	R3A GP: Indicator for Undeliverability of P.O. Box Address
42	DONT_USE_S	☐	GB_NO_USES	CHAR4	CHAR	4	0	R3A GP: Indicator for Undeliverability of Street Address
43	MOVE_DATE	☐	GB_MOVEDAT	DATUM	DATS	8	0	Validity Date (Valid from)
44	MOVE_ADDRESS	☐	GB_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves	*
45	VALIDFROMDATE	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
46	VALIDTODATE	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
47	MOVE_ADDR_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
48	CITY_NO	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
49	DISTRCT_NO	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
50	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
51	PBOXCIT_NO	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
52	STREET_NO	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
53	HOMECITYNO	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
54	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
55	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	*
56	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
57	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
58	COUNTY_NO	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
59	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
60	TOWNSHIP_NO	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*

History

Last changed by/on	SAP	20141013
SAP Release Created in