SAP ABAP Table OIJBERSOC (Assignment of berths to tanks)

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	OIJBERSOC	Table Relationship Diagram
Short Description	Assignment of berths to tanks

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	SOCNR	☑	OII_SOCNR	OII_SOCNR	CHAR	20	0	SOC: Storage object characteristic segment number	OIISOCK
3	BERID	☑	OIJ_BERID	OIJ_BERID	CHAR	20	0	Berth identifier	OIJBER
4	LSYST	☑	OIJ_LSYST	OIJ_TSYST	CHAR	10	0	Loading system	OIJTS
5	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
11	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
13	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJBERSOC	BERID	OIJBER	BERID	KEY	1	CN
2	OIJBERSOC	LSYST	OIJTS	TSYST
3	OIJBERSOC	MANDT	T000	MANDT		1	CN
4	OIJBERSOC	SOCNR	OIISOCK	SOCNR	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	46C