SAP ABAP Table OIKTT (TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV))

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	OIKTT	Table Relationship Diagram
Short Description	TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV)

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	SHNUMBER	☑	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
3	DLNUMBER	☑	OIG_DOCNR	OIG_DOCNR	CHAR	10	0	TD document number
4	LOADDATE	☐	OIG_SHSTDT	DATUM	DATS	8	0	Planned date for start of shipment
5	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
6	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
7	NDRIVETIME	☐	OIK_NDTIME	TIME	TIMS	6	0	TPI: Non-driving time
8	DRIVETIME	☐	OIK_DTIME	TIME	TIMS	6	0	TPI: Driving time
9	DISTANCE	☐	OIK_DIST	DEC5	DEC	5	0	Distance
10	DISTUOM	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
11	ETA	☐	OIK_ETA	TIME	TIMS	6	0	Estimated Time of Arrival at return plant
12	EDA	☐	OIK_EDA	DATUM	DATS	8	0	Estimated date of arrival at return plant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIKTT	CLIENT	T000	MANDT
2	OIKTT	DISTUOM	T006	MSEHI
3	OIKTT	SHIFT	TOIGH	SHIFT
4	OIKTT	SHIPTO	KNA1	KUNNR
5	OIKTT	SHNUMBER	OIGS	SHNUMBER

History

Last changed by/on	SAP	20110901
SAP Release Created in