EFISEL - Field Selection Control for Address Data

Field Selection Control for Address Data information is stored in SAP table EFISEL.
It is part of development package EE01 in software component IS-U-MD. This development package consists of objects that can be grouped under "IS-U Master Data".

Fields for table EFISEL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE				EFISEL_STRUC	0
TITEL	Form of address text		EFISEL_TITLE	CHAR	2
NAME1	Name 1		EFISEL_NAME1	CHAR	2
SORT1	Search term 1		EFISEL_SORT1	CHAR	2
NAME2	Name 2		EFISEL_NAME2	CHAR	2
SORT2	Search term 2		EFISEL_SORT2	CHAR	2
NAME3	Name 3		EFISEL_NAME3	CHAR	2
LANGU	Language Key		EFISEL_LANGU	CHAR	2
NOT_USED1	Field is not used		EFISEL_NOT_USED	CHAR	2
NAME4	Name 4		EFISEL_NAME4	CHAR	2
STREET	Street Name		EFISEL_STREET	CHAR	2
PO_BOX	Post office box		EFISEL_PO_BOX	CHAR	2
CITY1	Location		EFISEL_CITY1	CHAR	2
POST_CODE1	City postal code		EFISEL_POST_CODE1	CHAR	2
CITY2	City district		EFISEL_CITY2	CHAR	2
POST_CODE2	PO Box Postal Code		EFISEL_POST_CODE2	CHAR	2
COUNTRY	Country/Region Key		EFISEL_COUNTRY	CHAR	2
REGION	Region (state, province, county)		EFISEL_REGION	CHAR	2
DEFLT_COMM	Communication Type (Key) (Central Address Management)		EFISEL_DEFLT_COMM	CHAR	2
TEL_NUMBER	First Telephone No.: Area Code + Number		EFISEL_TEL_NUMBER	CHAR	2
FAX_NUMBER	First Fax No.: Dialling Code + Number		EFISEL_FAX_NUMBER	CHAR	2
MCOM	Other communications data		EFISEL_MCOM	CHAR	2
HOUSE_NUM1	House Number		EFISEL_HOUSE_NUM1	CHAR	2
NAME_CO	c/o Name		EFISEL_NAME_CO	CHAR	2
HOUSE_NUM2	House number affix		EFISEL_HOUSE_NUM2	CHAR	2
HOUSE_NUM3	House Number Range		EFISEL_HOUSE_NUM3	CHAR	2
STR_SUPPL1	Street 2		EFISEL_STR_SUPPL1	CHAR	2
STR_SUPPL2	Street 3		EFISEL_STR_SUPPL2	CHAR	2
LOCATION	Street 5		EFISEL_LOCATION	CHAR	2
BUILDING	Building (Number or Code)		EFISEL_BUILDING	CHAR	2
FLOOR	Floor in building		EFISEL_FLOOR	CHAR	2
ROOMNUMBER	Room or Appartment Number		EFISEL_ROOMNUMBER	CHAR	2
POSTALAREA	Post delivery district		EFISEL_POSTALAREA	CHAR	2
TRANSPZONE	Transportation zone to or from which the goods are delivered		EFISEL_TRANSPZON	CHAR	2
POST_CODE3	Company postal code (for large customers)		EFISEL_POST_CODE3	CHAR	2
REMARK	Address notes		EFISEL_REMARK	CHAR	2
ADDRORIGIN	Source for Address Data (key)		EFISEL_ADDRORIGIN	CHAR	2
DETAIL	Details		EFISEL_DETAIL	CHAR	2
NOT_USED2	Field is not used		EFISEL_NOT_USED	CHAR	2
NOT_USED3	Field is not used		EFISEL_NOT_USED	CHAR	2
NOT_USED6	Field is not used		EFISEL_NOT_USED	CHAR	2
NOT_USED7	Field is not used		EFISEL_NOT_USED	CHAR	2
NOT_USED4	Field is not used		EFISEL_NOT_USED	CHAR	2
NOT_USED5	Field is not used		EFISEL_NOT_USED	CHAR	2
TIME_ZONE	Address time zone		EFISEL_TIME_ZONE	CHAR	2
STR_SUPPL3	Street 4		EFISEL_STR_SUPPL3	CHAR	2
EXTENSION1	Extension (only for data conversion) (e.g. data line)		EFISEL_EXTENSION1	CHAR	2
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		EFISEL_EXTENSION2	CHAR	2
TAXJURCODE	Jurisdiction for tax calculation - tax jurisdiction code		EFISEL_TAXJURCODE	CHAR	2
REGIOGROUP	Regional structure grouping		EFISEL_REGIOGROUP	CHAR	2
SMTP_ADDR	E-mail Address		EFISEL_SMTP_ADDR	CHAR	2
NOT_USED51	Field is not used		EFISEL_NOT_USED10	CHAR	20
NOT_USED61	Field is not used		EFISEL_NOT_USED10	CHAR	20
NOT_USED71	Field is not used		EFISEL_NOT_USED10	CHAR	20
NOT_USED81	Field is not used		EFISEL_NOT_USED10	CHAR	20
NOT_USED91	Field is not used		EFISEL_NOT_USED10	CHAR	20
HOME_CITY	City (Different from Postal City)		EFISEL_HOME_CITY	CHAR	2
PO_BOX_NUM	Indicator: PO Box Without Number		EFISEL_PO_BOX_NUM	CHAR	2
PO_BOX_CTY	PO Box Country/Region		EFISEL_PO_BOX_CTY	CHAR	2
PO_BOX_REG	Region for PO Box (Country, State, Province, ...)		EFISEL_PO_BOX_REG	CHAR	2
PO_BOX_LOC	PO Box City		EFISEL_PO_BOX_LOC	CHAR	2
NOT_USED106	Street Address Undeliverable Flag		EFISEL_NO_USES	CHAR	2
NOT_USED107	PO Box Address Undeliverable Indicator		EFISEL_NO_USEP	CHAR	2
NOT_USED108	Field is not used		EFISEL_NOT_USED	CHAR	2
MOB_NUMBER	First Mobile Telephone Number: Area Code + Connection		EFISEL_MOB_NUMBER	CHAR	2
DELI_SERV_TYPE	Type of Delivery Service		EFISEL_DELI_SERV_TYPE	CHAR	2
DELI_SERV_NUMBER	Number of Delivery Service		EFISEL_DELI_SERV_NUMBER	CHAR	2
PO_BOX_LOBBY	PO Box Lobby		EFISEL_PO_BOX_LOBBY	CHAR	2
NOT_USED113	Field is not used		EFISEL_NOT_USED	CHAR	2
COUNTY	District (US: County)		EFISEL_COUNTY	CHAR	2
TOWNSHIP	City		EFISEL_TOWNSHIP	CHAR	2