0PM_FLEET

Fleet : Vehicle consumption detail | #TRAN | Extraction method: F1 | No Delta | Component: Plant Maintenance

Tables used: S114, MCIPMIS, EQUI, IFLOT, EAPL ... +62 more

🔑 Keys (15)
💰 Amounts (1)
∑ Quantities (10)
📅 Dates (1)
☰ Categorical
Other (2)
🔗 Relations (16)

Column Name	Description
SSOUR	Statistic(s) origin
VRSIO	Version number in the information structure
SPMON	Period to analyze - month
SPTAG	Period to analyze - current date
SPWOC	Period to analyze - week
SPBUP	Period to analyze - posting period
UNSYS	Unit System
SWERK FK	Maintenance Plant
EQTYP FK	Equipment category
EQART FK	Type of Technical Object
IWERK FK	Maintenance Planning Plant
HERST	Manufacturer of Asset
TYPBZ	Manufacturer model number
BAUJJ	Year of construction
EQUNR FK	Equipment Number

Column Name	Description
💲 Currency Key (WAERS):
IAKOSIST	Total(actual) maintenance costs

Column Name	Description
📏 PMIS: Unit Field for Distance Covered (DUNIT):
IAMENDISTT	PMIS: Quantity Key Figure for Reserved Trip Segment
📏 PMIS: Unit Field for Operating Hours (TUNIT):
IAMENOPHRS	PMIS: Quantity Key Figure for Operating Hours
📏 PMIS: Unit Field for Fuel Volumes (FUNIT):
IAMENFLVOL	PMIS: Fuel Volume Quantity Key Figure
📏 PMIS: Unit Field for Volume Mass (MUNIT):
IAMENFLMSS	PMIS: Fuel Mass Quantity Key Figure
📏 PMIS: Unit Field for Fuel Consumption per Route (FDUNIT):
IAFUELDIST	PMIS: Fuel Consumption According to Distance Covered
📏 PMIS: Unit for Fuel Consumption per Hour of Operation (FTUNIT):
IAFUELTIME	PMIS: Fuel Consumption According to Working Hours
📏 PMIS: Unit Field for Fuel Mass per Route (MDUNIT):
IAMASSDIST	PMIS: Fuel Mass According to Distance Covered
📏 PMIS: Unit Field for Fuel Mass per Operating Hour (MTUNIT):
IAMASSTIME	PMIS: Fuel Mass According to Working Hours
📏 PMIS: Unit for Actual Costs per Reserved Route (CDUNIT):
IATTLCDIST	PMIS: Total Actual Costs per Reserved Route
📏 PMIS: Unit for Actual Costs per Operating Hour (CTUNIT):
IATTLCOPTM	PMIS: Total Actual Costs per Operating Hour

Column Name	Description
SPTAG	Period to analyze - current date

Column Name	Description

Column Name	Description	Domain name
PERIV	Fiscal Year Variant	PERIV
VWDAT	Pointer to administrative data	VWDAT

Master Data Relations	Join Conditions
PMIS: Unit for Actual Costs per Reserved Route Client PMIS: Unit for Actual Costs per Reserved Route	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.CDUNIT == T006.MSEHI`
PMIS: Unit for Actual Costs per Operating Hour Client PMIS: Unit for Actual Costs per Operating Hour	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.CTUNIT == T006.MSEHI`
PMIS: Unit Field for Distance Covered Client PMIS: Unit Field for Distance Covered	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.DUNIT == T006.MSEHI`
Type of Technical Object Client Type of Technical Object	`0PM_FLEET.MANDT == T370K.MANDT` `0PM_FLEET.EQART == T370K.EQART`
Equipment category Client Equipment category	`0PM_FLEET.MANDT == T370T.MANDT` `0PM_FLEET.EQTYP == T370T.EQTYP`
Equipment Number Client Equipment Number	`0PM_FLEET.MANDT == EQUI.MANDT` `0PM_FLEET.EQUNR == EQUI.EQUNR`
PMIS: Unit Field for Fuel Consumption per Route Client PMIS: Unit Field for Fuel Consumption per Route	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.FDUNIT == T006.MSEHI`
PMIS: Unit for Fuel Consumption per Hour of Operation Client PMIS: Unit for Fuel Consumption per Hour of Operation	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.FTUNIT == T006.MSEHI`
PMIS: Unit Field for Fuel Volumes Client PMIS: Unit Field for Fuel Volumes	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.FUNIT == T006.MSEHI`
PMIS: Unit Field for Fuel Mass per Route Client PMIS: Unit Field for Fuel Mass per Route	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.MDUNIT == T006.MSEHI`
PMIS: Unit Field for Fuel Mass per Operating Hour Client PMIS: Unit Field for Fuel Mass per Operating Hour	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.MTUNIT == T006.MSEHI`
PMIS: Unit Field for Volume Mass Client PMIS: Unit Field for Volume Mass	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.MUNIT == T006.MSEHI`
Maintenance Plant Client Maintenance Plant	`0PM_FLEET.MANDT == T001W.MANDT` `0PM_FLEET.SWERK == T001W.WERKS`
PMIS: Unit Field for Operating Hours Client PMIS: Unit Field for Operating Hours	`0PM_FLEET.MANDT == T006.MANDT` `0PM_FLEET.TUNIT == T006.MSEHI`
Currency Key Client Currency Key	`0PM_FLEET.MANDT == TCURC.MANDT` `0PM_FLEET.WAERS == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Maintenance Planning Plant Client Maintenance Planning Plant	`0PM_FLEET.MANDT == T399I.MANDT` `0PM_FLEET.IWERK == T399I.IWERK`