SAP Table OIGSV

TD Vehicles in Transport/Shipment

OIGSV (TD Vehicles in Transport/Shipment) 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 OIGSV to other SAP tables.

OIGSV table fields

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

OIGSV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIGSV CALENDAR OIGSV CALENDAR TFACD Factory calendar definition IDENT
OIGSV CAP_UOM SYST MANDT T006 Units of Measurement MANDT
OIGSV CAP_UOM OIGSV CAP_UOM T006 Units of Measurement MSEHI
OIGSV CARRIER OIGV CLIENT LFA1 Vendor Master (General Section) MANDT
OIGSV CARRIER OIGSV CARRIER LFA1 Vendor Master (General Section) LIFNR
OIGSV CLASS_GRP SYST MANDT TOIGVCLGR Vehicle classification group MANDT
OIGSV CLASS_GRP OIGSV CLASS_GRP TOIGVCLGR Vehicle classification group CLASS_GRP
OIGSV CLIENT OIGSV CLIENT T000 Clients MANDT
OIGSV COMP_GROUP OIGV CLIENT TOIGBV TD Vehicle Group CLIENT
OIGSV COMP_GROUP OIGSV COMP_GROUP TOIGBV TD Vehicle Group GROUPNAME
OIGSV DEPOT OIGSV DEPOT T001W Plants/Branches WERKS
OIGSV DEPOT SYST MANDT T001W Plants/Branches MANDT
OIGSV DIM_UOM OIGSV DIM_UOM T006 Units of Measurement MSEHI
OIGSV DIM_UOM OIGV CLIENT T006 Units of Measurement MANDT
OIGSV EQUIP_NR OIGV CLIENT EQUI Equipment master data MANDT
OIGSV EQUIP_NR OIGSV EQUIP_NR EQUI Equipment master data EQUNR
OIGSV GRP_ID SYST MANDT TOI0_CP_GRP Compatibility Group Definition MANDT
OIGSV GRP_ID OIGSV GRP_ID TOI0_CP_GRP Compatibility Group Definition GRP_ID
OIGSV REAS_CODE OIGSV CLIENT TOIGS4 TD Reason Codes CLIENT
OIGSV REAS_CODE '8' TOIGS4 TD Reason Codes TDACT
OIGSV REAS_CODE OIGSV REAS_CODE TOIGS4 TD Reason Codes REAS_CODE
OIGSV REG_CNTRY SYST MANDT T005 Countries MANDT
OIGSV REG_CNTRY OIGSV REG_CNTRY T005 Countries LAND1
OIGSV ROUTE OIGSV CLIENT TVRO Routes MANDT
OIGSV ROUTE OIGSV ROUTE TVRO Routes ROUTE
OIGSV SHIFT OIGSV CLIENT TOIGH TD Shift Table CLIENT
OIGSV SHIFT OIGSV SHIFT TOIGH TD Shift Table SHIFT
OIGSV SHNUMBER OIGSV CLIENT OIGS TD Shipment Header CLIENT
OIGSV SHNUMBER OIGSV SHNUMBER OIGS TD Shipment Header SHNUMBER
OIGSV SKALSM OIGSV SKALSM T683 Pricing procedures KALSM
OIGSV SKALSM OIGSV CLIENT T683 Pricing procedures MANDT
OIGSV SKALSM 'A' T683 Pricing procedures KVEWE
OIGSV SKALSM 'F' T683 Pricing procedures KAPPL
OIGSV TPPOINT OIGSV TPPOINT TTDS Organizational Unit: Transportation Scheduling Point TPLST
OIGSV TPPOINT OIGSV CLIENT TTDS Organizational Unit: Transportation Scheduling Point MANDT
OIGSV TZONE SYST MANDT TTZZ Time zones CLIENT
OIGSV TZONE OIGSV TZONE TTZZ Time zones TZONE
OIGSV VEHICLE OIGSV VEHICLE OIGV TD Vehicle Header VEHICLE
OIGSV VEHICLE OIGSV CLIENT OIGV TD Vehicle Header CLIENT
OIGSV VEH_SCREL SYST MANDT OIGV TD Vehicle Header CLIENT
OIGSV VEH_SCREL OIGSV VEH_SCREL OIGV TD Vehicle Header VEHICLE
OIGSV VEH_TYPE OIGV CLIENT TOIGV TD Vehicle Type CLIENT
OIGSV VEH_TYPE OIGSV VEH_TYPE TOIGV TD Vehicle Type VEH_TYPE
OIGSV VOL_UOM OIGV CLIENT T006 Units of Measurement MANDT
OIGSV VOL_UOM OIGSV VOL_UOM T006 Units of Measurement MSEHI
OIGSV WGT_UOM OIGV CLIENT T006 Units of Measurement MANDT
OIGSV WGT_UOM OIGSV WGT_UOM T006 Units of Measurement MSEHI
OIGSV WT_UOM SYST MANDT T006 Units of Measurement MANDT
OIGSV WT_UOM OIGSV WT_UOM T006 Units of Measurement MSEHI