SAP ABAP Table ECRM_EFINDPAR (Search Parameter for IS-U Data Finder in R/3)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S (Application Component) Utilities Industry: Sales
     ⤷ CRM_UTILITY_SALES (Package) Package for IBU Utilities Sales
Basic Data
Table Category INTTAB    Structure 
Structure ECRM_EFINDPAR   Table Relationship Diagram
Short Description Search Parameter for IS-U Data Finder in R/3    
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 *
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 ECRM_ISU_SOC_SECU ECRM_ISU_SOC_SECU CHAR 12   0   Social Insurance Number  
22 C_DR_LICENSE ECRM_ISU_DR_LICENSE ECRM_ISU_DR_LICENSE CHAR 20   0   Driver's License Number  
23 C_WELFARE ECRM_ISU_WELFARE ECRM_ISU_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 ECRM_ISU_VKONT_KK ECRM_ISU_VKONT_KK CHAR 12   0   Contract Account Number  
30 A_ABWRE ECRM_ISU_ABWRE_KK BU_PARTNER CHAR 10   0   Alternative Payer *
31 A_ABWRA ECRM_ISU_ABWRA_KK BU_PARTNER CHAR 10   0   Different Payment Recipient *
32 A_ABWRH ECRM_ISU_ABWRH_KK BU_PARTNER CHAR 10   0   Alternative Bill Recipient *
33 A_ABWMA ECRM_ISU_ABWMA_KK BU_PARTNER CHAR 10   0   Alternative Dunning Recipient *
34 A_ABWVK ECRM_ISU_ABWVK_KK ECRM_ISU_VKONT_KK CHAR 12   0   Alternative Contract Account for Collective Bills  
35 A_VKONV ECRM_ISU_VKONV_KK ECRM_ISU_VKONT_KK CHAR 12   0   Contract Account Used for Payment Transactions  
36 V_VERTRAG ECRM_ISU_VERTRAG ECRM_ISU_VERTRAG CHAR 10   0   Contract  
37 V_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
38 V_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
39 V_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
40 C_OPBEL ECRM_ISU_ABPLANNR ECRM_ISU_ABPLANNR CHAR 12   0   Budget Billing Plan  
41 U_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
42 O_HAUS TPLNR TPLNR CHAR 30   0   Functional Location *
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 *
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 ECRM_ISU_VSTELLE ECRM_ISU_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 ECRM_ISU_GPARTNER BU_PARTNER CHAR 10   0   Owner *
66 I_ANLAGE ECRM_ISU_ANLAGE ECRM_ISU_ANLAGE CHAR 10   0   Installation  
67 I_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
68 I_AKLASSE ECRM_ISU_AKLASSE ECRM_ISU_AKLASSE CHAR 4   0   Billing Class  
69 I_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
70 I_POD ECRM_ISU_EXT_UI ECRM_ISU_EXT_UI CHAR 50   0   Point of Delivery ID  
71 I_POD_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
72 L_DEVLOC ECRM_ISU_DEVLOC TPLNR CHAR 30   0   Device Location *
73 L_STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object *
74 D_EQUNR CRM_ISU_EQUNR CRM_ISU_EQUNR CHAR 18   0   Equipment Number  
75 D_GERAET CRM_ISU_GERNR CRM_ISU_GERNR CHAR 18   0   Serial Number  
76 D_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
77 D_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
78 R_OPBEL ECRM_ISU_OPBEL_KK ECRM_ISU_OPBEL_KK CHAR 12   0   Contract Accounts Receivable and Payable Document Number  
79 R_DATE ECRM_ISU_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 ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
90 X_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
91 X_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
92 L_BY_DEVIC ECRM_ISU_ECF_BY_DEV CHAR1 CHAR 1   0   Search for Device Location via Device  
93 KEEPSEL ECRM_ISU_ECF_KEEP CHAR1 CHAR 1   0   Data Finder: Keep Selection  
94 SEARCHSTRING ECRM_ISU_SEARCHSTRING TEXT132 CHAR 132   0   Generic Search String in From of a User-Defined 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     DATS 8   0    
99 SD_PONUMBER BSTKD_M CHAR35 CHAR 35   0   Customer PO number as matchcode field  
100 SD_VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number  
101 SD_VKORG VKORG VKORG CHAR 4   0   Sales Organization *
102 SD_AUART AUART AUART CHAR 4   0   Sales Document Type *
103 X_ALL_NATIONS     CHAR 1   0    
104 X_NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
105 J_DISCPROCV     CHAR 4   0    
106 J_DISCREASON CRM_ISU_DISCREASON CRM_ISU_DISCREASON CHAR 2   0   Disconnection Reason  
107 J_STATUS CRM_ISU_EDCDOCSTAT CRM_ISU_EDCDOCSTAT NUMC 2   0   Status of Disconnection Document  
108 J_ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
109 J_DISCNO CRM_ISU_DISCNO CRM_ISU_DISCNO CHAR 12   0   Disconnection Document Number  
110 C_BANK_IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
111 C_ID_TYPE BU_ID_TYPE BU_ID_TYPE CHAR 6   0   Identification Type *
112 C_ID_NUMBER BU_ID_NUMBER CHAR60 CHAR 60   0   Identification Number  
113 R_TOBRELEASD     CHAR 1   0    
History
Last changed by/on SAP  20130604 
SAP Release Created in 300