SAP ABAP Table EFISEL (Field Selection Control for Address Data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EFISEL	Table Relationship Diagram
Short Description	Field Selection Control for Address Data

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☐				0	0	Fields of Table EFISEL Without Key
3	TITEL	☐	EFISEL_TITLE	EFISEL	CHAR	1	0	Form of address text
4	NAME1	☐	EFISEL_NAME1	EFISEL	CHAR	1	0	Name 1
5	SORT1	☐	EFISEL_SORT1	EFISEL	CHAR	1	0	Search term 1
6	NAME2	☐	EFISEL_NAME2	EFISEL	CHAR	1	0	Name 2
7	SORT2	☐	EFISEL_SORT2	EFISEL	CHAR	1	0	Search term 2
8	NAME3	☐	EFISEL_NAME3	EFISEL	CHAR	1	0	Name 3
9	LANGU	☐	EFISEL_LANGU	EFISEL	CHAR	1	0	Language Key
10	NOT_USED1	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
11	NAME4	☐	EFISEL_NAME4	EFISEL	CHAR	1	0	Name 4
12	STREET	☐	EFISEL_STREET	EFISEL	CHAR	1	0	Street Name
13	PO_BOX	☐	EFISEL_PO_BOX	EFISEL	CHAR	1	0	Post office box
14	CITY1	☐	EFISEL_CITY1	EFISEL	CHAR	1	0	Location
15	POST_CODE1	☐	EFISEL_POST_CODE1	EFISEL	CHAR	1	0	City postal code
16	CITY2	☐	EFISEL_CITY2	EFISEL	CHAR	1	0	City district
17	POST_CODE2	☐	EFISEL_POST_CODE2	EFISEL	CHAR	1	0	PO Box Postal Code
18	COUNTRY	☐	EFISEL_COUNTRY	EFISEL	CHAR	1	0	Country Key
19	REGION	☐	EFISEL_REGION	EFISEL	CHAR	1	0	Region (state, province, county)
20	DEFLT_COMM	☐	EFISEL_DEFLT_COMM	EFISEL	CHAR	1	0	Communication Type (Key) (Central Address Management)
21	TEL_NUMBER	☐	EFISEL_TEL_NUMBER	EFISEL	CHAR	1	0	First Telephone No.: Area Code + Number
22	FAX_NUMBER	☐	EFISEL_FAX_NUMBER	EFISEL	CHAR	1	0	First Fax No.: Dialling Code + Number
23	MCOM	☐	EFISEL_MCOM	EFISEL	CHAR	1	0	Other communications data
24	HOUSE_NUM1	☐	EFISEL_HOUSE_NUM1	EFISEL	CHAR	1	0	House Number
25	NAME_CO	☐	EFISEL_NAME_CO	EFISEL	CHAR	1	0	c/o Name
26	HOUSE_NUM2	☐	EFISEL_HOUSE_NUM2	EFISEL	CHAR	1	0	House number affix
27	HOUSE_NUM3	☐	EFISEL_HOUSE_NUM3	EFISEL	CHAR	1	0	House Number Range
28	STR_SUPPL1	☐	EFISEL_STR_SUPPL1	EFISEL	CHAR	1	0	Street 2
29	STR_SUPPL2	☐	EFISEL_STR_SUPPL2	EFISEL	CHAR	1	0	Street 3
30	LOCATION	☐	EFISEL_LOCATION	EFISEL	CHAR	1	0	Street 5
31	BUILDING	☐	EFISEL_BUILDING	EFISEL	CHAR	1	0	Building (Number or Code)
32	FLOOR	☐	EFISEL_FLOOR	EFISEL	CHAR	1	0	Floor in building
33	ROOMNUMBER	☐	EFISEL_ROOMNUMBER	EFISEL	CHAR	1	0	Room or Appartment Number
34	POSTALAREA	☐	EFISEL_POSTALAREA	EFISEL	CHAR	1	0	Post delivery district
35	TRANSPZONE	☐	EFISEL_TRANSPZON	EFISEL	CHAR	1	0	Transportation zone to or from which the goods are delivered
36	POST_CODE3	☐	EFISEL_POST_CODE3	EFISEL	CHAR	1	0	Company postal code (for large customers)
37	REMARK	☐	EFISEL_REMARK	EFISEL	CHAR	1	0	Address notes
38	ADDRORIGIN	☐	EFISEL_ADDRORIGIN	EFISEL	CHAR	1	0	Source for Address Data (key)
39	DETAIL	☐	EFISEL_DETAIL	EFISEL	CHAR	1	0	Details
40	NOT_USED2	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
41	NOT_USED3	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
42	NOT_USED6	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
43	NOT_USED7	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
44	NOT_USED4	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
45	NOT_USED5	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
46	TIME_ZONE	☐	EFISEL_TIME_ZONE	EFISEL	CHAR	1	0	Address time zone
47	STR_SUPPL3	☐	EFISEL_STR_SUPPL3	EFISEL	CHAR	1	0	Street 4
48	EXTENSION1	☐	EFISEL_EXTENSION1	EFISEL	CHAR	1	0	Extension (only for data conversion) (e.g. data line)
49	EXTENSION2	☐	EFISEL_EXTENSION2	EFISEL	CHAR	1	0	Extension (only for data conversion) (e.g. telebox)
50	TAXJURCODE	☐	EFISEL_TAXJURCODE	EFISEL	CHAR	1	0	Jurisdiction for tax calculation - tax jurisdiction code
51	REGIOGROUP	☐	EFISEL_REGIOGROUP	EFISEL	CHAR	1	0	Regional structure grouping
52	SMTP_ADDR	☐	EFISEL_SMTP_ADDR	EFISEL	CHAR	1	0	E-mail Address
53	NOT_USED51	☐	EFISEL_NOT_USED10	CHAR10	CHAR	10	0	Field is not used
54	NOT_USED61	☐	EFISEL_NOT_USED10	CHAR10	CHAR	10	0	Field is not used
55	NOT_USED71	☐	EFISEL_NOT_USED10	CHAR10	CHAR	10	0	Field is not used
56	NOT_USED81	☐	EFISEL_NOT_USED10	CHAR10	CHAR	10	0	Field is not used
57	NOT_USED91	☐	EFISEL_NOT_USED10	CHAR10	CHAR	10	0	Field is not used
58	HOME_CITY	☐	EFISEL_HOME_CITY	EFISEL	CHAR	1	0	City (Different from Postal City)
59	PO_BOX_NUM	☐	EFISEL_PO_BOX_NUM	EFISEL	CHAR	1	0	Indicator: PO Box Without Number
60	PO_BOX_CTY	☐	EFISEL_PO_BOX_CTY	EFISEL	CHAR	1	0	PO Box Country
61	PO_BOX_REG	☐	EFISEL_PO_BOX_REG	EFISEL	CHAR	1	0	Region for PO Box (Country, State, Province, ...)
62	PO_BOX_LOC	☐	EFISEL_PO_BOX_LOC	EFISEL	CHAR	1	0	PO Box City
63	NOT_USED106	☐	EFISEL_NO_USES	EFISEL	CHAR	1	0	Street Address Undeliverable Flag
64	NOT_USED107	☐	EFISEL_NO_USEP	EFISEL	CHAR	1	0	PO Box Address Undeliverable Indicator
65	NOT_USED108	☐	EFISEL_NOT_USED	EFISEL	CHAR	1	0	Field is not used
66	MOB_NUMBER	☐	EFISEL_MOB_NUMBER	EFISEL	CHAR	1	0	First Mobile Telephone Number: Area Code + Connection
67	DELI_SERV_TYPE	☐	EFISEL_DELI_SERV_TYPE	EFISEL	CHAR	1	0	Type of Delivery Service
68	DELI_SERV_NUMBER	☐	EFISEL_DELI_SERV_NUMBER	EFISEL	CHAR	1	0	Number of Delivery Service
69	PO_BOX_LOBBY	☐	EFISEL_PO_BOX_LOBBY	EFISEL	CHAR	1	0	PO Box Lobby

History

Last changed by/on	SAP	20110810
SAP Release Created in