| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | TEMPLATE_ID | Template Name in Enterprise Search | nvarchar | 32 | 0 | CHAR | (N' ') | No | T5TMCSROBJECTS | HRTMC_SEARCH_TEMPLATE_ID | Allow NULL? |
| 3 | REQUEST_TYPE_ID | Name of Search Request in Enterprise Search | nvarchar | 32 | 0 | CHAR | (N' ') | No | | HRTMC_SEARCH_REQUEST_TYPE_ID | Allow NULL? |
| 4 | REQUEST_ALIAS | Alias for Field in Search Request | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_REQUEST_ALIAS | Allow NULL? |
| 5 | RESPONSE_ALIAS | Alias for Field in Search Result | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_RESPONSE_ALIAS | Allow NULL? |
| 6 | USER_RESP_ALIAS | Search Request Alias for User Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_ALIAS_USER_RESP | Allow NULL? |
| 7 | VALIDITY_ALIAS | Alias for Restriction to Results Currently Valid | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_ALIAS_VALIDITY | Allow NULL? |