| 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 | T000 | MANDT | Allow NULL? |
| 2 | KATID | Health Problems Catalog | nvarchar | 40 | 0 | CHAR | (N' ') | No | | SYMPTKAT | Allow NULL? |
| 3 | SYMPTOM | Health Problem | nvarchar | 40 | 0 | CHAR | (N' ') | No | | SYMPTOM | Allow NULL? |
| 4 | SPRAS | Language Key | char | 1 | 0 | LANG | (N' ') | No | * | SPRAS | Allow NULL? |
| 5 | VALIDTO | Health Problem Is Valid to (Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALIDTO | Allow NULL? |
| 6 | COMPONENT | Health Problem Component | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | SYMPTCOMP | Allow NULL? |
| 7 | SYMPTEXT | Description for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTTEXT | Allow NULL? |
| 8 | SYMPTSHORT | Short Text for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTSHORT | Allow NULL? |
| 9 | SYMPKEY | Health Problem Coding | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPKEY | Allow NULL? |
| 10 | CRIT | Health Problem Criterion | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTCRIT | Allow NULL? |
| 11 | INCL | Inclusive (Health Problem) | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTINCL | Allow NULL? |
| 12 | EXCL | Exclusive (Health Problem) | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTEXCL | Allow NULL? |
| 13 | CONS | Take Health Problem Into Account | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTCONS | Allow NULL? |
| 14 | NOTE | Comment for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTNOTE | Allow NULL? |
| 15 | ICPC2 | Health Problem Is Active (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | SYMPTACT | Allow NULL? |
| 16 | SYMPTEXT1 | Supplementary Text for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTTEXTZ | Allow NULL? |
| 17 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 18 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 19 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 20 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 21 | SYMPTEXT_TRANS | Standardized Description for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTTEXT_TRANS | Allow NULL? |
| 22 | SYMPTSHORT_TRANS | Standardized Short Text for Health Problem | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYMPTSHORT_TRANS | Allow NULL? |
