| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | ORGID | Identification Key of Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | NORG | ORGID | Allow NULL? |
| 4 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ENDDT | Allow NULL? |
| 5 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 6 | KRZ01 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 7 | KRZ02 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 8 | KRZ03 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 9 | KRZ04 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 10 | KRZ05 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 11 | KRZ06 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 12 | KRZ07 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 13 | KRZ08 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 14 | KRZ09 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 15 | KRZ10 | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |