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