SAP ABAP Table ROIJ_STAGESIO (TSW (&TD) Stages IO)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_STAGESIO	Table Relationship Diagram
Short Description	TSW (&TD) Stages IO

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	STAGES_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
2	TSNUM	☐	TSNUM	TSNUM	NUMC	4	0	Stage of transport number	*
3	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
4	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
5	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
6	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
7	DESCNODEA	☐	BEZEI30	TEXT30	CHAR	30	0	Description
8	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
9	DESCNODEZ	☐	BEZEI30	TEXT30	CHAR	30	0	Description
10	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
11	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
12	GESZTD	☐	OIGGESZTDP	TSTRDURAG	DEC	11	0	TD Planned total time for stage (in days)
13	FAHZTD	☐	OIGEFFZTDP	TSTRDURAN	DEC	11	0	TD - planned duration for stage (in hours:minutes)
14	VEL_AVG	☐	OIJ_VEL_AVG	MENG13	QUAN	13	3	Average Velocity
15	VEL_UOM	☐	OIJ_VEL_UOM	MEINS	UNIT	3	0	Velocity UoM	T006
16	VEL_UOMT	☐	OIJ_VEL_UOMT	MEINS	UNIT	3	0	Velocity - Time	T006
17	GESZTDA	☐	OIGGESZTDA	TSTRDURAG	DEC	11	0	TD - actual total time for shipment stage (in days)
18	FAHZTDA	☐	OIGEFFZTDA	TSTRDURAN	DEC	11	0	TD - actual duration for shipment stage (in hours:minutes)
19	CRE_NAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	CRE_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	CRE_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
22	CHA_NAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	CHA_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	CHA_TIME	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
25	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
26	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	*
27	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	*
28	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	*
29	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	*
30	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	*
31	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	*
32	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
33	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	*
34	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	*
35	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	*
36	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	*
37	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	*
38	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	*
39	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
40	VEH_IND	☐	OIG_VEHIND	OIG_VEHIND	CHAR	1	0	TD-F: Vehicle stage indicator with first and last node
41	CONS_ICON	☐	OIJ_STAGE_CONSISTENT_ICON	ICON	CHAR	4	0	Icon for Stage consistency Flag	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_STAGESIO	KNOTA	TVKN	KNOTE
2	ROIJ_STAGESIO	KNOTZ	TVKN	KNOTE
3	ROIJ_STAGESIO	MEDST	T006	MSEHI
4	ROIJ_STAGESIO	VEL_UOM	T006	MSEHI
5	ROIJ_STAGESIO	VEL_UOMT	T006	MSEHI
6	ROIJ_STAGESIO	VSART	T173	VSART

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C