OIJ_STAGES - TSW (&TD) Shipment Stages

TSW (&TD) Shipment Stages information is stored in SAP table OIJ_STAGES.
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".

Fields for table OIJ_STAGES

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
STAGES_ID	Stages ID	X	OIJ_STAGES_ID	CHAR	44
TSNUM	Stage of transport number	X	TSNUM	NUMC	8
.INCLUDE				OIG_STAGES	0
TSTYP	Stage category		TSTYP	CHAR	2
TSRFO	Stage of transport sequence		TSRFO	NUMC	8
VEH_NR	Vehicle Sequence Number in Shipment		OIG_VEHNR	NUMC	6	*
ELUPD	Change Indicator		ELUPD	CHAR	2
CRE_NAME	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
CRE_DATE	Date on which the record was created		ERDAT	DATS	16
CRE_TIME	Time of creation		OI0_ERTIM	TIMS	12
CHA_NAME	Name of Person Who Changed Object		AENAM	CHAR	24
CHA_DATE	Last Changed On		AEDAT	DATS	16
CHA_TIME	Time of day the record was changed		OI0_AETIM	TIMS	12
ROUTE	Route for shipment stage		ROUTES	CHAR	12	TVRO
VSART	Shipping type for shipment stage		VERSARTS	CHAR	4	T173
LAUFK	Leg indicator for shipment stage		LAUFS	CHAR	2
ADRNA	Departure point: Address		ADRNA	CHAR	20	*
KNOTA	Departure Point		KNOTA	CHAR	20	TVKN
VSTEL	Shipping point at point of departure		VSTELA	CHAR	8	TVST
LSTEL	Point of departure: Loading point at shipping point		LSTELA	CHAR	4	TVLA
WERKA	Plant at point of departure		WERKSA	CHAR	8	T001W
LGORTA	Departure point: Storage location in plant		LGORTA	CHAR	8	T001L
KUNNA	Departure point: Customer		KUNNA	CHAR	20	KNA1
LIFNA	Vendor number of departure point		LIFNA	CHAR	20	LFA1
ADRNZ	Destination address		ADRNZ	CHAR	20	*
KNOTZ	Destination point		KNOTZ	CHAR	20	TVKN
VSTEZ	Shipping point at destination		VSTELZ	CHAR	8	TVST
LSTEZ	Destination: Loading point at shipping point		LSTELZ	CHAR	4	TVLA
WERKZ	Plant at destination point		WERKSZ	CHAR	8	T001W
LGORTZ	Destination: Storage location in plant		LGORTZ	CHAR	8	T001L
KUNNZ	Customer number for destination point		KUNNZ	CHAR	20	KNA1
LIFNZ	Vendor number of destination point		LIFNZ	CHAR	20	LFA1
TDLNR	Number of forwarding agent in the shipment stage		TDLNRS	CHAR	20	LFA1
DISTZ	Distance		DISTZ	QUAN	7
MEDST	Distance Unit of Measure		MEDST	UNIT	6	T006
OIG_GESZTD	Total time for stage		OIG_GESZTD	QUAN	7
OIG_FAHZTD	Total travel time for stage		OIG_FAHZTD	QUAN	7
MEIZT	Unit of measure for travelling times		MEIZT	UNIT	6	T006
ADRKNZA	Point of departure: Origin indicator of address		ADRKNZA	CHAR	2
KUNABLA	Point of departure: Customer's unloading point		KUNABLA	CHAR	50	KNVA
ADRKNZZ	Destination: Origin indicator of address		ADRKNZZ	CHAR	2
KUNABLZ	Destination: Customer's unloading point		KUNABLZ	CHAR	50	KNVA
FRKRL	Shipment costs relevance		FRKRL	CHAR	2
SKALSM	Pricing procedure in stage of shipment		KALSM_TRAB	CHAR	12	T683
FBSTA	Status of shipment costs calculation		FBSTA	CHAR	2
ARSTA	Status of shipment costs settlement		ARSTA	CHAR	2
VEH_IND	TD-F: Vehicle stage indicator with first and last node		OIG_VEHIND	CHAR	2
CARR_ROUT	TD-F carrier is copied from route / stage table		OIG_CRROUT	CHAR	2
GESZTD	TD Planned total time for stage (in days)		OIGGESZTDP	DEC	6
FAHZTD	TD - planned duration for stage (in hours:minutes)		OIGEFFZTDP	DEC	6
GESZTDA	TD - actual total time for shipment stage (in days)		OIGGESZTDA	DEC	6
FAHZTDA	TD - actual duration for shipment stage (in hours:minutes)		OIGEFFZTDA	DEC	6
VEL_AVG	Average Velocity		OIJ_VEL_AVG	QUAN	7
VEL_UOM	Velocity UoM		OIJ_VEL_UOM	UNIT	6	T006
VEL_UOMT	Velocity - Time		OIJ_VEL_UOMT	UNIT	6	T006
.INCLUDE				ROIJ02FRGHT_STAGES	0
O_ETA	ETA AT Load Port		OIJ02_LP1_ETA	DATS	16
D_ETA	Estimated Time of Arrival (ETA) Destination Point		OIJ02_DP1_ETA	DATS	16
FEU	TSW-Mining: Forty-foot Equivalent Units		OIJ02_FEU	DEC	3
TEU	TSW-Mining: Twenty Foot Equivalent Units		OIJ02_TEU	DEC	3
BFEU	TSW-Mining: Forty-foot Equivalent Units -booked		OIJ02_BFEU	DEC	3
BTEU	TSW-Mining: Twenty Foot Equivalent Units booked		OIJ02_BTEU	DEC	3
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16