SAP ABAP Table OIK01D (IS-OIL/TAS: deactivated LID Document Data)

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	OIK01D	Table Relationship Diagram
Short Description	IS-OIL/TAS: deactivated LID Document Data

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	.INCLUDE	☑				0	0	IS-OIL/TAS: Key LID Document Data
3	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category
4	DOCNO	☑	OIK_DOCNO	CHAR10	CHAR	10	0	SAP Document Number (TAS)	*
5	ITEMNO	☑	OIK_ITEMNO	NUMC10	NUMC	10	0	SAP document item for TAS
6	LIDNO	☑	OIK_LID	OIK_LID	CHAR	30	0	LOAD ID	OIKLIDW
7	LIDADDON	☑	OIK_LIDADD	TEXT20	CHAR	20	0	LOAD ID ADDON
8	LIDTYPE	☑	OIK_LIDTYP	OIK_LIDTYP	CHAR	6	0	LOAD ID type	OIKLT
9	CONTRTYP	☑	OIK_CNTTYP	OIK_CNTTYP	CHAR	1	0	Control structure type
10	TSTMP	☑	OIK_TSTMP	SYTSTP	NUMC	14	0	Timestamp
11	.INCLUDE	☐				0	0	IS-OIL/TAS: explicit LID Document Data
12	FROMDATE	☐	OIK_VDAT	DATUM	DATS	8	0	Valid from date (TAS)
13	FROMTIME	☐	OIK_VTIME	UZEIT	TIMS	6	0	Valid from-time (TAS)
14	TODATE	☐	OIK_TDAT	DATUM	DATS	8	0	Valid to date (TAS)
15	TOTIME	☐	OIK_TTIME	UZEIT	TIMS	6	0	Valid to Time TAS
16	COPY_FLAG	☐	OIK_COPFLG	CHAR1_X	CHAR	1	0	Copy flag
17	SEND_FLAG	☐	OIK_SNDFLG	CHAR1_X	CHAR	1	0	Flag: LID distributed
18	AUTOA_FLAG	☐	OIK_AUAFLA	CHAR1_X	CHAR	1	0	Automatic LID assignment enabled
19	CONTRSTR	☐	OIK_CNTSTR	OIK_CNTSTR	CHAR	6	0	Control structure	OIKLTC
20	CNTRLIND	☐	OIK_CNTIND	CHAR20	CHAR	20	0	LID control field indicator
21	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
22	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
23	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
24	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
25	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
26	AENAME	☐	AENAME	UNAME	CHAR	12	0	Last Changed By
27	.INCLUDE	☐				0	0	TAS Master Data Information Fields
28	LIDDESC	☐	OIK_LIDTXT	TEXT36	CHAR	36	0	Load ID description
29	LIDDEPOT	☐	OIK_LIDDEP	CHAR30	CHAR	30	0	LID used at depot
30	LID3COD1	☐	OIK_3RDCOD	TEXT30	CHAR	30	0	3rd party code
31	LIDACTIND	☐	OIK_ACTIND	OIK_ACTIND	CHAR	1	0	LID activation indicator
32	LIDDELIND	☐	OIK_DELIND	OIK_DELIND	CHAR	1	0	LID deletion indicator
33	LIDBLKIND	☐	OIK_BLKIND	OIK_BLKIND	CHAR	1	0	LID blocking indicator
34	LIDACTREAS	☐	OIK_ACTRCD	OIK_REACOD	CHAR	2	0	LID activation reason code	OIKLR
35	LIDDELREAS	☐	OIK_DELRCD	OIK_REACOD	CHAR	2	0	LID deletion reason code	OIKLR
36	LIDBLKREAS	☐	OIK_BLKRCD	OIK_REACOD	CHAR	2	0	LID blocking reason code	OIKLR
37	LID3RDPRTY	☐	OIK_3RDDEL	CHAR30	CHAR	30	0	3rd-party delivery number
38	MATNR3RDP	☐	OIK_MAT3RD	TEXT40	CHAR	40	0	3rd party material info
39	MATTXT3RDP	☐	OIK_MTXTRD	TEXT64	CHAR	64	0	3rd party material text
40	CUST3RDP	☐	OIK_CST3RD	TEXT40	CHAR	40	0	3rd party customer info
41	MATNRTAS	☐	OIK_MATTAS	TEXT40	CHAR	40	0	TAS material number
42	ADDITTAS	☐	OIK_ADDTAS	TEXT40	CHAR	40	0	TAS additive number
43	LIDTAS	☐	OIK_LIDTAS	TEXT30	CHAR	30	0	Load ID TAS
44	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
45	MMDOCNR	☐	OIK_MDOCNO	EBELN	CHAR	10	0	SAP MM document number for TAS	EKKO
46	MMDITMNR	☐	OIK_MITMNO	EBELP	NUMC	5	0	SAP MM document item for TAS	EKPO
47	TASGRP1	☐	OIK_TASGRP	OIK_TASGRP	CHAR	8	0	TAS Group 1	TOIKTGRP
48	TASGRP2	☐	OIK_TASGR2	OIK_TASGRP	CHAR	8	0	TAS Group 2	TOIKTGRP
49	FUNCGROUP	☐	OIK_LIDGRP	OIK_LIDGRP	CHAR	6	0	LOAD ID function group	TOIKLIDG
50	SDOCART	☐	OIK_DOCART	AUART	CHAR	4	0	Subsequent document type	TVAK
51	TASCFLAG	☐	OIK_CFLAG	OIK_CFLAG	CHAR	1	0	Check flag for load ID
52	KALSU	☐	KALSU	KALSM	CHAR	6	0	Procedure for material determination	*
53	.INCLUDE	☐				0	0	TAS Master Data - User Fields
54	USERFLD1	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
55	USERFLD2	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
56	USERFLD3	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
57	USERFLD4	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
58	USERFLD5	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
59	USERFLD6	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
60	USERFLD7	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
61	USERFLD8	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
62	USERFLD9	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
63	USERFLD10	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
64	USERFLD11	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
65	USERFLD12	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
66	USERFLD13	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
67	USERFLD14	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
68	USERFLD15	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
69	USERFLD16	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
70	USERFLD17	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
71	USERFLD18	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
72	USERFLD19	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
73	USERFLD20	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
74	.INCLUDE	☐				0	0	Structure for LID control field maintenance
75	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
76	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
77	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
78	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
79	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
80	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHB
81	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
82	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
83	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
84	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
85	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
86	DRIVERCODE	☐	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	OIGD
87	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
88	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
89	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
90	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
91	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIK01D	BWTAR	T149D	BWTAR
2	OIK01D	CHARG	MCHB	CHARG
3	OIK01D	CLIENT	T000	MANDT
4	OIK01D	CONTRSTR	OIKLTC	CONTRSTR
5	OIK01D	DRIVERCODE	OIGD	DRIVERCODE
6	OIK01D	FUNCGROUP	TOIKLIDG	LIDGROUP
7	OIK01D	LGORT	T001L	LGORT
8	OIK01D	LIDACTREAS	OIKLR	REACODE
9	OIK01D	LIDBLKREAS	OIKLR	REACODE
10	OIK01D	LIDDELREAS	OIKLR	REACODE
11	OIK01D	LIDNO	OIKLIDW	LIDNO
12	OIK01D	LIDTYPE	OIKLT	LIDTYPE
13	OIK01D	MATKL	T023	MATKL
14	OIK01D	MATNR	MARA	MATNR
15	OIK01D	MMDITMNR	EKPO	EBELP
16	OIK01D	MMDOCNR	EKKO	EBELN
17	OIK01D	OIC_MOT	TVTR	VKTRA
18	OIK01D	OIHANTYP	OIH5	HANTYP
19	OIK01D	SDOCART	TVAK	AUART
20	OIK01D	SHIFT	TOIGH	SHIFT
21	OIK01D	SHIPTO	KNA1	KUNNR
22	OIK01D	SOLDTO	KNA1	KUNNR
23	OIK01D	TASGRP1	TOIKTGRP	TASGROUP
24	OIK01D	TASGRP2	TOIKTGRP	TASGROUP
25	OIK01D	TPLST	TTDS	TPLST
26	OIK01D	VEHICLE	OIGV	VEHICLE
27	OIK01D	VSBED	TVSB	VSBED
28	OIK01D	VSTEL	TVST	VSTEL
29	OIK01D	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in