SAP ABAP View V_REBDBUNOO (Search Help: Building for Order (Direct Assignment))
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-BD (Application Component) Basic Data
     RE_BD_BU (Package) RE: Building (Master Data)
Basic Data
View Type D Database View 
Database View V_REBDBUNOO  
Short Description Search Help: Building for Order (Direct Assignment)    
Root table VIBDBU   Building 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIBDBU VIBDBU
2 AUFK  
3 VIBDOBJASS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VIBDBU MANDT JL EQ 0 0
2 VIBDOBJASS MANDT JR EQ AND 0 0
3 VIBDBU OBJNR JL EQ 0 0
4 VIBDOBJASS OBJNRSRC JR EQ AND 0 0
5 AUFK MANDT JL EQ 0 0
6 VIBDOBJASS MANDT JR EQ AND 0 0
7 AUFK OBJNR JL EQ 0 0
8 VIBDOBJASS OBJNRTRG JR EQ AND 0 0
9 VIBDOBJASS OBJNRSRC LK 'OR%' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIBDOBJASS MANDT   MANDT Client
2 INTRENO VIBDBU INTRENO   RECAINTRENO Internal Key of Real Estate Object
3 OBJASSTYPE VIBDOBJASS OBJASSTYPE   REBDOBJASSTYPE Type of Object Assignment
4 OBJNRSRC VIBDOBJASS OBJNRSRC   RECAOBJNR Object Number
5 OBJNRTRG VIBDOBJASS OBJNRTRG   RECAOBJNR Object Number
6 VALIDFROM VIBDOBJASS VALIDFROM   REBDRELVALIDFROM Date: Relationship Valid From
7 VALIDTO VIBDOBJASS VALIDTO   REBDRELVALIDTO Date: Relationship Valid To
8 AUFNR AUFK AUFNR   AUFNR Order Number
9 OBJNR VIBDBU OBJNR   RECAOBJNR Object Number
10 AUART AUFK AUART   AUFART Order Type
11 AUTYP AUFK AUTYP   AUFTYP Order category
12 KTEXT AUFK KTEXT   AUFTEXT Description
13 BUKRS VIBDBU BUKRS   BUKRS Company Code
14 SWENR VIBDBU SWENR   REBDBENO Business Entity Number
15 SGENR VIBDBU SGENR   REBDBUNO Number of Building
16 XGETXT VIBDBU XGETXT   REBDXBU Description of Building
17 USGFUNCTION VIBDBU USGFUNCTION   REBDUSGFUNCTION Function of 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 110