SAP table OIGV (TD Vehicle Header)

SAP table OIGV has 2 primary key fields being CLIENT,VEHICLE.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
VEHICLE TD Vehicle Number CHAR 10 0 OIG_VHLNMR
COMP_GROUP TD Vehicle Customer group CHAR 8 0 TOIGBV OIG_VEHCUSTGRP
VEH_TYPE TD vehicle type CHAR 4 0 TOIGV OIG_VHLTYP
VEH_ID TD vehicle identifier CHAR 18 0 OIG_VEHID
CARRIER TD carrier (vendor account number) CHAR 10 0 LFA1 OIG_LIFNR
VEH_NRTUS Number of transport units on vehicle (TD) NUMC 2 0 OIG_NMRTU
VOL_UOM TD volume unit of measure UNIT 3 0 T006 OIG_VOLUOM
WGT_UOM TD weight unit of measure UNIT 3 0 T006 OIG_WGTUOM
DIM_UOM TD dimension unit of measure UNIT 3 0 T006 OIG_DIMUOM
VEH_MAXWGT TD vehicle maximum weight FLTP 16 16 OIG_VEHMWT
VEH_UNLWGT TD vehicle unladen weight FLTP 16 16 OIG_VEHUWT
VEH_MAXVOL TD vehicle maximum volume FLTP 16 16 OIG_VEHMVL
EQUIP_NR Equipment Number CHAR 18 0 EQUI EQUNR
VEH_HEIGHT Vehicle height QUAN 13 3 OIG_VEHHEI
VEH_WIDTH TD width QUAN 13 3 OIG_VEHWID
VEH_LENGTH Vehicle length QUAN 13 3 OIG_VEHLEN
ROUTE TD-F vehicle route CHAR 6 0 TVRO OIG_ROUTEV
TZONE Time Zone CHAR 6 0 TTZZ TZNZONE
CALENDAR Factory Calendar ID CHAR 2 0 TFACD CR_WFCID
DEPOT Plant CHAR 4 0 T001W WERKS_D
VEH_SCREL Freight cost relevant vehicle CHAR 10 0 OIGV OIG_VHSCREL
NAME_EFF_DATE Name Effective Date DATS 8 0 OIG_NMEFFDT
CLF_EFDT Vehicle Classification Effective Date DATS 8 0 OIG_CLFEFFDT
REG_CNTRY Vehicle Registered Country/Region CHAR 3 0 T005 OIG_REG_CNTR
REG_DATE TD-Vehicle Registered Date DATS 8 0 OIG_REGDT
OWNER TD-Vehicle Owner CHAR 20 0 OIG_VEH_OWNER
REG_OWNER TD-Vehicle Registered Owner CHAR 20 0 OIG_VEH_REG_OWN
GRP_ID TD-Vehicle Berth Compatibility Group ID CHAR 10 0 TOI0_CP_GRP OIG_BR_CP_GRP_ID
OWN_FLAG TD-Vehicle Own Flag CHAR 1 0 OIG_VOWNFL
No
X Yes
BALLCAP TD-Vehicle Ballast Capacity QUAN 13 3 OIG_BALLCAP
FL_BNK_CAPA TD-Vehicle Fuel Bunker Capacity QUAN 13 3 OIG_FL_BNK_CAPA
DSL_BNK_CAPA TD-Vehicle Diesel Bunker Capacity QUAN 13 3 OIG_DSL_BNK_CAPA
CAP_UOM UoM of TD-Vehicle Bunker Capacity UNIT 3 0 T006 OIG_CAP_UOM
WT_UOM UoM of TD-Vehicle(For Draft) UNIT 3 0 T006 OIG_WT_UOM
CLASS_GRP TD-Vehicle Classification Group CHAR 10 0 TOIGVCLGR OIG_CL_GRP
VHCLSIGN TD-Vehicle Call Sign CHAR 10 0 OIG_VHCLSIGN
STCMNR TD-Vehicle Telex Number CHAR 30 0 OIG_STCMNR
SRFXNR TD-Vehicle Fax Number CHAR 30 0 OIG_STFXNR
DRAFT Maximum Vehicle Draft QUAN 13 3 OIG_VEH_DRAFT
AVERAGE_SPEED Average Speed QUAN 6 2 OIO_AVR_SPEED_02
AVR_SPEED_UOM Average Speed UoM UNIT 3 0 T006 OIO_SPEED_UOM_02
DECK_CAPACITY Deck Capacity QUAN 6 2 OIO_DECK_CAP_02
DECK_CAP_UOM Deck Capacity UoM UNIT 3 0 T006 OIO_DECK_UOM_02
ARRIVAL_BUFFER Arrival Buffer DEC 11 0 OIO_ARR_BUFF_02
DEPARTURE_BUFFER Departure Buffer DEC 11 0 OIO_DEP_BUFF_02
VEH_MAIL E-Mail Address CHAR 241 0 AD_SMTPADR
VEH_PHONE Vehicle Phone CHAR 30 0 OIO_VEH_PHONE_02
TPPOINT Transportation planning point CHAR 4 0 TTDS TPLST
VEH_STATUS TD vehicle status CHAR 1 0 OIG_VEHSTA
Vehicle available
1 Vehicle not available
2 Vehicle to be deleted
CRE_DATE Created On DATS 8 0 ERSDA
CRE_NAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CHA_DATE Date of Last Change DATS 8 0 LAEDA
CHA_NAME Name of Person Who Changed Object CHAR 12 0 AENAM
VEH_XBLCK Business Purpose Completed Indicator for Vehicle CHAR 1 0 VEH_XBLCK
Not Blocked
X Blocked

OIGV foreign key relationships

Table Field Check Table Check Field
0 OIGV AVR_SPEED_UOM T006 Units of Measurement MANDT
1 OIGV CAP_UOM T006 Units of Measurement MANDT
1 OIGV CAP_UOM T006 Units of Measurement MSEHI
0 OIGV CARRIER LFA1 Supplier Master (General Section) MANDT
0 OIGV CARRIER LFA1 Supplier Master (General Section) LIFNR
1 OIGV CLASS_GRP TOIGVCLGR Vehicle classification group MANDT
0 OIGV CLIENT T000 Clients MANDT
1 OIGV COMP_GROUP TOIGBV TD Vehicle Group CLIENT
0 OIGV DECK_CAP_UOM T006 Units of Measurement MANDT
1 OIGV DEPOT T001W Plants/Branches MANDT
1 OIGV DEPOT T001W Plants/Branches WERKS
0 OIGV DIM_UOM T006 Units of Measurement MANDT
0 OIGV DIM_UOM T006 Units of Measurement MSEHI
1 OIGV EQUIP_NR EQUI Equipment master data MANDT
0 OIGV GRP_ID TOI0_CP_GRP Compatibility Group Definition GRP_ID
1 OIGV REG_CNTRY T005 Countries MANDT
1 OIGV REG_CNTRY T005 Countries LAND1
0 OIGV ROUTE TVRO Routes MANDT
0 OIGV ROUTE TVRO Routes ROUTE
1 OIGV TPPOINT TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 OIGV TZONE TTZZ Time zones TZONE
1 OIGV VEH_SCREL OIGV TD Vehicle Header CLIENT
1 OIGV VEH_SCREL OIGV TD Vehicle Header VEHICLE
0 OIGV WGT_UOM T006 Units of Measurement MANDT
0 OIGV WGT_UOM T006 Units of Measurement MSEHI
1 OIGV WT_UOM T006 Units of Measurement MANDT