PCS Project
This dimension is for PCS Projects.
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom001 | Employees - General |
| tcmcs052 | Projects |
| tcmcs065 | Departments |
| tipcs020 | General Project Data |
| tipcs030 | Project Details |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Closing date | tipcs030.cldt |
| Actual Machine Hours | tipcs030.amch |
| Actual Man Hours | tipcs030.aman |
| Actualization Date | tipcs030.acdt |
| Budget | tipcs030.cbdg |
| Budget Desc | tcmcs052.dsca |
| Calculation Office | tipcs020.clco |
| Calculation Office Desc | tcmcs065.dsca |
| Company | Logical company of tcmcs052 |
| Completion Date | tipcs030.ddat |
| Date Filled by Sales | tipcs020.dtfs |
| Date Filled by Sales Filter | tipcs020.dtfs |
| Date Filled by Sales Sort | tipcs020.dtfs |
| Definitively Closed | tipcs030.defc |
| Definitively Closed Filter | tipcs030.defc |
| Definitively Closed Sort | tipcs030.defc |
| Engineering Allowed | tipcs020.peng |
| Engineering Allowed Filter | tipcs020.peng |
| Engineering Allowed Sort | tipcs020.peng |
| Estimated Capacity Aggregated | tipcs030.ecpa |
| Estimated Capacity Rough | tipcs030.ecpr |
| In Service | tcmcs052.isrv |
| In-Service Filter | tcmcs052.isrv |
| In-Service Sort | tcmcs052.isrv |
| Investment Project | tipcs030.intp |
| Investment Project Filter | tipcs030.intp |
| Investment Project Sort | tipcs030.intp |
| Invoiced Amount | tipcs030.tinv |
| PCS Project | tcmcs052.cprj |
| PCS Project ID Desc | tcmcs052.cprj + tcmcs052.dsca |
| Planning Method | tipcs030.plcd |
| Planning Method Filter | tipcs030.plcd |
| Planning Method Sort | tipcs030.plcd |
| Project Desc a | tcmcs052.dsca |
| Project Desc b | tcmcs052.dscb |
| Project Desc c | tcmcs052.dscc |
| Project Desc d | tcmcs052.dscd |
| Project Employee | tipcs020.pemp |
| Project Employee Name | tccom001.nama |
| Project Status | tipcs030.psts |
| Project Status Filter | tipcs030.psts |
| Project Status Sort | tipcs030.psts |
| Project Type | tipcs020.kopr |
| Project Type Filter | tipcs020.kopr |
| Project Type Sort | tipcs020.kopr |
| Reference | tipcs020.refe |
| Reference Date | tipcs020.cfdt |
| Revenue Expected | tipcs030.erev |
| Revenue Expected Filter | tipcs030.erev |
| Revenue Expected Sort | tipcs030.erev |
| Search Key a | tcmcs052.seak |
| Search Key b | tcmcs052.seab |
| Spent Critical Capacity | tipcs030.ascp |
| Stage of Completion | tipcs030.soco |
| Start Date | tipcs030.sdat |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |