Service Task
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tcemm170 | Companies |
tcmcs048 | Cost Components |
tsmdm015 | Tasks |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Company | tsmdm015_compnr |
Cost Component | tsmdm015.cpcp |
Cost Component Desc | tcmcs048.dsca |
Efficiency Rate | tsmdm015.occf |
Labor Rate Code | tsmdm015.clrt |
Search Argument | tsmdm015.sear |
Service Task | tsmdm015.ctsk |
Service Task Desc | tsmdm015.desc |
Service Task ID Desc | tsmdm015.ctsk |
Time Duration | tsmdm015.tmdu + tsmdm015.desc |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |