S036BIW1 SAP table for – S036BIW1 * LIS: Exchange balance ‘Lifts/Receipts’ (IS-Oil EX

Here we would like to draw your attention to S036BIW1 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). S036BIW1 is a SAP standard transp table used for storing S036BIW1 * LIS: Exchange balance ‘Lifts/Receipts’ (IS-Oil EX related data in SAP. It comes under the package OI0_BW.

SAP S036BIW1 table

Table S036BIW1 technical data

TableS036BIW1
Data storingS036BIW1 * LIS: Exchange balance ‘Lifts/Receipts’ (IS-Oil EX
ModuleIS-OIL
Sub ModuleIS-OIL-DS
SAP PackageOI0_BW
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S036BIW1 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 S036BIW1 table.

  • .INCLUDE : Help structure: Key of table S036
    Its a key field.
  • 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 : Calendar year / month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SPTAG : Calendar day
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPWOC : Calendar year / 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
  • MATREF : Material group reference for exchange balance reporting
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • WERKS : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • EXGPTR : Exchange partner (vendor number)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • UPENR : Constant to identify logical inventory adjustment
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • EXGTYP : Exchange type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • EXGNUM : Exchange agreement number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MATINEX : Posting rules for material
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OIBASPROD : Base product 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
  • BASME : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RECPT : Exchange receipts
    Its data type is QUAN (Quantity field) with field length 15
  • LIFTS : Exchange deliveries
    Its data type is QUAN (Quantity field) with field length 15