SAP ABAP Table S114 (Fahrzeugverbrauchsanalyse)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-IS-REP (Application Component) Reporting
     ⤷ MCI (Package) R/3 appl. development: Plant Maintenance Information System
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S114   Table Relationship Diagram
Short Description Fahrzeugverbrauchsanalyse    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 UNSYS DUNSYS CHAR3 CHAR 3   0   Unit System  
9 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
10 EQTYP EQTYP EQTYP CHAR 1   0   Equipment Category T370T
11 EQART EQART EQART CHAR 10   0   Type of Technical Object T370K
12 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
13 HERST HERST TEXT30 CHAR 30   0   Manufacturer of asset  
14 TYPBZ TYPBZ TYPBZ CHAR 20   0   Manufacturer model number  
15 BAUJJ BAUJJ CJAHR CHAR 4   0   Year of construction  
16 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
17 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
18 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
19 DUNIT DDUNIT MEINS UNIT 3   0   PMIS: Unit Field for Distance Covered T006
20 TUNIT DTUNIT MEINS UNIT 3   0   PMIS: Unit Field for Operating Hours T006
21 FUNIT DFUNIT MEINS UNIT 3   0   PMIS: Unit Field for Fuel Volumes T006
22 MUNIT DMUNIT MEINS UNIT 3   0   PMIS: Unit Field for Volume Mass T006
23 FDUNIT DFDUNIT MEINS UNIT 3   0   PMIS: Unit Field for Fuel Consumption per Route T006
24 FTUNIT DFTUNIT MEINS UNIT 3   0   PMIS: Unit for Fuel Consumption per Hour of Operation T006
25 MDUNIT DMDUNIT MEINS UNIT 3   0   PMIS: Unit Field for Fuel Mass per Route T006
26 MTUNIT DMTUNIT MEINS UNIT 3   0   PMIS: Unit Field for Fuel Mass per Operating Hour T006
27 CDUNIT DCDUNIT MEINS UNIT 3   0   PMIS: Unit for Actual Costs per Reserved Route T006
28 CTUNIT DCTUNIT MEINS UNIT 3   0   PMIS: Unit for Actual Costs per Operating Hour T006
29 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
30 IAMENDISTT DMENDISTT MENGV15 QUAN 15   3   PMIS: Quantity Key Figure for Reserved Trip Segment  
31 IAMENOPHRS DMENOPHRS MENGV15 QUAN 15   3   PMIS: Quantity Key Figure for Operating Hours  
32 IAMENFLVOL DMENFLVOL MENGV15 QUAN 15   3   PMIS: Fuel Volume Quantity Key Figure  
33 IAMENFLMSS DMENFLMSS MENGV15 QUAN 15   3   PMIS: Fuel Mass Quantity Key Figure  
34 IAFUELDIST DFUELDIST MENGV15 QUAN 15   3   PMIS: Fuel Consumption According to Distance Covered  
35 IAFUELTIME DFUELTIME MENGV15 QUAN 15   3   PMIS: Fuel Consumption According to Working Hours  
36 IAMASSDIST DMASSDIST MENGV15 QUAN 15   3   PMIS: Fuel Mass According to Distance Covered  
37 IAMASSTIME DMASSTIME MENGV15 QUAN 15   3   PMIS: Fuel Mass According to Working Hours  
38 IATTLCDIST DTTLCOSTD MENGV15 QUAN 15   3   PMIS: Total Actual Costs per Reserved Route  
39 IATTLCOPTM DTTLCOSTT MENGV15 QUAN 15   3   PMIS: Total Actual Costs per Operating Hour  
40 IAKOSIST DGESKOSIST WERTV8 CURR 15   2   Total(actual) maintenance costs  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S114 CDUNIT T006 MSEHI    
2 S114 CTUNIT T006 MSEHI    
3 S114 DUNIT T006 MSEHI    
4 S114 EQART T370K EQART KEY    
5 S114 EQTYP T370T EQTYP KEY    
6 S114 EQUNR EQUI EQUNR KEY    
7 S114 FDUNIT T006 MSEHI    
8 S114 FTUNIT T006 MSEHI    
9 S114 FUNIT T006 MSEHI    
10 S114 IWERK T399I IWERK KEY    
11 S114 MANDT T000 MANDT KEY    
12 S114 MDUNIT T006 MSEHI    
13 S114 MTUNIT T006 MSEHI    
14 S114 MUNIT T006 MSEHI    
15 S114 SWERK T001W WERKS KEY    
16 S114 TUNIT T006 MSEHI    
17 S114 WAERS TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in 470