ROIJ_3WP_GRID SAP (3WP ALV Grid display structure) Structure details
Description: 3WP ALV Grid display structure
Related tables to ROIJ_3WP_GRID
Access table ROIJ_3WP_GRID
Structure field list including key, data, relationships and ABAP select examples
ROIJ_3WP_GRID 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" 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 TYPE ROIJ_3WP_GRID.
The ROIJ_3WP_GRID table consists of various fields, each holding specific information or linking keys about 3WP ALV Grid display structure data available in SAP. These include MANDT (Client), SIM_SCHED_ID (TSW: Nomination Simulation ID), SIM_SCHED_LN (TSW: Nomination Simulation Line item), SIM_VERSION (TSW: Simulation Version).. 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 (Deep)
SAP ROIJ_3WP_GRID 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 |
ITEMID | Demand Item/Supply Avail indicator (DSI) | OIJ_ITEMID | CHAR | 10 | |||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SIM_SCHED_ID | TSW: Nomination Simulation ID | OIJ_SIMID | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
SIM_SCHED_LN | TSW: Nomination Simulation Line item | OIJ_SIMLN | NUMC | 10 | OIJ_ITEMNO | ||||
SIM_VERSION | TSW: Simulation Version | OIJ_SIMVERS | NUMC | 3 | OIJ_SIMVERS | ||||
SIM_SCHED_TYP | Simulation Schedule category | OIJ_SIM_SCHED_TYP | CHAR | 2 | OIJ_SIM_SCHED_TYP | ||||
SCHED_STAT | TSW: Status of Simulated Schedule line | OIJ_SIMSTAT | CHAR | 1 | OIJ_SIMSTAT | ||||
SCHED_ACF | TSW: Flag for automatically created entries | OIJ_SIM_AUTO_CREATE | CHAR | 1 | XFLAG | ||||
NOMTK | Nomination (technical) Key | OIJ_NOMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
NOMIT | Nomination Key Item | OIJ_ITEM | NUMC | 10 | Assigned to domain | OIJ_ITEM | |||
SCHED_COMM | Short comment | OIJ_SIM_SC | CHAR | 80 | CHAR80 | ||||
NOMCL | Nomination Class | OIJ_NOMCL | CHAR | 2 | OIJ_NOMCL | ||||
NOMTYP | Nomination type | OIJ_NOMTYP | CHAR | 4 | TOIJNOMTYP | OIJ_NOMTYP | OIJ_NOM_TYPE | ||
BUSTYP | Business type | OIRA_RNBT | CHAR | 4 | OIRARNBT | OIRA_RNBT | OIRA_0 | ||
NOMNR | Nomination number | OIJ_NOMNR | CHAR | 20 | OIJ_NOMNR | OIO | |||
NOMST | Nomination header status | OIJ_NOMST | CHAR | 1 | Assigned to domain | OIJ_ISTAT | |||
NMSHTYPE | TD shipment type | OIG_TDSTYP | CHAR | 4 | TOIGS | OIG_TDSTYP | OIC | ||
NMBALCH | Balance check indicator (default) | OIJ_BALCH | CHAR | 1 | XFELD | ||||
STAGES_ID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | Assigned to domain | SYSUUID_22 | |||
WORKLIST | Worklist entry indicator | OIJ_WORKLT | CHAR | 1 | XFELD | ||||
SENTDAT | Last header action date | OIJ_SENDAT | DATS | 8 | DATUM | ||||
SENTTIME | Last header action time | OIJ_SENTIM | TIMS | 6 | UZEIT | ||||
SENTNAM | Last user who worked on object | OIJ_SENNAM | CHAR | 12 | USNAM | ||||
ITEMS | Nomination item counter | OIJ_ITEMCOUNTER | NUMC | 4 | NUM04 | ||||
COUNTER1 | Nomination planned item Counter | OIJ_PLANNEDITEMS | NUMC | 4 | NUM04 | ||||
COUNTER2 | Nomination scheduled Item Counter | OIJ_SCHEDULEDITEMS | NUMC | 4 | NUM04 | ||||
COUNTER3 | Nomination rejected Item Counter | OIJ_REJECTEDITEMS | NUMC | 4 | NUM04 | ||||
COUNTER4 | Nomination confirmed Item Counter | OIJ_CONFIRMEDITEMS | NUMC | 4 | NUM04 | ||||
COUNTER5 | Nomination partially complete Item Counter | OIJ_PARTCOMPLETEITEMS | NUMC | 4 | NUM04 | ||||
COUNTER6 | Nomination completed Item Counter | OIJ_COMPLETEDITEMS | NUMC | 4 | NUM04 | ||||
APO_SHIPMENT_ID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
APO_SHIPMENT_NUM | Shipment Number | TKNUM | CHAR | 10 | Assigned to domain | ALPHA | TKNUM | TNR | SD_F4_SHP_ID |
NMBLOCK | Blocking indicator | OIJ_BLOIND | CHAR | 1 | XFELD | ||||
NOMTYPDESC | IS-Oil: Descriptive text | OI0_TEXT | CHAR | 36 | ALPHA | OI0_TEXT | |||
SHTYP | Shipment type | SHTYP | CHAR | 4 | TVTK | SHTYP | TSH | ||
TKNUM | Shipment Number | TKNUM | CHAR | 10 | VTTK | ALPHA | TKNUM | TNR | SD_F4_SHP_ID |
LOV_GL | Gain Loss LOV posting indicator | OIJ03_GLLOVPOST | CHAR | 1 | OIJ03_GLLOVPOST_D | ||||
TSYST | Transport system | OIJ_TSYST | CHAR | 10 | OIJTS | OIJ_TSYST | OIW | ||
NMSHIPPER | Shipper | OIJ_SHIPNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
NMCARRIER | Transport system Carrier | OIJ_CARRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
CYCLE | Nomination Pipeline cycle ID | OIJ_CYCLE | CHAR | 10 | CHAR10 | ||||
NMWERK | Transport system In-transit Plant | OIJ_WERK | CHAR | 4 | T001W | WERKS | |||
NMLGORT | Transport system In-transit Storage Location | OIJ_LGORT | CHAR | 4 | T001L | LGORT | |||
NMVEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | OIGV | ALPHA | OIG_VHLNMR | OIV | |
NMVESSEL | TD vehicle identifier | OIG_VEHID | CHAR | 18 | OIG_LICNMR | ||||
NMTPLST | Transportation planning point | TPLST | CHAR | 4 | TTDS | TPLST | TDP | ||
ROUTE | Route | ROUTE | CHAR | 6 | TVRO | ROUTE | |||
BOOKTS | Book TS indicator | OIJ_BOOKTS | CHAR | 1 | XFELD | ||||
EV_GROUP | TD - event default group | OIG_EVGRP | CHAR | 4 | OIG_EVGRP | ||||
VKTRA | Mode of transport | VKTRA | CHAR | 2 | TVTR | VKTRA | |||
QTYIN | Qty received in TS | OIJ_QTYIN | QUAN | 13(3) | MENG13 | ||||
QTYOUT | Qty delivered from TS | OIJ_QTYOUT | QUAN | 13(3) | MENG13 | ||||
UNIT | Nomination(pipe) UoM | OIJ_NMUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TST_FROM_MIN | Scheduled / Acceptance / Pipe Batch Start Timestamp | OIJ_SCHED_F | DEC | 15 | TZNTSTMPS | ||||
TST_TO_MAX | Scheduled / Acceptance / Pipe Batch End Timestamp | OIJ_SCHED_T | DEC | 15 | TZNTSTMPS | ||||
SITYP | Schedule type | OIJ_SITYP | CHAR | 2 | TOIJ_EL_SITYPES | OIJ_SITYP | |||
ISTAT | Nomination Item status | OIJ_ISTAT | CHAR | 1 | OIJSTAT | OIJ_ISTAT | |||
ISUBSTAT | Nomination Item sub-status | OIJ_SSTAT | CHAR | 1 | OIJSUBSTAT | OIJ_SSTAT | |||
IDATE | Scheduled date | OIJ_IDATE | DATS | 8 | DATUM | ||||
SCHED_TST_FROM | Scheduled / Acceptance / Pipe Batch Start Timestamp | OIJ_SCHED_F | DEC | 15 | TZNTSTMPS | ||||
SCHED_TST_TO | Scheduled / Acceptance / Pipe Batch End Timestamp | OIJ_SCHED_T | DEC | 15 | TZNTSTMPS | ||||
LOCID | Location ID | OIJ_LOCID | CHAR | 10 | OIJLOC | OIJ_LOCID | OIX | ||
S_MATNR_I | Scheduled material | OIJ_SMATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
MATNR_I | Demand material | OIJ_MATNRI | CHAR | 18 | MARA | MATN1 | MATNR | ||
MENGE | Scheduled qty | OIJ_MENGE | QUAN | 13(3) | MENG13 | ||||
UNIT_I | Scheduled UoM | OIJ_UNITI | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_I_T | Scheduled UoM Time | OIJ_UNITI_T | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DOCIND | Reference document indicator (PSX) | OIJ_DOCIND | CHAR | 1 | OIJ_DOCIND | ||||
DOCNR | Nomination Reference Document | OIJ_DOCNR | CHAR | 10 | ALPHA | OIJ_DOCNR | |||
DOCITM | Nomination Reference Document Item | OIJ_DOCITM | NUMC | 6 | NUM06 | ||||
DOCSCHEDLN | Nomination Reference Document Schedule line | OIJ_DOCSCHEDLN | NUMC | 4 | Assigned to domain | EETEN | |||
QTYFCR | First requested quantity | OIJ_QTYFCR | QUAN | 13(3) | MENG13 | ||||
QTYFCR_UOM | First Requested Quantity UoM | OIJ_QTYFCR_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WORKLIST_I | Worklist entry indicator | OIJ_WORKLT | CHAR | 1 | XFELD | ||||
TANK | Tankage Partner | OIJ_TANKAGE | CHAR | 10 | ALPHA | OIJ_PARTNR | |||
CONS | Consignee Partner | OIJ_CONSIGNEE | CHAR | 10 | ALPHA | OIJ_PARTNR | |||
PARTNR | Location Partner | OIJ_PARTNR | CHAR | 10 | ALPHA | OIJ_PARTNR | |||
CONPAT | Contract Partner | OIJ_CONPAT | CHAR | 10 | ALPHA | OIJ_PARTNR | |||
INSPE | Inspector | OIJ_INSPECTOR | CHAR | 10 | ALPHA | OIJ_PARTNR | |||
IMPOEXPO | Import / Export Partner | OIJ_IMEXPO | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
FLAG_IMEX | Import / Export Partner Indicator | OIJ_IMEXFL | CHAR | 2 | OIJIMEX | OIJ_IMEXFL | |||
OWNER | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
CHARG_O | Batch origin Location | OIJ_CHARGO | CHAR | 10 | Assigned to domain | CHARG | |||
CHARG_D | Batch destination Location | OIJ_CHARGD | CHAR | 10 | Assigned to domain | CHARG | |||
RVP | RVP value | OIJ_RVP | DEC | 4(1) | DEC3_1 | ||||
VALUATIONTYPE_O | Valuation Type Origin Loc. | OIJ_BWTAR_O | CHAR | 10 | T149D | BWTAR | BWT | ||
VALUATIONTYPE_D | Valuation Type Destination Loc. | OIJ_BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
SHNUM | TD shipment number | OIG_SHNUM | CHAR | 10 | OIGS | ALPHA | OIG_SHNUM | OIS | |
SHITEM | Shipment item | OIG_SHITM | NUMC | 4 | OIGSI | OIG_SHITM | |||
ILOCK | Nomination item complete flag | OIJ_ILOCK | CHAR | 1 | XFELD | ||||
PRORATEQTY | Prorated Quantity | OIJ_PRRA_QTY | QUAN | 13(3) | MENG13 | ||||
ASSIGNEDQTY | Assigned Quantity | OIJ_ASSG_QTY | QUAN | 13(3) | MENG13 | ||||
ACTDAT | Last item action date | OIJ_ACTDAT | DATS | 8 | DATUM | ||||
ACTTIME | Last item action time | OIJ_ACTIME | TIMS | 6 | UZEIT | ||||
ACTUALS | Nomination item partially complete | OIJ_ACTUAL | CHAR | 1 | XFELD | ||||
ACTUALQTY | Actual posted quantity | OIJ_ACTQTY | QUAN | 13(3) | MENG13 | ||||
ACTUALUOM | Actual posted quantity Unit of Measure | OIJ_ACTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
ITBOTOL | Quantity tolerance over (percentage) | OIJ_BOTOL | DEC | 4(1) | DEC3_1 | ||||
ITBUTOL | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 4(1) | DEC3_1 | ||||
ITBOTOLABS | Absolute tolerance qty over | OIJ_TOLABO | QUAN | 13(3) | MENG13 | ||||
ITBUTOLABS | Absolute tolerance qty under | OIJ_TOLABS | QUAN | 13(3) | MENG13 | ||||
ITTOLUNIT | Absolute tolerance UoM | OIJ_TOLUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNLIMITED | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | XFELD | ||||
DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | XFELD | ||||
UPDATEXDOK | Update external details failure flag | OIJ_EXDOK | CHAR | 1 | FLAG | ||||
INCOMPLETE_FLAG | Incompletion Flag | OIJ_INCOMPLETE_FLAG | CHAR | 1 | OIJ_INCOMPLETE_FLAG | ||||
DOCTYP | Reference Document Type | OIJ_DOCTYP | CHAR | 4 | CHAR04 | ||||
LDRATE | Planned load/discharge rate | OIJ_EL_LDRATE | QUAN | 13(3) | MENG13 | ||||
LDQUOM | Planned load/discharge rate quantity UoM | OIJ_EL_LDQUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LDTUOM | Planned load/discharge rate time UOM | OIJ_EL_LDTUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
THIRD_NOMNR | Partner Nomination number | OIJ_3RD_NOMNR | CHAR | 20 | OIJ_NOMNR | ||||
UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
REFITEM | Higher-level item in bill of material structures | OIJ_REF_BOM_ITEM | NUMC | 10 | Assigned to domain | OIJ_ITEM | |||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLKN | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
CHARG_D_CREATE | Destination Batch create new flag | OIJ_CHARG_D_C | CHAR | 1 | XFELD | ||||
CHARG_O_CREATE | Origin Batch create new flag | OIJ_CHARG_O_C | CHAR | 1 | XFELD | ||||
CO_CARR | Connecting carrier | OIJ_EL_CCA | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
CO_SHIP | Connecting shipper | OIJ_EL_CSH | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
CO_TSYST | Connecting Transport System | OIJ_EL_CTSYST | CHAR | 10 | Assigned to domain | OIJ_TSYST | |||
COMMCTL | Nomination Communication Control | OIJ_NOMCOMM | CHAR | 2 | OIJ_NOMCOMM | ||||
SOLDTO | Customer Sold-to or Vendor | OIJ_SOLDTO | CHAR | 10 | ALPHA | OIJ_SOLDTO | |||
PRORATE_ROUTINE | Prorate Calculation Routine Type | OIJ_EL_DE_PR_RT | CHAR | 6 | TOIJ_EL_PR_RT | OIJ_EL_DM_PR_RT | |||
CHARG_L | Batch load | OIJ_CHARGL | CHAR | 10 | Assigned to domain | CHARG | |||
CHARG_L_CREATE | Load Batch create new flag | OIJ_CHARG_L_C | CHAR | 1 | XFELD | ||||
TCNUM | TSW :Trading Contract number | OIJ_TCNR | CHAR | 10 | ALPHA | OIJ_TCNR | |||
TCITM | TSW: Trading contract item number | OIJ_TCITM | NUMC | 6 | OIJ_TCITM | ||||
GA_NMSHIPPER | Shipper | OIJ_SHIPNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
GA_CONF_QTY | Confirmed Quantity | OIJ_CONFQTY | QUAN | 13(3) | MENG13 | ||||
GA_CONF_UOM | Unit of Measure for Confirmed Quantity Field | OIJ_CONFUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GA_TECHSCH_QTY | Technical Scheduled Quantity Field | OIJ_TECHSCHQTY | QUAN | 13(3) | MENG13 | ||||
GA_TECHSCH_UOM | Unit of Measure for Technical Scheduled Quantity Field | OIJ_TECHSCHUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GA_CONF_QTY_CAL | Calculated Values of Confirmed Quantity Field | OIJ_CONFQTY_CAL | QUAN | 13(3) | MENG13 | ||||
GA_TSCH_QTY_CAL | Calculated Values of Technical Scheduled Quantity Field | OIJ_TECHSCH_QTY_CAL | QUAN | 13(3) | MENG13 | ||||
GA_ALLOCATED_QTY | Allocated Quantity | OIJ_ALLOCATED_QTY | QUAN | 13(3) | MENG13 | ||||
GA_ALLOCATED_UOM | Unit of Measure for Allocated Quantity Field | OIJ_ALLOCATED_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GA_RANK | Rank | OIJ_RANK | INT1 | 3 | OIJ_RANK | ||||
CYCLE_ITEM | Nomination Pipeline cycle ID at Item Level | OIJ_ITEMCYCLE | CHAR | 10 | CHAR10 | ||||
LESSHNUM | Shipment Number | TKNUM | CHAR | 10 | VTTK | ALPHA | TKNUM | TNR | SD_F4_SHP_ID |
LESTPNUM | Shipment item | TPNUM | NUMC | 4 | VTTP | TPNUM | |||
ATL_DELV_NUMBER | ATL credit check delivery number | OIJ_ATL_DELV | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
ATL_DELV_ITM | ATL credit check delivery item | OIJ_ATL_DELV_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
ATL_CRDT_QTY | ATL Credit Quantity | OIJ_ATL_CREDIT_QTY | QUAN | 13(3) | MENG13 | ||||
ATL_CRDT_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ATL_CRDT_VAL | ATL Credit Amount | OIJ_ATL_CREDIT_AMT | CURR | 15(2) | WERT8 | ||||
ATL_CRDT_CURR | ATL Credit Currency | OIJ_ATL_CREDIT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
PRE_EXIST_IND | ATL Preexisting Delivery Indicator | OIJ_ATL_PREEXIST_IND | CHAR | 1 | CHAR1_X | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FLTTNOMTK | Nomination (technical) Key | OIJ_NOMTK | CHAR | 20 | Assigned to domain | ALPHA | OIJ_NOMTK | ||
SCHED_QTY | Scheduled qty | OIJ_MENGE | QUAN | 13(3) | MENG13 | ||||
SCHED_UOM | Scheduled UoM | OIJ_UNITI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ITIME | Scheduled time (from) | OIJ_ITIME | TIMS | 6 | TIME | ||||
IDATE_TO | Scheduled date to | OIJ_IDATE_TO | DATS | 8 | DATUM | ||||
ITIME_TO | Scheduled time (to) | OIJ_ITIME_TO | TIMS | 6 | TIME | ||||
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 | ||||
DOCIND_FC | Freight Contract - Operational Terms Ref. Doc. Ind. (RDI) | OIJ_DOCIND_FC | CHAR | 1 | OIJ_DOCIND | ||||
DOCNR_FC | Freight Contract - Operational Terms Reference Document | OIJ_DOCNR_FC | CHAR | 10 | ALPHA | OIJ_DOCNR | |||
DOCITM_FC | Freight Contract - Operational Terms Ref. Doc. Item | OIJ_DOCITM_FC | NUMC | 6 | NUM06 | ||||
CB_IND | TSW: Clipboard indicator | OIJ_CB_IND | CHAR | 1 | BOOLE | ||||
NOM_DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | XFELD | ||||
PERIODIND | Oil-TSW: Period type indicator | OIJ_PERIND | CHAR | 1 | OIJ_PERIND | ||||
UPD_FLAG | Update flag | OIJ_UPDATEFLAG | CHAR | 1 | CHAR1 | ||||
CONTR_QTY | Reference document quantity (SD or MM) | OIJ_CONTR_QTY | QUAN | 13(3) | MENG13 | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
RING_TR | Ring trade identifier | OIJ_EL_RTR | CHAR | 1 | OIJ_EL_RTR | ||||
OICONTNR | Outline agreement: contract | OIC_CONTNR | CHAR | 10 | Assigned to domain | ALPHA | VBELN | KTN | |
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
SCHED_DATE_FROM | Scheduled date from | OIJ_SCHED_D_FROM | DATS | 8 | DATS | ||||
SCHED_TIME_FROM | Scheduled time from | OIJ_SCHED_T_FROM | TIMS | 6 | TIME | ||||
SCHED_DATE_TO | Scheduled date to | OIJ_SCHED_D_TO | DATS | 8 | DATS | ||||
SCHED_TIME_TO | Scheduled time to | OIJ_SCHED_T_TO | TIMS | 6 | TIME | ||||
PEGID_CN | Pegging identifier for Pegtype CN (Carrier Nomination) | OIJ_PEGID_CN | CHAR | 20 | ALPHA | OIJ_PEGID | |||
PEGID_DS | Pegging identifier for Pegtype DS (Demand-Supply) | OIJ_PEGID_DS | CHAR | 20 | ALPHA | OIJ_PEGID | |||
MAXINV | OIL-TSW: Planning maximum inventory level | OIJ_MAXINV | QUAN | 13(3) | MENG13V | ||||
MENGE_R | Scheduled Quantity Rate | OIJ_MENGE_R | QUAN | 13(3) | MENG13 | ||||
LOCID_DESC | TSW Location description | OIJ_LOCID_DESC | CHAR | 35 | CHAR35 | ||||
LOCID_PARENT | OIL-TSW: Parent Location of Bifurcation Branch | OIJ_LOCID_PARENT | CHAR | 10 | Assigned to domain | OIJ_LOCID | |||
BRANCH_NR | OIL-TSW: Number of Bifurcation Branch | OIJ_BRANCH_NR | NUMC | 5 | |||||
BRANCH_SEQ | TSW: Sequence number | OIJ_SEQNR | NUMC | 5 | NUMC | ||||
LOCPT | Location Partner Plant | OIJ_LOCPT | CHAR | 4 | Assigned to domain | WERKS | |||
LOCSL | Location Partner Storage Location | OIJ_LOCSL | CHAR | 4 | Assigned to domain | LGORT | |||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
VSART | Shipping type | VERSART | CHAR | 2 | T173 | VERSART | |||
TSSUOMV | TS standard volume UoM | OIJ_TSUOMV | UNIT | 3 | T006 | CUNIT | MEINS | ||
TEXT_IND | 3WP Text Indicator | OIJ_3WP_TIND | CHAR | 4 | Assigned to domain | ICON | |||
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 | ||
.INCLU-H | 0 | ||||||||
ERDATH | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEITH | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAMH | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATH | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZEITH | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAMH | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
CONSUMED_FLAG | Indicator for consumed 3WP ALV Grid data | OIJ_CONS_FLAG | CHAR | 1 | BOOLEAN | ||||
ALV_LINECOLOR | ALV Color code for grid rows | OIJ_GRID_COLOR | CHAR | 4 | CHAR4 | ||||
LOCK_DB | Data locked in Database | OIJ_LOCK_DB | CHAR | 1 | XFELD | ||||
DEFAULT_NOMTK | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
CELLIO_TAB | 0 | ||||||||
SHOW_FLAG | Flag to select item for display in ALV GRID | OIJ_SHOW_FLAG | CHAR | 1 | XFLAG | ||||
PUBL_FLAG | Flag to filter published items in Distribution Schedule | OIJ_PUBL_FLAG | CHAR | 1 | XFLAG | ||||
ITIMEZONE | Time Zone | TIMEZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
SOLDTO_NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
SHIPTO_NAME1 | Ship-to party name 1 | NAME1_TWE | CHAR | 28 | CHAR28 | ||||
DP_DATE | Date | DATUM | DATS | 8 | DATUM | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIJ_3WP_GRID using ABAP code?
As ROIJ_3WP_GRID 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 as there is no data to select.How to access SAP table ROIJ_3WP_GRID
Within an ECC or HANA version of SAP you can also view further information about ROIJ_3WP_GRID 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