SAP ABAP View V_OIJNOMI_LDS (View to take tanknr and berthnr from corresponding tables)
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
View Type D Database View 
Database View V_OIJNOMI_LDS  
Short Description View to take tanknr and berthnr from corresponding tables    
Root table OIJBER   Berth Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 OIJBER OIJBER
2 OIISOCIBL  
3 OIJBERLOC  
4 OIJBERSOC  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 OIJBER MANDT JL EQ 0 0
2 OIJBERLOC MANDT JR EQ AND 0 0
3 OIJBER BERID JL EQ 0 0
4 OIJBERLOC BERID JR EQ AND 0 0
5 OIJBERSOC MANDT JL EQ 0 0
6 OIJBER MANDT JR EQ AND 0 0
7 OIJBERSOC BERID JL EQ 0 0
8 OIJBER BERID JR EQ AND 0 0
9 OIISOCIBL MANDT JL EQ 0 0
10 OIJBERLOC MANDT JR EQ AND 0 0
11 OIISOCIBL PBLNR JL EQ 0 0
12 OIJBERLOC PBLNR JR EQ AND 0 0
13 OIISOCIBL SOCNR JL EQ 0 0
14 OIJBERSOC SOCNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT OIJBER MANDT   MANDT Client
2 TNKNR OIISOCIBL TNKNR   OII_BSEQNR Sequence number of SO assigned to business location
3 SOCNR OIISOCIBL SOCNR   OII_SOCNR SOC: Storage object characteristic segment number
4 PBLNR OIISOCIBL PBLNR   OIF_PBLNR Business location identifier (IS-Oil MRN)
5 BERNR OIJBERLOC BERNR   OIJ_BERNR Berth Number
6 BERID OIJBER BERID   OIJ_BERID Berth identifier
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20050224 
SAP Release Created in 46C