SAP Table OIGV
TD Vehicle Header
OIGV (TD Vehicle Header) 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 OIGV to other SAP tables.
OIGV table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | 0 | |||||||||
COMP_GROUP | TD Vehicle Customer group | OIG_VEHCUSTGRP | TOIGBV | CHAR | 8 | 0 | ||||||||
VEH_TYPE | TD vehicle type | OIG_VHLTYP | TOIGV | CHAR | 4 | 0 | ||||||||
VEH_ID | TD vehicle identifier | OIG_VEHID | CHAR | 18 | 0 | |||||||||
CARRIER | TD carrier (vendor account number) | OIG_LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||
VEH_NRTUS | Number of transport units on vehicle (TD) | OIG_NMRTU | NUMC | 2 | 0 | |||||||||
VOL_UOM | TD volume unit of measure | OIG_VOLUOM | T006 | UNIT | 3 | 0 | ||||||||
WGT_UOM | TD weight unit of measure | OIG_WGTUOM | T006 | UNIT | 3 | 0 | ||||||||
DIM_UOM | TD dimension unit of measure | OIG_DIMUOM | T006 | UNIT | 3 | 0 | ||||||||
VEH_MAXWGT | TD vehicle maximum weight | OIG_VEHMWT | FLTP | 16 | 16 | |||||||||
VEH_UNLWGT | TD vehicle unladen weight | OIG_VEHUWT | FLTP | 16 | 16 | |||||||||
VEH_MAXVOL | TD vehicle maximum volume | OIG_VEHMVL | FLTP | 16 | 16 | |||||||||
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 | |||||||||
ROUTE | TD-F vehicle route | OIG_ROUTEV | TVRO | CHAR | 6 | 0 | ||||||||
TZONE | Time Zone | TZNZONE | TTZZ | CHAR | 6 | 0 | ||||||||
CALENDAR | Factory calendar ID | CR_WFCID | TFACD | CHAR | 2 | 0 | ||||||||
DEPOT | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
VEH_SCREL | Freight cost relevant vehicle | OIG_VHSCREL | OIGV | CHAR | 10 | 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 |
Possible values
|
||||||||
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 | |||||||||
AVERAGE_SPEED | Average Speed | OIO_AVR_SPEED_02 | QUAN | 6 | 2 | |||||||||
AVR_SPEED_UOM | Average Speed UoM | OIO_SPEED_UOM_02 | T006 | UNIT | 3 | 0 | ||||||||
DECK_CAPACITY | Deck Capacity | OIO_DECK_CAP_02 | QUAN | 6 | 2 | |||||||||
DECK_CAP_UOM | Deck Capacity UoM | OIO_DECK_UOM_02 | T006 | UNIT | 3 | 0 | ||||||||
ARRIVAL_BUFFER | Arrival Buffer | OIO_ARR_BUFF_02 | DEC | 11 | 0 | |||||||||
DEPARTURE_BUFFER | Departure Buffer | OIO_DEP_BUFF_02 | DEC | 11 | 0 | |||||||||
VEH_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241 | 0 | |||||||||
VEH_PHONE | Vehicle Phone | OIO_VEH_PHONE_02 | CHAR | 30 | 0 | |||||||||
TPPOINT | Transportation planning point | TPLST | TTDS | CHAR | 4 | 0 | ||||||||
VEH_STATUS | TD vehicle status | OIG_VEHSTA | CHAR | 1 | 0 |
Possible values
|
||||||||
CRE_DATE | Created On | ERSDA | DATS | 8 | 0 | |||||||||
CRE_NAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||
CHA_DATE | Date of Last Change | LAEDA | DATS | 8 | 0 | |||||||||
CHA_NAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 |
OIGV foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
OIGV | AVR_SPEED_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
OIGV | AVR_SPEED_UOM | OIGV | AVR_SPEED_UOM | T006 | Units of Measurement | MSEHI |
OIGV | CALENDAR | OIGV | CALENDAR | TFACD | Factory calendar definition | IDENT |
OIGV | CAP_UOM | OIGV | CAP_UOM | T006 | Units of Measurement | MSEHI |
OIGV | CAP_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
OIGV | CARRIER | OIGV | CARRIER | LFA1 | Vendor Master (General Section) | LIFNR |
OIGV | CARRIER | OIGV | CLIENT | LFA1 | Vendor Master (General Section) | MANDT |
OIGV | CLASS_GRP | SYST | MANDT | TOIGVCLGR | Vehicle classification group | MANDT |
OIGV | CLASS_GRP | OIGV | CLASS_GRP | TOIGVCLGR | Vehicle classification group | CLASS_GRP |
OIGV | CLIENT | OIGV | CLIENT | T000 | Clients | MANDT |
OIGV | COMP_GROUP | OIGV | CLIENT | TOIGBV | TD Vehicle Group | CLIENT |
OIGV | COMP_GROUP | OIGV | COMP_GROUP | TOIGBV | TD Vehicle Group | GROUPNAME |
OIGV | DECK_CAP_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
OIGV | DECK_CAP_UOM | OIGV | DECK_CAP_UOM | T006 | Units of Measurement | MSEHI |
OIGV | DEPOT | OIGV | DEPOT | T001W | Plants/Branches | WERKS |
OIGV | DEPOT | SYST | MANDT | T001W | Plants/Branches | MANDT |
OIGV | DIM_UOM | OIGV | CLIENT | T006 | Units of Measurement | MANDT |
OIGV | DIM_UOM | OIGV | DIM_UOM | T006 | Units of Measurement | MSEHI |
OIGV | EQUIP_NR | OIGV | CLIENT | EQUI | Equipment master data | MANDT |
OIGV | EQUIP_NR | OIGV | EQUIP_NR | EQUI | Equipment master data | EQUNR |
OIGV | GRP_ID | SYST | MANDT | TOI0_CP_GRP | Compatibility Group Definition | MANDT |
OIGV | GRP_ID | OIGV | GRP_ID | TOI0_CP_GRP | Compatibility Group Definition | GRP_ID |
OIGV | REG_CNTRY | SYST | MANDT | T005 | Countries | MANDT |
OIGV | REG_CNTRY | OIGV | REG_CNTRY | T005 | Countries | LAND1 |
OIGV | ROUTE | OIGV | CLIENT | TVRO | Routes | MANDT |
OIGV | ROUTE | OIGV | ROUTE | TVRO | Routes | ROUTE |
OIGV | TPPOINT | OIGV | TPPOINT | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
OIGV | TPPOINT | OIGV | CLIENT | TTDS | Organizational Unit: Transportation Scheduling Point | MANDT |
OIGV | TZONE | SYST | MANDT | TTZZ | Time zones | CLIENT |
OIGV | TZONE | OIGV | TZONE | TTZZ | Time zones | TZONE |
OIGV | VEH_SCREL | SYST | MANDT | OIGV | TD Vehicle Header | CLIENT |
OIGV | VEH_SCREL | OIGV | VEH_SCREL | OIGV | TD Vehicle Header | VEHICLE |
OIGV | VEH_TYPE | OIGV | CLIENT | TOIGV | TD Vehicle Type | CLIENT |
OIGV | VEH_TYPE | OIGV | VEH_TYPE | TOIGV | TD Vehicle Type | VEH_TYPE |
OIGV | VOL_UOM | OIGV | CLIENT | T006 | Units of Measurement | MANDT |
OIGV | VOL_UOM | OIGV | VOL_UOM | T006 | Units of Measurement | MSEHI |
OIGV | WGT_UOM | OIGV | CLIENT | T006 | Units of Measurement | MANDT |
OIGV | WGT_UOM | OIGV | WGT_UOM | T006 | Units of Measurement | MSEHI |
OIGV | WT_UOM | OIGV | WT_UOM | T006 | Units of Measurement | MSEHI |
OIGV | WT_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |