S414 SAP table for – SSR DTF statistics

Here we would like to draw your attention to S414 table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). S414 is a SAP standard transp table used for storing SSR DTF statistics related data in SAP. It comes under the package OIR_E.

SAP S414 table

Table S414 technical data

TableS414
Data storingSSR DTF statistics
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_E
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S414 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in S414 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SSOUR : Statistic(s) origin
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VRSIO : Version number in the information structure
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • SPMON : Period to analyze – month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SPTAG : Period to analyze – current date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPWOC : Period to analyze – week
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SPBUP : Period to analyze – posting period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SSR_CCINS : SSR PC: Payment card type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • VRKME_01 : Sales unit
    Its a key field. Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • WAERS_02 : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • CHOBJ : SSR PC: Clearing house
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • STYP : Service type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PERIV : Fiscal Year Variant
    Its data type is CHAR (Character String) with field length 2
  • VWDAT : Pointer to administrative data
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VRKME : Sales unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • NUMHDR : Number of DTF transaction headers
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NUMITM : Number of DTF transaction items
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BRTWR : SSR PC: Gross value
    Its data type is CURR (Currency Field) with field length 13
  • MENGE : SSR PC: Quantity sold at the business location
    Its data type is QUAN (Quantity field) with field length 13
  • OCFEE : SSR PC: Fee paid by oil company to clearing house
    Its data type is CURR (Currency Field) with field length 11
  • DEFEE : SSR PC: Participation fee of the service station partner
    Its data type is CURR (Currency Field) with field length 11
  • NUMHDR_FEE : Number of DTF transaction headers
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NUMITM_FEE : Number of DTF transaction items
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CHDISC : SSR PC: Discount received from the clearing house/FCC
    Its data type is CURR (Currency Field) with field length 11