0OI_TD_OIGSV

Vehicles in shipments | #TRAN | Extraction method: F1 | No Delta | Component: Oil & Gas
Tables used: OIGSOIGSVOIGSSOIGSVCOIGV ... +19 more
Column Name Description
SHNUMBER FK TD shipment number
VEHICLE TD Vehicle Number
TPU_NR Transport unit sequence number in shipment
TU_NUMBER TD transport unit number
Column Name Description
Column Name Description
📏 Distance Unit of Measure (MEDST):
DISTZ Distance
Column Name Description
CRE_DATE Date on which the record was created
CRE_TIME Entry time
CHA_DATE Last Changed On
CHA_TIME Time last change was made
LOAD_STDTA Date for start of loading
LOAD_STTMA Actual time for start of loading
LOAD_EDDTA Actual date for end of loading
LOAD_EDTMA Actual time for end of loading
DEL_STDTA Actual date for start of delivery confirmation
DEL_STTMA Actual time for start of delivery confirmation
DEL_EDDTA Actual date for end of delivery confirm
DEL_EDTMA Actual time for end of delivery confirmation
LDDATE Loading Date
LDTIME Loading time
RTDATE Date of return
RTTIME Time of return
DDCDAT Document date in delivery confirmation
PSTDAT Posting date in delivery confirmation
Column Name Description
VEH_MODE TD vehicle mode of transport Show values
FRKRL_VEH TD - shipment cost relevance for vehicles Show values
SCLDTYPE TD-F -Shipment costing based on loaded or disch. quantitites Show values
OIG_SSTSF TD Shipment Status (Functional) Show values
FBGST Overall status of calculation of shipment costs for shipment Show values
ARGST Total status of shipment costs settlement for shipment Show values
FBGST_V Overall status of shipment costing vehicle level Show values
ARGST_V Overall status of shipment cost settlement vehicle level Show values
Column Name Description Domain name
SHTYPE TD shipment type OIG_TDSTYP
XBLNR Reference Document Number XBLNR1
FKART Shipment cost type FKART_T
TPLST Transportation planning point TPLST
CRE_NAME Name of Person Responsible for Creating the Object USNAM
CHA_NAME Name of Person Who Changed Object USNAM
COMP_GROUP TD vehicle group OIG_VCG
VEH_TYPE TD vehicle type OIG_VHLTYP
VEH_ID TD vehicle identifier OIG_LICNMR
CARRIER TD carrier (vendor account number) LIFNR
VEH_NRTUS Number of transport units on vehicle (TD) OIG_NMRTU
EQUIP_NR_V Equipment number - vehicle EQUNR
ROUTE TD-F vehicle route ROUTE
SHIFT TD driver shift OIG_SHIFT
TRIP Trip Number OIG_TRIP
TU_TYPE TD Transport unit type OIG_TRUTYP
TU_ID TD transport unit identifier OIG_LICNMR
TU_NRCOMPS Number of compartments (TD) OIB_UOMGR
TU_NRMETS TD number of meters on the transport unit OIB_UOMGR
EQUIP_NR_T Equipment number -(transport unit) EQUNR
SHNUM_PRV Previous shipment number OIG_SHNUM
SHNUM_NXT Next shipment number OIG_SHNUM
RECFLGPTL Indicator for reconciliation of prior to load CHAR1
RECFLGLOV Indicator for reconciliation of left on vehicle qty. CHAR1
GESZTD TD Planned total time for stage (in days) TSTRDURAG
FAHZTD TD - planned duration for stage (in hours:minutes) TSTRDURAN
GESZTDA TD - actual total time for shipment stage (in days) TSTRDURAG
FAHZTDA TD - actual duration for shipment stage (in hours:minutes) TSTRDURAN
COUNTER 4 Byte Signed Integer INT4