S413 SAP table for – SSR – Monthly/Daily Loc.Inv.

Here we would like to draw your attention to S413 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). S413 is a SAP standard transp table used for storing SSR – Monthly/Daily Loc.Inv. related data in SAP. It comes under the package OIR_I.

SAP S413 table

Table S413 technical data

TableS413
Data storingSSR – Monthly/Daily Loc.Inv.
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_I
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S413 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 S413 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
  • PKUNRG : Payer
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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
  • 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
  • OIRTOTGR : SSR-Location total gros
    Its data type is CURR (Currency Field) with field length 15
  • OIRPYTCDGR : SSR – Location payment card gross
    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
  • OIRFLFUGR : SSR – Location fleet card gross fuel sales
    Its data type is CURR (Currency Field) with field length 15
  • OIRDOPVAT : SSR-Location fleet dealer owned products vat
    Its data type is CURR (Currency Field) with field length 15
  • OIRDOPGR : SSR-Location fleet dealer owned products gross
    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
  • OIRREDUCT : SSR-Location dealer daily claim reduction
    Its data type is CURR (Currency Field) with field length 15
  • FKIMG : Actual billed quantity
    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