OIJ_STAGES SAP table for – TSW (&TD) Shipment Stages

Here we would like to draw your attention to OIJ_STAGES 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). OIJ_STAGES is a SAP standard transp table used for storing TSW (&TD) Shipment Stages related data in SAP. It comes under the package OIJ.

SAP OIJ_STAGES table

Table OIJ_STAGES technical data

TableOIJ_STAGES
Data storingTSW (&TD) Shipment Stages
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • STAGES_ID : Stages ID
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • TSNUM : Stage of transport number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : TSW / TD Shipment stages
  • TSTYP : Stage category
    Its data type is CHAR (Character String) with field length 1
  • TSRFO : Stage of transport sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VEH_NR : Vehicle Sequence Number in Shipment
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ELUPD : Change Indicator
    Its data type is CHAR (Character String) with field length 1
  • CRE_NAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • CRE_DATE : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRE_TIME : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHA_NAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • CHA_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHA_TIME : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ROUTE : Route for shipment stage
    Its data type is CHAR (Character String) with field length 6
  • VSART : Shipping type for shipment stage
    Its data type is CHAR (Character String) with field length 2
  • LAUFK : Leg indicator for shipment stage
    Its data type is CHAR (Character String) with field length 1
  • ADRNA : Departure point: Address
    Its data type is CHAR (Character String) with field length 10
  • KNOTA : Departure Point
    Its data type is CHAR (Character String) with field length 10
  • VSTEL : Shipping point at point of departure
    Its data type is CHAR (Character String) with field length 4
  • LSTEL : Point of departure: Loading point at shipping point
    Its data type is CHAR (Character String) with field length 2
  • WERKA : Plant at point of departure
    Its data type is CHAR (Character String) with field length 4
  • LGORTA : Departure point: Storage location in plant
    Its data type is CHAR (Character String) with field length 4
  • KUNNA : Departure point: Customer
    Its data type is CHAR (Character String) with field length 10
  • LIFNA : Vendor number of departure point
    Its data type is CHAR (Character String) with field length 10
  • ADRNZ : Destination address
    Its data type is CHAR (Character String) with field length 10
  • KNOTZ : Destination point
    Its data type is CHAR (Character String) with field length 10
  • VSTEZ : Shipping point at destination
    Its data type is CHAR (Character String) with field length 4
  • LSTEZ : Destination: Loading point at shipping point
    Its data type is CHAR (Character String) with field length 2
  • WERKZ : Plant at destination point
    Its data type is CHAR (Character String) with field length 4
  • LGORTZ : Destination: Storage location in plant
    Its data type is CHAR (Character String) with field length 4
  • KUNNZ : Customer number for destination point
    Its data type is CHAR (Character String) with field length 10
  • LIFNZ : Vendor number of destination point
    Its data type is CHAR (Character String) with field length 10
  • TDLNR : Number of forwarding agent in the shipment stage
    Its data type is CHAR (Character String) with field length 10
  • DISTZ : Distance
    Its data type is QUAN (Quantity field) with field length 13
  • MEDST : Unit of measure for distance
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OIG_GESZTD : Total time for stage
    Its data type is QUAN (Quantity field) with field length 13
  • OIG_FAHZTD : Total travel time for stage
    Its data type is QUAN (Quantity field) with field length 13
  • MEIZT : Unit of measure for travelling times
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ADRKNZA : Point of departure: Origin indicator of address
    Its data type is CHAR (Character String) with field length 1
  • KUNABLA : Point of departure: Customer’s unloading point
    Its data type is CHAR (Character String) with field length 25
  • ADRKNZZ : Destination: Origin indicator of address
    Its data type is CHAR (Character String) with field length 1
  • KUNABLZ : Destination: Customer’s unloading point
    Its data type is CHAR (Character String) with field length 25
  • FRKRL : Shipment costs relevance
    Its data type is CHAR (Character String) with field length 1
  • SKALSM : Pricing procedure in stage of shipment
    Its data type is CHAR (Character String) with field length 6
  • FBSTA : Status of shipment costs calculation
    Its data type is CHAR (Character String) with field length 1
  • ARSTA : Status of shipment costs settlement
    Its data type is CHAR (Character String) with field length 1
  • VEH_IND : TD-F: Vehicle stage indicator with first and last node
    Its data type is CHAR (Character String) with field length 1
  • CARR_ROUT : TD-F carrier is copied from route / stage table
    Its data type is CHAR (Character String) with field length 1
  • GESZTD : TD Planned total time for stage (in days)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • FAHZTD : TD – planned duration for stage (in hours:minutes)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GESZTDA : TD – actual total time for shipment stage (in days)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • FAHZTDA : TD – actual duration for shipment stage (in hours:minutes)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • VEL_AVG : Average Velocity
    Its data type is QUAN (Quantity field) with field length 13
  • VEL_UOM : Velocity UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VEL_UOMT : Velocity – Time
    Its data type is UNIT (Unit key for a Quantity field) with field length 3