S414 SAP (SSR DTF statistics) Table details
Dictionary Type: Table
Description: SSR DTF statistics
Description: SSR DTF statistics
Table field list including key, data, relationships and ABAP select examples
S414 is a standard SAP Table which is used to store SSR DTF statistics data and is available within R/3 SAP systems depending on the version and release level.
The S414 table consists of various fields, each holding specific information or linking keys about SSR DTF statistics data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S414 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | OIFSPBL | ALPHA | OIF_PBLNR | OI0 | OIFB |
| SSR_CCINS | SSR PC: Payment card type | OIRE_CCINS | CHAR | 4 | OIREPCTYP | OIRE_CCINS | OIRE_CCINS | ||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| VRKME_01 | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| WAERS_02 | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| CHOBJ | SSR PC: Clearing house | OIRE_CHOBJ | CHAR | 6 | OIRECH | OIRE_CHOBJ | |||
| STYP | Service type | OIRA_STYP | CHAR | 4 | OIRASTYP | OIRA_STYP | OIR_ST | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| NUMHDR | Number of DTF transaction headers | OIRE_NUMHEAD | INT4 | 10 | OIRE_NUMHEAD | ||||
| NUMITM | Number of DTF transaction items | OIRE_NUMITEM | INT4 | 10 | OIRE_NUMHEAD | ||||
| BRTWR | SSR PC: Gross value | OIRE_BRTWR | CURR | 13(2) | WERTV7 | ||||
| MENGE | SSR PC: Quantity sold at the business location | OIRE_MENGE | QUAN | 13(3) | MENG13V | ||||
| OCFEE | SSR PC: Fee paid by oil company to clearing house | OIRE_OCFEE | CURR | 11(2) | WERTV6 | ||||
| DEFEE | SSR PC: Participation fee of the service station partner | OIRE_DEFEE | CURR | 11(2) | WERTV6 | ||||
| NUMHDR_FEE | Number of DTF transaction headers | OIRE_NUMHEAD | INT4 | 10 | OIRE_NUMHEAD | ||||
| NUMITM_FEE | Number of DTF transaction items | OIRE_NUMITEM | INT4 | 10 | OIRE_NUMHEAD | ||||
| CHDISC | SSR PC: Discount received from the clearing house/FCC | OIRE_CHDISC | CURR | 11(2) | WERTV6 |
| Key field | Non-key field |
How do I retrieve data from SAP table S414 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S414 to SELECT all data from the tableDATA: WA_S414 TYPE S414.
SELECT SINGLE *
FROM S414
INTO CORRESPONDING FIELDS OF WA_S414
WHERE...
How to access SAP table S414
Within an ECC or HANA version of SAP you can also view further information about S414 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects