SAP ABAP Table OIKVD (TPI: Vehicle/Driver assignment)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIKVD	Table Relationship Diagram
Short Description	TPI: Vehicle/Driver assignment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LOADDATE	☑	OIG_SHSTDT	DATUM	DATS	8	0	Planned date for start of shipment
3	SHIFT	☑	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
4	DRIVERCODE	☑	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	OIGD
5	VEHICLE	☑	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
6	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
7	SH_LENGTH	☐	OIK_SHLEN	TIME	TIMS	6	0	Overall Shift length
8	START_TIME	☐	OIG_STTIME	UZEIT	TIMS	6	0	Start time
9	WORK_TIME	☐	OIK_WORKTI	TIME	TIMS	6	0	Maximum work time
10	SHIFT_DATE	☐	OIK_SHDAT	DATUM	DATS	8	0	Shift date
11	DRIVERHOUR	☐	OIK_DRHOUR	TIME	TIMS	6	0	Maximum drive time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIKVD	CLIENT	T000	MANDT
2	OIKVD	DRIVERCODE	OIGD	DRIVERCODE
3	OIKVD	SHIFT	TOIGH	SHIFT
4	OIKVD	TPLST	TTDS	TPLST
5	OIKVD	VEHICLE	OIGV	VEHICLE

History

Last changed by/on	SAP	20110901
SAP Release Created in