SAP ABAP Table RVIMI28_ZS (RE: Lease-Out - Sales Settlement History and Addit.Fields)

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

Table Category	INTTAB	Structure
Structure	RVIMI28_ZS	Table Relationship Diagram
Short Description	RE: Lease-Out - Sales Settlement History and Addit.Fields

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	.INCLUDE	☐				0	0	Sales settlement histories
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
7	YUMSJ	☐	VVYUMSJ	GJAHR	NUMC	4	0	Sales year
8	UMSDATE	☐	VVUMSVDATE	DDAT	DATS	8	0	Last sales settlement upto...
9	SKOART	☐	VVSKOART	SKOART	NUMC	4	0	Condition: Type	TZK01
10	PPROZJ	☐	PPROZJ	DEC3_2	DEC	5	2	Sales year percentage rate
11	BUMVR	☐	VVBUMVR	WRTV7	CURR	13	2	Sales settlement amount
12	BVZGM	☐	VVBVZGM	WRTV7	CURR	13	2	Customer advance payment of basic rent on sales-based lease
13	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
14	VVABBLN	☐	VVABBLN1	XBLNR1	CHAR	16	0	Settlement Identification ->Accounting Ref. Doc.Number
15	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
16	BMWSTSALDO	☐	BMWSTSALDO	WRTV7	CURR	13	2	Clearing balance tax amount
17	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
18	BMELD	☐	BMELD01	WRTV7	CURR	13	2	Reported sales
19	MON_PA	☐	VVMONAT	NUM2	NUMC	2	0	Number of months
20	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
21	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
22	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
23	DMELDV	☐	DMELD01V	DDAT	DATS	8	0	Reporting Interval Start for Sales-Based Lease-Out
24	DMELDB	☐	DMELD01B	DDAT	DATS	8	0	End of Reporting Interval for Sales-Based Lease-Out
25	BMELD_REL	☐	BMELD02	WRTV7	CURR	13	2	Relevant sales for settlement
26	UBMELD	☐	VVUBMELD	VVBGESWERT	QUAN	15	3	Reported Sales in Units
27	UBMELD_REL	☐	VVUBMELD02	VVBGESWERT	QUAN	15	3	Relevant sales in units for sales settlement
28	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
29	BUMVRGROSS	☐	VVBUMVRGRS	WRTV7	CURR	13	2	Gross amount of sales settlement
30	PMWST	☐	VVMWST_PRZ	PRZ43V	DEC	7	3	Percentage rate of sales tax
31	BUVDIFFNET	☐	BUVDIFFNET	WRTV7	CURR	13	2	Net difference between advance payment and sales settlement
32	BUVDIFFSTE	☐	BUVDIFFSTE	WRTV7	CURR	13	2	Tax on diff. between advance payment and sales settlement
33	BUVDIFFGRS	☐	BUVDIFFGRS	WRTV7	CURR	13	2	Gross difference between advance payment and sls settlement
34	XKOARTK	☐	XKOARTK	XKBEZ	CHAR	15	0	Name of condition type
35	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
36	XKOARTL	☐	XKOARTL	XMBEZ	CHAR	30	0	Name of condition type
37	XWHRKONDK	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
38	XWHRKONDL	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
39	XMWSKZ	☐	TEXT1_007T	TEXT50	CHAR	50	0	Name of Tax on Sales/Purchases
40	.INCLUDE	☐				0	0	Amounts from VIMI28 in second currency
41	SWHRKNDCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
42	BMELDCUK	☐	BMELD01CUK	WRTV7	CURR	13	2	Reported sales in second currency
43	BMLDRELCUK	☐	BMELD02CUK	WRTV7	CURR	13	2	Sales relevant for settlement in second currency
44	BMWSSALCUK	☐	BMWSSALCUK	WRTV7	CURR	13	2	Value added tax amount of clearing balance in 2nd currency
45	BUMVRCUK	☐	BUMVRCUK	WRTV7	CURR	13	2	Amount of sales settlement in second currency
46	BUMVRGRCUK	☐	BUMVRGRCUK	WRTV7	CURR	13	2	Net amount of sales settlement in second currency
47	BUVDGRSCUK	☐	BUVDGRSCUK	WRTV7	CURR	13	2	Gross difference AP and sales settlement in second currency
48	BUVDNETCUK	☐	BUVDNETCUK	WRTV7	CURR	13	2	Net difference AP and sales settlement in second currency
49	BUVDSTECUK	☐	BUVDSTECUK	WRTV7	CURR	13	2	Tax on difference from AP and sales settlement, 2nd currency
50	BVZGMCUK	☐	BVZGMCUK	WRTV7	CURR	13	2	AP basic rent of customer on sales-based LO in 2nd currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVIMI28_ZS	BUKRS	T001	BUKRS	KEY	1	CN
2	RVIMI28_ZS	MWSKZ	T007A	MWSKZ	KEY	1	CN
3	RVIMI28_ZS	SKOART	TZK01	SKOART
4	RVIMI28_ZS	SMENR	VIMI01	SMENR	KEY	1	CN
5	RVIMI28_ZS	SWENR	VIOB01	SWENR	KEY	1	CN
6	RVIMI28_ZS	SWHRKOND	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in