SAP Table ADRCS2 - Shadow Table 2: Addresses (Business Address Services)

Field	Key	Data Element	Type	Offset	Leng	Check Table	Text
CLIENT	X	MANDT	CLNT	0	3	T000	Client
TABLENAME	X	AD_APPLTAB	CHAR	3	10		Application table logical name (address management)
FIELDNAME	X	AD_APPLFLD	CHAR	13	10		Application table address where-used list logical field name
OBJKEY	X	AD_OBJKEY	CHAR	23	70		Address owner object ID
DATE_FROM	X	AD_DATE_FR	DATS	93	8		Valid-from date - in current Release only 00010101 possible
NATION	X	AD_NATION	CHAR	101	1	TSADV	International address version ID
DATE_TO		AD_DATE_TO	DATS	102	8		Valid-to date in current Release only 99991231 possible
TITLE		AD_TITLE	CHAR	110	4	TSAD3	Form-of-Address Key
NAME1		AD_NAME1	CHAR	114	40		Name 1
NAME2		AD_NAME2	CHAR	154	40		Name 2
NAME3		AD_NAME3	CHAR	194	40		Name 3
NAME4		AD_NAME4	CHAR	234	40		Name 4
NAME_TEXT		AD_NAMETXT	CHAR	274	50		Converted name field (with form of address)
NAME_CO		AD_NAME_CO	CHAR	324	40		c/o name
CITY1		AD_CITY1	CHAR	364	40		City
CITY2		AD_CITY2	CHAR	404	40		District
CITY_CODE		AD_CITYNUM	CHAR	444	12		City code for city/street file
CITYP_CODE		AD_CITYPNM	CHAR	456	8	ADRCITYPRT	District code for City and Street file
HOME_CITY		AD_CITY3	CHAR	464	40		City (different from postal city)
CITYH_CODE		AD_CITYHNM	CHAR	504	12		Different city for city/street file
CHCKSTATUS		AD_CHECKST	CHAR	516	1		City file test status
REGIOGROUP		REGIOGROUP	CHAR	517	8		Regional structure grouping
POST_CODE1		AD_PSTCD1	CHAR	525	10		City postal code
POST_CODE2		AD_PSTCD2	CHAR	535	10		PO Box postal code
POST_CODE3		AD_PSTCD3	CHAR	545	10		Company postal code (for large customers)
PCODE1_EXT		AD_PST1XT	CHAR	555	10		(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
PCODE2_EXT		AD_PST2XT	CHAR	565	10		(Not Supported) PO Box Postal Code Extension
PCODE3_EXT		AD_PST3XT	CHAR	575	10		(Not Supported) Major Customer Postal Code Extension
PO_BOX		AD_POBX	CHAR	585	10		PO Box
DONT_USE_P		AD_NO_USEP	CHAR	595	4		PO Box Address Undeliverable Flag
PO_BOX_NUM		AD_POBXNUM	CHAR	599	1		Flag: PO Box without number
PO_BOX_LOC		AD_POBXLOC	CHAR	600	40		PO Box city
CITY_CODE2		AD_CIT2NUM	CHAR	640	12		City PO box code (City file)
PO_BOX_REG		AD_POBXREG	CHAR	652	3	T005S	Region for PO Box (Country, State, Province, ...)
PO_BOX_CTY		AD_POBXCTY	CHAR	655	3	T005	PO box country
POSTALAREA		AD_PSTLAR	CHAR	658	15		(Not Supported) Post Delivery District
TRANSPZONE		LZONE	CHAR	673	10		Transportation zone to or from which the goods are delivered
STREET		AD_STREET	CHAR	683	60		Street
DONT_USE_S		AD_NO_USES	CHAR	743	4		Street Address Undeliverable Flag
STREETCODE		AD_STRNUM	CHAR	747	12		Street Number for City/Street File
STREETABBR		AD_STRABBR	CHAR	759	2	ADRSTRTYPE	(Not Supported) Abbreviation of Street Name
HOUSE_NUM1		AD_HSNM1	CHAR	761	10		House Number
HOUSE_NUM2		AD_HSNM2	CHAR	771	10		House number supplement
HOUSE_NUM3		AD_HSNM3	CHAR	781	10		(Not supported) House Number Range
STR_SUPPL1		AD_STRSPP1	CHAR	791	40		Street 2
STR_SUPPL2		AD_STRSPP2	CHAR	831	40		Street 3
STR_SUPPL3		AD_STRSPP3	CHAR	871	40		Street 4
LOCATION		AD_LCTN	CHAR	911	40		Street 5
BUILDING		AD_BLDNG	CHAR	951	20		Building (Number or Code)
FLOOR		AD_FLOOR	CHAR	971	10		Floor in building
ROOMNUMBER		AD_ROOMNUM	CHAR	981	10		Room or Appartment Number
COUNTRY		LAND1	CHAR	991	3	T005	Country Key
LANGU		SPRAS	LANG	994	1	T002	Language Key
REGION		REGIO	CHAR	995	3	T005S	Region (State, Province, County)
ADDR_GROUP		AD_GROUP	CHAR	998	4		Address Group (Key) (Business Address Services)
FLAGGROUPS		AD_FLGGP	CHAR	1002	1		Flag: There are more address group assignments
PERS_ADDR		AD_PRSADDR	CHAR	1003	1		Flag: This is a personal address
SORT1		AD_SORT1	CHAR	1004	20		Search Term 1
SORT2		AD_SORT2	CHAR	1024	20		Search Term 2
SORT_PHN		AD_SRTPHN	CHAR	1044	20		(Not Supported) Phonetic Search Sort Field
DEFLT_COMM		AD_COMM	CHAR	1064	3		Communication Method (Key) (Business Address Services)
TEL_NUMBER		AD_TLNMBR1	CHAR	1067	30		First telephone no.: dialling code+number
TEL_EXTENS		AD_TLXTNS1	CHAR	1097	10		First Telephone No.: Extension
FAX_NUMBER		AD_FXNMBR1	CHAR	1107	30		First fax no.: dialling code+number
FAX_EXTENS		AD_FXXTNS1	CHAR	1137	10		First fax no.: extension
FLAGCOMM2		AD_FLGCM02	CHAR	1147	1		Flag: Telephone number(s) maintained
FLAGCOMM3		AD_FLGCM03	CHAR	1148	1		Flag: Fax number(s) maintained
FLAGCOMM4		AD_FLGCM04	CHAR	1149	1		Flag: Teletex number(s) maintained
FLAGCOMM5		AD_FLGCM05	CHAR	1150	1		Flag: Telex number(s) maintained
FLAGCOMM6		AD_FLGCM06	CHAR	1151	1		Indicator: E-Mail Address(es) Maintained
FLAGCOMM7		AD_FLGCM07	CHAR	1152	1		Flag: RML (remote mail) addresse(s) maintained
FLAGCOMM8		AD_FLGCM08	CHAR	1153	1		Flag: X.400 addresse(s) maintained
FLAGCOMM9		AD_FLGCM09	CHAR	1154	1		Flag: RFC destination(s) maintained
FLAGCOMM10		AD_FLGCM10	CHAR	1155	1		Flag: Printer maintained
FLAGCOMM11		AD_FLGCM11	CHAR	1156	1		Flag: SSF maintained
FLAGCOMM12		AD_FLGCM12	CHAR	1157	1		Flag: URI/FTP address maintained
FLAGCOMM13		AD_FLGCM13	CHAR	1158	1		Flag: Pager address maintained
ADDRORIGIN		AD_ORIGINA	CHAR	1159	4		(Not Supported) Address Data Source (Key)
MC_NAME1		AD_MC_NAME	CHAR	1163	25		Name (field NAME1) in upper case for matchcode
MC_CITY1		AD_MC_CITY	CHAR	1188	25		City name in upper case for search help
MC_STREET		AD_MC_STRT	CHAR	1213	25		Street name in upper case for search help
EXTENSION1		AD_EXTENS1	CHAR	1238	40		Extension (only for data conversion) (e.g. data line)
EXTENSION2		AD_EXTENS2	CHAR	1278	40		Extension (only for data conversion) (e.g. telebox)
TIME_ZONE		AD_TZONE	CHAR	1318	6	TTZZ	Address time zone
TAXJURCODE		AD_TXJCD	CHAR	1324	15		Tax Jurisdiction
ADDRESS_ID		AD_ADDR_ID	CHAR	1339	10		(Not supported) Physical address ID
LANGU_CREA		AD_LANGUCR	LANG	1349	1	T002	Address record creation original language
PO_BOX_LOBBY		AD_PO_BOX_LBY	CHAR	1350	40		PO Box Lobby
DELI_SERV_TYPE		AD_DELIVERY_SERVICE_TYPE	CHAR	1390	4		Type of Delivery Service
DELI_SERV_NUMBER		AD_DELIVERY_SERVICE_NUMBER	CHAR	1394	10		Number of Delivery Service

1024253	Matchcode regeneration in Unicode systems
672835	Textflags could cause problems during Unicode conversion
673941	Unicode conversion for address tables (ADRC, ADRP)
385440	Repairing inconsistencies in Customizing addresses