SAP table T370CLC (Fleet Consumption Calculation Keys)
SAP table T370CLC has 2 primary key fields being MANDT,CALC_KEY.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| CALC_KEY | Indicator to determine the calculation method f. consumption | CHAR | 1 | 0 | PRI_CALC | ||
| MSEHI | SI Unit of Fleet Consumption Unit Group | UNIT | 3 | 0 | T370CONV | CONSUMP_GRP_DIMEN | |
| PRI_COUNT | Primary Counter for Calculation of Fleet Usage | CHAR | 20 | 0 | T370POS | FLEET_COUNTER | |
| PRI_FUEL | Fuel counter for calculation of fleet consumption values | CHAR | 20 | 0 | T370POS | FLEET_FUEL | |
| INVERT | Reversal of Unit of Measurement | CHAR | 1 | 0 | CALC_INVERT | ||
| BASE_UNIT | Display Unit for Fleet Consumption | UNIT | 3 | 0 | T370CONV | CONSUMP_DISP_UNIT | |
| PERIODS | Number of days for short-term analysis | NUMC | 5 | 0 | PERIOD_AVE_SHORT | ||
| PERIODL | Number of days for long-term analysis | NUMC | 5 | 0 | PERIOD_AVE_LONG |
T370CLC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T370CLC | BASE_UNIT | T370CONV | Fleet Consumption Units | MANDT |
| 0 T370CLC | BASE_UNIT | T370CONV | Fleet Consumption Units | MSEHI |
| 0 T370CLC | BASE_UNIT | T370CONV | Fleet Consumption Units | BASE_UNIT |
| 1 T370CLC | MANDT | T000 | Clients | MANDT |
| 0 T370CLC | MSEHI | T370CONV | Fleet Consumption Units | MANDT |
| 0 T370CLC | MSEHI | T370CONV | Fleet Consumption Units | MSEHI |
| 0 T370CLC | MSEHI | T370CONV | Fleet Consumption Units | BASE_UNIT |
| 1 T370CLC | PRI_COUNT | T370POS | Valid Measuring Point Positions (Sort Field) | MANDT |
| 1 T370CLC | PRI_COUNT | T370POS | Valid Measuring Point Positions (Sort Field) | MPPOS |
| 0 T370CLC | PRI_FUEL | T370POS | Valid Measuring Point Positions (Sort Field) | MANDT |
| 0 T370CLC | PRI_FUEL | T370POS | Valid Measuring Point Positions (Sort Field) | MPPOS |