| 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 | KHID | IS-H: Identification of Hospital | nvarchar | 10 | 0 | CHAR | (N' ') | No | NGPA | KHID | Allow NULL? |
| 3 | KZTXT | IS-H: Comment on Hospital | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_KRH | Allow NULL? |
| 4 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 5 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 6 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 7 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 8 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 9 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 10 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 11 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 12 | KHART | IS-H: Hospital Type / Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN18E | ISH_KART | Allow NULL? |
| 13 | KBPFLV | IS-H: Cooperation BPflV Hospital | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KBPFLV | Allow NULL? |
| 14 | MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_BPMIG_DONE | Allow NULL? |
| 15 | /ISHFR/SIRET | SIRET Number | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | /ISHFR/SIRET | Allow NULL? |