| 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 | RULEID | Code of the prefetch rule | nvarchar | 10 | 0 | CHAR | (N' ') | No | | N2_RULEID | Allow NULL? |
| 3 | PSTATUS | Status of the prefetch rule: active, inactive | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2_PSTATUS | Allow NULL? |
| 4 | RULEDESC | Short description of a prefetch rule | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2_RDESC | Allow NULL? |
| 5 | CONDTYPE | Condition type of a prefetch rule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2_CONDTYP | Allow NULL? |
| 6 | COND | Condition of a prefetch rule | nvarchar | 254 | 0 | CHAR | (N' ') | Yes | | N2_COND | Allow NULL? |
| 7 | CPARM | Parameter segment of the condition function called | nvarchar | 254 | 0 | CHAR | (N' ') | Yes | | N2_CPARM | Allow NULL? |
| 8 | CVALUE | Comparison Value that Satisfies the Condition | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2_CVALUE | Allow NULL? |
| 9 | ACTION | defined prefetch - action | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2_ACTION | Allow NULL? |
| 10 | DEVICEID | Codes of the modality, of the device | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2_DEVICE | Allow NULL? |
