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