SAP ABAP Table UKM_S_SEARCH_ID (Fields for the ID Search)

Hierarchy

☛ FINBASIS (Software Component) Fin. Basis
   ⤷ FIN-FSCM-CR-CR (Application Component) Basic Functions
     ⤷ UKM_BUSINESS_PARTNER (Package) SAP Credit Management - Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	UKM_S_SEARCH_ID	Table Relationship Diagram
Short Description	Fields for the ID Search

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	MATCH_GRADE	☐	UKM_SEARCH_ID_MATCH_GRADE		NUMC	4	0	Degree of Matching
2	SEARCH_RANK	☐	UKM_SEARCH_ID_SEARCH_RANK	INT4	INT4	10	0	Degree of Matching at Provider
3	COMPANY	☐	UKM_S_SEARCH_ID_COMPANY		STRU	0	0
4	BUSINESS_NAME	☐	UKM_SEARCHID_BUSINESS_NAME	BU_NAME	CHAR	40	0	Business Name
5	.INCLUDE	☐				0	0	UKM: Legal Data of the Organization
6	LEGAL_ENTITY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization
7	FOUNDATION_DATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
8	PERSON	☐	UKM_S_SEARCH_ID_PERSON		STRU	0	0
9	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
10	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
11	NAME_BIRTH	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
12	BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
13	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
14	BIRTH_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
15	MARITAL_STATUS	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner
16	SEX	☐	UKM_SEARCHID_SEX	UKM_SEARCHID_SEX	CHAR	1	0	Gender
17	NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality
18	ADDRESS	☐	UKM_S_SEARCH_ID_ADDRESS		STRU	0	0
19	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
20	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
21	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
22	TOWN	☐	AD_CITY2	TEXT40	CHAR	40	0	District
23	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
24	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
25	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
26	COMMUNICATION	☐	UKM_S_SEARCH_ID_COMMUNICATION		STRU	0	0
27	PHONE	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
28	PHONE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number
29	PHONE_EXTENSION	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
30	MOBILE	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
31	MOBILE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number
32	FAX	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
33	FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number
34	FAX_EXTENSION	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
35	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
36	IDS	☐	UKM_S_SEARCH_ID_IDS		STRU	0	0
37	ID_TYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type
38	ID	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
39	TAX	☐	UKM_S_SEARCH_ID_TAX		STRU	0	0
40	TAX_TYPE	☐	BPTAXTYPE	BPTAXTYPE	CHAR	4	0	Tax Number Category
41	TAX_NUMBER	☐	BPTAXNUM	BPTAXNUM	CHAR	20	0	Business Partner Tax Number
42	POBOX	☐	UKM_S_SEARCH_ID_POBOX		STRU	0	0
43	POBOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
44	POST_CODE_POBOX	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
45	POST_CODE_COMPANY	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
46	RELATI	☐	UKM_S_SEARCH_ID_RELATI		STRU	0	0
47	R_NAME_LAST	☐	UKM_SEARCH_ID_RELA_NAME_L	BU_NAME	CHAR	40	0	Last Name of Spouse
48	R_NAME_FIRST	☐	UKM_SEARCH_ID_RELA_NAMEP_F	BU_NAME	CHAR	40	0	First Name of Spouse
49	R_NAME_BIRTH	☐	UKM_SEARCH_ID_RELA_BIRTHNM	BU_NAME	CHAR	40	0	Name of Spouse at Birth
50	R_BIRTH_DATE	☐	UKM_SEARCH_ID_RELA_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Spouse
51	R_BIRTH_PLACE	☐	UKM_SEARCH_ID_RELA_BIRTHPL	TEXT40	CHAR	40	0	Place of Birth of Spouse
52	R_BIRTH_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
53	R_MARITAL_STATUS	☐	UKM_SEARCH_ID_RELA_MARST	BU_MARST	CHAR	1	0	Marital Status
54	R_SEX	☐	UKM_SEARCH_ID_RELA_SEX	UKM_SEARCHID_SEX	CHAR	1	0	Gender of Spouse

History

Last changed by/on	SAP	20130529
SAP Release Created in