| 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 | RGART | IS-H: Rule Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | TNT3 | ISH_RGART | Allow NULL? |
| 4 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | No | TNK01 | TARID | Allow NULL? |
| 5 | LEIST | IS-H: Service Group for Service Rules | nvarchar | 10 | 0 | CHAR | (N' ') | No | NTPK | LSGRP | Allow NULL? |
| 6 | N_MAX | IS-H: Max. number of services allowed from group | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_NMAX | Allow NULL? |
| 7 | NOBER | IS-H: Upper limit for number for maximum value rule | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_NOBER | Allow NULL? |
| 8 | JAHRE | IS-H: Service Rule Validity (Calendar Year) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_HJAHRE | Allow NULL? |
| 9 | QUART | IS-H: Service Rule Validity (Quarter) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_HQUART | Allow NULL? |
| 10 | TAGE | IS-H: Validity period of a service rule (days) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_HTAGE | Allow NULL? |
| 11 | PFALL | IS-H: Rule Valid per Case | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_FALLKZ | Allow NULL? |
| 12 | ETARI | IS-H: Catalog of Alternative Service for Max. Value Rule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | ISH_ETARI | Allow NULL? |
| 13 | ELEIS | IS-H: Alternative service for maximum value rule | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | ISH_ELEIS | Allow NULL? |
| 14 | MSGTY | Message type (E, I, W, ...) | char | 1 | 0 | CHAR | (N' ') | Yes | | MSGTY_CO | Allow NULL? |
| 15 | RESTM | IS-H: Remaining quantity cannot be billed for | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RESTMENGE | Allow NULL? |
| 16 | TASPA | IS-H: Column in Service Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TARSP | Allow NULL? |
| 17 | MXVAL | IS-H: Maximum Value Allowed for a Service | decimal | 15 | 2 | DEC | ((0)) | Yes | | ISH_MAXWERT | |