SAP ABAP Table ROIKINVH (IS-Oil/TAS Store phys. inventory, header segment)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK_I (Package) TAS (Terminal Automation System)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIKINVH	Table Relationship Diagram
Short Description	IS-Oil/TAS Store phys. inventory, header segment

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

History

Last changed by/on	SAP	20130529
SAP Release Created in