Summary Statement Detail
Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.
Table Name |
Description |
Type |
Primary Provider |
Sensitivity |
Load Frequency |
Last Load Date |
|---|---|---|---|---|---|---|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
22-JAN-2025 |
|
GL Account and Cost Element Dimension with built-in mechanism for organizing in preset Cost Element (GL Account) groups, derived from Cost Element Hierarchies (groups) in SAP. The value in the field Report-Type describes the type of grouping as it is defined in SAP. IMPORTANT: "REPORT TYPE" MUST BE SPECIFIED as a limit, for the query to return correct results. For more details see: GL Account Overview |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
22-JAN-2025 |
|
Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join. |
Dimension |
PUBLIC |
As Needed |
22-JAN-2025 |
||
Summary Statement reporting table which contains data from July 1999 through the current fiscal period. It is similar to Balances by Fiscal Period, except that it contains calculated overhead for those fiscal period(s) where costing sheets have not been run yet. Field RECORD_TYPE contains values "Posted" or "Calculated" and should be used in reports to clarify what the entries are. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
05-MAR-2009 |
|
Contains the history of Cost Collector Data by fiscal period and fiscal year. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
22-JAN-2025 |
|
Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
22-JAN-2025 |