| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | IDENT | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WFCID | Allow NULL? |
| 2 | VJAHR | Year from which data is stored | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | VJAHR | Allow NULL? |
| 3 | BJAHR | Year until which data is saved | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BJAHR | Allow NULL? |
| 4 | MOTAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 5 | DITAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 6 | MIWCH | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 7 | DOTAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 8 | FRTAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 9 | SATAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 10 | SOTAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 11 | FETAG | Bit for workday | char | 1 | 0 | CHAR | (N' ') | Yes | | KBIT | Allow NULL? |
| 12 | HOCID | Public Holiday Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | THOCI | HIDENT | Allow NULL? |
| 13 | BASIS | Start of factory calendar day numbering | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | KFTAG | Allow NULL? |
| 14 | ABBR | Calendar: Termination flag | char | 1 | 0 | CHAR | (N' ') | Yes | | KABBR | Allow NULL? |
| 15 | CRUSR | Calendar: Calendar creator/changer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | KUSER | Allow NULL? |
| 16 | CRDAT | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FABDAT | Allow NULL? |
| 17 | CRTIME | Calendar: Creation or change time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CRTIME | Allow NULL? |
| 18 | INTERV | Calendar: Termination flag | char | 1 | 0 | CHAR | (N' ') | Yes | | KABBR | Allow NULL? |
| 19 | AKTVJAHR | Year, from which calendar is in buffer | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AKTVJAHR | Allow NULL? |
| 20 | AKTBJAHR | Year, until which calendar is in buffer | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AKTBJAHR | Allow NULL? |