SAP ABAP View H_REBDAONOFL (Search Help for Arch. Object by Functional Location)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-BD (Application Component) Basic Data
     RE_BD_AO (Package) RE: Arch. Object (Master Data of Architectural Object)
Basic Data
View Type D Database View 
Database View H_REBDAONOFL  
Short Description Search Help for Arch. Object by Functional Location    
Root table VIBDOBJASS   Object Assignment 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIBDOBJASS VIBDOBJASS
2 IFLOT  
3 VIBDAO  
4 IFLOTX  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 IFLOT MANDT JL EQ 0 0
2 IFLOTX MANDT JR EQ AND 0 0
3 IFLOT TPLNR JL EQ 0 0
4 IFLOTX TPLNR JR EQ AND 0 0
5 IFLOT MANDT JL EQ 0 0
6 VIBDOBJASS MANDT JR EQ AND 0 0
7 IFLOT OBJNR JL EQ 0 0
8 VIBDOBJASS OBJNRTRG JR EQ AND 0 0
9 VIBDOBJASS MANDT JL EQ 0 0
10 VIBDAO MANDT JR EQ AND 0 0
11 VIBDOBJASS OBJNRSRC JL EQ 0 0
12 VIBDAO OBJNR JR EQ AND 0 0
13 VIBDOBJASS OBJASSTYPE EQ '61' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT IFLOTX MANDT   MANDT Client
2 TPLNR IFLOT TPLNR   TPLNR Functional Location
3 OBJNR VIBDAO OBJNR   RECAOBJNR Object Number
4 VALIDFROM VIBDOBJASS VALIDFROM   REBDRELVALIDFROM Date: Relationship Valid From
5 AOID VIBDAO AOID   REBDAOID Identification of Architectural Object
6 AONR VIBDAO AONR   REBDAONR Number of Architectural Object
7 XAO VIBDAO XAO   REBDXAO Name of Architectural Object
8 AOTYPE VIBDAO AOTYPE   REBDAOTYPE Architectural Object Type
9 VALIDTO VIBDOBJASS VALIDTO   REBDRELVALIDTO Date: Relationship Valid To
10 SPRAS IFLOTX SPRAS   SPRAS Language Key
11 PLTXT IFLOTX PLTXT   PLTXT Description of functional location
12 INTRENO VIBDAO INTRENO   REBDINTRENOAO Internal Object Number for Architecture Objects (INTRENO)
13 AOFUNCTION VIBDAO AOFUNCTION   REBDAOFUNCTION Function of Architectural Object
                 
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 200