ROIJ_3WP_GRID_TRANS SAP (3WP ALV Grid display structure: Transport Avails) Structure details
Dictionary Type: Structure
Description: 3WP ALV Grid display structure: Transport Avails
Description: 3WP ALV Grid display structure: Transport Avails
ABAP Code to SELECT data from ROIJ_3WP_GRID_TRANS
Related tables to ROIJ_3WP_GRID_TRANS
Access table ROIJ_3WP_GRID_TRANS
Related tables to ROIJ_3WP_GRID_TRANS
Access table ROIJ_3WP_GRID_TRANS
Structure field list including key, data, relationships and ABAP select examples
ROIJ_3WP_GRID_TRANS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "3WP ALV Grid display structure: Transport Avails" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ROIJ_3WP_GRID_TRANS TYPE ROIJ_3WP_GRID_TRANS.
The ROIJ_3WP_GRID_TRANS table consists of various fields, each holding specific information or linking keys about 3WP ALV Grid display structure: Transport Avails data available in SAP. These include RC_CODE (Vehicle availability reason code), VEHICLE (TD Vehicle Number), PRNOMTK (Previous Nomination Technical Key), PRNOMNR (Previous Nomination Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ROIJ_3WP_GRID_TRANS structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CONSUMED_FLAG | Indicator for consumed 3WP ALV Grid data | OIJ_CONS_FLAG | CHAR | 1 | BOOLEAN | ||||
| RC_CODE | Vehicle availability reason code | OIJ_VHAVL_RCCODE | CHAR | 2 | OIJ_VHAVL_RCCODE | ||||
| VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | Assigned to domain | ALPHA | OIG_VHLNMR | OIV | |
| PRNOMTK | Previous Nomination Technical Key | OIJ_PRNMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
| PRNOMNR | Previous Nomination Number | OIJ_PRNMNR | CHAR | 20 | OIJ_NOMNR | ||||
| PRPOT_DEP_DATE | Potential Departure Date of the Previous Nom. Of TD-Vehicle | OIJ_PRPOT_DEP_DATE | DATS | 8 | OIJ_POT_DEP_DATE | ||||
| PRLOCID | Previous Location ID | OIJ_PRLOCID | CHAR | 10 | Assigned to domain | OIJ_LOCID | |||
| POT_DEP_DATE | Potential Departure Date of TD-Vehicle | OIJ_POT_DEP_DATE | DATS | 8 | OIJ_POT_DEP_DATE | ||||
| CRNOMTK | Current Nominations Technical Key | OIJ_CRNMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
| CRNOMNR | Current Nomination Number | OIJ_CRNMNR | CHAR | 20 | OIJ_NOMNR | ||||
| CRLOCID | Current Location ID | OIJ_CRLOCID | CHAR | 10 | Assigned to domain | OIJ_LOCID | |||
| CRLOC_ATTR | Current Location Attribute | OIJ_CRLOCATTR | CHAR | 1 | OIJ_EL_LOATT | ||||
| CRNMFRDT | From Date of Current Nomination | OIJ_CURR_NOM_FR_DT | DATS | 8 | OIJ_CURR_NOM_FR_DT | ||||
| CRNMFRTM | From Time of Current Nomination | OIJ_CRNM_FRTM | TIMS | 6 | UZEIT | ||||
| CRNMTODT | To Date of Current Nomination | OIJ_CURR_NOM_TO_DT | DATS | 8 | OIJ_CURR_NOM_TO_DT | ||||
| CRNMTOTM | To Time of Current Nomination | OIJ_CRNM_TOTM | TIMS | 6 | UZEIT | ||||
| NXLOCID | Next Location ID | OIJ_NXLOCID | CHAR | 10 | Assigned to domain | OIJ_LOCID | |||
| NXLOC_ATTR | Next Location Attribute | OIJ_NXLOCATTR | CHAR | 1 | OIJ_EL_LOATT | ||||
| NXARDT | TD-Vehicle Arrival Date | OIJ_ARR_DATE | DATS | 8 | OIJ_ARR_DATE | ||||
| NXNOMTK | Future Nomination Technical Key | OIJ_NXNMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
| NXNOMNR | Next Nomination Number | OIJ_NXNMNR | CHAR | 20 | OIJ_NOMNR | ||||
| VBELN | Freight contract number | OIJ_EL_CPNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| VBTYP | TSW Details document type | OIJ_EL_VBTYP | CHAR | 1 | OIJ_EL_VBTYP | ||||
| POSNR | Contract item number | OIJ_EL_POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| SINGLE_VOY | Single voyage flag | OIJ_EL_SV | CHAR | 1 | XFELD | ||||
| VEH_AVAIL_FR_DATE | Start Date of Vehicle Availability | OIJ_VEH_AVAIL_FR_DATE | DATS | 8 | OIJ_VEH_AVAIL_FR_DATE | ||||
| VEH_AVAIL_FR_TIME | From Time of Vehicle Availability | OIJ_VEH_AVAIL_FR_TIME | TIMS | 6 | UZEIT | ||||
| VEH_AVAIL_TO_DATE | End Date of Vehicle Availability | OIJ_VEH_AVAIL_TO_DATE | DATS | 8 | OIJ_VEH_AVAIL_TO_DATE | ||||
| VEH_AVAIL_TO_TIME | To Time of Vehicle Availability | OIJ_VEH_AVAIL_TO_TIME | TIMS | 6 | UZEIT | ||||
| VAL_FROM | Validity period start date | OIJ_EL_VALF | DATS | 8 | DATUM | ||||
| VAL_TO | Validity period end date | OIJ_EL_VALT | DATS | 8 | DATUM | ||||
| VEH_TYPE | TD vehicle type | OIG_VHLTYP | CHAR | 4 | Assigned to domain | OIG_VHLTYP | OIE | ||
| STFXNR | TD-Vehicle Fax Number | OIG_STFXNR | CHAR | 30 | OIG_STFXNR | ||||
| DECL | Declare flag: charterer or owner driven | OIJ_EL_DECL | CHAR | 1 | OIJ_EL_CHOW | ||||
| DECL_QU | Declare flag: charterers or owners option | OIJ_EL_DEQU | CHAR | 1 | OIJ_EL_CHOW | ||||
| TOL_MIN | Cargo size tolerance - minimum | OIJ_EL_TMIN | DEC | 3(1) | PRZ21 | ||||
| TOL_MAX | Cargo size tolerance - maximum | OIJ_EL_TMAX | DEC | 3(1) | PRZ21 | ||||
| VEH_ID | TD vehicle identifier | OIG_VEHID | CHAR | 18 | OIG_LICNMR | ||||
| VEH_MAXWGT | Vehicle maximum weight | OIG_VEMWGT | CHAR | 14 | OIG_VEHQUA | ||||
| VEH_UNLWGT | Vehicle unladen weight | OIG_VEUWGT | CHAR | 14 | OIG_VEHQUA | ||||
| WGT_UOM | TD weight unit of measure | OIG_WGTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| EQUIP_NR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
| VEH_HEIGHT | Vehicle height | OIG_VEHHEI | QUAN | 13(3) | MENG13 | ||||
| VEH_WIDTH | TD width | OIG_VEHWID | QUAN | 13(3) | MENG13 | ||||
| VEH_LENGTH | Vehicle length | OIG_VEHLEN | QUAN | 13(3) | MENG13 | ||||
| DIM_UOM | TD dimension unit of measure | OIG_DIMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| CONTR_QTY | Reference document quantity (SD or MM) | OIJ_CONTR_QTY | QUAN | 13(3) | MENG13 | ||||
| CONS_CONTR_QTY | Consumed Reference Document Quantity (MM or SD) | OIJ_CONS_QTY | QUAN | 13(3) | MENG13 | ||||
| REM_CONTR_QTY | Remaining Reference Document Quantity (MM or SD) | OIJ_REM_QTY | QUAN | 13(3) | MENG13 | ||||
| CONTR_QTY_UOM | UoM for Freight Contract - Charter Arrangements Contract Qty | OIJ_CONTR_QTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| DOCIND_FCC | Freight Contract - Charter Arrangements Ref. Doc. Ind. | OIJ_DOCIND_FCC | CHAR | 1 | OIJ_DOCIND | ||||
| DOCNR_FCC | Freight Contract - Charter Arrangements Reference Document | OIJ_DOCNR_FCC | CHAR | 10 | ALPHA | OIJ_DOCNR | |||
| DOCITM_FCC | Freight Contract - Charter Arrangements Ref. Doc. Item | OIJ_DOCITM_FCC | NUMC | 6 | NUM06 | ||||
| MAX_CAP | Maximal capacity for a marine vehicle | OIJ_MAX_CAP | QUAN | 13(3) | MENG13 | ||||
| REM_CAP | Remaining capacity for a marine vehicle | OIJ_REM_CAP | QUAN | 13(3) | MENG13V | ||||
| VEH_CAP_UOM | UoM of marine vehicle capacity | OIJ_CAP_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| BASE_SPEED | Charter contract: base speed for voyage | OIJ_EL_SPEED | QUAN | 6(1) | OIJ_Q6_01 | ||||
| MIN_SPEED | Charter contract: Minimum speed | OIJ_EL_MINSP | QUAN | 6(1) | OIJ_Q6_01 | ||||
| MAX_SPEED | Charter contract: Maximum speed | OIJ_EL_MAXSP | QUAN | 6(1) | OIJ_Q6_01 | ||||
| SP_UOM | Speed unit of measurement | OIJ_EL_SPUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| NAME_EFF_DATE | Name Effective Date | OIG_NMEFFDT | DATS | 8 | Assigned to domain | OIG_NMEFFDT | |||
| CLF_EFDT | Vehicle Classification Effective Date | OIG_CLFEFFDT | DATS | 8 | Assigned to domain | OIG_CLFEFFDT | |||
| REG_CNTRY | Vehicle Registered Country | OIG_REG_CNTR | CHAR | 3 | T005 | LAND1 | |||
| REG_DATE | TD-Vehicle Registered Date | OIG_REGDT | DATS | 8 | Assigned to domain | OIG_REGDT | |||
| OWNER | TD-Vehicle Owner | OIG_VEH_OWNER | CHAR | 20 | OIG_VEH_OWNER | ||||
| REG_OWNER | TD-Vehicle Registered Owner | OIG_VEH_REG_OWN | CHAR | 20 | OIG_VEH_REG_OWN | ||||
| GRP_ID | TD-Vehicle Berth Compatibility Group ID | OIG_BR_CP_GRP_ID | CHAR | 10 | TOI0_CP_GRP | OI0_CP_GRP_ID | OIJ_CP_VEH_GRP_ID | ||
| OWN_FLAG | TD-Vehicle Own Flag | OIG_VOWNFL | CHAR | 1 | OIG_VOWNFL | ||||
| BALLCAP | TD-Vehicle Ballast Capacity | OIG_BALLCAP | QUAN | 13(3) | OIG_BALLCAP | ||||
| FL_BNK_CAPA | TD-Vehicle Fuel Bunker Capacity | OIG_FL_BNK_CAPA | QUAN | 13(3) | OIG_FL_BNK_CAPA | ||||
| DSL_BNK_CAPA | TD-Vehicle Diesel Bunker Capacity | OIG_DSL_BNK_CAPA | QUAN | 13(3) | OIG_DSL_BNK_CAPA | ||||
| CAP_UOM | UoM of TD-Vehicle Bunker Capacity | OIG_CAP_UOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| WT_UOM | UoM of TD-Vehicle(For Draft) | OIG_WT_UOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| CLASS_GRP | TD-Vehicle Classification Group | OIG_CL_GRP | CHAR | 10 | TOIGVCLGR | OIG_CL_GRP | |||
| VHCLSIGN | TD-Vehicle Call Sign | OIG_VHCLSIGN | CHAR | 10 | OIG_VHCLSIGN | ||||
| STCMNR | TD-Vehicle Telex Number | OIG_STCMNR | CHAR | 30 | OIG_STCMNR | ||||
| SRFXNR | TD-Vehicle Fax Number | OIG_STFXNR | CHAR | 30 | OIG_STFXNR | ||||
| DRAFT | Maximum Vehicle Draft | OIG_VEH_DRAFT | QUAN | 13(3) | OIG_VEH_DRAFT | ||||
| ALV_ICON | Icon for Highlighted Transport Avails | OIJ_TRANS_ICON | CHAR | 4 | CHAR4 | ||||
| ALV_LINECOLOR | ALV Color code for highlighted transport avails | OIJ_TRANS_COLOR | CHAR | 4 | CHAR4 | ||||
| LP1 | Location ID for Loading Port | OIJ02_LP1 | CHAR | 10 | OIJ02_LOADPORT1 | ||||
| LP1_ETA | ETA AT Load Port | OIJ02_LP1_ETA | DATS | 8 | OIJ02_LOADPORT1_ETA | ||||
| LP1_ETD | Estimated Time of Departure at Loading Port | OIJ02_LP1_ETD | DATS | 8 | OIJ02_LOADPORT1_ETD | ||||
| LP_KNOT1 | Transportation Connection Point | OIJ02_LP1_KNOT1 | CHAR | 10 | KNOTA | ||||
| DP1 | Location ID for Discharge Port | OIJ02_DP1 | CHAR | 10 | OIJ02_DISPORT1 | ||||
| DP1_ETA | Estimated Time of Arrival (ETA) Destination Point | OIJ02_DP1_ETA | DATS | 8 | OIJ02_DISPORT1_ETA | ||||
| DP_KNOT2 | Transportation Connection Point | OIJ02_DP_KNOT2 | CHAR | 10 | KNOTZ | ||||
| DP2 | Location ID for Discharge Port | OIJ02_DP2 | CHAR | 10 | OIJ02_DISPORT2 | ||||
| DP2_ETA | Estimated Time of Arrival (ETA) Destination Point | OIJ02_DP2_ETA | DATS | 8 | OIJ02_DISPORT1_ETA | ||||
| DP_KNOT3 | Transportation Connection Point | OIJ02_DP_KNOT3 | CHAR | 10 | KNOTZ | ||||
| DP3 | Location ID for Discharge Port | OIJ02_DP3 | CHAR | 10 | OIJ02_DISPORT3 | ||||
| DP3_ETA | Estimated Time of Arrival (ETA) Destination Point | OIJ02_DP3_ETA | DATS | 8 | OIJ02_DISPORT3_ETA | ||||
| DP_KNOT4 | Transportation Connection Point | OIJ02_DP_KNOT4 | CHAR | 10 | KNOTZ | ||||
| KNOT1_TXT | Text Field for Location | OIJ02_KNOT1_TXT | CHAR | 30 | OIJ02_KNOT1_TXT | ||||
| KNOT2_TXT | Text Field for Location | OIJ02_KNOT2_TXT | CHAR | 30 | OIJ02_KNOT2_TXT | ||||
| KNOT3_TXT | Text Field for Location | OIJ02_KNOT3_TXT | CHAR | 30 | OIJ02_KNOT3_TXT | ||||
| KNOT4_TXT | Text Field for Location | OIJ02_KNOT4_TXT | CHAR | 30 | OIJ02_KNOT4_TXT | ||||
| FREIGHT_VENDOR | Name of the Freight Vendor | OIJ02_FREIGHT_VENDOR | CHAR | 35 | OIJ02_FREIGHT_VENDOR | ||||
| FEU | TSW-Mining: Forty-foot Equivalent Units | OIJ02_FEU | DEC | 4 | OIJ02_FEU | ||||
| FTU | TSW-Mining: Twenty Foot Equivalent Units | OIJ02_TEU | DEC | 4 | OIJ02_TEU | ||||
| BFEU | TSW-Mining: Forty-foot Equivalent Units -booked | OIJ02_BFEU | DEC | 4 | OIJ02_FEU | ||||
| BTEU | TSW-Mining: Twenty Foot Equivalent Units booked | OIJ02_BTEU | DEC | 4 | OIJ02_TEU | ||||
| NMVEHICLE_TXT | TD vehicle header text | OIG_VHLTXT | CHAR | 40 | OIG_TEXT | ||||
| ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
| CARRIER | Transport system Carrier | OIJ_CARRNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
| FLTTNOMTK | Nomination (technical) Key | OIJ_NOMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK |
| Key field | Non-key field |
How do I retrieve data from SAP structure ROIJ_3WP_GRID_TRANS using ABAP code?
As ROIJ_3WP_GRID_TRANS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIJ_3WP_GRID_TRANS as there is no data to select.How to access SAP table ROIJ_3WP_GRID_TRANS
Within an ECC or HANA version of SAP you can also view further information about ROIJ_3WP_GRID_TRANS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects