OIJ_STAGES

TSW (&TD) Shipment Stages | #transactional | Component: Trader's and Scheduler's Workbench

🔑 Keys (3)
💰 Amounts
∑ Quantities (4)
📅 Dates (7)
☰ Categorical (9)
Other (15)
🔗 Relations (24)

Column Name	Description
CLIENT	Client
STAGES_ID	Stages ID
TSNUM	Stage of transport number

Column Name	Description

Column Name	Description
📏 Distance Unit of Measure (MEDST):
DISTZ	Distance
📏 Unit of measure for travelling times (MEIZT):
OIG_GESZTD	Total time for stage
OIG_FAHZTD	Total travel time for stage
📏 Velocity UoM (OIJTS.VEL_UOM):
VEL_AVG	Average Velocity

Column Name	Description
CRE_DATE	Date on which the record was created
CRE_TIME	Time of creation
CHA_DATE	Last Changed On
CHA_TIME	Time of day the record was changed
O_ETA	ETA AT Load Port
D_ETA	Estimated Time of Arrival (ETA) Destination Point
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
TSTYP	Stage category	Show values
ELUPD	Change Indicator	Show values
LAUFK	Leg indicator for shipment stage	Show values
ADRKNZA	Point of departure: Origin indicator of address	Show values
ADRKNZZ	Destination: Origin indicator of address	Show values
FRKRL	Shipment costs relevance	Show values
FBSTA	Status of shipment costs calculation	Show values
ARSTA	Status of shipment costs settlement	Show values
CARR_ROUT	TD-F carrier is copied from route / stage table	Show values

Column Name	Description	Domain name
TSRFO	Stage of transport sequence	TSRFO
VEH_NR	Vehicle Sequence Number in Shipment	OIG_VEHNR
CRE_NAME	Name of Person Responsible for Creating the Object	USNAM
CHA_NAME	Name of Person Who Changed Object	USNAM
ADRNA	Departure point: Address	ADRNR
ADRNZ	Destination address	ADRNR
VEH_IND	TD-F: Vehicle stage indicator with first and last node	OIG_VEHIND
GESZTD	TD Planned total time for stage (in days)	TSTRDURAG
FAHZTD	TD - planned duration for stage (in hours:minutes)	TSTRDURAN
GESZTDA	TD - actual total time for shipment stage (in days)	TSTRDURAG
FAHZTDA	TD - actual duration for shipment stage (in hours:minutes)	TSTRDURAN
FEU	TSW-Mining: Forty-foot Equivalent Units	OIJ02_FEU
TEU	TSW-Mining: Twenty Foot Equivalent Units	OIJ02_TEU
BFEU	TSW-Mining: Forty-foot Equivalent Units -booked	OIJ02_FEU
BTEU	TSW-Mining: Twenty Foot Equivalent Units booked	OIJ02_TEU

