SAP ABAP Table ROIJ_3WP_GRID_TRANS (3WP ALV Grid display structure: 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_3WP_GRID_TRANS	Table Relationship Diagram
Short Description	3WP ALV Grid display structure: 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	CONSUMED_FLAG	☐	OIJ_CONS_FLAG	BOOLEAN	CHAR	1	0	Indicator for consumed 3WP ALV Grid data
2	RC_CODE	☐	OIJ_VHAVL_RCCODE	OIJ_VHAVL_RCCODE	CHAR	2	0	Vehicle availability reason code
3	.INCLUDE	☐				0	0	Vehicle Availability Structure
4	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
5	PRNOMTK	☐	OIJ_PRNMTK	OIJ_NOMTK	CHAR	20	0	Previous Nomination Technical Key	*
6	PRNOMNR	☐	OIJ_PRNMNR	OIJ_NOMNR	CHAR	20	0	Previous Nomination Number
7	PRPOT_DEP_DATE	☐	OIJ_PRPOT_DEP_DATE	OIJ_POT_DEP_DATE	DATS	8	0	Potential Departure Date of the Previous Nom. Of TD-Vehicle
8	PRLOCID	☐	OIJ_PRLOCID	OIJ_LOCID	CHAR	10	0	Previous Location ID	*
9	POT_DEP_DATE	☐	OIJ_POT_DEP_DATE	OIJ_POT_DEP_DATE	DATS	8	0	Potential Departure Date of TD-Vehicle
10	CRNOMTK	☐	OIJ_CRNMTK	OIJ_NOMTK	CHAR	20	0	Current Nominations Technical Key	*
11	CRNOMNR	☐	OIJ_CRNMNR	OIJ_NOMNR	CHAR	20	0	Current Nomination Number
12	CRLOCID	☐	OIJ_CRLOCID	OIJ_LOCID	CHAR	10	0	Current Location ID	*
13	CRLOC_ATTR	☐	OIJ_CRLOCATTR	OIJ_EL_LOATT	CHAR	1	0	Current Location Attribute
14	CRNMFRDT	☐	OIJ_CURR_NOM_FR_DT	OIJ_CURR_NOM_FR_DT	DATS	8	0	From Date of Current Nomination
15	CRNMFRTM	☐	OIJ_CRNM_FRTM	UZEIT	TIMS	6	0	From Time of Current Nomination
16	CRNMTODT	☐	OIJ_CURR_NOM_TO_DT	OIJ_CURR_NOM_TO_DT	DATS	8	0	To Date of Current Nomination
17	CRNMTOTM	☐	OIJ_CRNM_TOTM	UZEIT	TIMS	6	0	To Time of Current Nomination
18	NXLOCID	☐	OIJ_NXLOCID	OIJ_LOCID	CHAR	10	0	Next Location ID	*
19	NXLOC_ATTR	☐	OIJ_NXLOCATTR	OIJ_EL_LOATT	CHAR	1	0	Next Location Attribute
20	NXARDT	☐	OIJ_ARR_DATE	OIJ_ARR_DATE	DATS	8	0	TD-Vehicle Arrival Date
21	NXNOMTK	☐	OIJ_NXNMTK	OIJ_NOMTK	CHAR	20	0	Future Nomination Technical Key	*
22	NXNOMNR	☐	OIJ_NXNMNR	OIJ_NOMNR	CHAR	20	0	Next Nomination Number
23	VBELN	☐	OIJ_EL_CPNO	VBELN	CHAR	10	0	Freight contract number	*
24	VBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
25	POSNR	☐	OIJ_EL_POSNR	POSNR	NUMC	6	0	Contract item number	*
26	SINGLE_VOY	☐	OIJ_EL_SV	XFELD	CHAR	1	0	Single voyage flag
27	VEH_AVAIL_FR_DATE	☐	OIJ_VEH_AVAIL_FR_DATE	OIJ_VEH_AVAIL_FR_DATE	DATS	8	0	Start Date of Vehicle Availability
28	VEH_AVAIL_FR_TIME	☐	OIJ_VEH_AVAIL_FR_TIME	UZEIT	TIMS	6	0	From Time of Vehicle Availability
29	VEH_AVAIL_TO_DATE	☐	OIJ_VEH_AVAIL_TO_DATE	OIJ_VEH_AVAIL_TO_DATE	DATS	8	0	End Date of Vehicle Availability
30	VEH_AVAIL_TO_TIME	☐	OIJ_VEH_AVAIL_TO_TIME	UZEIT	TIMS	6	0	To Time of Vehicle Availability
31	VAL_FROM	☐	OIJ_EL_VALF	DATUM	DATS	8	0	Validity period start date
32	VAL_TO	☐	OIJ_EL_VALT	DATUM	DATS	8	0	Validity period end date
33	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	*
34	STFXNR	☐	OIG_STFXNR	OIG_STFXNR	CHAR	30	0	TD-Vehicle Fax Number
35	DECL	☐	OIJ_EL_DECL	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterer or owner driven
36	DECL_QU	☐	OIJ_EL_DEQU	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterers or owners option
37	TOL_MIN	☐	OIJ_EL_TMIN	PRZ21	DEC	3	1	Cargo size tolerance - minimum
38	TOL_MAX	☐	OIJ_EL_TMAX	PRZ21	DEC	3	1	Cargo size tolerance - maximum
39	VEH_ID	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
40	VEH_MAXWGT	☐	OIG_VEMWGT	OIG_VEHQUA	CHAR	14	0	Vehicle maximum weight
41	VEH_UNLWGT	☐	OIG_VEUWGT	OIG_VEHQUA	CHAR	14	0	Vehicle unladen weight
42	WGT_UOM	☐	OIG_WGTUOM	MEINS	UNIT	3	0	TD weight unit of measure	T006
43	EQUIP_NR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
44	VEH_HEIGHT	☐	OIG_VEHHEI	MENG13	QUAN	13	3	Vehicle height
45	VEH_WIDTH	☐	OIG_VEHWID	MENG13	QUAN	13	3	TD width
46	VEH_LENGTH	☐	OIG_VEHLEN	MENG13	QUAN	13	3	Vehicle length
47	DIM_UOM	☐	OIG_DIMUOM	MEINS	UNIT	3	0	TD dimension unit of measure	T006
48	CONTR_QTY	☐	OIJ_CONTR_QTY	MENG13	QUAN	13	3	Reference document quantity (SD or MM)
49	CONS_CONTR_QTY	☐	OIJ_CONS_QTY	MENG13	QUAN	13	3	Consumed Reference Document Quantity (MM or SD)
50	REM_CONTR_QTY	☐	OIJ_REM_QTY	MENG13	QUAN	13	3	Remaining Reference Document Quantity (MM or SD)
51	CONTR_QTY_UOM	☐	OIJ_CONTR_QTY_UOM	MEINS	UNIT	3	0	UoM for Freight Contract - Charter Arrangements Contract Qty	*
52	.INCLUDE	☐				0	0	Nomination header: marine fields
53	DOCIND_FCC	☐	OIJ_DOCIND_FCC	OIJ_DOCIND	CHAR	1	0	Freight Contract - Charter Arrangements Ref. Doc. Ind.
54	DOCNR_FCC	☐	OIJ_DOCNR_FCC	OIJ_DOCNR	CHAR	10	0	Freight Contract - Charter Arrangements Reference Document
55	DOCITM_FCC	☐	OIJ_DOCITM_FCC	NUM06	NUMC	6	0	Freight Contract - Charter Arrangements Ref. Doc. Item
56	MAX_CAP	☐	OIJ_MAX_CAP	MENG13	QUAN	13	3	Maximal capacity for a marine vehicle
57	REM_CAP	☐	OIJ_REM_CAP	MENG13V	QUAN	13	3	Remaining capacity for a marine vehicle
58	VEH_CAP_UOM	☐	OIJ_CAP_UOM	MEINS	UNIT	3	0	UoM of marine vehicle capacity	*
59	BASE_SPEED	☐	OIJ_EL_SPEED	OIJ_Q6_01	QUAN	6	1	Charter contract: base speed for voyage
60	MIN_SPEED	☐	OIJ_EL_MINSP	OIJ_Q6_01	QUAN	6	1	Charter contract: Minimum speed
61	MAX_SPEED	☐	OIJ_EL_MAXSP	OIJ_Q6_01	QUAN	6	1	Charter contract: Maximum speed
62	SP_UOM	☐	OIJ_EL_SPUOM	MEINS	UNIT	3	0	Speed unit of measurement	*
63	.INCLUDE	☐				0	0	TD Vehicle, Marine Scheduling Attributes
64	NAME_EFF_DATE	☐	OIG_NMEFFDT	OIG_NMEFFDT	DATS	8	0	Name Effective Date	*
65	CLF_EFDT	☐	OIG_CLFEFFDT	OIG_CLFEFFDT	DATS	8	0	Vehicle Classification Effective Date	*
66	REG_CNTRY	☐	OIG_REG_CNTR	LAND1	CHAR	3	0	Vehicle Registered Country	T005
67	REG_DATE	☐	OIG_REGDT	OIG_REGDT	DATS	8	0	TD-Vehicle Registered Date	*
68	OWNER	☐	OIG_VEH_OWNER	OIG_VEH_OWNER	CHAR	20	0	TD-Vehicle Owner
69	REG_OWNER	☐	OIG_VEH_REG_OWN	OIG_VEH_REG_OWN	CHAR	20	0	TD-Vehicle Registered Owner
70	GRP_ID	☐	OIG_BR_CP_GRP_ID	OI0_CP_GRP_ID	CHAR	10	0	TD-Vehicle Berth Compatibility Group ID	TOI0_CP_GRP
71	OWN_FLAG	☐	OIG_VOWNFL	OIG_VOWNFL	CHAR	1	0	TD-Vehicle Own Flag
72	BALLCAP	☐	OIG_BALLCAP	OIG_BALLCAP	QUAN	13	3	TD-Vehicle Ballast Capacity
73	FL_BNK_CAPA	☐	OIG_FL_BNK_CAPA	OIG_FL_BNK_CAPA	QUAN	13	3	TD-Vehicle Fuel Bunker Capacity
74	DSL_BNK_CAPA	☐	OIG_DSL_BNK_CAPA	OIG_DSL_BNK_CAPA	QUAN	13	3	TD-Vehicle Diesel Bunker Capacity
75	CAP_UOM	☐	OIG_CAP_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle Bunker Capacity	T006
76	WT_UOM	☐	OIG_WT_UOM	MEINS	UNIT	3	0	UoM of TD-Vehicle(For Draft)	T006
77	CLASS_GRP	☐	OIG_CL_GRP	OIG_CL_GRP	CHAR	10	0	TD-Vehicle Classification Group	TOIGVCLGR
78	VHCLSIGN	☐	OIG_VHCLSIGN	OIG_VHCLSIGN	CHAR	10	0	TD-Vehicle Call Sign
79	STCMNR	☐	OIG_STCMNR	OIG_STCMNR	CHAR	30	0	TD-Vehicle Telex Number
80	SRFXNR	☐	OIG_STFXNR	OIG_STFXNR	CHAR	30	0	TD-Vehicle Fax Number
81	DRAFT	☐	OIG_VEH_DRAFT	OIG_VEH_DRAFT	QUAN	13	3	Maximum Vehicle Draft
82	ALV_ICON	☐	OIJ_TRANS_ICON	CHAR4	CHAR	4	0	Icon for Highlighted Transport Avails
83	ALV_LINECOLOR	☐	OIJ_TRANS_COLOR	CHAR4	CHAR	4	0	ALV Color code for highlighted transport avails

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_3WP_GRID_TRANS	CAP_UOM	T006	MSEHI
2	ROIJ_3WP_GRID_TRANS	CLASS_GRP	TOIGVCLGR	CLASS_GRP
3	ROIJ_3WP_GRID_TRANS	DIM_UOM	T006	MSEHI
4	ROIJ_3WP_GRID_TRANS	EQUIP_NR	EQUI	EQUNR
5	ROIJ_3WP_GRID_TRANS	GRP_ID	TOI0_CP_GRP	GRP_ID	REF	C	CN
6	ROIJ_3WP_GRID_TRANS	REG_CNTRY	T005	LAND1
7	ROIJ_3WP_GRID_TRANS	WGT_UOM	T006	MSEHI
8	ROIJ_3WP_GRID_TRANS	WT_UOM	T006	MSEHI

History

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