SAP ABAP Table OIKLIDR (TD - TAS Reference Table)

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	OIKLIDR	Table Relationship Diagram
Short Description	TD - TAS Reference Table

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	LIDNO	☑	OIK_LID	OIK_LID	CHAR	30	0	LOAD ID	*
3	LIDADDON	☑	OIK_LIDADD	TEXT20	CHAR	20	0	LOAD ID ADDON
4	LIDTYPE	☑	OIK_LIDTYP	OIK_LIDTYP	CHAR	6	0	LOAD ID type	OIKLT
5	FROMDATE	☑	OIK_VDATTS	SYTSTP	NUMC	14	0	Timestamp valid from
6	TODATE	☑	OIK_TDATTS	SYTSTP	NUMC	14	0	Timestamp valid from
7	DOCNO	☑	OIK_DOCNO	CHAR10	CHAR	10	0	SAP Document Number (TAS)
8	ITEMNO	☑	OIK_ITEMNO	NUMC10	NUMC	10	0	SAP document item for TAS
9	DOCTYPE	☑	OIK_DOCTYP	VBTYP	CHAR	1	0	SAP Document Type (TAS)
10	CONTRTYP	☐	OIK_CNTTYP	OIK_CNTTYP	CHAR	1	0	Control structure type
11	.INCLUDE	☐				0	0	TAS Master Data Information Fields
12	LIDDESC	☐	OIK_LIDTXT	TEXT36	CHAR	36	0	Load ID description
13	LIDDEPOT	☐	OIK_LIDDEP	CHAR30	CHAR	30	0	LID used at depot
14	LID3COD1	☐	OIK_3RDCOD	TEXT30	CHAR	30	0	3rd party code
15	LIDACTIND	☐	OIK_ACTIND	OIK_ACTIND	CHAR	1	0	LID activation indicator
16	LIDDELIND	☐	OIK_DELIND	OIK_DELIND	CHAR	1	0	LID deletion indicator
17	LIDBLKIND	☐	OIK_BLKIND	OIK_BLKIND	CHAR	1	0	LID blocking indicator
18	LIDACTREAS	☐	OIK_ACTRCD	OIK_REACOD	CHAR	2	0	LID activation reason code	*
19	LIDDELREAS	☐	OIK_DELRCD	OIK_REACOD	CHAR	2	0	LID deletion reason code	*
20	LIDBLKREAS	☐	OIK_BLKRCD	OIK_REACOD	CHAR	2	0	LID blocking reason code	*
21	LID3RDPRTY	☐	OIK_3RDDEL	CHAR30	CHAR	30	0	3rd-party delivery number
22	MATNR3RDP	☐	OIK_MAT3RD	TEXT40	CHAR	40	0	3rd party material info
23	MATTXT3RDP	☐	OIK_MTXTRD	TEXT64	CHAR	64	0	3rd party material text
24	CUST3RDP	☐	OIK_CST3RD	TEXT40	CHAR	40	0	3rd party customer info
25	MATNRTAS	☐	OIK_MATTAS	TEXT40	CHAR	40	0	TAS material number
26	ADDITTAS	☐	OIK_ADDTAS	TEXT40	CHAR	40	0	TAS additive number
27	LIDTAS	☐	OIK_LIDTAS	TEXT30	CHAR	30	0	Load ID TAS
28	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
29	MMDOCNR	☐	OIK_MDOCNO	EBELN	CHAR	10	0	SAP MM document number for TAS	EKKO
30	MMDITMNR	☐	OIK_MITMNO	EBELP	NUMC	5	0	SAP MM document item for TAS	EKPO
31	TASGRP1	☐	OIK_TASGRP	OIK_TASGRP	CHAR	8	0	TAS Group 1	TOIKTGRP
32	TASGRP2	☐	OIK_TASGR2	OIK_TASGRP	CHAR	8	0	TAS Group 2	TOIKTGRP
33	FUNCGROUP	☐	OIK_LIDGRP	OIK_LIDGRP	CHAR	6	0	LOAD ID function group	TOIKLIDG
34	SDOCART	☐	OIK_DOCART	AUART	CHAR	4	0	Subsequent document type	*
35	TASCFLAG	☐	OIK_CFLAG	OIK_CFLAG	CHAR	1	0	Check flag for load ID
36	KALSU	☐	KALSU	KALSM	CHAR	6	0	Procedure for material determination	*
37	.INCLUDE	☐				0	0	Structure for LID control field maintenance
38	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
39	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
40	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
41	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
43	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHB
44	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
45	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
46	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
47	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
48	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
49	DRIVERCODE	☐	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	OIGD
50	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
51	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
52	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
53	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
54	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
55	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
56	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
57	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
58	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
59	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
60	AENAME	☐	AENAME	UNAME	CHAR	12	0	Last Changed By

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in