| 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 | COUNTER | Counter for Records in Time Recording | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CATSCOUNTE | Allow NULL? |
| 3 | STOKZ | Indicator: Document Has Been Reversed | char | 1 | 0 | CHAR | (N' ') | No | | CO_STOKZ | Allow NULL? |
| 4 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 5 | WORKDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CATSDATE | Allow NULL? |
| 6 | UNAME1 | User who wrote record to interface | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME1 | Allow NULL? |
| 7 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM1 | Allow NULL? |
| 8 | UZEIT1 | Time at which record was written to interface | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT1 | Allow NULL? |
| 9 | PGMID1 | Write Record to Interface Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID1 | Allow NULL? |
| 10 | UNAME2 | Name of user who initially accessed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME2 | Allow NULL? |
| 11 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM2 | Allow NULL? |
| 12 | UZEIT2 | Time at which record was initially accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT2 | Allow NULL? |
| 13 | PGMID2 | Report used to access record initially | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID2 | Allow NULL? |
| 14 | STATU2 | Log status when record was first accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU2 | Allow NULL? |
| 15 | UNAME3 | Last user to access record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME3 | Allow NULL? |
| 16 | DATUM3 | Date on which record was last accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM3 | Allow NULL? |
| 17 | UZEIT3 | Time at which record was last accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT3 | Allow NULL? |
| 18 | PGMID3 | Last Used to Access Record Program | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID3 | Allow NULL? |
| 19 | STATU3 | Log status when record was last accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU3 | Allow NULL? |
| 20 | UNAME4 | User who first retrieved the record successfully | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME4 | Allow NULL? |
| 21 | DATUM4 | Date on which record was first retrieved successfully | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM4 | Allow NULL? |
| 22 | UZEIT4 | Time at which record was first retrieved successfully | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT4 | Allow NULL? |
| 23 | PGMID4 | Report first used to retrieve record successfully | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID4 | Allow NULL? |
| 24 | SKOSTL | Sender Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SKOSTL | Allow NULL? |
| 25 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 26 | SEBELN | Sending purchase order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SEBELN | Allow NULL? |
| 27 | SEBELP | Sending purchase order item | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | SEBELP | Allow NULL? |
| 28 | LSTNR | Service number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | LSTNR | Allow NULL? |
| 29 | SPRZNR | Sender Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SPRZNR | Allow NULL? |
| 30 | RKOSTL | Receiver Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EKOSTL | Allow NULL? |
| 31 | RPROJEXT | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID | Allow NULL? |
| 32 | RAUFNR | Receiver Order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | EAUFNR | Allow NULL? |
| 33 | RNPLNR | Network number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NW_AUFNR | Allow NULL? |
| 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 35 | UVORN | Suboperation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | UVORN | Allow NULL? |
| 36 | RKDAUF | Receiver sales order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EKDAU | Allow NULL? |
| 37 | RKDPOS | Item number in receiver sales order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | EKDPO | Allow NULL? |
| 38 | RKSTR | Receiver cost object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | EKSTR | Allow NULL? |
| 39 | RPRZNR | Receiver business process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | EPRZNR | Allow NULL? |
| 40 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554S | AWART | Allow NULL? |
| 41 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGART | Allow NULL? |
| 42 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | REINR | Allow NULL? |
| 43 | VERSL | Overtime Compensation Type | char | 1 | 0 | CHAR | (N' ') | Yes | T555R | VRSCH | Allow NULL? |
| 44 | BWGRL | Valuation basis | decimal | 13 | 2 | CURR | ((0)) | Yes | | CATSBWGRL | |
| 45 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 46 | AUFKZ | Extra Pay Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFKN | Allow NULL? |
| 47 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | TRFGR | Allow NULL? |
| 48 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TRFST | Allow NULL? |
| 49 | PRAKN | Premium Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PRAKN | Allow NULL? |
| 50 | PRAKZ | Premium Indicator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PRAKZ | Allow NULL? |
| 51 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 52 | PLANS | Position | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | T528B | PLANS | Allow NULL? |
| 53 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 54 | MEINH | Unit of Measure for Display | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINH | Allow NULL? |
| 55 | TCURR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWAER | Allow NULL? |
| 56 | PRICE | Price in Transaction Currency | decimal | 11 | 2 | CURR | ((0)) | Yes | | CATSPRICE | |
| 57 | ARBID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | OBJEKTID | Allow NULL? |
| 58 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 59 | ERSDA | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CATS_ERSDA | Allow NULL? |
| 60 | ERSTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CATS_CPUTM | Allow NULL? |
| 61 | ERNAM | User Who Created Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CATS_ERNAM | Allow NULL? |
| 62 | LAEDA | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CATS_LAEDA | Allow NULL? |
| 63 | LAETM | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CATS_LAETM | Allow NULL? |
| 64 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 65 | APNAM | Name of person who approved data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CATSAPNAM | Allow NULL? |
| 66 | APDAT | Date of Approval | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CATSAPDAT | Allow NULL? |
| 67 | WORKITEMID | Work item ID | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | SWW_WIID | Allow NULL? |
| 68 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 69 | STATUS | Processing status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CATSSTATUS | Allow NULL? |
| 70 | REFCOUNTER | Reference Counter for Record to be Changed | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CATSREFCOU | Allow NULL? |
| 71 | REASON | Reason for rejection | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CATSREASON | Allow NULL? |
| 72 | BELNR | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CATSBELNR | Allow NULL? |
| 73 | EXTSYSTEM | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HR_AWSYS | Allow NULL? |
| 74 | EXTAPPLICATION | External Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | HR_AWTYP | Allow NULL? |
| 75 | EXTDOCUMENTNO | Document number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | HR_AWKEY | Allow NULL? |
| 76 | TASKCOUNTER | CATS: Task Counter | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CATSTASKCOUNTER | Allow NULL? |
| 77 | CATSHOURS | Hours | decimal | 4 | 2 | QUAN | ((0)) | Yes | | CATSHOURS | |
| 78 | BEGUZ | Start time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CATSBEGUZ | Allow NULL? |
| 79 | ENDUZ | End time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CATSENDUZ | Allow NULL? |
| 80 | VTKEN | Previous Day Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VTKEN | Allow NULL? |
| 81 | ALLDF | Record is for Full Day | char | 1 | 0 | CHAR | (N' ') | Yes | | ALLDF | Allow NULL? |
| 82 | LTXA1 | Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CATSSHORTT | Allow NULL? |
| 83 | ZCPR_GUID | cProjects: Projekt-GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ZCPR_GUID | Allow NULL? |
| 84 | ZCPR_EXTID | cProjects: Project Number | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | ZCPR_EXTID | Allow NULL? |
| 85 | ZCPR_OBJGUID | cProjects: Object GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ZCPR_OBJGUID | Allow NULL? |
| 86 | ZCPR_OBJGEXTID | cProjects: Object Name | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | ZCPR_OBJGEXTID | Allow NULL? |
| 87 | ZCPR_OBJTYPE | cProjects: Object Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ZCPR_OBJTYPE | Allow NULL? |
| 88 | YYRPM_REL_TYPE | Relation Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_REL_TYPE | Allow NULL? |
| 89 | YYRPM_PROJ_GUID | Project GUID (xRPM) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_PROJ_GUID | Allow NULL? |
| 90 | YYRPM_PROJ_ID | Project ID (ext.) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_PROJ_ID | Allow NULL? |
| 91 | YYRPM_RES_GUID | Resource GUID (xRPM) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_RES_GUID | Allow NULL? |
| 92 | YYRPM_RES_ID | Resource ID (ext.) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_RES_ID | Allow NULL? |
| 93 | YYRPM_ROLE_GUID | Role GUID (xRPM) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_ROLE_GUID | Allow NULL? |
| 94 | YYRPM_ROLE_ID | Role ID (ext.) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_ROLE_ID | Allow NULL? |
| 95 | YYRPM_TASK_GUID | Task GUID (xRPM) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_TASK_GUID | Allow NULL? |
| 96 | YYRPM_TASK_ID | Task ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | Y23_RPM_TASK_ID | Allow NULL? |
