S412 SAP table for – SSR Margin Report

Here we would like to draw your attention to S412 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). S412 is a SAP standard transp table used for storing SSR Margin Report related data in SAP. It comes under the package OIR_I.

SAP S412 table

Table S412 technical data

TableS412
Data storingSSR Margin Report
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_I
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S412 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 S412 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
  • OIRIPBLNR : Business location identifier (IS-Oil MRN)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • OISTYP : 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
  • STWAE : Statistics currency
    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
  • BASME : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OIRCOMMNET : SSR – Location net commission
    Its data type is CURR (Currency Field) with field length 15
  • OIRCOMMVAT : SSR – Location vat on commission
    Its data type is CURR (Currency Field) with field length 15
  • OIRPFEENET : SSR – Location net participation fee
    Its data type is CURR (Currency Field) with field length 15
  • OIRPFEEVAT : SSR – Location net participation vat
    Its data type is CURR (Currency Field) with field length 15
  • OIRFUGR : SSR-Location fuel sales gross
    Its data type is CURR (Currency Field) with field length 15
  • OIREBV : EBV cost
    Its data type is CURR (Currency Field) with field length 15
  • OIRFCFEES : SSR Fleet Card processing fees
    Its data type is CURR (Currency Field) with field length 15
  • OIRCHFEES : SSR Clearing house processing fees
    Its data type is CURR (Currency Field) with field length 15
  • OIRFREIGHT : Freight cost
    Its data type is CURR (Currency Field) with field length 15
  • OIRPURPR : Purchase cost of material
    Its data type is CURR (Currency Field) with field length 15
  • OIRFUNET : Fuel sales net
    Its data type is CURR (Currency Field) with field length 15
  • OIRFUVAT : Fuel sales vat
    Its data type is CURR (Currency Field) with field length 15
  • MCUPD : Indicator whether statistical record was updated
    Its data type is CHAR (Character String) with field length 1
  • FKIMG : Actual billed quantity
    Its data type is QUAN (Quantity field) with field length 13
  • FKLMG : Billing quantity in stockkeeping unit
    Its data type is QUAN (Quantity field) with field length 13
  • WAERK : SD document currency
    Its data type is CUKY (Currency key for a currency field) with field length 5