| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SAPPSSRM/TH_TYP | Threshold Types | 8 | PERIOD_TYPE | Period Type for Thresholds | nvarchar | 1 | 0 | | |
| 2 | ZCM_DCS_DATA_TAB | Database table for DCS | 3 | PERIOD_TYPE | Period Type | nvarchar | 4 | 0 | | |
| TOPCustom Development Management Cockpit |
| 3 | CNVCDMC_STAT_PRO | CDMC: Programs for Statistics Collection | 3 | PERIOD_TYPE | CDMC : Period type | nvarchar | 1 | 0 | | |
| TOPE-Recruiting |
| 4 | T77RCF_LAWPERIOD | Legal Periods | 4 | PERIOD_TYPE | Legal Period Type | nvarchar | 1 | 0 | | |
| TOPMaterials Management |
| 5 | J_1GVL_WHB000 | Material valuation: global settings | 4 | PERIOD_TYPE | Period type | nvarchar | 1 | 0 | | |
| TOPPerishables Procurement |
| 6 | FIP_D_STAT_PER | Table containing default Statistical Data Periods | 3 | PERIOD_TYPE | Period Type | nvarchar | 6 | 0 | | |
| TOPPortfolio Management |
| 7 | /RPM/BUCKET_D | Operational bucket persisted data | 7 | PERIOD_TYPE | Financial Period Breakdown | nvarchar | 2 | 0 | | |
| 8 | /RPM/FIN_PLA_INT | FI Intermediate table(with exchratedate) | 5 | PERIOD_TYPE | Period Type | nvarchar | 2 | 0 | | |
| 9 | /RPM/PORTFOLIO_D | Portfolio Operational persisted data | 10 | PERIOD_TYPE | Financial Period Breakdown | nvarchar | 2 | 0 | | |
| 10 | RPM_BUCKET_D_CD | Bucket - Pseudo table for change documents | 7 | PERIOD_TYPE | Financial Period Breakdown | nvarchar | 2 | 0 | | |
| 11 | RPM_PORTFOLIO_CD | Portfolio attributes - Pseudo table for change documents | 10 | PERIOD_TYPE | Financial Period Breakdown | nvarchar | 2 | 0 | | |
| TOPResources |
| 12 | DPR_DIST_VAL | Make Settings for Distribution | 4 | PERIOD_TYPE | Period Type (Weekly/Monthly/Generic Interval) | nvarchar | 2 | 0 | | |
| TOPRuntime WorkbenchMonitoring |
| 13 | SXMSAGGDAT | SAP XI Status Overview: Aggregated Data | 4 | PERIOD_TYPE | SAP XI Status Overview: Aggregation Period | nvarchar | 1 | 0 | | |
| 14 | SXMSAGGPERIOD | SAP XI Status Overview: Aggregration Profile Periods | 2 | PERIOD_TYPE | SAP XI Status Overview: Aggregation Period | nvarchar | 1 | 0 | | |
| TOPTime Sheet |
| 15 | CATS_APPR_PERSP | Approval Views | 3 | PERIOD_TYPE | Period Type | tinyint | 3 | 0 | | |
| TOPTransaction Manager |
| 16 | RDPT_SET | Quantity of Redemption Schedules | 10 | PERIOD_TYPE | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
| 17 | TRCOTS_PERIODS | Period Defintions | 1 | PERIOD_TYPE | Type of Price Period | nvarchar | 2 | 0 | | |
| 18 | TRCOTS_PERIODS_T | Period Defintions | 1 | PERIOD_TYPE | Type of Price Period | nvarchar | 2 | 0 | | |
| TOPTreasury |
| 19 | TCRT_CTY_FWDRATE | Market Data for Forward Rates | 7 | PERIOD_TYPE | Type of Price Period | nvarchar | 2 | 0 | | |
| TOPWorkforce Management Application |
| 20 | WFAFC_WKGEN_CODE | Parameters to generate a list of weeks | 3 | PERIOD_TYPE | Period Type | nvarchar | 2 | 0 | | |
| TOPWorkforce Management Core |
| 21 | WFMFC_WKGEN_CODE | Parameters to generate a list of weeks | 3 | PERIOD_TYPE | Period Type | nvarchar | 2 | 0 | | |
