SAP ABAP Table S414BIW2 (S414BIW2 * SSR DTF statistics)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S414BIW2   Table Relationship Diagram
Short Description S414BIW2 * SSR DTF statistics    
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 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
9 PBLNR OIF_PBLNR OIF_PBLNR CHAR 10   0   Business location identifier (IS-Oil MRN) OIFSPBL
10 SSR_CCINS OIRE_CCINS OIRE_CCINS CHAR 4   0   SSR PC: Payment card type OIREPCTYP
11 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
12 VRKME_01 VRKME MEINS UNIT 3   0   Sales unit T006
13 WAERS_02 WAERS WAERS CUKY 5   0   Currency Key TCURC
14 CHOBJ OIRE_CHOBJ OIRE_CHOBJ CHAR 6   0   SSR PC: Clearing house OIRECH
15 STYP OIRA_STYP OIRA_STYP CHAR 4   0   Service type OIRASTYP
16 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
17 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
18 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
19 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
20 NUMHDR OIRE_NUMHEAD OIRE_NUMHEAD INT4 10   0   Number of DTF transaction headers  
21 NUMITM OIRE_NUMITEM OIRE_NUMHEAD INT4 10   0   Number of DTF transaction items  
22 BRTWR OIRE_BRTWR WERTV7 CURR 13   2   SSR PC: Gross value  
23 MENGE OIRE_MENGE MENG13V QUAN 13   3   SSR PC: Quantity sold at the business location  
24 OCFEE OIRE_OCFEE WERTV6 CURR 11   2   SSR PC: Fee paid by oil company to clearing house  
25 DEFEE OIRE_DEFEE WERTV6 CURR 11   2   SSR PC: Participation fee of the service station partner  
26 NUMHDR_FEE OIRE_NUMHEAD OIRE_NUMHEAD INT4 10   0   Number of DTF transaction headers  
27 NUMITM_FEE OIRE_NUMITEM OIRE_NUMHEAD INT4 10   0   Number of DTF transaction items  
28 CHDISC OIRE_CHDISC WERTV6 CURR 11   2   SSR PC: Discount received from the clearing house/FCC  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S414BIW2 BUKRS T001 BUKRS KEY    
2 S414BIW2 CHOBJ OIRECH CHOBJ KEY    
3 S414BIW2 MANDT T000 MANDT KEY    
4 S414BIW2 MATNR MARA MATNR KEY    
5 S414BIW2 PBLNR OIFSPBL PBLNR KEY    
6 S414BIW2 SSR_CCINS OIREPCTYP SSR_CCINS KEY    
7 S414BIW2 STYP OIRASTYP STYP KEY    
8 S414BIW2 VRKME T006 MSEHI    
9 S414BIW2 VRKME_01 T006 MSEHI KEY    
10 S414BIW2 WAERS TCURC WAERS    
11 S414BIW2 WAERS_02 TCURC WAERS KEY    
History
Last changed by/on SAP  20050224 
SAP Release Created in 472