SAP ABAP Table ROIKSD (OIKSD)

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	INTTAB	Structure
Structure	ROIKSD	Table Relationship Diagram
Short Description	OIKSD

Delivery and Maintenance

Pool/cluster
Delivery Class
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	SHNUMBER	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
2	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
3	OIG_SSTSF	☐	OIG_SSTSF	OIG_SSTSF	CHAR	1	0	TD Shipment Status (Functional)
4	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
5	VEH_TEXT	☐	OIG_VHLTXT	OIG_TEXT	CHAR	40	0	TD vehicle header text
6	COMPPL_INDI	☐	OIK_COMPPL_INDI	CHECKBOX	CHAR	1	0	TPI Compartement Planning Indicator
7	LOADPLANT	☐	OIG_LDPLT	WERKS	CHAR	4	0	Loading plant	T001W
8	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
9	SHIPTONAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
10	DOC_TYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
11	DLNUMBER	☐	OIG_DOCNR	OIG_DOCNR	CHAR	10	0	TD document number
12	DLSEQ	☐	OIG_DELSEQ	OIG_DELSEQ	CHAR	4	0	TD document sequence field
13	LOAD_INDI	☐	OIG_LDIND	OIG_LDIND	CHAR	1	0	TD shipment item load indicator
14	DISCH_INDI	☐	OIG_DCIND	OIG_DCIND	CHAR	1	0	TD shipment item discharge indicator
15	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
16	STATUS	☐	OIK_PST	OIK_PST	CHAR	1	0	TPI planning status
17	LED	☐	OIK_LED	CHAR80	CHAR	80	0	Log state indicator for TAS/TPI purposes
18	IND	☐	OIK_DMODE	CHAR80	CHAR	80	0	Display mode indicator for TAS/TPI purposes
19	DLVOLUME	☐	OIK_QUANT	MENG13	QUAN	13	3	Document quantity
20	DLUOM	☐	OIG_SHUOM	MEINS	UNIT	3	0	Shipment unit of measure	T006
21	NDRIVETIME	☐	OIK_NDTIME	TIME	TIMS	6	0	TPI: Non-driving time
22	DRIVETIME	☐	OIK_DTIME	TIME	TIMS	6	0	TPI: Driving time
23	DISTANCE	☐	OIK_DIST	DEC5	DEC	5	0	Distance
24	DISTUOM	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
25	ETA	☐	OIK_ETA	TIME	TIMS	6	0	Estimated Time of Arrival at return plant
26	EDA	☐	OIK_EDA	DATUM	DATS	8	0	Estimated date of arrival at return plant
27	CHECK_STATUS	☐	OIK_STATUS	OIK_STATUS	CHAR	1	0	Check status
28	STATUS_ICON	☐	OIK_STAT_ICON	CHAR80	CHAR	80	0	Check status
29	RADIO_DEL	☐	OIG_RBDEL	OIG_RBDEL	CHAR	1	0	TD Delivery (doc.type) radio button
30	RADIO_RES	☐	OIG_RBRES	OIG_RBRES	CHAR	1	0	TD radio button reservation (doc.type)
31	RADIO_SN	☐	OIG_RBSN	OIG_RBSN	CHAR	1	0	TD radio button: shipping notification(doc.type)
32	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
33	DRIVERCODE	☐	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	*
34	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	*
35	START_TIME	☐	OIG_STTIME	UZEIT	TIMS	6	0	Start time
36	SH_LENGTH	☐	OIK_SHLEN	TIME	TIMS	6	0	Overall Shift length
37	CHG_REASON	☐	OIG_CHREAS	OIG_REASC	CHAR	2	0	OIL-TPI: Change reason code	TOIGS4
38	LOADDATE	☐	OIG_SHSTDT	DATUM	DATS	8	0	Planned date for start of shipment
39	VEH_SCREL	☐	OIG_VHSCREL	OIG_VHLNMR	CHAR	10	0	Freight cost relevant vehicle	OIGV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIKSD	CHG_REASON	TOIGS4	REAS_CODE
2	ROIKSD	DISTUOM	T006	MSEHI
3	ROIKSD	DLUOM	T006	MSEHI
4	ROIKSD	LOADPLANT	T001W	WERKS
5	ROIKSD	SHIFT	TOIGH	SHIFT
6	ROIKSD	SHIPTO	KNA1	KUNNR
7	ROIKSD	SHNUMBER	OIGS	SHNUMBER
8	ROIKSD	VEHICLE	OIGV	VEHICLE
9	ROIKSD	VEH_SCREL	OIGV	VEHICLE
10	ROIKSD	VGBEL	VBUK	VBELN

History

Last changed by/on	SAP	20130529
SAP Release Created in