SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

EFISEL Table in SAP | Field Selection Control for Address Data Table & Fields List

EFISEL is a SAP table coming under IS module and IS-UT component.View details, Fields & related tables of EFISEL in SAP.

  • Table description : Field Selection Control for Address Data
  • Module : IS-U-MD
  • Parent Module : IS
  • Package : EE01
  • Software Component : IS-UT
EFISEL table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP EFISEL Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
.INCLUDEFields of Table EFISEL Without Key    
TITELForm of address textEFISEL_TITLEEFISEL
NAME1Name 1EFISEL_NAME1EFISEL
SORT1Search term 1EFISEL_SORT1EFISEL
NAME2Name 2EFISEL_NAME2EFISEL
SORT2Search term 2EFISEL_SORT2EFISEL
NAME3Name 3EFISEL_NAME3EFISEL
LANGULanguage KeyEFISEL_LANGUEFISEL
NOT_USED1Field is not usedEFISEL_NOT_USEDEFISEL
NAME4Name 4EFISEL_NAME4EFISEL
STREETStreet NameEFISEL_STREETEFISEL
PO_BOXPost office boxEFISEL_PO_BOXEFISEL
CITY1LocationEFISEL_CITY1EFISEL
POST_CODE1City postal codeEFISEL_POST_CODE1EFISEL
CITY2City districtEFISEL_CITY2EFISEL
POST_CODE2PO Box Postal CodeEFISEL_POST_CODE2EFISEL
COUNTRYCountry KeyEFISEL_COUNTRYEFISEL
REGIONRegion (state, province, county)EFISEL_REGIONEFISEL
DEFLT_COMMCommunication Type (Key) (Central Address Management)EFISEL_DEFLT_COMMEFISEL
TEL_NUMBERFirst Telephone No.: Area Code + NumberEFISEL_TEL_NUMBEREFISEL
FAX_NUMBERFirst Fax No.: Dialling Code + NumberEFISEL_FAX_NUMBEREFISEL
MCOMOther communications dataEFISEL_MCOMEFISEL
HOUSE_NUM1House NumberEFISEL_HOUSE_NUM1EFISEL
NAME_COc/o NameEFISEL_NAME_COEFISEL
HOUSE_NUM2House number affixEFISEL_HOUSE_NUM2EFISEL
HOUSE_NUM3House Number RangeEFISEL_HOUSE_NUM3EFISEL
STR_SUPPL1Street 2EFISEL_STR_SUPPL1EFISEL
STR_SUPPL2Street 3EFISEL_STR_SUPPL2EFISEL
LOCATIONStreet 5EFISEL_LOCATIONEFISEL
BUILDINGBuilding (Number or Code)EFISEL_BUILDINGEFISEL
FLOORFloor in buildingEFISEL_FLOOREFISEL
ROOMNUMBERRoom or Appartment NumberEFISEL_ROOMNUMBEREFISEL
POSTALAREAPost delivery districtEFISEL_POSTALAREAEFISEL
TRANSPZONETransportation zone to or from which the goods are deliveredEFISEL_TRANSPZONEFISEL
POST_CODE3Company postal code (for large customers)EFISEL_POST_CODE3EFISEL
REMARKAddress notesEFISEL_REMARKEFISEL
ADDRORIGINSource for Address Data (key)EFISEL_ADDRORIGINEFISEL
DETAILDetailsEFISEL_DETAILEFISEL
NOT_USED2Field is not usedEFISEL_NOT_USEDEFISEL
NOT_USED3Field is not usedEFISEL_NOT_USEDEFISEL
NOT_USED6Field is not usedEFISEL_NOT_USEDEFISEL
NOT_USED7Field is not usedEFISEL_NOT_USEDEFISEL
NOT_USED4Field is not usedEFISEL_NOT_USEDEFISEL
NOT_USED5Field is not usedEFISEL_NOT_USEDEFISEL
TIME_ZONEAddress time zoneEFISEL_TIME_ZONEEFISEL
STR_SUPPL3Street 4EFISEL_STR_SUPPL3EFISEL
EXTENSION1Extension (only for data conversion) (e.g. data line)EFISEL_EXTENSION1EFISEL
EXTENSION2Extension (only for data conversion) (e.g. telebox)EFISEL_EXTENSION2EFISEL
TAXJURCODEJurisdiction for tax calculation - tax jurisdiction codeEFISEL_TAXJURCODEEFISEL
REGIOGROUPRegional structure groupingEFISEL_REGIOGROUPEFISEL
SMTP_ADDRE-mail AddressEFISEL_SMTP_ADDREFISEL
NOT_USED51Field is not usedEFISEL_NOT_USED10CHAR10
NOT_USED61Field is not usedEFISEL_NOT_USED10CHAR10
NOT_USED71Field is not usedEFISEL_NOT_USED10CHAR10
NOT_USED81Field is not usedEFISEL_NOT_USED10CHAR10
NOT_USED91Field is not usedEFISEL_NOT_USED10CHAR10
HOME_CITYCity (Different from Postal City)EFISEL_HOME_CITYEFISEL
PO_BOX_NUMIndicator: PO Box Without NumberEFISEL_PO_BOX_NUMEFISEL
PO_BOX_CTYPO Box CountryEFISEL_PO_BOX_CTYEFISEL
PO_BOX_REGRegion for PO Box (Country, State, Province, ...)EFISEL_PO_BOX_REGEFISEL
PO_BOX_LOCPO Box CityEFISEL_PO_BOX_LOCEFISEL
NOT_USED106Street Address Undeliverable FlagEFISEL_NO_USESEFISEL
NOT_USED107PO Box Address Undeliverable IndicatorEFISEL_NO_USEPEFISEL
NOT_USED108Field is not usedEFISEL_NOT_USEDEFISEL
MOB_NUMBERFirst Mobile Telephone Number: Area Code + ConnectionEFISEL_MOB_NUMBEREFISEL
DELI_SERV_TYPEType of Delivery ServiceEFISEL_DELI_SERV_TYPEEFISEL
DELI_SERV_NUMBERNumber of Delivery ServiceEFISEL_DELI_SERV_NUMBEREFISEL
PO_BOX_LOBBYPO Box LobbyEFISEL_PO_BOX_LOBBYEFISEL

EFISEL related tables

TableNote
EFISELField Selection Control for Address Data
EPROP_ADRFLD_SELField Selection Control for Address Screen of Property
TSAD6Source Address or Personal Data (Business Address Services)
/SAPSLL/ADRCMPKPrepared Address for Address Comparison: Communication Data
JBFIELDSELLISTControl Table for Field Selection Control
/SAPSLL/TFCSFNField Control: Field Names for Field Structure
/SAPSLL/TFCSFNTField Control: Field Names for Field Structure - Texts
DPR_FC_FC_OBJTYPField Control: Object Categories per Field Control Profile
ADCPPerson/Address Assignment (Business Address Services)
ADRCTAddress Texts (Business Address Services)
ADRCTS2Shadow Table 2: Address Texts (Business Address Services)
ADRSTATUSSADR -> ADRC address conversion status per address group
ADRVAddress Where-Used List (Business Address Services)
BBP_ADDRMAPMapping EBP Address Number <--> External Address Number/Type
CDBD_ADCPPerson/Address assignment (central address administration)
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com