SAP ABAP Table M_MVANB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_MVANB	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SMVANG	☑	VVSMVANG	RANL	CHAR	13	0	Lease-out - Offer
4	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
6	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
7	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
8	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
9	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
10	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
11	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
12	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
13	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_MVANB	BUKRS	T001	BUKRS	KEY	1	CN
2	M_MVANB	MANDT	T000	MANDT
3	M_MVANB	SGENR	VIOB03	SGENR	KEY	1	CN
4	M_MVANB	SGRNR	VIOB02	SGRNR	KEY	1	CN
5	M_MVANB	SMENR	VIMI01	SMENR	KEY	1	CN
6	M_MVANB	SMVANART	TIV27	SMVANART	KEY	1	CN
7	M_MVANB	SMVART	TIV26	SMVART	KEY	1	CN
8	M_MVANB	SNUNR	TIV01	SNUNR	REF	1	CN
9	M_MVANB	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in