1. Home
  2. Resources
  3. SAP Tables
  4. EFINDPAR - Search Parameters for the IS-U Data Finder

SAP Table EFINDPAR

Search Parameters for the IS-U Data Finder

EFINDPAR (Search Parameters for the IS-U Data Finder) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EFINDPAR to other SAP tables.

EFINDPAR table fields

Field Data element Checktable Datatype Length Decimals
C_BUPART Business Partner Number BU_PARTNER CHAR 10 0
C_MC_NAME1 Name field 1 (name1/last name) BU_NAME1 CHAR 40 0
C_MC_NAME2 Name field 2 (name2/first name) BU_NAME2 CHAR 40 0
C_CITY1 City AD_CITY1 CHAR 40 0
C_CITY2 District AD_CITY2 CHAR 40 0
C_POST_CO1 City postal code AD_PSTCD1 CHAR 10 0
C_POST_CO2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
C_POST_CO3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
C_PO_BOX_L PO Box city AD_POBXLOC CHAR 40 0
C_STREET Street AD_STREET CHAR 60 0
C_HOUSE_N1 House Number AD_HSNM1 CHAR 10 0
C_HOUSE_N2 House number supplement AD_HSNM2 CHAR 10 0
C_HOUSE_N3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
C_COUNTRY Country Key LAND1 T005 CHAR 3 0
C_REGION Region (State, Province, County) REGIO CHAR 3 0
C_SORT1 Search Term 1 AD_SORT1 CHAR 20 0
C_SORT2 Search Term 2 AD_SORT2 CHAR 20 0
C_SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
C_ADDRNUM Address number AD_ADDRNUM CHAR 10 0
C_TELNR_LONG Complete number: dialling code+number+extension AD_TELNRLG CHAR 30 0
C_SOC_SECURE Social Insurance Number E_SOC_SECU CHAR 12 0
C_DR_LICENSE Driver's license number DR_LICENSE CHAR 20 0
C_WELFARE Welfare office WELFARE CHAR 9 0
C_BANK_ACCOUNT Bank account number BANKN CHAR 18 0
C_BANK_NUMBER Bank number BANKL CHAR 15 0
C_BANK_COUNTRY Bank country key BANKS CHAR 3 0
C_TAXTYPE Tax Number Category BPTAXTYPE CHAR 4 0
C_TAXNUM Business Partner Tax Number BPTAXNUM CHAR 20 0
A_VKONT Contract Account Number VKONT_KK CHAR 12 0
A_ABWRE Alternative Payer ABWRE_KK CHAR 10 0
A_ABWRA Alternative Payee ABWRA_KK CHAR 10 0
A_ABWRH Alternative Invoice Recipient ABWRH_KK CHAR 10 0
A_ABWMA Alternative dunning recipient ABWMA_KK CHAR 10 0
A_ABWVK Alternative contract account for collective bills ABWVK_KK CHAR 12 0
A_VKONV Contract account used for payment transactions VKONV_KK CHAR 12 0
V_VERTRAG Contract VERTRAG CHAR 10 0
V_BUKRS Company Code BUKRS CHAR 4 0
V_SPARTE Division SPARTE TSPA CHAR 2 0
V_DATE Date used in finding object ECF_DATE DATS 8 0
U_OPBEL Budget billing plan ABPLANNR CHAR 12 0
U_DATE Date used in finding object ECF_DATE DATS 8 0
O_HAUS Connection Object HAUS CHAR 30 0
O_CITY1 City AD_CITY1 CHAR 40 0
O_CITY2 District AD_CITY2 CHAR 40 0
O_POST_CO1 City postal code AD_PSTCD1 CHAR 10 0
O_POST_CO2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
O_POST_CO3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
O_PO_BOX_L PO Box city AD_POBXLOC CHAR 40 0
O_STREET Street AD_STREET CHAR 60 0
O_HOUSE_N1 House Number AD_HSNM1 CHAR 10 0
O_HOUSE_N2 House number supplement AD_HSNM2 CHAR 10 0
O_HOUSE_N3 House Number AD_HSNM1 CHAR 10 0
O_COUNTRY Country Key LAND1 T005 CHAR 3 0
O_REGION Region (State, Province, County) REGIO CHAR 3 0
O_SORT1 Search Term 1 AD_SORT1 CHAR 20 0
O_SORT2 Search Term 2 AD_SORT2 CHAR 20 0
O_SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
O_ADDRNUM Address number AD_ADDRNUM CHAR 10 0
P_VSTELLE Premise VSTELLE CHAR 10 0
P_HAUS_NUM2 House number supplement AD_HSNM2 CHAR 10 0
P_STR_ERG2 Street 3 AD_STRSPP2 CHAR 40 0
P_STR_ERG4 Street 5 AD_LCTN CHAR 40 0
P_FLOOR Floor in building AD_FLOOR CHAR 10 0
P_ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
P_EIGENT Owner E_GPARTNER CHAR 10 0
I_ANLAGE Installation ANLAGE CHAR 10 0
I_SPARTE Division SPARTE TSPA CHAR 2 0
I_AKLASSE Billing class AKLASSE CHAR 4 0
I_DATE Date used in finding object ECF_DATE DATS 8 0
I_POD Point of delivery ID EXT_UI CHAR 50 0
I_POD_DATE Date used in finding object ECF_DATE DATS 8 0
L_DEVLOC Device Location DEVLOC CHAR 30 0
L_STORT Location of maintenance object PMLOC CHAR 10 0
D_EQUNR Equipment Number EQUNR CHAR 18 0
D_GERAET Serial Number GERNR CHAR 18 0
D_SPARTE Division SPARTE TSPA CHAR 2 0
D_DATE Date used in finding object ECF_DATE DATS 8 0
R_OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
R_DATE Posting Date in the Document BUDAT_KK DATS 8 0
S_AUFNR Order Number AUFNR CHAR 12 0
S_ASTNR Order status AUFASTNR NUMC 2 0
S_AUART Order Type AUFART CHAR 4 0
S_AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
S_QMNUM Notification No QMNUM CHAR 12 0
M_AUFNR Order Number AUFNR CHAR 12 0
M_ASTNR Order status AUFASTNR NUMC 2 0
M_QMNUM Notification No QMNUM CHAR 12 0
M_AUART Order Type AUFART CHAR 4 0
X_DATE Global date ECF_XDATE DATS 8 0
X_BUKRS Company Code BUKRS CHAR 4 0
X_SPARTE Division SPARTE TSPA CHAR 2 0
L_BY_DEVIC Find device location via device ECF_BY_DEV CHAR 1 0
NULL Field inactive
X Field active
KEEPSEL Data finder: keep selection ECF_KEEP CHAR 1 0
NULL Field inactive
X Field active
SEARCHSTRING Generic Search String in Form of Free Text Field SEARCHSTRING CHAR 132 0
C_BIRTHDT Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
C_BIRTHPL Birthplace of business partner BU_BIRTHPL CHAR 40 0
C_EMAIL E-Mail Address AD_SMTPADR CHAR 241 0
V_DATE_TO Date used in finding object ECF_DATE DATS 8 0
SD_PONUMBER Customer PO number as matchcode field BSTKD_M CHAR 35 0
SD_VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
SD_VKORG Sales Organization VKORG TVKO CHAR 4 0
SD_AUART Sales Document Type AUART TVAK CHAR 4 0
X_ALL_NATIONS Take into Account Versions for Internation Addresses Only E_ALL_NATIONS CHAR 1 0
X Yes
NULL No
X_NATION Version ID for International Addresses AD_NATION CHAR 1 0
J_DISCPROCV Processing variant for disconnection/reconnection DISCPROCV CHAR 4 0
J_DISCREASON Disconnection reason DISCREASON CHAR 2 0
00 Unknown disconnection reason
01 Disconnection dunning level has been reached
02 Vacant status disconnection
03 Customer request
04 Tecnical Disconnection Reason
J_STATUS Status of disconnection document EDCDOCSTAT NUMC 2 0
00 New
01 New, release unnecessary
10 Released
20 Disconnection started
21 Disconnection carried out
22 Reconnection started
23 Device removal started
24 Device Removal Executed
25 Device installation started
26 Device installation carried out
27 All Devices Removed and Disconnected
30 Reconnection carried out completely
99 completed
J_ERDAT Date on Which Record Was Created ERDAT DATS 8 0
J_DISCNO Disconnection document number DISCNO CHAR 12 0
C_BANK_IBAN IBAN (International Bank Account Number) BU_IBAN CHAR 34 0
C_ID_TYPE Identification Type BU_ID_TYPE CHAR 6 0
C_ID_NUMBER Identification Number BU_ID_NUMBER CHAR 60 0
R_TOBRELEASD Indicator: document not released yet TOBRELEASD CHAR 1 0
NULL Field inactive
X Field active

