| 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 | QUERY_ID | Query ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | /BCV/C_QHEAD | /BCV/QRM_QUERY_ID | Allow NULL? |
| 3 | ATTRIBUTE_ID | Query Field ID | nvarchar | 30 | 0 | CHAR | (N' ') | No | | /BCV/QRM_ATTRIBUTE_ID | Allow NULL? |
| 4 | TYPE | Type of Query Field | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_ATTRIBUTE_TYPE | Allow NULL? |
| 5 | ORIGIN | Origin of Query Field | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_ATTRIBUTE_ORIGIN | Allow NULL? |
| 6 | SIN_ATTRIBUTE_ID | ID of Search Connector Field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_SIN_ATTRIBUTE_ID | Allow NULL? |
| 7 | SEARCH_ID | Internal ID of Search Connector | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /BCV/C_QSCON | /BCV/QRM_SEARCH_ID | Allow NULL? |
| 8 | DATA_ELEM | Data Element of Query Field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_ATTRIBUTE_DATA_ELEM | Allow NULL? |
| 9 | DATATYPE | Data Type of Query Field | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_ATTRIBUTE_DATATYPE | Allow NULL? |
| 10 | LENGTH | Length of Query Field | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | /BCV/QRM_ATTRIBUTE_LENGTH | Allow NULL? |
| 11 | DECIMALS | Decimals of Query Field | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | /BCV/QRM_ATTRIBUTE_DECIMALS | Allow NULL? |
| 12 | CONVEXIT | Conversion Exit | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | /BCV/FND_CONVEXIT | Allow NULL? |
| 13 | REQUIRED_IND | Query Input Field Value Required | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_REQUIRED_IND | Allow NULL? |
| 14 | LOWERCASE_IND | Lowercase Letters Allowed in Query Input Field Values | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_LOWERCASE_IND | Allow NULL? |
| 15 | SELECT_MODE | Query Input Field Selection Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_SELECT_MODE | Allow NULL? |
| 16 | RELATION | Reference Field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_RELATION | Allow NULL? |
| 17 | RELATION_TYPE | Reference Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /BCV/QRM_RELATION_TYPE | Allow NULL? |
| 18 | MEANING | Meaning | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /BCV/FND_MEANING | Allow NULL? |
