SAP ABAP View M_MRTAB (Generated View for Matchcode ID MRTA -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_MRTAB
Short Description	Generated View for Matchcode ID MRTA -B
Root table	VIMIMV	Lease-Out

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIMIMV	VIMIMV
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	1	INACT
2	VIMIMV	MANDT	JR	EQ			AND	0	1	INACT
3	ONR00	OBJNR	JL	EQ				0	1	INACT
4	VIMIMV	SNKS	JR	EQ			AND	0	1	INACT
5	ONR00	MANDT	JL	EQ				0	1	INACT
6	JEST	MANDT	JR	EQ			AND	0	1	INACT
7	ONR00	OBJNR	JL	EQ				0	1	INACT
8	JEST	OBJNR	JR	EQ			AND	0	1	INACT
9	JEST	STAT		EQ	'I0119'		AND	0	5	STAT
10	JEST	INACT		EQ	' '			0	1	INACT

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VIMIMV	MANDT		☐	MANDT	☐	Client
2	BUKRS	VIMIMV	BUKRS		☐	BUKRS	☐	Company Code
3	SMIVE	VIMIMV	SMIVE		☐	SMIVE	☐	Lease-Out Number
4	SWENR	VIMIMV	SWENR		☐	SWENR	☐	Business Entity Number
5	SMENR	VIMIMV	SMENR		☐	SMENR	☐	Number of Rental Unit
6	SMVART	VIMIMV	SMVART		☐	SMVART	☐	External Real Estate contract type
7	SMVANART	VIMIMV	SMVANART		☐	SMVAR	☐	Lease-Out Adjustment Type
8	DMIBEG	VIMIMV	DMIBEG		☐	DMIBE	☐	Rental start date
9	DMIEND	VIMIMV	DMIEND		☐	DMIEN	☐	Rental end date
10	DKUEZU	VIMIMV	DKUEZU		☐	DKUZU	☐	Contract Notice Per
11	OSMIVE	VIMIMV	OSMIVE		☐	VVOSMIVE	☐	Number of old contract
12	KONTOBV	VIMIMV	KONTOBV		☐	VVIKONTOBV	☐	Bank procedure account number
13	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
14	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
15	OBJNR	VIMIMV	SNKS		☐	SNKS	☐	Service Charge Collector Number
16	KUNNR	VIMIMV	KUNNR		☐	VVRDEBIHVP	☐	Customer number main contract partner

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	20110901
SAP Release Created in