| 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 | FILENAME | Shift Report: File Name | nvarchar | 70 | 0 | CHAR | (N' ') | No | | COCF_SR_FILENAME | Allow NULL? |
| 3 | SR_ORIGIN | Origin or Use of Shift Note or Report | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | COCF_SRN_ORIGIN | Allow NULL? |
| 4 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 5 | TYP | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 6 | ARBHI | Name of Work Center or Hierarchy | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | COCF_SRN_ARBHI | Allow NULL? |
| 7 | FUNCT_LOC | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TPLNR | Allow NULL? |
| 8 | EQUIPMENT | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EQUNR | Allow NULL? |
| 9 | COUNTER | Running Number for Shift Reports with Same Key | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | COCF_SR_KEY_CNT | Allow NULL? |
| 10 | START_DATE | Start of Evaluation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | COCF_SR_START_DATE | Allow NULL? |
| 11 | START_TIME | Start Time of Evaluation Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | COCF_SR_START_TIME | Allow NULL? |
| 12 | END_DATE | End of Evaluation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | COCF_SR_END_DATE | Allow NULL? |
| 13 | END_TIME | End Time of Evaluation Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | COCF_SR_END_TIME | Allow NULL? |
| 14 | STATUS | Status of Shift Report | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | COCF_SR_STATUS | Allow NULL? |
| 15 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TZNZONE | Allow NULL? |
| 16 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 17 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 18 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | * | SPRAS | Allow NULL? |
| 19 | PRODSUP | Person Responsible for Shift | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | COCF_PRODUCTION_SUPERVISOR | Allow NULL? |
| 20 | SIGNER | Signatory of Digital Signature | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SIGNER | Allow NULL? |
| 21 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 22 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 23 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 24 | AEZET | Time last change was made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZET | Allow NULL? |
| 25 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SCHGRUP | Allow NULL? |
| 26 | KAPTPROG | Shift definition | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KAPTPROG | Allow NULL? |
| 27 | HASH_PDF | Hash Value (160 Bits) | varbinary | 20 | 0 | RAW | | Yes | | HASH160X | |
| 28 | KPRO_CLASS | Document class | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SDOK_CLASS | Allow NULL? |
| 29 | KPRO_OBJID | ID for documents and relations | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SDOK_DOCID | Allow NULL? |
