SAP ABAP View V_RECNCNH (View for RECNCNH 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_RECNCNH  
Short Description View for RECNCNH Search Help    
Root table VIBDBU   Building 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VIBDBU VIBDBU
2 VICNCN  
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 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 VIBDBU MANDT   MANDT Client
2 INTRENOBU VIBDBU 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 BUKRSBU VIBDBU BUKRS   BUKRS Company Code
6 SWENR VIBDBU SWENR   REBDBENO Business Entity Number
7 SGENR VIBDBU SGENR   REBDBUNO Number of Building
8 XGETXT VIBDBU XGETXT   REBDXBU Description of Building
9 VALIDTO VIBDOBJASS VALIDTO   REBDRELVALIDTO Date: Relationship Valid To
10 RECNTYPE VICNCN RECNTYPE   RECNCONTRACTTYPE Contract Type
11 BUKRS VICNCN BUKRS   BUKRS Company Code
12 RECNNR VICNCN RECNNR   RECNNUMBER Contract Number
13 RECNBEG VICNCN RECNBEG   RECNCNBEG Date of contract start
14 RECNENDABS VICNCN RECNENDABS   RECNCNENDABS Term End Date
15 RECNTXT VICNCN RECNTXT   RECNTXT Contract name
16 OBJNR VICNCN OBJNR   RECAOBJNR Object Number
17 IMKEY VICNCN IMKEY   RECAIMKEY Internal Key of Real Estate Object (FI)
18 BENOCN VICNCN BENOCN   RECNBENOCN Business Entity That Belongs to Contract
                 
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