SAP ABAP Table ROIKLIDW (TAS LID Communication structure)

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	ROIKLIDW	Table Relationship Diagram
Short Description	TAS LID Communication structure

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	.INCLUDE	☐				0	0	TAS LID Working version (NOTE: keep DB eq to DB OIKLID)
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LIDNO	☐	OIK_LID	OIK_LID	CHAR	30	0	LOAD ID	*
4	LIDTYPE	☐	OIK_LIDTYP	OIK_LIDTYP	CHAR	6	0	LOAD ID type	OIKLT
5	CONTRTYP	☐	OIK_CNTTYP	OIK_CNTTYP	CHAR	1	0	Control structure type
6	.INCLUDE	☐				0	0	TAS Master Data Information Fields
7	LIDDESC	☐	OIK_LIDTXT	TEXT36	CHAR	36	0	Load ID description
8	LIDDEPOT	☐	OIK_LIDDEP	CHAR30	CHAR	30	0	LID used at depot
9	LID3COD1	☐	OIK_3RDCOD	TEXT30	CHAR	30	0	3rd party code
10	LIDACTIND	☐	OIK_ACTIND	OIK_ACTIND	CHAR	1	0	LID activation indicator
11	LIDDELIND	☐	OIK_DELIND	OIK_DELIND	CHAR	1	0	LID deletion indicator
12	LIDBLKIND	☐	OIK_BLKIND	OIK_BLKIND	CHAR	1	0	LID blocking indicator
13	LIDACTREAS	☐	OIK_ACTRCD	OIK_REACOD	CHAR	2	0	LID activation reason code	OIKLR
14	LIDDELREAS	☐	OIK_DELRCD	OIK_REACOD	CHAR	2	0	LID deletion reason code	OIKLR
15	LIDBLKREAS	☐	OIK_BLKRCD	OIK_REACOD	CHAR	2	0	LID blocking reason code	OIKLR
16	LID3RDPRTY	☐	OIK_3RDDEL	CHAR30	CHAR	30	0	3rd-party delivery number
17	MATNR3RDP	☐	OIK_MAT3RD	TEXT40	CHAR	40	0	3rd party material info
18	MATTXT3RDP	☐	OIK_MTXTRD	TEXT64	CHAR	64	0	3rd party material text
19	CUST3RDP	☐	OIK_CST3RD	TEXT40	CHAR	40	0	3rd party customer info
20	MATNRTAS	☐	OIK_MATTAS	TEXT40	CHAR	40	0	TAS material number
21	ADDITTAS	☐	OIK_ADDTAS	TEXT40	CHAR	40	0	TAS additive number
22	LIDTAS	☐	OIK_LIDTAS	TEXT30	CHAR	30	0	Load ID TAS
23	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
24	MMDOCNR	☐	OIK_MDOCNO	EBELN	CHAR	10	0	SAP MM document number for TAS	EKKO
25	MMDITMNR	☐	OIK_MITMNO	EBELP	NUMC	5	0	SAP MM document item for TAS	EKPO
26	TASGRP1	☐	OIK_TASGRP	OIK_TASGRP	CHAR	8	0	TAS Group 1	TOIKTGRP
27	TASGRP2	☐	OIK_TASGR2	OIK_TASGRP	CHAR	8	0	TAS Group 2	TOIKTGRP
28	FUNCGROUP	☐	OIK_LIDGRP	OIK_LIDGRP	CHAR	6	0	LOAD ID function group	TOIKLIDG
29	SDOCART	☐	OIK_DOCART	AUART	CHAR	4	0	Subsequent document type	*
30	TASCFLAG	☐	OIK_CFLAG	OIK_CFLAG	CHAR	1	0	Check flag for load ID
31	KALSU	☐	KALSU	KALSM	CHAR	6	0	Procedure for material determination	*
32	.INCLUDE	☐				0	0	User Audit
33	CREAAUTHOR	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
34	CREADATE	☐	CRDATE	DATUM	DATS	8	0	Created on
35	CREATIME	☐	CRTIME	UZEIT	TIMS	6	0	Calendar: Creation or change time
36	CHAUTHOR	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
37	CHDATE	☐	CHDATE	DATUM	DATS	8	0	Changed On
38	CHTIME	☐	CRTIME	UZEIT	TIMS	6	0	Calendar: Creation or change time
39	.INCLUDE	☐				0	0	Structure for LID control field maintenance
40	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
41	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
42	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
43	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
44	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
45	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHB
46	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
47	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
48	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
49	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
50	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
51	DRIVERCODE	☐	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	OIGD
52	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
53	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
54	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
55	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
56	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
57	.INCLUDE	☐				0	0	TAS Master Data - User Fields
58	USERFLD1	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
59	USERFLD2	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
60	USERFLD3	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
61	USERFLD4	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
62	USERFLD5	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
63	USERFLD6	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
64	USERFLD7	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
65	USERFLD8	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
66	USERFLD9	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
67	USERFLD10	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
68	USERFLD11	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
69	USERFLD12	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
70	USERFLD13	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
71	USERFLD14	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
72	USERFLD15	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
73	USERFLD16	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
74	USERFLD17	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
75	USERFLD18	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
76	USERFLD19	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
77	USERFLD20	☐	OIK_TASFLD	TEXT30	CHAR	30	0	TAS user fields
78	CONTRSTR	☐	OIK_CNTSTR	OIK_CNTSTR	CHAR	6	0	Control structure	OIKLTC
79	LIDACTREAT	☐	OIK_REATXT	TEXT36	CHAR	36	0	TAS Load ID reason code text
80	LIDDELREAT	☐	OIK_REATXT	TEXT36	CHAR	36	0	TAS Load ID reason code text
81	LIDBLKREAT	☐	OIK_REATXT	TEXT36	CHAR	36	0	TAS Load ID reason code text
82	LIDACTINDT	☐	OIK_INDTXT	CHAR36	CHAR	36	0	LID indicator text
83	LIDDELINDT	☐	OIK_INDTXT	CHAR36	CHAR	36	0	LID indicator text
84	LIDBLKINDT	☐	OIK_INDTXT	CHAR36	CHAR	36	0	LID indicator text

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in