SAP ABAP Table REXCJP_F1791 (Header Form)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_JP (Package) Localization Flexible Real Estate Japan

Basic Data

Table Category	INTTAB	Structure
Structure	REXCJP_F1791	Table Relationship Diagram
Short Description	Header Form

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	FSD	☐	REXCJPF1791_FSD		STRU	0	0
2	ALV_TEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
3	N01_REPDATE_ERA	☐	REXCJPREPJAPCALERA	CHAR20	CHAR	20	0	Reporting Date's Era (Wareki)
4	N01_REPDATE_YEAR	☐	REXCJPREPJAPCALYEAR	CHAR3	CHAR	3	0	Reporting Date's Year (Wareki)
5	N01_REPDATE_MONTH	☐	REXCJPREPJAPCALMON	CHAR2	CHAR	2	0	Reporting Date's Month (Wareki)
6	N01_REPDATE_DAY	☐	REXCJPREPJAPCALDAY	CHAR2	CHAR	2	0	Reporting Date's Day (Wareki)
7	N02_TAXOFFNAME	☐	REXCJPTONAME	BU_NAME	CHAR	40	0	Tax Office Name
8	N03_REPORTERADDR	☐	REXCJPREPORTERADDR	CHAR100	CHAR	100	0	Reporter's Address
9	N03_REPORTER	☐	REXCJPREPORTER		STRU	0	0
10	ALV_NO_DISPLAY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
11	.INCLUDE	☐				0	0	Addresses (Business Address Services)
12	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
13	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
14	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
15	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
16	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
17	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
18	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
19	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
20	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
21	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
22	NAME_TEXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
23	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
24	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
25	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
26	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
27	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
28	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
29	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
30	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
31	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
32	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
33	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
34	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
35	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
36	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
37	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
38	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
39	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
40	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
41	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
42	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
43	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
44	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
45	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
46	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
47	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
48	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
49	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
50	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
51	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
52	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
53	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
54	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
55	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
56	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
57	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
58	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
59	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
60	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
61	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
62	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
63	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
64	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)
65	FLAGGROUPS	☐	AD_FLGGP	XFELD	CHAR	1	0	Flag: There are more address group assignments
66	PERS_ADDR	☐	AD_PRSADDR	XFELD	CHAR	1	0	Flag: This is a personal address
67	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
68	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
69	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
70	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
71	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
72	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
73	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
74	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
75	FLAGCOMM2	☐	AD_FLGCM02	XFELD	CHAR	1	0	Flag: Telephone number(s) maintained
76	FLAGCOMM3	☐	AD_FLGCM03	XFELD	CHAR	1	0	Flag: Fax number(s) maintained
77	FLAGCOMM4	☐	AD_FLGCM04	XFELD	CHAR	1	0	Flag: Teletex number(s) maintained
78	FLAGCOMM5	☐	AD_FLGCM05	XFELD	CHAR	1	0	Flag: Telex number(s) maintained
79	FLAGCOMM6	☐	AD_FLGCM06	XFELD	CHAR	1	0	Indicator: E-Mail Address(es) Maintained
80	FLAGCOMM7	☐	AD_FLGCM07	XFELD	CHAR	1	0	Flag: RML (remote mail) addresse(s) maintained
81	FLAGCOMM8	☐	AD_FLGCM08	XFELD	CHAR	1	0	Flag: X.400 addresse(s) maintained
82	FLAGCOMM9	☐	AD_FLGCM09	XFELD	CHAR	1	0	Flag: RFC destination(s) maintained
83	FLAGCOMM10	☐	AD_FLGCM10	XFELD	CHAR	1	0	Flag: Printer maintained
84	FLAGCOMM11	☐	AD_FLGCM11	XFELD	CHAR	1	0	Flag: SSF maintained
85	FLAGCOMM12	☐	AD_FLGCM12	XFELD	CHAR	1	0	Flag: URI/FTP address maintained
86	FLAGCOMM13	☐	AD_FLGCM13	XFELD	CHAR	1	0	Flag: Pager address maintained
87	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
88	MC_NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
89	MC_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
90	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
91	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
92	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
93	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
94	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
95	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
96	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
97	ADRC_UUID	☐	AD_UUID	SYSUUID	RAW	16	0	UUID Used in the Address
98	UUID_BELATED	☐	AD_UUID_BELATED	AD_UUID_BELATED	CHAR	1	0	Indicator: UUID was generated later
99	ID_CATEGORY	☐	AD_ID_CATEGORY	AD_ID_CATEGORY	CHAR	1	0	Category of an Address ID
100	ADRC_ERR_STATUS	☐	AD_ERR_STATUS	AD_ERR_STATUS	CHAR	1	0	Error Status of Address
101	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
102	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
103	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
104	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
105	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
106	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
107	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
108	MC_COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
109	MC_TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
110	XPCPT	☐	AD_XPCPT	AD_XPCPT	CHAR	1	0	Business Purpose Completed Flag
111	XREGION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
112	N04_REPALTNAME	☐	REXCJPREPALTNAME	TEXT40	CHAR	40	0	Reporter Company's Alternative Name
113	N05_REPNAME	☐	REXCJPREPNAME	TEXT40	CHAR	40	0	Reporting Company's Name
114	N06_REPPRENAM	☐	REXCJPPRESNAME	TEXT40	CHAR	40	0	Reporting Company's President's Name
115	N07_REPCNNAME	☐	REXCJPCNNAME	TEXT40	CHAR	40	0	Contact Person's Name
116	N08_REPTEL	☐	REXCJPREPTEL	CHAR30	CHAR	30	0	Phone Number of the Contact Person
117	N09_REPTELEXT	☐	REXCJPREPTELEXT	CHAR10	CHAR	10	0	Contact Person's Phone Extension
118	N10_BDLOC	☐	REXCJPBDLOC		STRU	0	0
119	ALV_NO_DISPLAY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
120	.INCLUDE	☐				0	0	Address of an RE Object - Internal
121	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number
122	OBJTYPE	☐	RECABUSOBJTYPE	J_OBART	CHAR	2	0	Business Object Type of Object
123	OBJID	☐	RECABUSOBJID	CHAR45	CHAR	45	0	ID of Object
124	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
125	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
126	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
127	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
128	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
129	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
130	ADRZUS	☐	ADRZUS	TEXT35	CHAR	35	0	Address addit. info. (e.g. storey)
131	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
132	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
133	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
134	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
135	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
136	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
137	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
138	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
139	XREGION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
140	N10_BDLOCADDR	☐	REXCJPBUSIMPLELOCATION	CHAR200	CHAR	200	0	Address of Building
141	N11_BDNAME	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
142	N12_BDFLAREA	☐	REXCJPBDFLAREA	CHAR20	CHAR	20	0	Floor Area
143	N13_BDFLAEXP	☐	REXCJPBDFLAEXP	CHAR20	CHAR	20	0	Exclusive Floor Area
144	N14_BDFLBUS	☐	REXCJPBDFLBUS	CHAR20	CHAR	20	0	Business Floor Area
145	N15_BDFLRES	☐	REXCJPBDFLRES	CHAR20	CHAR	20	0	Residential Floor Area
146	N16_BDFLTOTAL	☐	REXCJPBDFLTOTAL	CHAR20	CHAR	20	0	Total Common Floor Area
147	N17_BDFLTAXFR	☐	REXCJPBDFLTAXFR	CHAR20	CHAR	20	0	Tax Free Floor Area
148	N18_BDFLNOTAXF	☐	REXCJPBDFLNOTAXF	CHAR20	CHAR	20	0	No Tax Free Floor Area
149	N19_BDFLBUS2	☐	REXCJPBUS2	CHAR20	CHAR	20	0	Calculated Business Floor Area
150	N20_BDCONST	☐	REXCJPBDCONST	CHAR20	CHAR	20	0	Construction Status
151	N21_BDCONDT_ERA	☐	REXCJPBDCONDTERA	CHAR20	CHAR	20	0	Construction Date's Era (Wareki)
152	N21_BDCONDT_YEAR	☐	REXCJPBDCONDTYEAR	CHAR3	CHAR	3	0	Construction Date's Year (Wareki)
153	N21_BDCONDT_MONTH	☐	REXCJPBDCONDTMONTH	CHAR2	CHAR	2	0	Construction Date's Month (Wareki)
154	N21_BDCONDT_DAY	☐	REXCJPBDCONDTDAY	CHAR2	CHAR	2	0	Construction Date's Day (Wareki)
155	N22_BDOWNSH	☐	REXCJPBDOWNSH	CHAR20	CHAR	20	0	Ownership of the Building
156	N23_BDOTHOW	☐	REXCJPBDOTHOW	INT4	INT4	10	0	Number of Another Owners in the Same Building
157	N24_BDFIREPREV	☐	REXCJPBDFIREPREV	CHAR8	CHAR	8	0	Fire Fighting Method Number
158	N25_REPEXFLAR	☐	REXCJPEXFLAR	CHAR20	CHAR	20	0	Exclusive Floor Area
159	N26_REPCOFLAR	☐	REXCJPCOFLAR	CHAR20	CHAR	20	0	Common Floor Area
160	N27_REPTOTFLAR	☐	REXCJPTOFLAR	CHAR20	CHAR	20	0	Total Floor Area
161	N28_REPKOCH	☐	REXCJPPKOCH	CHAR20	CHAR	20	0	Kind of Change
162	N29_REPKOCHDAT_ERA	☐	REXCJPKOCHJAPCALERA	CHAR20	CHAR	20	0	Change Date's Era (Wareki)
163	N29_REPKOCHDAT_YEAR	☐	REXCJPKOCHJAPCALYEAR	CHAR3	CHAR	3	0	Change Date's Year (Wareki)
164	N29_REPKOCHDAT_MONTH	☐	REXCJPKOCHJAPCALMON	CHAR2	CHAR	2	0	Change Date's Month (Wareki)
165	N29_REPKOCHDAT_DAY	☐	REXCJPKOCHJAPCALDAY	CHAR2	CHAR	2	0	Change Date's Day (Wareki)
166	N30_SLADDRESSSHORT	☐	REXCJPSLADDRESSSHORT	CHAR100	CHAR	100	0	Owner's Address
167	N30_SLADDRESS	☐	REXCJPSLADDRESS		STRU	0	0
168	ALV_NO_DISPLAY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
169	.INCLUDE	☐				0	0	Addresses (Business Address Services)
170	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
171	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
172	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
173	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
174	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
175	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
176	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
177	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
178	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
179	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
180	NAME_TEXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
181	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
182	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
183	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
184	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
185	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
186	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
187	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
188	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
189	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
190	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
191	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
192	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
193	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
194	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
195	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
196	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
197	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
198	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
199	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
200	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
201	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
202	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
203	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
204	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
205	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
206	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
207	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
208	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
209	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
210	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
211	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
212	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
213	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
214	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
215	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
216	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
217	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
218	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
219	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
220	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
221	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
222	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)
223	FLAGGROUPS	☐	AD_FLGGP	XFELD	CHAR	1	0	Flag: There are more address group assignments
224	PERS_ADDR	☐	AD_PRSADDR	XFELD	CHAR	1	0	Flag: This is a personal address
225	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
226	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
227	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
228	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
229	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
230	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
231	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
232	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
233	FLAGCOMM2	☐	AD_FLGCM02	XFELD	CHAR	1	0	Flag: Telephone number(s) maintained
234	FLAGCOMM3	☐	AD_FLGCM03	XFELD	CHAR	1	0	Flag: Fax number(s) maintained
235	FLAGCOMM4	☐	AD_FLGCM04	XFELD	CHAR	1	0	Flag: Teletex number(s) maintained
236	FLAGCOMM5	☐	AD_FLGCM05	XFELD	CHAR	1	0	Flag: Telex number(s) maintained
237	FLAGCOMM6	☐	AD_FLGCM06	XFELD	CHAR	1	0	Indicator: E-Mail Address(es) Maintained
238	FLAGCOMM7	☐	AD_FLGCM07	XFELD	CHAR	1	0	Flag: RML (remote mail) addresse(s) maintained
239	FLAGCOMM8	☐	AD_FLGCM08	XFELD	CHAR	1	0	Flag: X.400 addresse(s) maintained
240	FLAGCOMM9	☐	AD_FLGCM09	XFELD	CHAR	1	0	Flag: RFC destination(s) maintained
241	FLAGCOMM10	☐	AD_FLGCM10	XFELD	CHAR	1	0	Flag: Printer maintained
242	FLAGCOMM11	☐	AD_FLGCM11	XFELD	CHAR	1	0	Flag: SSF maintained
243	FLAGCOMM12	☐	AD_FLGCM12	XFELD	CHAR	1	0	Flag: URI/FTP address maintained
244	FLAGCOMM13	☐	AD_FLGCM13	XFELD	CHAR	1	0	Flag: Pager address maintained
245	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
246	MC_NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
247	MC_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
248	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
249	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
250	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
251	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
252	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
253	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
254	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
255	ADRC_UUID	☐	AD_UUID	SYSUUID	RAW	16	0	UUID Used in the Address
256	UUID_BELATED	☐	AD_UUID_BELATED	AD_UUID_BELATED	CHAR	1	0	Indicator: UUID was generated later
257	ID_CATEGORY	☐	AD_ID_CATEGORY	AD_ID_CATEGORY	CHAR	1	0	Category of an Address ID
258	ADRC_ERR_STATUS	☐	AD_ERR_STATUS	AD_ERR_STATUS	CHAR	1	0	Error Status of Address
259	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
260	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
261	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
262	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
263	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
264	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
265	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
266	MC_COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
267	MC_TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
268	XPCPT	☐	AD_XPCPT	AD_XPCPT	CHAR	1	0	Business Purpose Completed Flag
269	XREGION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
270	N31_SLALTNAME	☐	REXCJPSALTNAME	TEXT40	CHAR	40	0	Owner's Alternative Name
271	N32_SLNAME	☐	REXCJPSNAME	TEXT40	CHAR	40	0	Owner's Name
272	N33_SLTEL	☐	REXCJPSLTEL	CHAR30	CHAR	30	0	Owner's Phone Number
273	N34_SLTELEXT	☐	REXCJPTELEXT	CHAR10	CHAR	10	0	Owner's Phone Extension
274	MEASUREUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit
275	S1M	☐	IDALV_T_MSG		TTYP	0	0
276	S1S	☐	IDALV_T_STAT		TTYP	0	0

History

Last changed by/on	SAP	20140121
SAP Release Created in	700