| 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 | T5TMCSROBJFLD | HRTMC_SEARCH_TEMPLATE_ID | Allow NULL? |
| 3 | REQUEST_TYPE_ID | Name of Search Request in Enterprise Search | nvarchar | 32 | 0 | CHAR | (N' ') | No | T5TMCSROBJFLD | HRTMC_SEARCH_REQUEST_TYPE_ID | Allow NULL? |
| 4 | SEARCH_FIELDNAME | Search Field Name | nvarchar | 32 | 0 | CHAR | (N' ') | No | | HRTMC_SEARCH_FIELDNAME | Allow NULL? |
| 5 | REQUEST_ALIAS | Alias for Field in Search Request | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_REQUEST_ALIAS | Allow NULL? |
| 6 | RESPONSE_ALIAS | Alias for Field in Search Result | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_RESPONSE_ALIAS | Allow NULL? |
| 7 | RESPONSE_NODE | Node Name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_NODE_NAME | Allow NULL? |
| 8 | TABLENAME | Reference Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_TABLENAME | Allow NULL? |
| 9 | FIELDNAME | Reference Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | HRTMC_SEARCH_REF_FIELDNAME | Allow NULL? |
| 10 | TABLENAME_AUTH | Reference Table Name for Authorization Check | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_TABLENAME_AUTH | Allow NULL? |
| 11 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | HRTMC_SEARCH_OTYPE_AUTH | Allow NULL? |
| 12 | F4_HELP | F4 Help | char | 1 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_F4_HELP | Allow NULL? |
| 13 | DDIC_LABEL | DDIC Label | char | 1 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_DDIC_LABEL | Allow NULL? |
| 14 | RESTRICTIONS | Complex Restrictions | char | 1 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_COMPL_RESTRICTION | Allow NULL? |
| 15 | INFTY | Infotype | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | HRTMC_SEARCH_INFTY_AUTH | Allow NULL? |
| 16 | SUBTYP | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HRTMC_SEARCH_SUBTYP_AUTH | Allow NULL? |
