OIJPLANWL SAP table for – OIJ-TSW: Worklist entries for planning

Here we would like to draw your attention to OIJPLANWL 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). OIJPLANWL is a SAP standard transp table used for storing OIJ-TSW: Worklist entries for planning related data in SAP. It comes under the package OIJ.

SAP OIJPLANWL table

Table OIJPLANWL technical data

TableOIJPLANWL
Data storingOIJ-TSW: Worklist entries for planning
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TSYST : Transport system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    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
  • DATUM : Stock Projection item date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTSYST : Transport system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • PLOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SMATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • PDATUM : Stock Projection item date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WLINDX : OIL-TSW: Worklist item index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • WLITEM : TSW: Worklist item number
    Its data type is NUMC (Character String with Digits Only) with field length 10