SAP ABAP Table EFISEL_STRUC (Fields of Table EFISEL Without Key)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WA (Application Component) Waste Management
     ⤷ EEWA (Package) IS-U: Waste Management

Basic Data

Table Category	INTTAB	Structure
Structure	EFISEL_STRUC	Table Relationship Diagram
Short Description	Fields of Table EFISEL Without Key

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