SAP ABAP View V_OIJSTAT (View for Complete Status (with Texts))
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_OIJSTAT  
Short Description View for Complete Status (with Texts)    
Root table OIJSTAT   OIL-TSW : Status Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 OIJSTAT OIJSTAT
2 OIJSUBSTAT OIJSUBSTAT
3 OIJSTATT  
4 OIJSUBSTT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 OIJSTATT MANDT JL EQ 0 0
2 OIJSTAT MANDT JR EQ AND 0 0
3 OIJSUBSTAT MANDT JL EQ 0 0
4 OIJSTAT MANDT JR EQ AND 0 0
5 OIJSUBSTT MANDT JL EQ 0 0
6 OIJSTAT MANDT JR EQ AND 0 0
7 OIJSTATT TABNAME JL EQ 0 0
8 OIJSTAT TABNAME JR EQ AND 0 0
9 OIJSUBSTAT TABNAME JL EQ 0 0
10 OIJSTAT TABNAME JR EQ AND 0 0
11 OIJSUBSTT TABNAME JL EQ 0 0
12 OIJSTAT TABNAME JR EQ AND 0 0
13 OIJSTATT STATUS JL EQ 0 0
14 OIJSTAT STATUS JR EQ AND 0 0
15 OIJSUBSTAT STATUS JL EQ 0 0
16 OIJSTAT STATUS JR EQ AND 0 0
17 OIJSUBSTT STATUS JL EQ 0 0
18 OIJSTAT STATUS JR EQ AND 0 0
19 OIJSUBSTT SPRAS JL EQ 0 0
20 OIJSTATT SPRAS JR EQ AND 0 0
21 OIJSUBSTT SUBSTATUS JL EQ 0 0
22 OIJSUBSTAT SUBSTATUS JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT OIJSTAT MANDT   MANDT Client
2 TABNAME OIJSTAT TABNAME   OIJ_REFTAB OIL-TSW: Reference table ID
3 STATUS OIJSTAT STATUS   OIJ_ISTAT Nomination Item status
4 SUBSTATUS OIJSUBSTAT SUBSTATUS   OIJ_SSTAT Nomination Item sub-status
5 TEXT OIJSTATT TEXT   OIJ_TXT15 Short text
6 STEXT OIJSUBSTT STEXT   OIJ_TXT15 Short text
                 
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  20130529 
SAP Release Created in