SAP ABAP Table UKM_S_SEARCH_ID_RESULT (Structure for Displaying the Output of 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_RESULT	Table Relationship Diagram
Short Description	Structure for Displaying the Output of 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	SEARCH_RANK	☐	UKM_SEARCH_ID_SEARCH_RANK	INT4	INT4	10	0	Degree of Matching at Provider
2	MATCH_GRADE	☐	UKM_SEARCH_ID_MATCH_GRADE		NUMC	4	0	Degree of Matching
3	.INCLUDE	☐				0	0	Administrative Data of GUI List Item
4	GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
5	STATUS	☐	UKM_SEARCH_ID_STATUS	UKM_SEARCH_ID_STATUS	CHAR	16	0	Status of ID Received
6	SENDING_ICON	☐			CHAR	44	0
7	ROW_C	☐			CHAR	4	0
8	.INCLUDE	☐				0	0	Key for a Business Partner at the Information Provider
9	GRADE_METHOD	☐	UKM_PROVIDER_EXT	BP_GRADE_METHOD	CHAR	10	0	External Provider	*
10	BP_EXT_ID_TYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
11	BP_EXT_ID	☐	UKM_BP_EXT_ID	CHAR60	CHAR	60	0	ID of Business Partner at Information Provider
12	.INCLUDE	☐				0	0	UKM: Company Fields of the ID Search
13	BUSINESS_NAME	☐	UKM_SEARCHID_BUSINESS_NAME	BU_NAME	CHAR	40	0	Business Name
14	.INCLUDE	☐				0	0	UKM: Legal Data of the Organization
15	LEGAL_ENTITY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
16	FOUNDATION_DATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
17	.INCLUDE	☐				0	0	UKM: Person Fields of the ID Search
18	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
19	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
20	NAME_BIRTH	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
21	BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
22	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
23	BIRTH_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	MARITAL_STATUS	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
25	SEX	☐	UKM_SEARCHID_SEX	UKM_SEARCHID_SEX	CHAR	1	0	Gender
26	NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	T005
27	.INCLUDE	☐				0	0	UKM: General Fields for the ID Search
28	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
29	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
30	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
31	TOWN	☐	AD_CITY2	TEXT40	CHAR	40	0	District
32	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
33	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
34	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
35	.INCLUDE	☐				0	0	UKM: Communication Fields of the ID Search
36	PHONE	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
37	PHONE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
38	PHONE_EXTENSION	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
39	MOBILE	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
40	MOBILE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
41	FAX	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
42	FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
43	FAX_EXTENSION	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
44	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
45	.INCLUDE	☐				0	0	UKM: ID Fields for the ID Search
46	ID_TYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	TB039A
47	ID	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
48	.INCLUDE	☐				0	0	UKM: Tax Number Fields for the ID Search
49	TAX_TYPE	☐	BPTAXTYPE	BPTAXTYPE	CHAR	4	0	Tax Number Category	TFKTAXNUMTYPE_C
50	TAX_NUMBER	☐	BPTAXNUM	BPTAXNUM	CHAR	20	0	Business Partner Tax Number
51	.INCLUDE	☐				0	0	UKM: PO Box-Fields of the Search Unique ID
52	POBOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
53	POST_CODE_POBOX	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
54	POST_CODE_COMPANY	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
55	.INCLUDE	☐				0	0	Relations of a Person
56	R_NAME_LAST	☐	UKM_SEARCH_ID_RELA_NAME_L	BU_NAME	CHAR	40	0	Last Name of Spouse
57	R_NAME_FIRST	☐	UKM_SEARCH_ID_RELA_NAMEP_F	BU_NAME	CHAR	40	0	First Name of Spouse
58	R_NAME_BIRTH	☐	UKM_SEARCH_ID_RELA_BIRTHNM	BU_NAME	CHAR	40	0	Name of Spouse at Birth
59	R_BIRTH_DATE	☐	UKM_SEARCH_ID_RELA_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Spouse
60	R_BIRTH_PLACE	☐	UKM_SEARCH_ID_RELA_BIRTHPL	TEXT40	CHAR	40	0	Place of Birth of Spouse
61	R_BIRTH_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
62	R_MARITAL_STATUS	☐	UKM_SEARCH_ID_RELA_MARST	BU_MARST	CHAR	1	0	Marital Status	TB027
63	R_SEX	☐	UKM_SEARCH_ID_RELA_SEX	UKM_SEARCHID_SEX	CHAR	1	0	Gender of Spouse

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UKM_S_SEARCH_ID_RESULT	BIRTH_COUNTRY	T005	LAND1
2	UKM_S_SEARCH_ID_RESULT	COUNTRY	T005	LAND1
3	UKM_S_SEARCH_ID_RESULT	FAX_COUNTRY	T005	LAND1
4	UKM_S_SEARCH_ID_RESULT	ID_TYPE	TB039A	TYPE
5	UKM_S_SEARCH_ID_RESULT	LEGAL_ENTITY	TB019	LEGAL_ENTY
6	UKM_S_SEARCH_ID_RESULT	MARITAL_STATUS	TB027	MARST
7	UKM_S_SEARCH_ID_RESULT	MOBILE_COUNTRY	T005	LAND1
8	UKM_S_SEARCH_ID_RESULT	NATIONALITY	T005	LAND1
9	UKM_S_SEARCH_ID_RESULT	PHONE_COUNTRY	T005	LAND1
10	UKM_S_SEARCH_ID_RESULT	R_BIRTH_COUNTRY	T005	LAND1
11	UKM_S_SEARCH_ID_RESULT	R_MARITAL_STATUS	TB027	MARST
12	UKM_S_SEARCH_ID_RESULT	STATE	T005S	BLAND
13	UKM_S_SEARCH_ID_RESULT	TAX_TYPE	TFKTAXNUMTYPE_C	TAXTYPE

History

Last changed by/on	SAP	20130529
SAP Release Created in