OIGSS

TD Shipment Stages | #transactional | Component: Transportation and Distribution

🔑 Keys (3)
💰 Amounts
∑ Quantities (3)
📅 Dates (4)
☰ Categorical (10)
Other (11)
🔗 Relations (22)

Column Name	Description
CLIENT FK	Client
SHNUMBER FK	TD shipment number
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

Column Name	Description
CRE_DATE	Date on which the record was created
CRE_TIME	Entry time
CHA_DATE	Last Changed On
CHA_TIME	Time last change was made

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
CONT_DG	Indicator: Section contains dangerous goods	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

Master Data Relations	Join Conditions
Client	`OIGSS.CLIENT == T000.MANDT`
Departure Point Departure Point Client	`OIGSS.KNOTA == TVKN.KNOTE` `OIGSS.CLIENT == TVKN.MANDT`
Destination point Destination point Client	`OIGSS.KNOTZ == TVKN.KNOTE` `OIGSS.CLIENT == TVKN.MANDT`
Point of departure: Customer's unloading point Departure point: Customer Client Point of departure: Customer's unloading point	`OIGSS.KUNNA == KNVA.KUNNR` `OIGSS.CLIENT == KNVA.MANDT` `OIGSS.KUNABLA == KNVA.ABLAD`
Destination: Customer's unloading point Departure point: Customer Client Destination: Customer's unloading point	`OIGSS.KUNNA == KNVA.KUNNR` `OIGSS.CLIENT == KNVA.MANDT` `OIGSS.KUNABLZ == KNVA.ABLAD`
Departure point: Customer	`OIGSS.CLIENT == KNA1.MANDT` `OIGSS.KUNNA == KNA1.KUNNR`
Customer number for destination point	`OIGSS.CLIENT == KNA1.MANDT` `OIGSS.KUNNZ == KNA1.KUNNR`
Departure point: Storage location in plant Departure point: Storage location in plant Client Plant at point of departure	`OIGSS.LGORTA == T001L.LGORT` `OIGSS.CLIENT == T001L.MANDT` `OIGSS.WERKA == T001L.WERKS`
Destination: Storage location in plant Destination: Storage location in plant Client Plant at point of departure	`OIGSS.LGORTZ == T001L.LGORT` `OIGSS.CLIENT == T001L.MANDT` `OIGSS.WERKA == T001L.WERKS`
Vendor number of departure point	`OIGSS.CLIENT == LFA1.MANDT` `OIGSS.LIFNA == LFA1.LIFNR`
Vendor number of destination point	`OIGSS.CLIENT == LFA1.MANDT` `OIGSS.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	`OIGSS.CLIENT == TVLA.MANDT` `OIGSS.VSTEL == TVLA.VSTEL` `OIGSS.LSTEL == TVLA.LSTEL`
Destination: Loading point at shipping point Shipping point at point of departure Destination: Loading point at shipping point	`OIGSS.CLIENT == TVLA.MANDT` `OIGSS.VSTEL == TVLA.VSTEL` `OIGSS.LSTEZ == TVLA.LSTEL`
Route for shipment stage	`OIGSS.CLIENT == TVRO.MANDT` `OIGSS.ROUTE == TVRO.ROUTE`
Pricing procedure in stage of shipment ? Pricing procedure in stage of shipment ?	`OIGSS.CLIENT == T683.MANDT` `OIGSS.[column in domain "KAPPL"] == T683.KAPPL` `OIGSS.SKALSM == T683.KALSM` `OIGSS.[column in domain "KVEWE"] == T683.KVEWE`
Number of forwarding agent in the shipment stage	`OIGSS.CLIENT == LFA1.MANDT` `OIGSS.TDLNR == LFA1.LIFNR`
Shipping type for shipment stage Shipping type for shipment stage Client	`OIGSS.VSART == T173.VSART` `OIGSS.CLIENT == T173.MANDT`
Shipping point at point of departure	`OIGSS.CLIENT == TVST.MANDT` `OIGSS.VSTEL == TVST.VSTEL`
Shipping point at destination	`OIGSS.CLIENT == TVST.MANDT` `OIGSS.VSTEZ == TVST.VSTEL`
Plant at point of departure	`OIGSS.CLIENT == T001W.MANDT` `OIGSS.WERKA == T001W.WERKS`
Plant at destination point	`OIGSS.CLIENT == T001W.MANDT` `OIGSS.WERKZ == T001W.WERKS`