OIGV SAP (TD Vehicle Header) Table details
Dictionary Type: Table
Description: TD Vehicle Header
Description: TD Vehicle Header
Table field list including key, data, relationships and ABAP select examples
OIGV is a standard SAP Table which is used to store TD Vehicle Header data and is available within R/3 SAP systems depending on the version and release level.
The OIGV table consists of various fields, each holding specific information or linking keys about TD Vehicle Header data available in SAP. These include VEHICLE (TD Vehicle Number), COMP_GROUP (TD Vehicle Customer group), VEH_TYPE (TD vehicle type), VEH_ID (TD vehicle identifier).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = OIGVT
SAP OIGV table 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 |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | ALPHA | OIG_VHLNMR | OIV | ||
COMP_GROUP | TD Vehicle Customer group | OIG_VEHCUSTGRP | CHAR | 8 | TOIGBV | ALPHA | OIG_VCG | OI9 | |
VEH_TYPE | TD vehicle type | OIG_VHLTYP | CHAR | 4 | TOIGV | OIG_VHLTYP | OIE | ||
VEH_ID | TD vehicle identifier | OIG_VEHID | CHAR | 18 | OIG_LICNMR | ||||
CARRIER | TD carrier (vendor account number) | OIG_LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
VEH_NRTUS | Number of transport units on vehicle (TD) | OIG_NMRTU | NUMC | 2 | OIG_NMRTU | ||||
VOL_UOM | TD volume unit of measure | OIG_VOLUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
WGT_UOM | TD weight unit of measure | OIG_WGTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
DIM_UOM | TD dimension unit of measure | OIG_DIMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
VEH_MAXWGT | TD vehicle maximum weight | OIG_VEHMWT | FLTP | 16(16) | OIB_ADQNT | ||||
VEH_UNLWGT | TD vehicle unladen weight | OIG_VEHUWT | FLTP | 16(16) | OIB_ADQNT | ||||
VEH_MAXVOL | TD vehicle maximum volume | OIG_VEHMVL | FLTP | 16(16) | OIB_ADQNT | ||||
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 | ||||
ROUTE | TD-F vehicle route | OIG_ROUTEV | CHAR | 6 | TVRO | ROUTE | |||
TZONE | Time Zone | TZNZONE | CHAR | 6 | TTZZ | TZNZONE | |||
CALENDAR | Factory calendar ID | CR_WFCID | CHAR | 2 | TFACD | WFCID | FCI | ||
DEPOT | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
VEH_SCREL | Freight cost relevant vehicle | OIG_VHSCREL | CHAR | 10 | OIGV | ALPHA | OIG_VHLNMR | ||
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 | ||||
AVERAGE_SPEED | Average Speed | OIO_AVR_SPEED_02 | QUAN | 6(2) | OIO_AVR_SPEED_02 | ||||
AVR_SPEED_UOM | Average Speed UoM | OIO_SPEED_UOM_02 | UNIT | 3 | T006 | CUNIT | MEINS | ||
DECK_CAPACITY | Deck Capacity | OIO_DECK_CAP_02 | QUAN | 6(2) | OIO_DECK_CAP_02 | ||||
DECK_CAP_UOM | Deck Capacity UoM | OIO_DECK_UOM_02 | UNIT | 3 | T006 | CUNIT | MEINS | ||
ARRIVAL_BUFFER | Arrival Buffer | OIO_ARR_BUFF_02 | DEC | 11 | TSTRN | TSTRDURAN | |||
DEPARTURE_BUFFER | Departure Buffer | OIO_DEP_BUFF_02 | DEC | 11 | TSTRN | TSTRDURAN | |||
VEH_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
VEH_PHONE | Vehicle Phone | OIO_VEH_PHONE_02 | CHAR | 30 | CHAR30 | ||||
TPPOINT | Transportation planning point | TPLST | CHAR | 4 | TTDS | TPLST | TDP | ||
VEH_STATUS | TD vehicle status | OIG_VEHSTA | CHAR | 1 | OIG_VEHSTA | ||||
CRE_DATE | Created On | ERSDA | DATS | 8 | DATUM | ||||
CRE_NAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
CHA_DATE | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
CHA_NAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM |
Key field | Non-key field |
How do I retrieve data from SAP table OIGV using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIGV to SELECT all data from the tableDATA: WA_OIGV TYPE OIGV.
SELECT SINGLE *
FROM OIGV
INTO CORRESPONDING FIELDS OF WA_OIGV
WHERE...
How to access SAP table OIGV
Within an ECC or HANA version of SAP you can also view further information about OIGV 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