EROB_ADDRFLD_SEL SAP (Field Selection Control for Add. Screen of Cleaning Object) Table details

Dictionary Type: Table
Description: Field Selection Control for Add. Screen of Cleaning Object




ABAP Code to SELECT data from EROB_ADDRFLD_SEL
Related tables to EROB_ADDRFLD_SEL
Access table EROB_ADDRFLD_SEL




Table field list including key, data, relationships and ABAP select examples

EROB_ADDRFLD_SEL is a standard SAP Table which is used to store Field Selection Control for Add. Screen of Cleaning Object data and is available within R/3 SAP systems depending on the version and release level.

The EROB_ADDRFLD_SEL table consists of various fields, each holding specific information or linking keys about Field Selection Control for Add. Screen of Cleaning Object data available in SAP. These include TITEL (Form of address text), NAME1 (Name 1), SORT1 (Search term 1), NAME2 (Name 2).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP EROB_ADDRFLD_SEL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
TITELForm of address text EFISEL_TITLECHAR1EFISEL
NAME1Name 1 EFISEL_NAME1CHAR1EFISEL
SORT1Search term 1 EFISEL_SORT1CHAR1EFISEL
NAME2Name 2 EFISEL_NAME2CHAR1EFISEL
SORT2Search term 2 EFISEL_SORT2CHAR1EFISEL
NAME3Name 3 EFISEL_NAME3CHAR1EFISEL
LANGULanguage Key EFISEL_LANGUCHAR1EFISEL
NOT_USED1Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NAME4Name 4 EFISEL_NAME4CHAR1EFISEL
STREETStreet Name EFISEL_STREETCHAR1EFISEL
PO_BOXPost office box EFISEL_PO_BOXCHAR1EFISEL
CITY1Location EFISEL_CITY1CHAR1EFISEL
POST_CODE1City postal code EFISEL_POST_CODE1CHAR1EFISEL
CITY2City district EFISEL_CITY2CHAR1EFISEL
POST_CODE2PO Box Postal Code EFISEL_POST_CODE2CHAR1EFISEL
COUNTRYCountry Key EFISEL_COUNTRYCHAR1EFISEL
REGIONRegion (state, province, county) EFISEL_REGIONCHAR1EFISEL
DEFLT_COMMCommunication Type (Key) (Central Address Management) EFISEL_DEFLT_COMMCHAR1EFISEL
TEL_NUMBERFirst Telephone No.: Area Code + Number EFISEL_TEL_NUMBERCHAR1EFISEL
FAX_NUMBERFirst Fax No.: Dialling Code + Number EFISEL_FAX_NUMBERCHAR1EFISEL
MCOMOther communications data EFISEL_MCOMCHAR1EFISEL
HOUSE_NUM1House Number EFISEL_HOUSE_NUM1CHAR1EFISEL
NAME_COc/o Name EFISEL_NAME_COCHAR1EFISEL
HOUSE_NUM2House number affix EFISEL_HOUSE_NUM2CHAR1EFISEL
HOUSE_NUM3House Number Range EFISEL_HOUSE_NUM3CHAR1EFISEL
STR_SUPPL1Street 2 EFISEL_STR_SUPPL1CHAR1EFISEL
STR_SUPPL2Street 3 EFISEL_STR_SUPPL2CHAR1EFISEL
LOCATIONStreet 5 EFISEL_LOCATIONCHAR1EFISEL
BUILDINGBuilding (Number or Code) EFISEL_BUILDINGCHAR1EFISEL
FLOORFloor in building EFISEL_FLOORCHAR1EFISEL
ROOMNUMBERRoom or Appartment Number EFISEL_ROOMNUMBERCHAR1EFISEL
POSTALAREAPost delivery district EFISEL_POSTALAREACHAR1EFISEL
TRANSPZONETransportation zone to or from which the goods are delivered EFISEL_TRANSPZONCHAR1EFISEL
POST_CODE3Company postal code (for large customers) EFISEL_POST_CODE3CHAR1EFISEL
REMARKAddress notes EFISEL_REMARKCHAR1EFISEL
ADDRORIGINSource for Address Data (key) EFISEL_ADDRORIGINCHAR1EFISEL
DETAILDetails EFISEL_DETAILCHAR1EFISEL
NOT_USED2Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NOT_USED3Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NOT_USED6Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NOT_USED7Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NOT_USED4Field is not used EFISEL_NOT_USEDCHAR1EFISEL
NOT_USED5Field is not used EFISEL_NOT_USEDCHAR1EFISEL
TIME_ZONEAddress time zone EFISEL_TIME_ZONECHAR1EFISEL
STR_SUPPL3Street 4 EFISEL_STR_SUPPL3CHAR1EFISEL
EXTENSION1Extension (only for data conversion) (e.g. data line) EFISEL_EXTENSION1CHAR1EFISEL
EXTENSION2Extension (only for data conversion) (e.g. telebox) EFISEL_EXTENSION2CHAR1EFISEL
TAXJURCODEJurisdiction for tax calculation - tax jurisdiction code EFISEL_TAXJURCODECHAR1EFISEL
REGIOGROUPRegional structure grouping EFISEL_REGIOGROUPCHAR1EFISEL
SMTP_ADDRE-mail Address EFISEL_SMTP_ADDRCHAR1EFISEL
NOT_USED51Field is not used EFISEL_NOT_USED10CHAR10CHAR10
NOT_USED61Field is not used EFISEL_NOT_USED10CHAR10CHAR10
NOT_USED71Field is not used EFISEL_NOT_USED10CHAR10CHAR10
NOT_USED81Field is not used EFISEL_NOT_USED10CHAR10CHAR10
NOT_USED91Field is not used EFISEL_NOT_USED10CHAR10CHAR10
HOME_CITYCity (Different from Postal City) EFISEL_HOME_CITYCHAR1EFISEL
PO_BOX_NUMIndicator: PO Box Without Number EFISEL_PO_BOX_NUMCHAR1EFISEL
PO_BOX_CTYPO Box Country EFISEL_PO_BOX_CTYCHAR1EFISEL
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) EFISEL_PO_BOX_REGCHAR1EFISEL
PO_BOX_LOCPO Box City EFISEL_PO_BOX_LOCCHAR1EFISEL
NOT_USED106Street Address Undeliverable Flag EFISEL_NO_USESCHAR1EFISEL
NOT_USED107PO Box Address Undeliverable Indicator EFISEL_NO_USEPCHAR1EFISEL
NOT_USED108Field is not used EFISEL_NOT_USEDCHAR1EFISEL
MOB_NUMBERFirst Mobile Telephone Number: Area Code + Connection EFISEL_MOB_NUMBERCHAR1EFISEL
DELI_SERV_TYPEType of Delivery Service EFISEL_DELI_SERV_TYPECHAR1EFISEL
DELI_SERV_NUMBERNumber of Delivery Service EFISEL_DELI_SERV_NUMBERCHAR1EFISEL
PO_BOX_LOBBYPO Box Lobby EFISEL_PO_BOX_LOBBYCHAR1EFISEL
NOT_USED113Field is not used EFISEL_NOT_USEDCHAR1EFISEL
COUNTYDistrict (US: County) EFISEL_COUNTYCHAR1EFISEL
TOWNSHIPCity EFISEL_TOWNSHIPCHAR1EFISEL

Key field Non-key field



How do I retrieve data from SAP table EROB_ADDRFLD_SEL using ABAP code

The following ABAP code Example will allow you to do a basic selection on EROB_ADDRFLD_SEL to SELECT all data from the table
DATA: WA_EROB_ADDRFLD_SEL TYPE EROB_ADDRFLD_SEL.

SELECT SINGLE *
FROM EROB_ADDRFLD_SEL
INTO CORRESPONDING FIELDS OF WA_EROB_ADDRFLD_SEL
WHERE...

How to access SAP table EROB_ADDRFLD_SEL

Within an ECC or HANA version of SAP you can also view further information about EROB_ADDRFLD_SEL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!