EFINDD SAP (IS-U Data Finder Screen Fields) Structure details

Dictionary Type: Structure
Description: IS-U Data Finder Screen Fields




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




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

EFINDD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-U Data Finder Screen Fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_EFINDD TYPE EFINDD.

The EFINDD table consists of various fields, each holding specific information or linking keys about IS-U Data Finder Screen Fields data available in SAP. These include C_BUPART (Business Partner Number), C_MC_NAME1 (Name field 1 (name1/last name)), C_MC_NAME2 (Name field 2 (name2/first name)), C_CITY1 (City).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP EFINDD structure 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
C_BUPARTBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
C_MC_NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
C_MC_NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
C_CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
C_CITY2District AD_CITY2CHAR40TEXT40CITY_PART
C_POST_CO1City postal code AD_PSTCD1CHAR10CHAR10
C_POST_CO2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
C_POST_CO3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
C_PO_BOX_LPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
C_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
C_HOUSE_N1House Number AD_HSNM1CHAR10TEXT10
C_HOUSE_N2House number supplement AD_HSNM2CHAR10TEXT10
C_HOUSE_N3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
C_COUNTRYCountry Key LAND1CHAR3T005LAND1LND
C_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
C_SORT1Search Term 1 AD_SORT1CHAR20CHAR20
C_SORT2Search Term 2 AD_SORT2CHAR20CHAR20
C_SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
C_ADDRNUMAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
C_TELNR_LONGComplete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
C_SOC_SECURESocial Insurance Number E_SOC_SECUCHAR12E_SOC_SECU
C_DR_LICENSEDriver's license number DR_LICENSECHAR20DR_LICENSE
C_WELFAREWelfare office WELFARECHAR9WELFARE
C_BANK_ACCOUNTBank account number BANKNCHAR18BANKN
C_BANK_NUMBERBank number BANKLCHAR15BANKLBLZ
C_BANK_COUNTRYBank country key BANKSCHAR3Assigned to domainLAND1BKL
C_TAXTYPETax Number Category BPTAXTYPECHAR4BPTAXTYPE
C_TAXNUMBusiness Partner Tax Number BPTAXNUMCHAR20BPTAXNUM
A_VKONTContract Account Number VKONT_KKCHAR12Assigned to domainALPHAVKONT_KKKTOFKKVKP_F4
A_ABWREAlternative Payer ABWRE_KKCHAR10Assigned to domainALPHABU_PARTNERBUPA
A_ABWRAAlternative Payee ABWRA_KKCHAR10Assigned to domainALPHABU_PARTNERBUPA
A_ABWRHAlternative Invoice Recipient ABWRH_KKCHAR10Assigned to domainALPHABU_PARTNERBUPA
A_ABWMAAlternative dunning recipient ABWMA_KKCHAR10Assigned to domainALPHABU_PARTNERBUPA
A_ABWVKAlternative contract account for collective bills ABWVK_KKCHAR12Assigned to domainALPHAVKONT_KK
A_VKONVContract account used for payment transactions VKONV_KKCHAR12Assigned to domainALPHAVKONT_KK
V_VERTRAGContract VERTRAGCHAR10Assigned to domainALPHAVERTRAGVTGEVER
V_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
V_SPARTEDivision SPARTECHAR2TSPASPARTSPA
V_DATEDate used in finding object ECF_DATEDATS8DATUM
U_OPBELBudget billing plan ABPLANNRCHAR12Assigned to domainALPHAOPBEL_KKOP1EABP
U_DATEDate used in finding object ECF_DATEDATS8DATUM
O_HAUSConnection Object HAUSCHAR30Assigned to domainTPLNRTPLNRHAUEHAU
O_CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
O_CITY2District AD_CITY2CHAR40TEXT40CITY_PART
O_POST_CO1City postal code AD_PSTCD1CHAR10CHAR10
O_POST_CO2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
O_POST_CO3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
O_PO_BOX_LPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
O_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
O_HOUSE_N1House Number AD_HSNM1CHAR10TEXT10
O_HOUSE_N2House number supplement AD_HSNM2CHAR10TEXT10
O_HOUSE_N3House Number AD_HSNM1CHAR10TEXT10
O_COUNTRYCountry Key LAND1CHAR3T005LAND1LND
O_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
O_SORT1Search Term 1 AD_SORT1CHAR20CHAR20
O_SORT2Search Term 2 AD_SORT2CHAR20CHAR20
O_SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
O_ADDRNUMAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
P_VSTELLEPremise VSTELLECHAR10Assigned to domainALPHAVSTELLEVBSEVBS
P_HAUS_NUM2House number supplement AD_HSNM2CHAR10TEXT10
P_STR_ERG2Street 3 AD_STRSPP2CHAR40TEXT40
P_STR_ERG4Street 5 AD_LCTNCHAR40TEXT40
P_FLOORFloor in building AD_FLOORCHAR10TEXT10
P_ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
P_EIGENTOwner E_GPARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
I_ANLAGEInstallation ANLAGECHAR10Assigned to domainALPHAANLAGEANLEANL
I_SPARTEDivision SPARTECHAR2TSPASPARTSPA
I_AKLASSEBilling class AKLASSECHAR4Assigned to domainAKLASSEAKL
I_DATEDate used in finding object ECF_DATEDATS8DATUM
I_PODPoint of delivery ID EXT_UICHAR50EXT_UIEXT_POD
I_POD_DATEDate used in finding object ECF_DATEDATS8DATUM
L_DEVLOCDevice Location DEVLOCCHAR30Assigned to domainTPLNRTPLNRGEPEGPL
L_STORTLocation of maintenance object PMLOCCHAR10Assigned to domainAP_STAND
D_EQUNREquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
D_GERAETSerial Number GERNRCHAR18GERNRGERNRSER
D_SPARTEDivision SPARTECHAR2TSPASPARTSPA
D_DATEDate used in finding object ECF_DATEDATS8DATUM
R_OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B
R_DATEPosting Date in the Document BUDAT_KKDATS8DATUM
S_AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
S_ASTNROrder status AUFASTNRNUMC2Assigned to domainAUFSTNR
S_AUARTOrder Type AUFARTCHAR4Assigned to domainAUFARTAAT
S_AUTYPOrder category AUFTYPNUMC2AUFTYP
S_QMNUMNotification No QMNUMCHAR12Assigned to domainALPHAQMNUMIQM
M_AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
M_ASTNROrder status AUFASTNRNUMC2Assigned to domainAUFSTNR
M_QMNUMNotification No QMNUMCHAR12Assigned to domainALPHAQMNUMIQM
M_AUARTOrder Type AUFARTCHAR4Assigned to domainAUFARTAAT
X_DATEGlobal date ECF_XDATEDATS8DATUM
X_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
X_SPARTEDivision SPARTECHAR2TSPASPARTSPA
L_BY_DEVICFind device location via device ECF_BY_DEVCHAR1KENNZX
KEEPSELData finder: keep selection ECF_KEEPCHAR1KENNZX
SEARCHSTRINGGeneric Search String in Form of Free Text Field SEARCHSTRINGCHAR132TEXT132
C_BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
C_BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
C_EMAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
V_DATE_TODate used in finding object ECF_DATEDATS8DATUM
SD_PONUMBERCustomer PO number as matchcode field BSTKD_MCHAR35CHAR35
SD_VBELNSales and Distribution Document Number VBELNCHAR10VBUKALPHAVBELNAUN
SD_VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
SD_AUARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
X_ALL_NATIONSTake into Account Versions for Internation Addresses Only E_ALL_NATIONSCHAR1XFELDE_ALL_NATIONS
X_NATIONVersion ID for International Addresses AD_NATIONCHAR1Assigned to domainAD_NATIONADDRESS_NATION
J_DISCPROCVProcessing variant for disconnection/reconnection DISCPROCVCHAR4Assigned to domainDISCPROCV
J_DISCREASONDisconnection reason DISCREASONCHAR2DISCREASON
J_STATUSStatus of disconnection document EDCDOCSTATNUMC2ALPHAEDCDOCSTAT
J_ERDATDate on Which Record Was Created ERDATDATS8DATUM
J_DISCNODisconnection document number DISCNOCHAR12Assigned to domainALPHADISCNOEDNEDISCDOCSUM
C_BANK_IBANIBAN (International Bank Account Number) BU_IBANCHAR34CHAR34
C_ID_TYPEIdentification Type BU_ID_TYPECHAR6Assigned to domainBU_ID_TYPE
C_ID_NUMBERIdentification Number BU_ID_NUMBERCHAR60CHAR60
R_TOBRELEASDIndicator: document not released yet TOBRELEASDCHAR1KENNZX
DEVL_BY_COFind device location via connection object ECF_BY_COBCHAR1KENNZX
DEVL_BY_DEFind device location via device ECF_BY_DEVCHAR1KENNZX
ADRTYPE_BPAddress is a business partner address ECF_ADR_BPCHAR1EBA_FLAG
ADRTYPE_COAddress is a connection object address ECF_ADR_COCHAR1EBA_FLAG
ADRTYPEAddress Category for Search ECF_ADRCHAR1ECF_ADR
EXIT_STD_FLDS_NOT_CLEAREDStandard Search Fields in User Exit Not Deleted EFINDD_EXIT_STD_FLDS_NO_CLEARCHAR1FLAG

Key field Non-key field



How do I retrieve data from SAP structure EFINDD using ABAP code?

As EFINDD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EFINDD as there is no data to select.

How to access SAP table EFINDD

Within an ECC or HANA version of SAP you can also view further information about EFINDD 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!