SAP ABAP Table VIMI28 (Sales settlement histories)

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	TRANSP	Transparent table
Transparent table	VIMI28	Table Relationship Diagram
Short Description	Sales settlement histories

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SMIVE	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
4	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
6	YUMSJ	☑	VVYUMSJ	GJAHR	NUMC	4	0	Sales year
7	UMSDATE	☑	VVUMSVDATE	DDAT	DATS	8	0	Last sales settlement upto...
8	SKOART	☑	VVSKOART	SKOART	NUMC	4	0	Condition: Type	TZK01
9	PPROZJ	☐	PPROZJ	DEC3_2	DEC	5	2	Sales year percentage rate
10	BUMVR	☐	VVBUMVR	WRTV7	CURR	13	2	Sales settlement amount
11	BVZGM	☐	VVBVZGM	WRTV7	CURR	13	2	Customer advance payment of basic rent on sales-based lease
12	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
13	VVABBLN	☐	VVABBLN1	XBLNR1	CHAR	16	0	Settlement Identification ->Accounting Ref. Doc.Number
14	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
15	BMWSTSALDO	☐	BMWSTSALDO	WRTV7	CURR	13	2	Clearing balance tax amount
16	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
17	BMELD	☐	BMELD01	WRTV7	CURR	13	2	Reported sales
18	MON_PA	☐	VVMONAT	NUM2	NUMC	2	0	Number of months
19	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
20	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
21	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
22	DMELDV	☐	DMELD01V	DDAT	DATS	8	0	Reporting Interval Start for Sales-Based Lease-Out
23	DMELDB	☐	DMELD01B	DDAT	DATS	8	0	End of Reporting Interval for Sales-Based Lease-Out
24	BMELD_REL	☐	BMELD02	WRTV7	CURR	13	2	Relevant sales for settlement
25	UBMELD	☐	VVUBMELD	VVBGESWERT	QUAN	15	3	Reported Sales in Units
26	UBMELD_REL	☐	VVUBMELD02	VVBGESWERT	QUAN	15	3	Relevant sales in units for sales settlement
27	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in