OIGSV SAP (TD Vehicles in Transport/Shipment) Table details
Dictionary Type: Table
Description: TD Vehicles in Transport/Shipment
Description: TD Vehicles in Transport/Shipment
Table field list including key, data, relationships and ABAP select examples
OIGSV is a standard SAP Table which is used to store TD Vehicles in Transport/Shipment data and is available within R/3 SAP systems depending on the version and release level.
The OIGSV table consists of various fields, each holding specific information or linking keys about TD Vehicles in Transport/Shipment data available in SAP. These include SHNUMBER (TD shipment number), VEH_NR (Vehicle Sequence Number in Shipment), VEHICLE (TD Vehicle Number), COMP_GROUP (TD Vehicle Customer group).. 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)
SAP OIGSV 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 | |||
SHNUMBER | TD shipment number | OIG_SHNUM | CHAR | 10 | OIGS | ALPHA | OIG_SHNUM | OIS | |
VEH_NR | Vehicle Sequence Number in Shipment | OIG_VEHNR | NUMC | 3 | OIG_VEHNR | ||||
VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | OIGV | 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 | ||||
OIG_SSTSF | TD Shipment Status (Functional) | OIG_SSTSF | CHAR | 1 | OIG_SSTSF | ||||
LDDATE | Loading Date | OIG_LDDATE | DATS | 8 | DATUM | ||||
LDTIME | Loading time | OIG_LDTIME | TIMS | 6 | TIME | ||||
SHIFT | TD driver shift | OIG_SHIFT | CHAR | 1 | TOIGH | OIG_SHIFT | |||
TRIP | Trip Number | OIG_TRIP | NUMC | 5 | OIG_TRIP | ||||
RTDATE | Date of return | OIG_RTDATE | DATS | 8 | DATUM | ||||
RTTIME | Time of return | OIG_RTTIME | TIMS | 6 | TIME | ||||
PRINTFLG | Output selection flag (indicates print required) | OIG_PRNTFL | CHAR | 1 | OIG_PRNTFL | ||||
DDCDAT | Document date in delivery confirmation | OIG_DDCDAT | DATS | 8 | DATUM | ||||
PSTDAT | Posting date in delivery confirmation | OIG_PSTDAT | DATS | 8 | DATUM | ||||
MBLNRGL | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
VCLOSE | Vehicle close flag; set confirmation to complete (status=6) | OIG_VCLOSE | CHAR | 1 | CHAR1_X | ||||
GLPST | TD gain/loss postings at vehicle close | OIG_GLPST | CHAR | 1 | CHAR1_X | ||||
VBALNC | TD vehicle balance check against tolerance table (TOIGS5) | OIG_VBALNC | CHAR | 1 | CHAR1_X | ||||
REAS_CODE | Reason code - to group quantities in shipment process | OIG_REASCD | CHAR | 2 | TOIGS4 | OIG_REASC | |||
CHK_OVL | TD check overloading | OIG_CHKOVL | CHAR | 1 | CHAR1_X | ||||
CRE_DATE | Created On | ERSDA | DATS | 8 | DATUM | ||||
CRE_NAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
CRE_TIME | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
CHA_DATE | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
CHA_NAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
CHA_TIME | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
TPPOINT | Transportation planning point | TPLST | CHAR | 4 | TTDS | TPLST | TDP | ||
FBSTA | Status of shipment costing vehicle level | OIG_VFBSTA | CHAR | 1 | FBSTA | ||||
FBGST | Overall status of shipment costing vehicle level | OIG_VFBGST | CHAR | 1 | FBGST | ||||
ARSTA | Status of shipment cost settlement vehicle level | OIG_VARSTA | CHAR | 1 | ARSTA | ||||
ARGST | Overall status of shipment cost settlement vehicle level | OIG_VARGST | CHAR | 1 | ARGST | ||||
SKALSM | Pricing procedure in vehicle of shipment | OIG_KALSM_V | CHAR | 6 | T683 | KALSM |
Key field | Non-key field |
How do I retrieve data from SAP table OIGSV using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIGSV to SELECT all data from the tableDATA: WA_OIGSV TYPE OIGSV.
SELECT SINGLE *
FROM OIGSV
INTO CORRESPONDING FIELDS OF WA_OIGSV
WHERE...
How to access SAP table OIGSV
Within an ECC or HANA version of SAP you can also view further information about OIGSV 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