SAP ABAP View M_RECNB (Generated View for Matchcode ID RECN -B)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

View Type	D	Database View
Database View	M_RECNB
Short Description	Generated View for Matchcode ID RECN -B
Root table	VICN01	Real Estate Contract: Contract Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VICN01	VICN01
2	ONR00
3	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ONR00	MANDT	JL	EQ				0	0
2	VICN01	MANDT	JR	EQ			AND	0	0
3	ONR00	OBJNR	JL	EQ				0	0
4	VICN01	RECNOBJNR	JR	EQ			AND	0	0
5	ONR00	MANDT	JL	EQ				0	0
6	JEST	MANDT	JR	EQ			AND	0	0
7	ONR00	OBJNR	JL	EQ				0	0
8	JEST	OBJNR	JR	EQ			AND	0	0
9	JEST	STAT		EQ	'I0119'		AND	0	0
10	JEST	INACT		EQ	' '		AND	0	0
11	VICN01	RECNPREDATA		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VICN01	MANDT		☐	MANDT	☐	Client
2	BUKRS	VICN01	BUKRS		☐	BUKRS	☐	Company Code
3	RECNTYPE	VICN01	RECNTYPE		☐	SMVART	☐	External Real Estate contract type
4	RECNNR	VICN01	RECNNR		☐	RECNNR	☐	Real Estate Contract Number
5	RECNADJT	VICN01	RECNADJT		☐	SMVAR	☐	Lease-Out Adjustment Type
6	RECNBEG	VICN01	RECNBEG		☐	RECNBEG	☐	Date of contract start
7	RECNEND	VICN01	RECNEND		☐	RECNEND	☐	Date of contract end
8	RECNNOTPER	VICN01	RECNNOTPER		☐	DKUZU	☐	Contract Notice Per
9	RECNTXTOLD	VICN01	RECNTXTOLD		☐	VVOSMIVE	☐	Number of old contract
10	RECNNRCOLLECT	VICN01	RECNNRCOLLECT		☐	RECNNRCOLLECT	☐	Number of Real Estate main contract
11	RECNTXT	VICN01	RECNTXT		☐	RECNTXT	☐	Contract name
12	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
13	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
14	OBJNR	VICN01	RECNOBJNR		☐	J_OBJNR	☐	Object number
15	RECNMANDATTYP	VICN01	RECNMANDATTYP		☐	RECNMANDATTYP	☐	Role of Contract in Mandate

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