SAP table OIGSV (TD Vehicles in Transport/Shipment)

SAP table OIGSV has 3 primary key fields being CLIENT,SHNUMBER,VEH_NR.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
SHNUMBER TD shipment number CHAR 10 0 OIGS OIG_SHNUM
VEH_NR Vehicle Sequence Number in Shipment NUMC 3 0 OIG_VEHNR
VEHICLE TD Vehicle Number CHAR 10 0 OIGV 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
OIG_SSTSF TD Shipment Status (Functional) CHAR 1 0 OIG_SSTSF
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
LDDATE Loading Date DATS 8 0 OIG_LDDATE
LDTIME Loading time TIMS 6 0 OIG_LDTIME
SHIFT TD driver shift CHAR 1 0 TOIGH OIG_SHIFT
TRIP Trip Number NUMC 5 0 OIG_TRIP
RTDATE Date of return DATS 8 0 OIG_RTDATE
RTTIME Time of return TIMS 6 0 OIG_RTTIME
PRINTFLG Output selection flag (indicates print required) CHAR 1 0 OIG_PRNTFL
no output required
1 output required
DDCDAT Document date in delivery confirmation DATS 8 0 OIG_DDCDAT
PSTDAT Posting date in delivery confirmation DATS 8 0 OIG_PSTDAT
MBLNRGL Number of Material Document CHAR 10 0 MBLNR
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
VCLOSE Vehicle close flag; set confirmation to complete (status=6) CHAR 1 0 OIG_VCLOSE
GLPST TD gain/loss postings at vehicle close CHAR 1 0 OIG_GLPST
VBALNC TD vehicle balance check against tolerance table (TOIGS5) CHAR 1 0 OIG_VBALNC
REAS_CODE Reason code - to group quantities in shipment process CHAR 2 0 TOIGS4 OIG_REASCD
CHK_OVL TD check overloading CHAR 1 0 OIG_CHKOVL
CRE_DATE Created On DATS 8 0 ERSDA
CRE_NAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CRE_TIME Time at Which Record Was Added TIMS 6 0 ERZEIT
CHA_DATE Date of Last Change DATS 8 0 LAEDA
CHA_NAME Name of Person Who Changed Object CHAR 12 0 AENAM
CHA_TIME Time of Change TIMS 6 0 AEZEIT
TPPOINT Transportation planning point CHAR 4 0 TTDS TPLST
FBSTA Status of shipment costing vehicle level CHAR 1 0 OIG_VFBSTA
FBGST Overall status of shipment costing vehicle level CHAR 1 0 OIG_VFBGST
ARSTA Status of shipment cost settlement vehicle level CHAR 1 0 OIG_VARSTA
ARGST Overall status of shipment cost settlement vehicle level CHAR 1 0 OIG_VARGST
SKALSM Pricing procedure in vehicle of shipment CHAR 6 0 T683 OIG_KALSM_V

OIGSV foreign key relationships

Table Field Check Table Check Field
0 OIGSV CAP_UOM T006 Units of Measurement MANDT
0 OIGSV CAP_UOM T006 Units of Measurement MSEHI
1 OIGSV CARRIER LFA1 Supplier Master (General Section) MANDT
1 OIGSV CARRIER LFA1 Supplier Master (General Section) LIFNR
0 OIGSV CLASS_GRP TOIGVCLGR Vehicle classification group MANDT
1 OIGSV CLIENT T000 Clients MANDT
0 OIGSV COMP_GROUP TOIGBV TD Vehicle Group CLIENT
1 OIGSV DEPOT T001W Plants/Branches MANDT
1 OIGSV DEPOT T001W Plants/Branches WERKS
0 OIGSV DIM_UOM T006 Units of Measurement MANDT
0 OIGSV DIM_UOM T006 Units of Measurement MSEHI
1 OIGSV EQUIP_NR EQUI Equipment master data MANDT
0 OIGSV GRP_ID TOI0_CP_GRP Compatibility Group Definition GRP_ID
1 OIGSV REAS_CODE TOIGS4 TD Reason Codes CLIENT
0 OIGSV REG_CNTRY T005 Countries MANDT
0 OIGSV REG_CNTRY T005 Countries LAND1
1 OIGSV ROUTE TVRO Routes MANDT
1 OIGSV ROUTE TVRO Routes ROUTE
0 OIGSV SHIFT TOIGH TD Shift Table CLIENT
0 OIGSV SHIFT TOIGH TD Shift Table SHIFT
1 OIGSV SHNUMBER OIGS TD Shipment Header CLIENT
1 OIGSV SHNUMBER OIGS TD Shipment Header SHNUMBER
0 OIGSV SKALSM T683 Pricing procedures KAPPL
0 OIGSV SKALSM T683 Pricing procedures KALSM
1 OIGSV TPPOINT TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 OIGSV TZONE TTZZ Time zones TZONE
1 OIGSV VEHICLE OIGV TD Vehicle Header CLIENT
1 OIGSV VEHICLE OIGV TD Vehicle Header VEHICLE
0 OIGSV VEH_SCREL OIGV TD Vehicle Header CLIENT
0 OIGSV VEH_SCREL OIGV TD Vehicle Header VEHICLE
1 OIGSV WGT_UOM T006 Units of Measurement MANDT
1 OIGSV WGT_UOM T006 Units of Measurement MSEHI
0 OIGSV WT_UOM T006 Units of Measurement MANDT