SAP ABAP View V_RECNCNE (View for RECNCNE Search Help)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-CN (Application Component) Real Estate Contract
     RE_CN_CN (Package) RE: Contract
Basic Data
View Type D Database View 
Database View V_RECNCNE  
Short Description View for RECNCNE Search Help    
Root table VIBDRO   Rental Object 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIBDRO VIBDRO
2 VICNCN  
3 VIBDOBJASS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VIBDRO MANDT JL EQ 0 0
2 VIBDOBJASS MANDT JR EQ AND 0 0
3 VIBDRO OBJNR JL EQ 0 0
4 VIBDOBJASS OBJNRTRG JR EQ AND 0 0
5 VIBDOBJASS MANDT JL EQ 0 0
6 VICNCN MANDT JR EQ AND 0 0
7 VIBDOBJASS OBJNRSRC JL EQ 0 0
8 VICNCN OBJNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VIBDRO MANDT   MANDT Client
2 INTRENORO VIBDRO INTRENO   RECAINTRENO Internal Key of Real Estate Object
3 VALIDFROM VIBDOBJASS VALIDFROM   REBDRELVALIDFROM Date: Relationship Valid From
4 INTRENO VICNCN INTRENO   RECAINTRENO Internal Key of Real Estate Object
5 BUKRSRO VIBDRO BUKRS   BUKRS Company Code
6 SWENR VIBDRO SWENR   REBDBENO Business Entity Number
7 SGRNR VIBDRO SGRNR   REBDPRNO Number of Land
8 SGENR VIBDRO SGENR   REBDBUNO Number of Building
9 SMENR VIBDRO SMENR   REBDRONO Number of Rental Object
10 XMETXT VIBDRO XMETXT   REBDXRO Rental Object Name
11 ROTYPE VIBDRO ROTYPE   REBDROTYPE Rental Object Type
12 SNUNR VIBDRO SNUNR   REBDUSAGETYPE Usage Type of Rental Object
13 VALIDTO VIBDOBJASS VALIDTO   REBDRELVALIDTO Date: Relationship Valid To
14 RECNTYPE VICNCN RECNTYPE   RECNCONTRACTTYPE Contract Type
15 BUKRS VICNCN BUKRS   BUKRS Company Code
16 RECNNR VICNCN RECNNR   RECNNUMBER Contract Number
17 RECNBEG VICNCN RECNBEG   RECNCNBEG Date of contract start
18 RECNENDABS VICNCN RECNENDABS   RECNCNENDABS Term End Date
19 RECNTXT VICNCN RECNTXT   RECNTXT Contract name
20 BENOCN VICNCN BENOCN   RECNBENOCN Business Entity That Belongs to Contract
21 OBJNR VICNCN OBJNR   RECAOBJNR Object Number
22 IMKEY VICNCN IMKEY   RECAIMKEY Internal Key of Real Estate Object (FI)
                 
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