SAP ABAP Table EFINDPAR (Search Parameters for the IS-U Data Finder)
Hierarchy
☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U (Application Component) SAP Utilities
     ⤷ EE00 (Package) IS-U: General (Domains and General Objects)
Basic Data
Table Category INTTAB    Structure 
Structure EFINDPAR   Table Relationship Diagram
Short Description Search Parameters for the IS-U Data Finder    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 C_BUPART BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
2 C_MC_NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
3 C_MC_NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
4 C_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
5 C_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
6 C_POST_CO1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
7 C_POST_CO2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
8 C_POST_CO3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
9 C_PO_BOX_L AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
10 C_STREET AD_STREET TEXT60 CHAR 60   0   Street  
11 C_HOUSE_N1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
12 C_HOUSE_N2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
13 C_HOUSE_N3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
14 C_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
15 C_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
16 C_SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
17 C_SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
18 C_SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
19 C_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
20 C_TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
21 C_SOC_SECURE E_SOC_SECU E_SOC_SECU CHAR 12   0   Social Insurance Number  
22 C_DR_LICENSE DR_LICENSE DR_LICENSE CHAR 20   0   Driver's license number  
23 C_WELFARE WELFARE WELFARE CHAR 9   0   Welfare office  
24 C_BANK_ACCOUNT BANKN BANKN CHAR 18   0   Bank account number  
25 C_BANK_NUMBER BANKL BANKL CHAR 15   0   Bank number  
26 C_BANK_COUNTRY BANKS LAND1 CHAR 3   0   Bank country key *
27 C_TAXTYPE BPTAXTYPE BPTAXTYPE CHAR 4   0   Tax Number Category  
28 C_TAXNUM BPTAXNUM BPTAXNUM CHAR 20   0   Business Partner Tax Number  
29 A_VKONT VKONT_KK VKONT_KK CHAR 12   0   Contract Account Number *
30 A_ABWRE ABWRE_KK BU_PARTNER CHAR 10   0   Alternative Payer *
31 A_ABWRA ABWRA_KK BU_PARTNER CHAR 10   0   Alternative Payee *
32 A_ABWRH ABWRH_KK BU_PARTNER CHAR 10   0   Alternative Invoice Recipient *
33 A_ABWMA ABWMA_KK BU_PARTNER CHAR 10   0   Alternative dunning recipient *
34 A_ABWVK ABWVK_KK VKONT_KK CHAR 12   0   Alternative contract account for collective bills *
35 A_VKONV VKONV_KK VKONT_KK CHAR 12   0   Contract account used for payment transactions *
36 V_VERTRAG VERTRAG VERTRAG CHAR 10   0   Contract *
37 V_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
38 V_SPARTE SPARTE SPART CHAR 2   0   Division TSPA
39 V_DATE ECF_DATE DATUM DATS 8   0   Date used in finding object  
40 U_OPBEL ABPLANNR OPBEL_KK CHAR 12   0   Budget billing plan *
41 U_DATE ECF_DATE DATUM DATS 8   0   Date used in finding object  
42 O_HAUS HAUS TPLNR CHAR 30   0   Connection Object *
43 O_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
44 O_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
45 O_POST_CO1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
46 O_POST_CO2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
47 O_POST_CO3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
48 O_PO_BOX_L AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
49 O_STREET AD_STREET TEXT60 CHAR 60   0   Street  
50 O_HOUSE_N1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
51 O_HOUSE_N2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
52 O_HOUSE_N3 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
53 O_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
54 O_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
55 O_SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
56 O_SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
57 O_SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
58 O_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
59 P_VSTELLE VSTELLE VSTELLE CHAR 10   0   Premise *
60 P_HAUS_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
61 P_STR_ERG2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
62 P_STR_ERG4 AD_LCTN TEXT40 CHAR 40   0   Street 5  
63 P_FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
64 P_ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
65 P_EIGENT E_GPARTNER BU_PARTNER CHAR 10   0   Owner *
66 I_ANLAGE ANLAGE ANLAGE CHAR 10   0   Installation *
67 I_SPARTE SPARTE SPART CHAR 2   0   Division TSPA
68 I_AKLASSE AKLASSE AKLASSE CHAR 4   0   Billing class *
69 I_DATE ECF_DATE DATUM DATS 8   0   Date used in finding object  
70 I_POD EXT_UI EXT_UI CHAR 50   0   Point of delivery ID  
71 I_POD_DATE ECF_DATE DATUM DATS 8   0   Date used in finding object  
72 L_DEVLOC DEVLOC TPLNR CHAR 30   0   Device Location *
73 L_STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object *
74 D_EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
75 D_GERAET GERNR GERNR CHAR 18   0   Serial Number  
76 D_SPARTE SPARTE SPART CHAR 2   0   Division TSPA
77 D_DATE ECF_DATE DATUM DATS 8   0   Date used in finding object  
78 R_OPBEL OPBEL_KK OPBEL_KK CHAR 12   0   Number of Contract Accts Rec. & Payable Doc. *
79 R_DATE BUDAT_KK DATUM DATS 8   0   Posting Date in the Document  
80 S_AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
81 S_ASTNR AUFASTNR AUFSTNR NUMC 2   0   Order status *
82 S_AUART AUFART AUFART CHAR 4   0   Order Type *
83 S_AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
84 S_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
85 M_AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
86 M_ASTNR AUFASTNR AUFSTNR NUMC 2   0   Order status *
87 M_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
88 M_AUART AUFART AUFART CHAR 4   0   Order Type *
89 X_DATE ECF_XDATE DATUM DATS 8   0   Global date  
90 X_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
91 X_SPARTE SPARTE SPART CHAR 2   0   Division TSPA
92 L_BY_DEVIC ECF_BY_DEV KENNZX CHAR 1   0   Find device location via device  
93 KEEPSEL ECF_KEEP KENNZX CHAR 1   0   Data finder: keep selection  
94 SEARCHSTRING SEARCHSTRING TEXT132 CHAR 132   0   Generic Search String in Form of Free Text Field  
95 C_BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
96 C_BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
97 C_EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
98 V_DATE_TO ECF_DATE DATUM DATS 8   0   Date used in finding object  
99 SD_PONUMBER     CHAR 35   0    
100 SD_VBELN     CHAR 10   0    
101 SD_VKORG     CHAR 4   0    
102 SD_AUART     CHAR 4   0    
103 X_ALL_NATIONS     CHAR 1   0    
104 X_NATION     CHAR 1   0    
105 J_DISCPROCV     CHAR 4   0    
106 J_DISCREASON     CHAR 2   0    
107 J_STATUS     CHAR 2   0    
108 J_ERDAT     CHAR 8   0    
109 J_DISCNO     CHAR 12   0    
110 C_BANK_IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EFINDPAR C_COUNTRY T005 LAND1    
2 EFINDPAR D_SPARTE TSPA SPART    
3 EFINDPAR I_SPARTE TSPA SPART    
4 EFINDPAR O_COUNTRY T005 LAND1    
5 EFINDPAR V_SPARTE TSPA SPART    
6 EFINDPAR X_SPARTE TSPA SPART    
History
Last changed by/on SAP  20130529 
SAP Release Created in