| 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 | PROFILE_ID | Profile Template Key | nvarchar | 33 | 0 | CHAR | (N' ') | No | | N2DWSWL_PROFILE_ID | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 4 | AREA | Work Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_AREA | Allow NULL? |
| 5 | GROUP_ID | Group Key | nvarchar | 33 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_GROUP_ID | Allow NULL? |
| 6 | SHORT_CODE | Profile Template Identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_PROFILE_SHORT_CODE | Allow NULL? |
| 7 | STATE | Technical Status of Profile Template | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_PROFILE_STATE | Allow NULL? |
| 8 | AVAIL_IN_CATALOG | Available in Selection Dialog | char | 1 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_AVAIL_IN_CATALOG | Allow NULL? |
| 9 | VALID_FROM | Profile Template Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2DWSWL_PROFILE_VALID_FROM | Allow NULL? |
| 10 | VALID_TO | Profile Template Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2DWSWL_PROFILE_VALID_TO | Allow NULL? |
| 11 | CONTACT_PERSON | Name of Contact Person | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_PROFILE_CONTACT_PERSON | Allow NULL? |
| 12 | CONTACT_PHONE | Telephone Number of Contact Person | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_CONTACT_PHONE | Allow NULL? |
| 13 | CONTACT_EMAIL | e-mail Address of Contact Person | nvarchar | 53 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_CONTACT_EMAIL | Allow NULL? |
| 14 | INSDATE | Date of Creation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2DWSWL_INSDATE | Allow NULL? |
| 15 | INSUSER | User who Created Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_INSUSER | Allow NULL? |
| 16 | UPDDATE | Date on Which Record Was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2DWSWL_UPDDATE | Allow NULL? |
| 17 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_UPDUSER | Allow NULL? |
| 18 | PURPOSE | Usage of a Profile | char | 1 | 0 | CHAR | (N' ') | Yes | | N2DWSWL_PURPOSE | Allow NULL? |
| 19 | MONCON_ID | Identification of a Monitoring Configuration | nvarchar | 33 | 0 | CHAR | (N' ') | Yes | | N1MONCON_ID | Allow NULL? |
