SAP ABAP Table OIJLOC (Location table)

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in