SAP table EFINDD_CIC (IS-U Data Finder Screen Fields)

Field Description Data Type Length Decimals Checktable Data Element
C_BUPART Business Partner Number CHAR 10 0 BU_PARTNER
C_MC_NAME1 Name field 1 (name1/last name) CHAR 40 0 BU_NAME1
C_MC_NAME2 Name field 2 (name2/first name) CHAR 40 0 BU_NAME2
C_CITY1 City CHAR 40 0 AD_CITY1
C_CITY2 District CHAR 40 0 AD_CITY2
C_POST_CO1 City postal code CHAR 10 0 AD_PSTCD1
C_POST_CO2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
C_POST_CO3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
C_PO_BOX_L PO Box city CHAR 40 0 AD_POBXLOC
C_STREET Street CHAR 60 0 AD_STREET
C_HOUSE_N1 House Number CHAR 10 0 AD_HSNM1
C_HOUSE_N2 House number supplement CHAR 10 0 AD_HSNM2
C_HOUSE_N3 (Not supported) House Number Range CHAR 10 0 AD_HSNM3
C_COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
C_REGION Region (State, Province, County) CHAR 3 0 * REGIO
C_SORT1 Search Term 1 CHAR 20 0 AD_SORT1
C_SORT2 Search Term 2 CHAR 20 0 AD_SORT2
C_SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
C_ADDRNUM Address Number CHAR 10 0 * AD_ADDRNUM
C_TELNR_LONG Complete Number: Dialling Code+Number+Extension CHAR 30 0 AD_TELNRLG
C_SOC_SECURE Social Insurance Number CHAR 12 0 E_SOC_SECU
C_DR_LICENSE Driver's license number CHAR 20 0 DR_LICENSE
C_WELFARE Welfare office CHAR 9 0 WELFARE
C_BANK_ACCOUNT Bank account number CHAR 18 0 BANKN
C_BANK_NUMBER Bank Number CHAR 15 0 BANKL
C_BANK_COUNTRY Country/Region Key of Bank CHAR 3 0 * BANKS
C_TAXTYPE Tax Number Category CHAR 4 0 BPTAXTYPE
C_TAXNUM Business Partner Tax Number CHAR 20 0 BPTAXNUM
A_VKONT Contract Account Number CHAR 12 0 VKONT_KK
A_ABWRE Alternative Payer CHAR 10 0 ABWRE_KK
A_ABWRA Alternative Payee CHAR 10 0 ABWRA_KK
A_ABWRH Alternative Invoice Recipient CHAR 10 0 ABWRH_KK
A_ABWMA Alternative Dunning Recipient CHAR 10 0 ABWMA_KK
A_ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 * ABWVK_KK
A_VKONV Contract account used for payment transactions CHAR 12 0 * VKONV_KK
V_VERTRAG Contract CHAR 10 0 VERTRAG
V_BUKRS Company Code CHAR 4 0 BUKRS
V_SPARTE Division CHAR 2 0 TSPA SPARTE
V_DATE Date used in finding object DATS 8 0 ECF_DATE
U_OPBEL Budget billing plan CHAR 12 0 ABPLANNR
U_DATE Date used in finding object DATS 8 0 ECF_DATE
O_HAUS Connection Object CHAR 30 0 HAUS
O_CITY1 City CHAR 40 0 AD_CITY1
O_CITY2 District CHAR 40 0 AD_CITY2
O_POST_CO1 City postal code CHAR 10 0 AD_PSTCD1
O_POST_CO2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
O_POST_CO3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
O_PO_BOX_L PO Box city CHAR 40 0 AD_POBXLOC
O_STREET Street CHAR 60 0 AD_STREET
O_HOUSE_N1 House Number CHAR 10 0 AD_HSNM1
O_HOUSE_N2 House number supplement CHAR 10 0 AD_HSNM2
O_HOUSE_N3 House Number CHAR 10 0 AD_HSNM1
O_COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
O_REGION Region (State, Province, County) CHAR 3 0 * REGIO
O_SORT1 Search Term 1 CHAR 20 0 AD_SORT1
O_SORT2 Search Term 2 CHAR 20 0 AD_SORT2
O_SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
O_ADDRNUM Address Number CHAR 10 0 * AD_ADDRNUM
P_VSTELLE Premise CHAR 10 0 VSTELLE
P_HAUS_NUM2 House number supplement CHAR 10 0 AD_HSNM2
P_STR_ERG2 Street 3 CHAR 40 0 AD_STRSPP2
P_STR_ERG4 Street 5 CHAR 40 0 AD_LCTN
P_FLOOR Floor in building CHAR 10 0 AD_FLOOR
P_ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
P_EIGENT Owner CHAR 10 0 E_GPARTNER
I_ANLAGE Installation CHAR 10 0 ANLAGE
I_SPARTE Division CHAR 2 0 TSPA SPARTE
I_AKLASSE Billing Class CHAR 4 0 * AKLASSE
I_DATE Date used in finding object DATS 8 0 ECF_DATE
I_POD Point of Delivery ID CHAR 50 0 EXT_UI
I_POD_DATE Date used in finding object DATS 8 0 ECF_DATE
L_DEVLOC Device Location CHAR 30 0 DEVLOC
L_STORT Location of maintenance object CHAR 10 0 * PMLOC
D_EQUNR Equipment Number CHAR 18 0 EQUNR
D_GERAET Serial Number CHAR 18 0 GERNR
D_SPARTE Division CHAR 2 0 TSPA SPARTE
D_DATE Date used in finding object DATS 8 0 ECF_DATE
R_OPBEL Number of a FI-CA Document CHAR 12 0 * OPBEL_KK
R_DATE Posting Date in the Document DATS 8 0 BUDAT_KK
S_AUFNR Order Number CHAR 12 0 * AUFNR
S_ASTNR Order Status NUMC 2 0 * AUFASTNR
S_AUART Order Type CHAR 4 0 * AUFART
S_AUTYP Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
S_QMNUM Notification Number CHAR 12 0 * QMNUM
M_AUFNR Order Number CHAR 12 0 * AUFNR
M_ASTNR Order Status NUMC 2 0 * AUFASTNR
M_QMNUM Notification Number CHAR 12 0 * QMNUM
M_AUART Order Type CHAR 4 0 * AUFART
X_DATE Global date DATS 8 0 ECF_XDATE
X_BUKRS Company Code CHAR 4 0 BUKRS
X_SPARTE Division CHAR 2 0 TSPA SPARTE
L_BY_DEVIC Find device location via device CHAR 1 0 ECF_BY_DEV
KEEPSEL Data finder: keep selection CHAR 1 0 ECF_KEEP
SEARCHSTRING Generic Search String in Form of Free Text Field CHAR 132 0 SEARCHSTRING
C_BIRTHDT Date of Birth of Business Partner DATS 8 0 BU_BIRTHDT
C_BIRTHPL Birthplace of business partner CHAR 40 0 BU_BIRTHPL
C_EMAIL E-Mail Address CHAR 241 0 AD_SMTPADR
V_DATE_TO Date used in finding object DATS 8 0 ECF_DATE
SD_PONUMBER Customer Reference as Matchcode Field CHAR 35 0 BSTKD_M
SD_VBELN Sales and Distribution Document Number CHAR 10 0 * VBELN
SD_VKORG Sales Organization CHAR 4 0 TVKO VKORG
SD_AUART Sales Document Type CHAR 4 0 TVAK AUART
X_ALL_NATIONS Take into Account Versions for Internation Addresses Only CHAR 1 0 E_ALL_NATIONS
X_NATION Version ID for International Addresses CHAR 1 0 * AD_NATION
J_DISCPROCV Processing variant for disconnection/reconnection CHAR 4 0 * DISCPROCV
J_DISCREASON Disconnection reason CHAR 2 0 DISCREASON
00 Unknown disconnection reason
01 Disconnection dunning level has been reached
02 Vacant status disconnection
03 Customer request
04 Technical Disconnection Reason
J_STATUS Status of disconnection document NUMC 2 0 EDCDOCSTAT
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 the record was created DATS 8 0 ERDAT
J_DISCNO Disconnection document number CHAR 12 0 DISCNO
C_BANK_IBAN IBAN (International Bank Account Number) CHAR 34 0 BU_IBAN
C_ID_TYPE Identification Type CHAR 6 0 * BU_ID_TYPE
C_ID_NUMBER Identification Number CHAR 60 0 BU_ID_NUMBER
R_TOBRELEASD Indicator: document not released yet CHAR 1 0 TOBRELEASD
DEVL_BY_CO Find device location via connection object CHAR 1 0 ECF_BY_COB
DEVL_BY_DE Find device location via device CHAR 1 0 ECF_BY_DEV
ADRTYPE_BP Address is a business partner address CHAR 1 0 ECF_ADR_BP
ADRTYPE_CO Address is a connection object address CHAR 1 0 ECF_ADR_CO
ADRTYPE Address Category for Search CHAR 1 0 ECF_ADR
C Connection object: street/number/enhancements
P Business partner: street/number/enhancements
EXIT_STD_FLDS_NOT_CLEARED Standard Search Fields in User Exit Not Deleted CHAR 1 0 EFINDD_EXIT_STD_FLDS_NO_CLEAR

