1. Home
  2. Resources
  3. SAP Tables
  4. ROIJ_3WP_GRID_TRANS - 3WP ALV Grid display structure: Transport Avails

SAP Table ROIJ_3WP_GRID_TRANS

3WP ALV Grid display structure: Transport Avails

ROIJ_3WP_GRID_TRANS (3WP ALV Grid display structure: Transport Avails) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIJ_3WP_GRID_TRANS to other SAP tables.

ROIJ_3WP_GRID_TRANS table fields

Field Data element Checktable Datatype Length Decimals
CONSUMED_FLAG Indicator for consumed 3WP ALV Grid data OIJ_CONS_FLAG CHAR 1 0
X true
- false
NULL unknown
RC_CODE Vehicle availability reason code OIJ_VHAVL_RCCODE CHAR 2 0
01 Vehicle master data events
02 Vehicle not reachable
03 No valid freight contract
04 Vehicle is blocked for nomination
05 No valid material
06 No valid location
07 Less than minimum available period
08 Capacity not available
09 Location is excluded in freight contract
10 Deletion flag is set for the vehicle equipment
11 No route connects between locations
12 Remaining capacity not checked for availability
13 Freight Contract is not valid
VEHICLE TD Vehicle Number OIG_VHLNMR CHAR 10 0
PRNOMTK Previous Nomination Technical Key OIJ_PRNMTK CHAR 20 0
PRNOMNR Previous Nomination Number OIJ_PRNMNR CHAR 20 0
PRPOT_DEP_DATE Potential Departure Date of the Previous Nom. Of TD-Vehicle OIJ_PRPOT_DEP_DATE DATS 8 0
PRLOCID Previous Location ID OIJ_PRLOCID CHAR 10 0
POT_DEP_DATE Potential Departure Date of TD-Vehicle OIJ_POT_DEP_DATE DATS 8 0
CRNOMTK Current Nominations Technical Key OIJ_CRNMTK CHAR 20 0
CRNOMNR Current Nomination Number OIJ_CRNMNR CHAR 20 0
CRLOCID Current Location ID OIJ_CRLOCID CHAR 10 0
CRLOC_ATTR Current Location Attribute OIJ_CRLOCATTR CHAR 1 0
O Loading
D Discharge
S Delivery area
R Redelivery area
CRNMFRDT From Date of Current Nomination OIJ_CURR_NOM_FR_DT DATS 8 0
CRNMFRTM From Time of Current Nomination OIJ_CRNM_FRTM TIMS 6 0
CRNMTODT To Date of Current Nomination OIJ_CURR_NOM_TO_DT DATS 8 0
CRNMTOTM To Time of Current Nomination OIJ_CRNM_TOTM TIMS 6 0
NXLOCID Next Location ID OIJ_NXLOCID CHAR 10 0
NXLOC_ATTR Next Location Attribute OIJ_NXLOCATTR CHAR 1 0
O Loading
D Discharge
S Delivery area
R Redelivery area
NXARDT TD-Vehicle Arrival Date OIJ_ARR_DATE DATS 8 0
NXNOMTK Future Nomination Technical Key OIJ_NXNMTK CHAR 20 0
NXNOMNR Next Nomination Number OIJ_NXNMNR CHAR 20 0
VBELN Freight contract number OIJ_EL_CPNO CHAR 10 0
VBTYP TSW Details document type OIJ_EL_VBTYP CHAR 1 0
K Puchase contract
V Purchase order
G Sales contract
C Sales order
H Sales return order
B Sales quotation
P Purchase requisition
w Reservation
I Trading Contract Sales
J Trading Contract Purchase
L Trading Contract -STO
M Pre-Trading Contract -Purchase
N Pre-Trading Contract- Sales
O Pre-Trading- STO
POSNR Contract item number OIJ_EL_POSNR NUMC 6 0
SINGLE_VOY Single voyage flag OIJ_EL_SV CHAR 1 0
X Yes
NULL No
VEH_AVAIL_FR_DATE Start Date of Vehicle Availability OIJ_VEH_AVAIL_FR_DATE DATS 8 0
VEH_AVAIL_FR_TIME From Time of Vehicle Availability OIJ_VEH_AVAIL_FR_TIME TIMS 6 0
VEH_AVAIL_TO_DATE End Date of Vehicle Availability OIJ_VEH_AVAIL_TO_DATE DATS 8 0
VEH_AVAIL_TO_TIME To Time of Vehicle Availability OIJ_VEH_AVAIL_TO_TIME TIMS 6 0
VAL_FROM Validity period start date OIJ_EL_VALF DATS 8 0
VAL_TO Validity period end date OIJ_EL_VALT DATS 8 0
VEH_TYPE TD vehicle type OIG_VHLTYP CHAR 4 0
STFXNR TD-Vehicle Fax Number OIG_STFXNR CHAR 30 0
DECL Declare flag: charterer or owner driven OIJ_EL_DECL CHAR 1 0
C Charterer
O Owner
DECL_QU Declare flag: charterers or owners option OIJ_EL_DEQU CHAR 1 0
C Charterer
O Owner
TOL_MIN Cargo size tolerance - minimum OIJ_EL_TMIN DEC 3 1
TOL_MAX Cargo size tolerance - maximum OIJ_EL_TMAX DEC 3 1
VEH_ID TD vehicle identifier OIG_VEHID CHAR 18 0
VEH_MAXWGT Vehicle maximum weight OIG_VEMWGT CHAR 14 0
VEH_UNLWGT Vehicle unladen weight OIG_VEUWGT CHAR 14 0
WGT_UOM TD weight unit of measure OIG_WGTUOM T006 UNIT 3 0
EQUIP_NR Equipment Number EQUNR EQUI CHAR 18 0
VEH_HEIGHT Vehicle height OIG_VEHHEI QUAN 13 3
VEH_WIDTH TD width OIG_VEHWID QUAN 13 3
VEH_LENGTH Vehicle length OIG_VEHLEN QUAN 13 3
DIM_UOM TD dimension unit of measure OIG_DIMUOM T006 UNIT 3 0
CONTR_QTY Reference document quantity (SD or MM) OIJ_CONTR_QTY QUAN 13 3
CONS_CONTR_QTY Consumed Reference Document Quantity (MM or SD) OIJ_CONS_QTY QUAN 13 3
REM_CONTR_QTY Remaining Reference Document Quantity (MM or SD) OIJ_REM_QTY QUAN 13 3
CONTR_QTY_UOM UoM for Freight Contract - Charter Arrangements Contract Qty OIJ_CONTR_QTY_UOM UNIT 3 0
DOCIND_FCC Freight Contract - Charter Arrangements Ref. Doc. Ind. OIJ_DOCIND_FCC CHAR 1 0
G Sales Contract
K Purchase Contract
P Purchase order
R Sales return
S Sales order
T Stock Transfer Order
X Plant-to-plant transfer
B Sales Quotation
Q Requisition document for SPW
U Stock Transfer Requisition
L Un Released Trading Contract -Purchase Order
M Un Released Trading Contract -Sales Order
N Un Released Trading Contract -Stock Transport Order
H Released Pre-Trading Contract-Purchase Order
I Released Pre-Trading Contract- Sales Order
J Released Pre-Trading Contract- Stock Transport Order
DOCNR_FCC Freight Contract - Charter Arrangements Reference Document OIJ_DOCNR_FCC CHAR 10 0
DOCITM_FCC Freight Contract - Charter Arrangements Ref. Doc. Item OIJ_DOCITM_FCC NUMC 6 0
MAX_CAP Maximal capacity for a marine vehicle OIJ_MAX_CAP QUAN 13 3
REM_CAP Remaining capacity for a marine vehicle OIJ_REM_CAP QUAN 13 3
VEH_CAP_UOM UoM of marine vehicle capacity OIJ_CAP_UOM UNIT 3 0
BASE_SPEED Charter contract: base speed for voyage OIJ_EL_SPEED QUAN 6 1
MIN_SPEED Charter contract: Minimum speed OIJ_EL_MINSP QUAN 6 1
MAX_SPEED Charter contract: Maximum speed OIJ_EL_MAXSP QUAN 6 1
SP_UOM Speed unit of measurement OIJ_EL_SPUOM UNIT 3 0
NAME_EFF_DATE Name Effective Date OIG_NMEFFDT DATS 8 0
CLF_EFDT Vehicle Classification Effective Date OIG_CLFEFFDT DATS 8 0
REG_CNTRY Vehicle Registered Country OIG_REG_CNTR T005 CHAR 3 0
REG_DATE TD-Vehicle Registered Date OIG_REGDT DATS 8 0
OWNER TD-Vehicle Owner OIG_VEH_OWNER CHAR 20 0
REG_OWNER TD-Vehicle Registered Owner OIG_VEH_REG_OWN CHAR 20 0
GRP_ID TD-Vehicle Berth Compatibility Group ID OIG_BR_CP_GRP_ID TOI0_CP_GRP CHAR 10 0
OWN_FLAG TD-Vehicle Own Flag OIG_VOWNFL CHAR 1 0
NULL No
X Yes
BALLCAP TD-Vehicle Ballast Capacity OIG_BALLCAP QUAN 13 3
FL_BNK_CAPA TD-Vehicle Fuel Bunker Capacity OIG_FL_BNK_CAPA QUAN 13 3
DSL_BNK_CAPA TD-Vehicle Diesel Bunker Capacity OIG_DSL_BNK_CAPA QUAN 13 3
CAP_UOM UoM of TD-Vehicle Bunker Capacity OIG_CAP_UOM T006 UNIT 3 0
WT_UOM UoM of TD-Vehicle(For Draft) OIG_WT_UOM T006 UNIT 3 0
CLASS_GRP TD-Vehicle Classification Group OIG_CL_GRP TOIGVCLGR CHAR 10 0
VHCLSIGN TD-Vehicle Call Sign OIG_VHCLSIGN CHAR 10 0
STCMNR TD-Vehicle Telex Number OIG_STCMNR CHAR 30 0
SRFXNR TD-Vehicle Fax Number OIG_STFXNR CHAR 30 0
DRAFT Maximum Vehicle Draft OIG_VEH_DRAFT QUAN 13 3
ALV_ICON Icon for Highlighted Transport Avails OIJ_TRANS_ICON CHAR 4 0
ALV_LINECOLOR ALV Color code for highlighted transport avails OIJ_TRANS_COLOR CHAR 4 0
LP1 Location ID for Loading Port OIJ02_LP1 CHAR 10 0
LP1_ETA ETA AT Load Port OIJ02_LP1_ETA DATS 8 0
LP1_ETD Estimated Time of Departure at Loading Port OIJ02_LP1_ETD DATS 8 0
LP_KNOT1 Transportation Connection Point OIJ02_LP1_KNOT1 CHAR 10 0
DP1 Location ID for Discharge Port OIJ02_DP1 CHAR 10 0
DP1_ETA Estimated Time of Arrival (ETA) Destination Point OIJ02_DP1_ETA DATS 8 0
DP_KNOT2 Transportation Connection Point OIJ02_DP_KNOT2 CHAR 10 0
DP2 Location ID for Discharge Port OIJ02_DP2 CHAR 10 0
DP2_ETA Estimated Time of Arrival (ETA) Destination Point OIJ02_DP2_ETA DATS 8 0
DP_KNOT3 Transportation Connection Point OIJ02_DP_KNOT3 CHAR 10 0
DP3 Location ID for Discharge Port OIJ02_DP3 CHAR 10 0
DP3_ETA Estimated Time of Arrival (ETA) Destination Point OIJ02_DP3_ETA DATS 8 0
DP_KNOT4 Transportation Connection Point OIJ02_DP_KNOT4 CHAR 10 0
KNOT1_TXT Text Field for Location OIJ02_KNOT1_TXT CHAR 30 0
KNOT2_TXT Text Field for Location OIJ02_KNOT2_TXT CHAR 30 0
KNOT3_TXT Text Field for Location OIJ02_KNOT3_TXT CHAR 30 0
KNOT4_TXT Text Field for Location OIJ02_KNOT4_TXT CHAR 30 0
FREIGHT_VENDOR Name of the Freight Vendor OIJ02_FREIGHT_VENDOR CHAR 35 0
FEU TSW-Mining: Forty-foot Equivalent Units OIJ02_FEU DEC 4 0
FTU TSW-Mining: Twenty Foot Equivalent Units OIJ02_TEU DEC 4 0
BFEU TSW-Mining: Forty-foot Equivalent Units -booked OIJ02_BFEU DEC 4 0
BTEU TSW-Mining: Twenty Foot Equivalent Units booked OIJ02_BTEU DEC 4 0
NMVEHICLE_TXT TD vehicle header text OIG_VHLTXT CHAR 40 0
ROUTE Route ROUTE CHAR 6 0
CARRIER Transport system Carrier OIJ_CARRNR CHAR 10 0
FLTTNOMTK Nomination (technical) Key OIJ_NOMTK CHAR 20 0

