The CATS_MY_DATES table in SAP ERP or S/4HANA stores CATS notebook: Periods for Target Hours and Data Storage data. There are total 8 fields in CATS_MY_DATES table. The CATS notebook: Periods for Target Hours and Data Storage table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CATS_MY_DATES table. It is in myCATS: Schnittstellen-Objekte (CATS_MY_INTERFACE) ABAP package and is part of the Time Sheet (CA-TS) module.
SAP CATS_MY_DATES Table Fields
Following is the list of fields that are available in SAP CATS_MY_DATES table. The primary key fields of CATS notebook: Periods for Target Hours and Data Storage table in SAP are MANDT (Client), PROFILE (Data Entry Profile).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| PROFILE | Data Entry Profile | CATSVARIAN | * | CHAR (8) |
| ABSOLUTE_DATE | Date | CATSDATE | DATS (8) | |
| NUMBER_OF_DAYS | Number of Days in the Past | NUMBER_OF_DAYS | NUMC (4) | |
| MONTH_YEAR | Indicator: Month/Year | MONTH_YEAR_INDICATOR | CHAR (1) | |
| NUMBER_OF_MONTHS | Number of Months | NUMBER_OF_MONTH | NUMC (2) | |
| RELATIVE_NEG | Relative Period (Days): Negative | REL_NEGATIVE | NUMC (3) | |
| RELATIVE_POS | Relative Period (Days): Positive | REL_POSITIVE | NUMC (3) |
