SAP ABAP Table OIL_OIJTS (Oil APPEND to core table (OIJTS retrofitted))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL (Application Component) Industry Solution Oil
     ⤷ OI1_NO_SW (Package) IS-Oil objects w/o switch assignment (use carefully!)

Basic Data

Table Category	APPEND	Append structure
Append structure	OIL_OIJTS	Table Relationship Diagram
Short Description	Oil APPEND to core table (OIJTS retrofitted)

Delivery and Maintenance

Pool/cluster	OIJTS
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	TSNAM	☐	OIJ_TSNAM	OIJ_TSNAM	CHAR	60	0	OIL-TSW: Transport system name
2	.INCLUDE	☐				0	0	OIL-TSW: TS attributes sub-structure
3	BOOKTS	☐	OIJ_BOOKTS	XFELD	CHAR	1	0	Book TS indicator
4	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	T173
5	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
6	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
7	VEHID	☐	OIJ_DEFVEH	OIG_VHLNMR	CHAR	10	0	Default vehicle number	OIGV
8	TSSUOMV	☐	OIJ_TSUOMV	MEINS	UNIT	3	0	TS standard volume UoM	T006
9	TSSUOMM	☐	OIJ_TSUOMM	MEINS	UNIT	3	0	TS standard weight UoM	T006
10	CYCPERD	☐	OIJ_CYCDUR	OIJ_CYCPD	QUAN	10	0	TS cycle duration
11	CYCPUOM	☐	OIJ_CYDUOM	MEINS	UNIT	3	0	TS cycle duration UoM	T006
12	CARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
13	WERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
14	LGORT	☐	OIJ_LGORT	LGORT	CHAR	4	0	Transport system In-transit Storage Location	T001L
15	NOMMSK	☐	OIJ_NOMMSK	OIJ_NOMMSK	CHAR	10	0	Nomination mask
16	SHIPPER	☐	OIJ_SHPPER	OIJ_SHPPER	CHAR	10	0	Default TS shipper code
17	CONLTM	☐	OIJ_CONLTM	OIJ_CONLTM	QUAN	3	0	Carrier lead time
18	CONLUOM	☐	OIJ_CONTUM	MEINS	UNIT	3	0	Confirmation lead time UoM	T006
19	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
20	BOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
21	BUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
22	BOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
23	BUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
24	BULTOLUOM	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
25	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
26	BALCH	☐	OIJ_BALCH	XFELD	CHAR	1	0	Balance check indicator (default)
27	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
28	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
29	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
30	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
31	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
32	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
33	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
34	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
35	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
36	KALSM	☐	OIJ_KALSM	KALSM	CHAR	6	0	Output determination procedure for nominations	T683
37	KAPPL	☐	OIJ_KAPPL	KAPPL	CHAR	2	0	Application in output determination for nominations	T681A
38	KSCHL	☐	OIJ_KSCHL	KSCHL	CHAR	4	0	Output determination/output type for nominations	T685
39	.INCLUDE	☐				0	0
40	.INCLUDE	☐				0	0	Transport System / Location Rate Structure
41	MAXRATE	☐	OIJ_MAXRATE	MENG13	QUAN	13	3	Maximum rate per period
42	MINRATE	☐	OIJ_MINRATE	MENG13	QUAN	13	3	Minimum rate per period
43	OPERATE	☐	OIJ_OPERATE	MENG13	QUAN	13	3	Operating rate per period
44	RATEUOM	☐	OIJ_RATEUOM	MEINS	UNIT	3	0	Rate unit	T006
45	RATEPERD	☐	OIJ_RATEPERD	MEINS	UNIT	3	0	Ttime unit of measurement for rate	T006
46	SEQIND	☐	OIJ_TSSEQIND	OI0_XFELD	CHAR	1	0	Location sequence index
47	MAXUSAGE	☐	OIJ_MAXUSAGE	MENG13	QUAN	13	3	Maximum volume per period
48	MINUSAGE	☐	OIJ_MINUSAGE	MENG13	QUAN	13	3	Minimum volume per period
49	USAGEUOM	☐	OIJ_USAGEUOM	MEINS	UNIT	3	0	Usage unit	T006
50	USAGEPERD	☐	OIJ_USAGEPERD	MEINS	UNIT	3	0	Time unit of measument for usage	T006
51	PIPE_BATCH	☐	OIJ_PIPE_BATCH	OI0_XFELD	CHAR	1	0	Pipeline Batching active
52	VEL_AVG	☐	OIJ_VEL_AVG	MENG13	QUAN	13	3	Average Velocity
53	VEL_MAX	☐	OIJ_VEL_MAX	MENG13	QUAN	13	3	Maximum Velocity
54	VEL_MIN	☐	OIJ_VEL_MIN	MENG13	QUAN	13	3	Minimum Velocity
55	BUSTYP	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
56	VEL_UOM	☐	OIJ_VEL_UOM	MEINS	UNIT	3	0	Velocity UoM	T006
57	VEL_UOMT	☐	OIJ_VEL_UOMT	MEINS	UNIT	3	0	Velocity - Time	*
58	ROUTE_TOLERANCE	☐	OIJ_ROUTE_TOLERANCE	INT1	INT1	3	0	Tolerance in percent for stage duration for timestamp check
59	RDTSACT	☐	OIJ_RDACT	XFELD	CHAR	1	0	Stock Projection activation indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIL_OIJTS	BULTOLUOM	T006	MSEHI	KEY	1	CN
2	OIL_OIJTS	BUSTYP	OIRARNBT	RNBT
3	OIL_OIJTS	CARRIER	LFA1	LIFNR	KEY	C	CN
4	OIL_OIJTS	CONLUOM	T006	MSEHI	KEY	1	CN
5	OIL_OIJTS	CYCPUOM	T006	MSEHI	KEY	1	CN
6	OIL_OIJTS	KALSM	T683	KALSM	REF	1	CN
7	OIL_OIJTS	KAPPL	T681A	KAPPL	REF	1	CN
8	OIL_OIJTS	KSCHL	T685	KSCHL	REF	1	CN
9	OIL_OIJTS	LGORT	T001L	LGORT	KEY	1	CN
10	OIL_OIJTS	RATEPERD	T006	MSEHI
11	OIL_OIJTS	RATEUOM	T006	MSEHI
12	OIL_OIJTS	SHTYPE	TOIGS	SHTYP	KEY	1	CN
13	OIL_OIJTS	TPLST	TTDS	TPLST	KEY	1	CN
14	OIL_OIJTS	TSSUOMM	T006	MSEHI	KEY	1	CN
15	OIL_OIJTS	TSSUOMV	T006	MSEHI	KEY	1	CN
16	OIL_OIJTS	USAGEPERD	T006	MSEHI
17	OIL_OIJTS	USAGEUOM	T006	MSEHI
18	OIL_OIJTS	VEHID	OIGV	VEHICLE	KEY	1	CN
19	OIL_OIJTS	VEL_UOM	T006	MSEHI
20	OIL_OIJTS	VKTRA	TVTR	VKTRA	KEY	1	CN
21	OIL_OIJTS	VSART	T173	VSART	KEY	1	CN
22	OIL_OIJTS	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	472