S410BIW1 SAP table for – S410BIW1 * SIS: Business Location Statistics via ‘Ship-to’ (

Here we would like to draw your attention to S410BIW1 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). S410BIW1 is a SAP standard transp table used for storing S410BIW1 * SIS: Business Location Statistics via ‘Ship-to’ ( related data in SAP. It comes under the package OI0_BW.

SAP S410BIW1 table

Table S410BIW1 technical data

TableS410BIW1
Data storingS410BIW1 * SIS: Business Location Statistics via ‘Ship-to’ (
ModuleIS-OIL
Sub ModuleIS-OIL-DS
SAP PackageOI0_BW
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S410BIW1 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 S410BIW1 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
  • OIPBLP : Business location identifier (IS-Oil MRN)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • KUNNR : Ship-to party
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VKORG : Sales Organization
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • 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
  • BASME : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AENETWR : Net value of incoming orders
    Its data type is CURR (Currency Field) with field length 19
  • UMNETWR : Net value of invoiced sales
    Its data type is CURR (Currency Field) with field length 19
  • OAUWE : Open net value of orders
    Its data type is CURR (Currency Field) with field length 19
  • RENETWR : Net value of incoming returns
    Its data type is CURR (Currency Field) with field length 19
  • GUNETWR : Net value of credit memos
    Its data type is CURR (Currency Field) with field length 19
  • AEMENGE : Incoming orders quantity
    Its data type is QUAN (Quantity field) with field length 15
  • UMMENGE : Sales quantity
    Its data type is QUAN (Quantity field) with field length 15
  • OAUME : Open orders quantity in base unit of measure
    Its data type is QUAN (Quantity field) with field length 15
  • REMENGE : Returns Quantity
    Its data type is QUAN (Quantity field) with field length 15
  • GUMENGE : Credit memos quantity
    Its data type is QUAN (Quantity field) with field length 15
  • ANZAUPOS : Number of order items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ANZREPOS : No.of returns items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • AEWAVWR : Cost of incoming orders
    Its data type is CURR (Currency Field) with field length 19
  • UMWAVWR : Cost of invoiced sales
    Its data type is CURR (Currency Field) with field length 19
  • REWAVWR : Incoming returns: cost
    Its data type is CURR (Currency Field) with field length 19
  • GUWAVWR : Credit memos: cost
    Its data type is CURR (Currency Field) with field length 19
  • AEKZWI1 : Incoming orders: gross
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI1 : Invoiced sales: gross
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI1 : Incoming returns: gross
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI1 : Credit memos: gross
    Its data type is CURR (Currency Field) with field length 17
  • AEKZWI2 : Incoming orders: net 1
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI2 : Invoiced sales: net 1
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI2 : Incoming returns: net 1
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI2 : Credit memos: net 1
    Its data type is CURR (Currency Field) with field length 17
  • AEKZWI3 : Incoming orders: net 2
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI3 : Invoiced sales: net 2
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI3 : Incoming returns: net 2
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI3 : Credit memos: net 2
    Its data type is CURR (Currency Field) with field length 17
  • AEKZWI4 : Incoming orders: freight
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI4 : Invoice freight charges
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI4 : Incoming returns: freight
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI4 : Credit memos: freight
    Its data type is CURR (Currency Field) with field length 17
  • AEKZWI5 : Incoming orders: pricing subtotal 5
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI5 : Billing document: pricing subtotal 5
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI5 : Incoming returns: pricing subtotal 5
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI5 : Credit memos: pricing subtotal 5
    Its data type is CURR (Currency Field) with field length 17
  • AEKZWI6 : Incoming orders: pricing subtotal 6
    Its data type is CURR (Currency Field) with field length 17
  • UMKZWI6 : Billing document: pricing subtotal 6
    Its data type is CURR (Currency Field) with field length 17
  • REKZWI6 : Incoming returns: pricing subtotal 6
    Its data type is CURR (Currency Field) with field length 17
  • GUKZWI6 : Credit memos: pricing subtotal 6
    Its data type is CURR (Currency Field) with field length 17