| 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 | DECID | SI Declaration identifier | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | P12_DECID | Allow NULL? |
| 3 | DYEAR | Year the declaration refers to | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | P12_DYEAR | Allow NULL? |
| 4 | DQART | Quarter the declaration refers to | char | 1 | 0 | NUMC | (N'0') | No | | P12_DQART | Allow NULL? |
| 5 | DSQNR | Sequence number per declaration step | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | P12_DSQNR | Allow NULL? |
| 6 | DSTAT | Status SI declaration | char | 1 | 0 | CHAR | (N' ') | No | | P12_DSTAT | Allow NULL? |
| 7 | CDATE | Creation date SI declaration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_CDATE | Allow NULL? |
| 8 | CTIME | | nvarchar | 6 | 0 | | (N'000000') | Yes | | | Allow NULL? |
| 9 | RDATE | Release date SI declaration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_RDATE | Allow NULL? |
| 10 | RTIME | | nvarchar | 6 | 0 | | (N'000000') | Yes | | | Allow NULL? |
| 11 | DDATE | Rejection date SI declaration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_DDATE | Allow NULL? |
| 12 | DTIME | | nvarchar | 6 | 0 | | (N'000000') | Yes | | | Allow NULL? |
| 13 | ADATE | Acceptance date SI declaration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_ADATE | Allow NULL? |
| 14 | ATIME | | nvarchar | 6 | 0 | | (N'000000') | Yes | | | Allow NULL? |
| 15 | SDATE | Selection date payroll results in SI declaration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_SDATE | Allow NULL? |
| 16 | ADMIN | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUBNAME | Allow NULL? |
| 17 | STREF | Reference pointing to the detailed declaration info | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P12_STREF | Allow NULL? |
| 18 | ONECO | Corrective declarations limited to one | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_ONECO | Allow NULL? |