S414BIW1 - S414BIW1 * SSR DTF statistics
S414BIW1 * SSR DTF statistics information is stored in SAP table S414BIW1.
It is part of development package OI0_BW in software component IS-OIL-DS. This development package consists of objects that can be grouped under "Oil/BW Business Information Warehouse (extractors,..)".
It is part of development package OI0_BW in software component IS-OIL-DS. This development package consists of objects that can be grouped under "Oil/BW Business Information Warehouse (extractors,..)".
Fields for table S414BIW1
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| PBLNR | Business location identifier (IS-Oil MRN) | X | OIF_PBLNR | CHAR | 20 | OIFSPBL |
| SSR_CCINS | SSR PC: Payment card type | X | OIRE_CCINS | CHAR | 8 | OIREPCTYP |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| VRKME_01 | Sales unit | X | VRKME | UNIT | 6 | T006 |
| WAERS_02 | Currency Key | X | WAERS | CUKY | 10 | TCURC |
| CHOBJ | SSR PC: Clearing house | X | OIRE_CHOBJ | CHAR | 12 | OIRECH |
| STYP | Service type | X | OIRA_STYP | CHAR | 8 | OIRASTYP |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
| NUMHDR | Number of DTF transaction headers | OIRE_NUMHEAD | INT4 | 4 | ||
| NUMITM | Number of DTF transaction items | OIRE_NUMITEM | INT4 | 4 | ||
| BRTWR | SSR PC: Gross value | OIRE_BRTWR | CURR | 7 | ||
| MENGE | SSR PC: Quantity sold at the business location | OIRE_MENGE | QUAN | 7 | ||
| OCFEE | SSR PC: Fee paid by oil company to clearing house | OIRE_OCFEE | CURR | 6 | ||
| DEFEE | SSR PC: Participation fee of the service station partner | OIRE_DEFEE | CURR | 6 | ||
| NUMHDR_FEE | Number of DTF transaction headers | OIRE_NUMHEAD | INT4 | 4 | ||
| NUMITM_FEE | Number of DTF transaction items | OIRE_NUMITEM | INT4 | 4 | ||
| CHDISC | SSR PC: Discount received from the clearing house/FCC | OIRE_CHDISC | CURR | 6 |