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