SAP ABAP Table EFINDD (IS-U Data Finder Screen Fields)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in