| 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 | REGNO | ECD Register Number | nvarchar | 4 | 0 | CHAR | (N' ') | No | | J_1BECD_REGISTER | Allow NULL? |
| 3 | TYPE_G | Category of File Register for Type G | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_G | Allow NULL? |
| 4 | TYPE_R | Category of File Register for Type R | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_R | Allow NULL? |
| 5 | TYPE_B | Category of File Register for Type B | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_B | Allow NULL? |
| 6 | TYPE_Z | Category of File Register for Type Z | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_Z | Allow NULL? |
| 7 | TYPE_A | Category of File Register for Type A | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_A | Allow NULL? |
| 8 | TYPE_G_VAR | Category of File Register for Type G Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_G_VAR | Allow NULL? |
| 9 | TYPE_R_VAR | Category of File Register for Type R Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_R_VAR | Allow NULL? |
| 10 | TYPE_B_VAR | Category of File Register for Type B Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_B_VAR | Allow NULL? |
| 11 | TYPE_Z_VAR | Category of File Register for Type Z Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_Z_VAR | Allow NULL? |
| 12 | TYPE_A_VAR | Category of File Register for Type A Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BECD_REG_CAT_TYPE_A_VAR | Allow NULL? |
