SAP ABAP Table ROIJ_TRANS_AVAIL (Transport Avails)

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_TRANS_AVAIL	Table Relationship Diagram
Short Description	Transport Avails

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	.INCLUDE	☐				0	0	Vehicle Availability Structure
2	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
3	PRNOMTK	☐	OIJ_PRNMTK	OIJ_NOMTK	CHAR	20	0	Previous Nomination Technical Key	*
4	PRNOMNR	☐	OIJ_PRNMNR	OIJ_NOMNR	CHAR	20	0	Previous Nomination Number
5	PRPOT_DEP_DATE	☐	OIJ_PRPOT_DEP_DATE	OIJ_POT_DEP_DATE	DATS	8	0	Potential Departure Date of the Previous Nom. Of TD-Vehicle
6	PRLOCID	☐	OIJ_PRLOCID	OIJ_LOCID	CHAR	10	0	Previous Location ID	*
7	POT_DEP_DATE	☐	OIJ_POT_DEP_DATE	OIJ_POT_DEP_DATE	DATS	8	0	Potential Departure Date of TD-Vehicle
8	CRNOMTK	☐	OIJ_CRNMTK	OIJ_NOMTK	CHAR	20	0	Current Nominations Technical Key	*
9	CRNOMNR	☐	OIJ_CRNMNR	OIJ_NOMNR	CHAR	20	0	Current Nomination Number
10	CRLOCID	☐	OIJ_CRLOCID	OIJ_LOCID	CHAR	10	0	Current Location ID	*
11	CRLOC_ATTR	☐	OIJ_CRLOCATTR	OIJ_EL_LOATT	CHAR	1	0	Current Location Attribute
12	CRNMFRDT	☐	OIJ_CURR_NOM_FR_DT	OIJ_CURR_NOM_FR_DT	DATS	8	0	From Date of Current Nomination
13	CRNMFRTM	☐	OIJ_CRNM_FRTM	UZEIT	TIMS	6	0	From Time of Current Nomination
14	CRNMTODT	☐	OIJ_CURR_NOM_TO_DT	OIJ_CURR_NOM_TO_DT	DATS	8	0	To Date of Current Nomination
15	CRNMTOTM	☐	OIJ_CRNM_TOTM	UZEIT	TIMS	6	0	To Time of Current Nomination
16	NXLOCID	☐	OIJ_NXLOCID	OIJ_LOCID	CHAR	10	0	Next Location ID	*
17	NXLOC_ATTR	☐	OIJ_NXLOCATTR	OIJ_EL_LOATT	CHAR	1	0	Next Location Attribute
18	NXARDT	☐	OIJ_ARR_DATE	OIJ_ARR_DATE	DATS	8	0	TD-Vehicle Arrival Date
19	NXNOMTK	☐	OIJ_NXNMTK	OIJ_NOMTK	CHAR	20	0	Future Nomination Technical Key	*
20	NXNOMNR	☐	OIJ_NXNMNR	OIJ_NOMNR	CHAR	20	0	Next Nomination Number
21	VBELN	☐	OIJ_EL_CPNO	VBELN	CHAR	10	0	Freight contract number	*
22	VBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
23	POSNR	☐	OIJ_EL_POSNR	POSNR	NUMC	6	0	Contract item number	*
24	SINGLE_VOY	☐	OIJ_EL_SV	XFELD	CHAR	1	0	Single voyage flag
25	VEH_AVAIL_FR_DATE	☐	OIJ_VEH_AVAIL_FR_DATE	OIJ_VEH_AVAIL_FR_DATE	DATS	8	0	Start Date of Vehicle Availability
26	VEH_AVAIL_FR_TIME	☐	OIJ_VEH_AVAIL_FR_TIME	UZEIT	TIMS	6	0	From Time of Vehicle Availability
27	VEH_AVAIL_TO_DATE	☐	OIJ_VEH_AVAIL_TO_DATE	OIJ_VEH_AVAIL_TO_DATE	DATS	8	0	End Date of Vehicle Availability
28	VEH_AVAIL_TO_TIME	☐	OIJ_VEH_AVAIL_TO_TIME	UZEIT	TIMS	6	0	To Time of Vehicle Availability
29	VAL_FROM	☐	OIJ_EL_VALF	DATUM	DATS	8	0	Validity period start date
30	VAL_TO	☐	OIJ_EL_VALT	DATUM	DATS	8	0	Validity period end date
31	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	*
32	STFXNR	☐	OIG_STFXNR	OIG_STFXNR	CHAR	30	0	TD-Vehicle Fax Number
33	DECL	☐	OIJ_EL_DECL	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterer or owner driven
34	DECL_QU	☐	OIJ_EL_DEQU	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterers or owners option
35	TOL_MIN	☐	OIJ_EL_TMIN	PRZ21	DEC	3	1	Cargo size tolerance - minimum
36	TOL_MAX	☐	OIJ_EL_TMAX	PRZ21	DEC	3	1	Cargo size tolerance - maximum
37	AVAIL_CAPACITY	☐	OIJ_AVAL_CAP	MENGE	QUAN	13	3	TD-Vehicle's Available Capacity
38	AVAIL_CAP_UOM	☐	OIJ_AVAL_CAP_UOM	OIJ_AVAL_CAP_UOM	UNIT	3	0	TD-Vehicle's Available capacity UoM
39	OWN_FLAG	☐	OIG_VOWNFL	OIG_VOWNFL	CHAR	1	0	TD-Vehicle Own Flag
40	CLF_EFDT	☐	OIG_CLFEFFDT	OIG_CLFEFFDT	DATS	8	0	Vehicle Classification Effective Date	*
41	STCMNR	☐	OIG_STCMNR	OIG_STCMNR	CHAR	30	0	TD-Vehicle Telex Number
42	MAT_LIST	☐	OIJ_EL_PRODUCT_T		TTYP	0	0
43	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
44	SPEED	☐	OIJ_EL_SPEED	OIJ_Q6_01	QUAN	6	1	Charter contract: base speed for voyage
45	SP_UOM	☐	OIJ_EL_SPUOM	MEINS	UNIT	3	0	Speed unit of measurement	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_TRANS_AVAIL	SP_UOM	T006	MSEHI

History

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