| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CONDNAME | Selection condition ID | nvarchar | 30 | 0 | CHAR | (N' ') | No | | CONDNAME | Allow NULL? |
| 2 | AS4LOCAL | Activation Status of a Repository Object | char | 1 | 0 | CHAR | (N' ') | No | | AS4LOCAL | Allow NULL? |
| 3 | AS4VERS | Version of a selection condition | nvarchar | 4 | 0 | NUMC | (N'0000') | No | DD29L | CONDVERS | Allow NULL? |
| 4 | POSITION | Position in a repetition group | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MCPOS | Allow NULL? |
| 5 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 6 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIELDNAME | Allow NULL? |
| 7 | NEGATION | NOT operator in selection conditions | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VSNEGATION | Allow NULL? |
| 8 | OPERATOR | Operator in a Join Condition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VSOPERATOR | Allow NULL? |
| 9 | CONSTANTS | Constant in selection conditions | nvarchar | 38 | 0 | CHAR | (N' ') | Yes | | VSCONST | Allow NULL? |
| 10 | CONTLINE | Flag for continuation line in selection conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | VSCONTFLAG | Allow NULL? |
| 11 | AND_OR | AND/OR link in a selection condition | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VSCONJ | Allow NULL? |
| 12 | OFFSET | Offset within a matchcode field | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MCIDOFFS | Allow NULL? |
| 13 | FLENGTH | Field length within a MC ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MCIDLEN | Allow NULL? |
| 14 | MCOFIELD | Matchcode field name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | MCFIELDN | Allow NULL? |
| 15 | JOPERATOR | DD: Join Operator; Example: INNER JOIN, LEFT OUTER JOIN | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | JOPERATOR | Allow NULL? |