ROIJ_3WP_GRID_TRANS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIJ_3WP_GRID_TRANS CAP_UOM SYST MANDT T006 Units of Measurement MANDT
ROIJ_3WP_GRID_TRANS CAP_UOM ROIJ_3WP_GRID_TRANS CAP_UOM T006 Units of Measurement MSEHI
ROIJ_3WP_GRID_TRANS CLASS_GRP SYST MANDT TOIGVCLGR Vehicle classification group MANDT
ROIJ_3WP_GRID_TRANS CLASS_GRP ROIJ_3WP_GRID_TRANS CLASS_GRP TOIGVCLGR Vehicle classification group CLASS_GRP
ROIJ_3WP_GRID_TRANS DIM_UOM SYST MANDT T006 Units of Measurement MANDT
ROIJ_3WP_GRID_TRANS DIM_UOM ROIJ_3WP_GRID_TRANS DIM_UOM T006 Units of Measurement MSEHI
ROIJ_3WP_GRID_TRANS EQUIP_NR SYST MANDT EQUI Equipment master data MANDT
ROIJ_3WP_GRID_TRANS EQUIP_NR ROIJ_3WP_GRID_TRANS EQUIP_NR EQUI Equipment master data EQUNR
ROIJ_3WP_GRID_TRANS GRP_ID SYST MANDT TOI0_CP_GRP Compatibility Group Definition MANDT
ROIJ_3WP_GRID_TRANS GRP_ID ROIJ_3WP_GRID_TRANS GRP_ID TOI0_CP_GRP Compatibility Group Definition GRP_ID
ROIJ_3WP_GRID_TRANS REG_CNTRY SYST MANDT T005 Countries MANDT
ROIJ_3WP_GRID_TRANS REG_CNTRY ROIJ_3WP_GRID_TRANS REG_CNTRY T005 Countries LAND1
ROIJ_3WP_GRID_TRANS WGT_UOM SYST MANDT T006 Units of Measurement MANDT
ROIJ_3WP_GRID_TRANS WGT_UOM ROIJ_3WP_GRID_TRANS WGT_UOM T006 Units of Measurement MSEHI
ROIJ_3WP_GRID_TRANS WT_UOM ROIJ_3WP_GRID_TRANS WT_UOM T006 Units of Measurement MSEHI
ROIJ_3WP_GRID_TRANS WT_UOM SYST MANDT T006 Units of Measurement MANDT