OIJTSLOC SAP table for – OIL-TSW: transport system/location assignment table

Here we would like to draw your attention to OIJTSLOC 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). OIJTSLOC is a SAP standard transp table used for storing OIL-TSW: transport system/location assignment table related data in SAP. It comes under the package OIJ.

SAP OIJTSLOC table

Table OIJTSLOC technical data

TableOIJTSLOC
Data storingOIL-TSW: transport system/location assignment table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJTSLOC 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 OIJTSLOC 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
  • LOCNAM : Location name (used by system owner)
    Its data type is CHAR (Character String) with field length 60
  • TSLOCID : OIL-TSW: Transport system location ID
    Its data type is CHAR (Character String) with field length 10
  • TSLOCNAM : OIL-TSW: Name of location in transport system
    Its data type is CHAR (Character String) with field length 60
  • ODINDO : OIL-TSW: Location is origin flag
    Its data type is CHAR (Character String) with field length 1
  • ODINDD : OIL-TSW: Location destination flag
    Its data type is CHAR (Character String) with field length 1
  • CONSIND : OIL-TSW: Location bunker consumption dummy location flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW:Structure for Dimensions of Location Sequence Number
  • LOCID_PARENT : OIL-TSW: Parent Location of Bifurcation Branch
    Its data type is CHAR (Character String) with field length 10
  • BRANCH_NR : OIL-TSW: Number of Bifurcation Branch
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • BRANCH_SEQ : TSW: Sequence number
    Its data type is NUMC (Character String with Digits Only) with field length 5