EFINDPAR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EFINDPAR C_COUNTRY SYST MANDT T005 Countries MANDT
EFINDPAR C_COUNTRY EFINDPAR C_COUNTRY T005 Countries LAND1
EFINDPAR D_SPARTE EFINDPAR D_SPARTE TSPA Organizational Unit: Sales Divisions SPART
EFINDPAR D_SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
EFINDPAR I_SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
EFINDPAR I_SPARTE EFINDPAR I_SPARTE TSPA Organizational Unit: Sales Divisions SPART
EFINDPAR O_COUNTRY SYST MANDT T005 Countries MANDT
EFINDPAR O_COUNTRY EFINDPAR O_COUNTRY T005 Countries LAND1
EFINDPAR SD_AUART SYST MANDT TVAK Sales Document Types MANDT
EFINDPAR SD_AUART EFINDPAR SD_AUART TVAK Sales Document Types AUART
EFINDPAR SD_VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
EFINDPAR SD_VBELN EFINDPAR SD_VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
EFINDPAR SD_VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
EFINDPAR SD_VKORG EFINDPAR SD_VKORG TVKO Organizational Unit: Sales Organizations VKORG
EFINDPAR V_SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
EFINDPAR V_SPARTE EFINDPAR V_SPARTE TSPA Organizational Unit: Sales Divisions SPART
EFINDPAR X_SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
EFINDPAR X_SPARTE EFINDPAR X_SPARTE TSPA Organizational Unit: Sales Divisions SPART