SAP ABAP Table ROIJLOC (OIL-TSW: Location table (process structure))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJLOC	Table Relationship Diagram
Short Description	OIL-TSW: Location table (process 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	Location table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
4	LOCTYP	☐	OIJ_LOCTYP	OIJ_LOCTYP	CHAR	4	0	OIL-TSW: Location type	OIJLOCT
5	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
6	KNOTE	☐	OIJ_KNOTE	KNOTN	CHAR	10	0	OIL-TSW: Transport connection point (node reference)	TVKN
7	PLANLOC	☐			CHAR	10	0		*
8	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
16	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
17	RDACT	☐	OIJ_RDACT	XFELD	CHAR	1	0	Stock Projection activation indicator
18	.INCLUDE	☐				0	0	Transport System / Location Rate Structure
19	MAXRATE	☐	OIJ_MAXRATE	MENG13	QUAN	13	3	Maximum rate per period
20	MINRATE	☐	OIJ_MINRATE	MENG13	QUAN	13	3	Minimum rate per period
21	OPERATE	☐	OIJ_OPERATE	MENG13	QUAN	13	3	Operating rate per period
22	RATEUOM	☐	OIJ_RATEUOM	MEINS	UNIT	3	0	Rate unit	T006
23	RATEPERD	☐	OIJ_RATEPERD	MEINS	UNIT	3	0	Ttime unit of measurement for rate	T006
24	.INCLUDE	☐				0	0	Transport System/ Location usage structure
25	MAXUSAGE	☐	OIJ_MAXUSAGE	MENG13	QUAN	13	3	Maximum volume per period
26	MINUSAGE	☐	OIJ_MINUSAGE	MENG13	QUAN	13	3	Minimum volume per period
27	OPEUSAGE	☐	OIJ_OPEUSAGE	MENG13	QUAN	13	3	Operating volume/ weight per period
28	USAGEUOM	☐	OIJ_USAGEUOM	MEINS	UNIT	3	0	Usage unit	T006
29	USAGEPERD	☐	OIJ_USAGEPERD	MEINS	UNIT	3	0	Time unit of measument for usage	T006
30	.INCLUDE	☐				0	0	Marine scheduling flags on location
31	SS_RT	☐	OIJ_DE_SS_RT	OIJ_DE_SS_RT	CHAR	12	0	Measurement Comparison calculation routine type	OIJ_SS_RT
32	BSCHFLAG	☐	OIJ_BSCHFLAG	OI0_XFELD	CHAR	1	0	Berth scheduling flag
33	BSCHPERD	☐	OIJ_BSCHPERD	OIJ_PER_5	QUAN	5	0	Berth scheduling period
34	BSCHPUOM	☐	OIJ_BSCHPUOM	MEINS	UNIT	3	0	Unit of measurement for berth scheduling period	T006
35	TANKAGG	☐	OIJ_TANKAGG	XFELD	CHAR	1	0	Aggregate Tank Constraints
36	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
37	UPD_FLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJLOC	BSCHPUOM	T006	MSEHI
2	ROIJLOC	KNOTE	TVKN	KNOTE	REF	1	CN
3	ROIJLOC	LOCTYP	OIJLOCT	LOCTYP	REF	1	CN
4	ROIJLOC	MANDT	T000	MANDT	KEY	1	CN
5	ROIJLOC	PBLNR	OIFSPBL	PBLNR
6	ROIJLOC	RATEPERD	T006	MSEHI
7	ROIJLOC	RATEUOM	T006	MSEHI
8	ROIJLOC	SS_RT	OIJ_SS_RT	SS_RT
9	ROIJLOC	USAGEPERD	T006	MSEHI
10	ROIJLOC	USAGEUOM	T006	MSEHI

History

Last changed by/on	SAP	20050224
SAP Release Created in