SAP ABAP Table ROIKLOAD (TAS: Loading related data from depot)

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	ROIKLOAD	Table Relationship Diagram
Short Description	TAS: Loading related data from depot

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	VSTEL_S	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
5	SHIPTO_S	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
6	LOADDATE_S	☐	OIG_LDEDDA	DATUM	DATS	8	0	Actual date for end of loading
7	INTNO_S	☐	OIK_INTNR	NUM4	NUMC	4	0	OIK-OIL/TAS: Interims number
8	ITEMNO_S	☐	OIK_ITEMNO	NUMC10	NUMC	10	0	SAP document item for TAS
9	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
10	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
11	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	*
12	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
13	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
14	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	*
15	BDICH	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
16	BSWCN	☐	OIB_BSWCN	OIB_BSWCN	FLTP	16	16	BSW %
17	MCF	☐	OIB_MCF1	OIB_VCF	FLTP	16	16	Meter correction factor
18	ABIND	☐	OIB_ABIND	OIB_XFELD	CHAR	1	0	Air Bouyancy Indicator
19	HYDRO	☐	OIB_HYDRO	OIB_XFELD	CHAR	1	0	Hydrometer Correction Indicator
20	TRQNT	☐	OIK_TRQNT	OIB_ADQNT	FLTP	16	16	Loaded quantity from depot
21	TRUOM	☐	OIB_TRUOM	MEINS	UNIT	3	0	Transaction entry unit of measure	*
22	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
23	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
24	LOADDATE	☐	OIG_LDEDDA	DATUM	DATS	8	0	Actual date for end of loading
25	LOADTIME	☐	OIG_LDEDTA	UZEIT	TIMS	6	0	Actual time for end of loading
26	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
27	OIB_BLTIME	☐	OIB_BLTIME	TIMES	TIMS	6	0	Posting time in the document
28	.INCLUDE	☐				0	0	TAS LID reference structure
29	.INCLUDE	☐				0	0	TD - TAS Reference Table
30	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
31	LIDNO	☐	OIK_LID	OIK_LID	CHAR	30	0	LOAD ID	*
32	LIDADDON	☐	OIK_LIDADD	TEXT20	CHAR	20	0	LOAD ID ADDON
33	LIDTYPE	☐	OIK_LIDTYP	OIK_LIDTYP	CHAR	6	0	LOAD ID type	OIKLT
34	FROMDATE	☐	OIK_VDATTS	SYTSTP	NUMC	14	0	Timestamp valid from
35	TODATE	☐	OIK_TDATTS	SYTSTP	NUMC	14	0	Timestamp valid from
36	DOCNO	☐	OIK_DOCNO	CHAR10	CHAR	10	0	SAP Document Number (TAS)
37	ITEMNO	☐	OIK_ITEMNO	NUMC10	NUMC	10	0	SAP document item for TAS
38	DOCTYPE	☐	OIK_DOCTYP	VBTYP	CHAR	1	0	SAP Document Type (TAS)
39	CONTRTYP	☐	OIK_CNTTYP	OIK_CNTTYP	CHAR	1	0	Control structure type
40	.INCLUDE	☐				0	0	TAS Master Data Information Fields
41	LIDDESC	☐	OIK_LIDTXT	TEXT36	CHAR	36	0	Load ID description
42	LIDDEPOT	☐	OIK_LIDDEP	CHAR30	CHAR	30	0	LID used at depot
43	LID3COD1	☐	OIK_3RDCOD	TEXT30	CHAR	30	0	3rd party code
44	LIDACTIND	☐	OIK_ACTIND	OIK_ACTIND	CHAR	1	0	LID activation indicator
45	LIDDELIND	☐	OIK_DELIND	OIK_DELIND	CHAR	1	0	LID deletion indicator
46	LIDBLKIND	☐	OIK_BLKIND	OIK_BLKIND	CHAR	1	0	LID blocking indicator
47	LIDACTREAS	☐	OIK_ACTRCD	OIK_REACOD	CHAR	2	0	LID activation reason code	*
48	LIDDELREAS	☐	OIK_DELRCD	OIK_REACOD	CHAR	2	0	LID deletion reason code	*
49	LIDBLKREAS	☐	OIK_BLKRCD	OIK_REACOD	CHAR	2	0	LID blocking reason code	*
50	LID3RDPRTY	☐	OIK_3RDDEL	CHAR30	CHAR	30	0	3rd-party delivery number
51	MATNR3RDP	☐	OIK_MAT3RD	TEXT40	CHAR	40	0	3rd party material info
52	MATTXT3RDP	☐	OIK_MTXTRD	TEXT64	CHAR	64	0	3rd party material text
53	CUST3RDP	☐	OIK_CST3RD	TEXT40	CHAR	40	0	3rd party customer info
54	MATNRTAS	☐	OIK_MATTAS	TEXT40	CHAR	40	0	TAS material number
55	ADDITTAS	☐	OIK_ADDTAS	TEXT40	CHAR	40	0	TAS additive number
56	LIDTAS	☐	OIK_LIDTAS	TEXT30	CHAR	30	0	Load ID TAS
57	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
58	MMDOCNR	☐	OIK_MDOCNO	EBELN	CHAR	10	0	SAP MM document number for TAS	EKKO
59	MMDITMNR	☐	OIK_MITMNO	EBELP	NUMC	5	0	SAP MM document item for TAS	EKPO
60	TASGRP1	☐	OIK_TASGRP	OIK_TASGRP	CHAR	8	0	TAS Group 1	TOIKTGRP
61	TASGRP2	☐	OIK_TASGR2	OIK_TASGRP	CHAR	8	0	TAS Group 2	TOIKTGRP
62	FUNCGROUP	☐	OIK_LIDGRP	OIK_LIDGRP	CHAR	6	0	LOAD ID function group	TOIKLIDG
63	SDOCART	☐	OIK_DOCART	AUART	CHAR	4	0	Subsequent document type	*
64	TASCFLAG	☐	OIK_CFLAG	OIK_CFLAG	CHAR	1	0	Check flag for load ID
65	KALSU	☐	KALSU	KALSM	CHAR	6	0	Procedure for material determination	*
66	.INCLUDE	☐				0	0	Structure for LID control field maintenance
67	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
68	SHIPTO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
69	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
70	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
71	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
72	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHB
73	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
74	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
75	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
76	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
77	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
78	DRIVERCODE	☐	OIG_DRVNMR	OIG_DRVNMR	CHAR	10	0	TD driver number	OIGD
79	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
80	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
81	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
82	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
83	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
84	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
85	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
86	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
87	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
88	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
89	AENAME	☐	AENAME	UNAME	CHAR	12	0	Last Changed By
90	DOCNUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
91	SEGNUM	☐	IDOCDSGNUM	EDI_NUMBER	NUMC	6	0	Number of SAP segment
92	VBTYP_C	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
93	VBELN_C	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
94	POSNR_C	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
95	COPY_FLG_C	☐	OIK_COPFLG	CHAR1_X	CHAR	1	0	Copy flag
96	VBTYP_J	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
97	VBELN_J	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
98	POSNR_J	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
99	COPY_FLG_J	☐	OIK_COPFLG	CHAR1_X	CHAR	1	0	Copy flag
100	ACTION	☐	OIK_ACTFLG	OIK_ACTFLG	CHAR	2	0	Action for TAS and TPI Idoc
101	LOEIN_LIPS	☐	LOEIN	CHAR1	CHAR	1	0	Deletion indicator
102	LOEIN_EKPO	☐	LOEIN	CHAR1	CHAR	1	0	Deletion indicator
103	CHG_REASON	☐	OIG_CHREAS	OIG_REASC	CHAR	2	0	OIL-TPI: Change reason code	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in