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 |
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 | |||||||||||||||
OIG_SSTSF | TD Shipment Status (Functional) | OIG_SSTSF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
GLPST | TD gain/loss postings at vehicle close | OIG_GLPST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VBALNC | TD vehicle balance check against tolerance table (TOIGS5) | OIG_VBALNC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
FBGST | Overall status of shipment costing vehicle level | OIG_VFBGST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
ARSTA | Status of shipment cost settlement vehicle level | OIG_VARSTA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
ARGST | Overall status of shipment cost settlement vehicle level | OIG_VARGST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
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 |