| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | MOLGA | Allow NULL? |
| 3 | WHO_TYPE | ESS Who's Who: Type of Who's Who Application | nvarchar | 5 | 0 | CHAR | (N' ') | No | | ESS_WHO_TYPE | Allow NULL? |
| 4 | WHO_SRD | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | No | | CHAR1 | Allow NULL? |
| 5 | WHO_SRD_CNT | Numc3, internal use | nvarchar | 3 | 0 | NUMC | (N'000') | No | | NUMC3 | Allow NULL? |
| 6 | SORT | Numeric 1-character | char | 1 | 0 | NUMC | (N'0') | Yes | | NUM1 | Allow NULL? |
| 7 | NUMB | SAP Query (S): Field group name | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | AQS_NUMB | Allow NULL? |
| 8 | SGNA | SAP Query (S): Table name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AQS_TNAME | Allow NULL? |
| 9 | NAME | SAP Query (S): Field name (table field) | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | AQS_FNAME | Allow NULL? |
| 10 | FTEXT | SAP Query (S): Long text for a field | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AQS_FTEXT | Allow NULL? |
| 11 | TYPE | SAP Query (S): ABAP type | char | 1 | 0 | CHAR | (N' ') | Yes | | AQS_ATYPE | Allow NULL? |
| 12 | OLENG | SAP Query (S): Length | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AQS_LENG | Allow NULL? |
| 13 | DECIMALS | SAP Query (S): Decimal places | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | AQS_DEC | Allow NULL? |
| 14 | CURRY | SAP Query (S): Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | AQS_FLAG | Allow NULL? |
| 15 | LENG | SAP Query (S): Length | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AQS_LENG | Allow NULL? |
| 16 | LIKEFIELD | SAP Query (S): Field name (table field) | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | AQS_FNAME | Allow NULL? |
| 17 | INFTY | Infotype | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | INFTY | Allow NULL? |
| 18 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIELDNAME | Allow NULL? |
| 19 | FIELDKIND | Type of Field (Infotype, Additional, Text, ...) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | HR_FIELD_KIND | Allow NULL? |
| 20 | DESCRIPTION | Description | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HR_FIELD_DESCRIPTION | Allow NULL? |