EFINDD_CIC foreign key relationships

Table Field Check Table Check Field
0 EFINDD_CIC C_COUNTRY T005 Countries MANDT
0 EFINDD_CIC C_COUNTRY T005 Countries LAND1
1 EFINDD_CIC D_SPARTE TSPA Organizational Unit: Sales Divisions MANDT
1 EFINDD_CIC D_SPARTE TSPA Organizational Unit: Sales Divisions SPART
0 EFINDD_CIC I_SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 EFINDD_CIC I_SPARTE TSPA Organizational Unit: Sales Divisions SPART
1 EFINDD_CIC O_COUNTRY T005 Countries MANDT
1 EFINDD_CIC O_COUNTRY T005 Countries LAND1
0 EFINDD_CIC SD_AUART TVAK Sales Document Types MANDT
0 EFINDD_CIC SD_AUART TVAK Sales Document Types AUART
1 EFINDD_CIC SD_VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 EFINDD_CIC SD_VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 EFINDD_CIC V_SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 EFINDD_CIC V_SPARTE TSPA Organizational Unit: Sales Divisions SPART
1 EFINDD_CIC X_SPARTE TSPA Organizational Unit: Sales Divisions MANDT
1 EFINDD_CIC X_SPARTE TSPA Organizational Unit: Sales Divisions SPART