SAP ABAP View V_RECNCNB (View for Search Help RECNCNB)
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_RECNCNB  
Short Description View for Search Help RECNCNB    
Root table VICNCN   Real Estate Contract 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VICNCN VICNCN
2 JEST  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VICNCN MANDT JL EQ 0 0
2 JEST MANDT JR EQ AND 0 0
3 VICNCN OBJNR JL EQ 0 0
4 JEST OBJNR JR EQ AND 0 0
5 JEST STAT EQ 'I0119' AND 0 0
6 JEST INACT EQ ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VICNCN MANDT   MANDT Client
2 INTRENO VICNCN INTRENO   RECAINTRENO Internal Key of Real Estate Object
3 OBJNR JEST OBJNR   RECAOBJNR Object Number
4 STAT JEST STAT   J_STATUS Object status
5 BUKRS VICNCN BUKRS   BUKRS Company Code
6 RECNTYPE VICNCN RECNTYPE   RECNCONTRACTTYPE Contract Type
7 RECNNR VICNCN RECNNR   RECNNUMBER Contract Number
8 RECNBEG VICNCN RECNBEG   RECNCNBEG Date of contract start
9 RECNENDABS VICNCN RECNENDABS   RECNCNENDABS Term End Date
10 RECNTXT VICNCN RECNTXT   RECNTXT Contract name
11 INDUSTRY VICNCN INDUSTRY   BU_IND_SECTOR Industry
12 SRRELEVANT VICNCN SRRELEVANT   RECNSALESRENTRELEVANT Relevant to Sales
13 RECNNOTPER VICNCN RECNNOTPER   RECNNTPER Contract Notice Per
14 RECNNOTREASON VICNCN RECNNOTREASON   RECNNTREASON Reason for Notice
15 RESPONSIBLE VICNCN RESPONSIBLE   RECARESPONSIBLE Person Responsible
16 AUTHGRP VICNCN AUTHGRP   RECAAUTHGRP Authorization Group
17 RECNBUKRSCOLLECT VICNCN RECNBUKRSCOLLECT   RECNBUKRSCOLLECT Company code of main contract
18 RECNNRCOLLECT VICNCN RECNNRCOLLECT   RECNNUMBERCOLLECT Number of Real Estate Main Contract
19 RECNTXTOLD VICNCN RECNTXTOLD   VVOSMIVE Number of old contract
20 BENOCN VICNCN BENOCN   RECNBENOCN Business Entity That Belongs to Contract
21 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