Master Data Relations	Join Conditions
Departure Point Departure Point Client	`OIJ_STAGES.KNOTA == TVKN.KNOTE` `OIJ_STAGES.CLIENT == TVKN.MANDT`
Destination point Destination point Client	`OIJ_STAGES.KNOTZ == TVKN.KNOTE` `OIJ_STAGES.CLIENT == TVKN.MANDT`
Point of departure: Customer's unloading point Departure point: Customer Client Point of departure: Customer's unloading point	`OIJ_STAGES.KUNNA == KNVA.KUNNR` `OIJ_STAGES.CLIENT == KNVA.MANDT` `OIJ_STAGES.KUNABLA == KNVA.ABLAD`
Destination: Customer's unloading point Departure point: Customer Client Destination: Customer's unloading point	`OIJ_STAGES.KUNNA == KNVA.KUNNR` `OIJ_STAGES.CLIENT == KNVA.MANDT` `OIJ_STAGES.KUNABLZ == KNVA.ABLAD`
Departure point: Customer	`OIJ_STAGES.CLIENT == KNA1.MANDT` `OIJ_STAGES.KUNNA == KNA1.KUNNR`
Customer number for destination point	`OIJ_STAGES.CLIENT == KNA1.MANDT` `OIJ_STAGES.KUNNZ == KNA1.KUNNR`
Departure point: Storage location in plant Departure point: Storage location in plant Client Plant at point of departure	`OIJ_STAGES.LGORTA == T001L.LGORT` `OIJ_STAGES.CLIENT == T001L.MANDT` `OIJ_STAGES.WERKA == T001L.WERKS`
Destination: Storage location in plant Destination: Storage location in plant Client Plant at point of departure	`OIJ_STAGES.LGORTZ == T001L.LGORT` `OIJ_STAGES.CLIENT == T001L.MANDT` `OIJ_STAGES.WERKA == T001L.WERKS`
Vendor number of departure point	`OIJ_STAGES.CLIENT == LFA1.MANDT` `OIJ_STAGES.LIFNA == LFA1.LIFNR`
Vendor number of destination point	`OIJ_STAGES.CLIENT == LFA1.MANDT` `OIJ_STAGES.LIFNZ == LFA1.LIFNR`
Point of departure: Loading point at shipping point Shipping point at point of departure Point of departure: Loading point at shipping point	`OIJ_STAGES.CLIENT == TVLA.MANDT` `OIJ_STAGES.VSTEL == TVLA.VSTEL` `OIJ_STAGES.LSTEL == TVLA.LSTEL`
Destination: Loading point at shipping point Shipping point at point of departure Destination: Loading point at shipping point	`OIJ_STAGES.CLIENT == TVLA.MANDT` `OIJ_STAGES.VSTEL == TVLA.VSTEL` `OIJ_STAGES.LSTEZ == TVLA.LSTEL`
Distance Unit of Measure	`OIJ_STAGES.CLIENT == T006.MANDT` `OIJ_STAGES.MEDST == T006.MSEHI`
Unit of measure for travelling times	`OIJ_STAGES.CLIENT == T006.MANDT` `OIJ_STAGES.MEIZT == T006.MSEHI`
Route for shipment stage	`OIJ_STAGES.CLIENT == TVRO.MANDT` `OIJ_STAGES.ROUTE == TVRO.ROUTE`
Pricing procedure in stage of shipment ? Pricing procedure in stage of shipment ?	`OIJ_STAGES.CLIENT == T683.MANDT` `OIJ_STAGES.[column in domain "KAPPL"] == T683.KAPPL` `OIJ_STAGES.SKALSM == T683.KALSM` `OIJ_STAGES.[column in domain "KVEWE"] == T683.KVEWE`
Number of forwarding agent in the shipment stage	`OIJ_STAGES.CLIENT == LFA1.MANDT` `OIJ_STAGES.TDLNR == LFA1.LIFNR`
Velocity UoM	`OIJ_STAGES.CLIENT == T006.MANDT` `OIJ_STAGES.VEL_UOM == T006.MSEHI`
Velocity - Time	`OIJ_STAGES.CLIENT == T006.MANDT` `OIJ_STAGES.VEL_UOMT == T006.MSEHI`
Shipping type for shipment stage Shipping type for shipment stage Client	`OIJ_STAGES.VSART == T173.VSART` `OIJ_STAGES.CLIENT == T173.MANDT`
Shipping point at point of departure	`OIJ_STAGES.CLIENT == TVST.MANDT` `OIJ_STAGES.VSTEL == TVST.VSTEL`
Shipping point at destination	`OIJ_STAGES.CLIENT == TVST.MANDT` `OIJ_STAGES.VSTEZ == TVST.VSTEL`
Plant at point of departure	`OIJ_STAGES.CLIENT == T001W.MANDT` `OIJ_STAGES.WERKA == T001W.WERKS`
Plant at destination point	`OIJ_STAGES.CLIENT == T001W.MANDT` `OIJ_STAGES.WERKZ == T001W.WERKS`