SAP VIMI28 Sales settlement histories Table
Overview
VIMI28 is a standard SAP S/4HANA table that stores Sales settlement histories data. There are total 27 fields in the VIMI28 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI28 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIMI28 to other SAP tables and standard CDS views available based on VIMI28 table in S/4HANA 2020.
Techincal Settings of VIMI28
Below are technical details of the table VIMI28
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI28 Fields
The following table gives you an overview of the fields available in VIMI28
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| YUMSJ | Sales year | VVYUMSJ | NUMC | 4 | |
| UMSDATE | Last sales settlement upto... | VVUMSVDATE | DATS | 8 | |
| SKOART | Condition: Type | VVSKOART | TZK01 | NUMC | 4 |
| PPROZJ | Sales year percentage rate | PPROZJ | DEC | 5 | |
| BUMVR | Sales settlement amount | VVBUMVR | CURR | 13 | |
| BVZGM | Customer advance payment of basic rent on sales-based lease | VVBVZGM | CURR | 13 | |
| SWHRKOND | Currency of Condition Item | SWHRKOND | TCURC | CUKY | 5 |
| VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | VVABBLN1 | CHAR | 16 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| BMWSTSALDO | Clearing balance tax amount | BMWSTSALDO | CURR | 13 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| BMELD | Reported sales | BMELD01 | CURR | 13 | |
| MON_PA | Number of months | VVMONAT | NUMC | 2 | |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| DMELDV | Reporting Interval Start for Sales-Based Lease-Out | DMELD01V | DATS | 8 | |
| DMELDB | End of Reporting Interval for Sales-Based Lease-Out | DMELD01B | DATS | 8 | |
| BMELD_REL | Relevant sales for settlement | BMELD02 | CURR | 13 | |
| UBMELD | Reported Sales in Units | VVUBMELD | QUAN | 15 | |
| UBMELD_REL | Relevant sales in units for sales settlement | VVUBMELD02 | QUAN | 15 | |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIMI28
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI28 | BUKRS | 1: CN | T001 |
| VIMI28 | MWSKZ | 1: CN | T007A |
| VIMI28 | SKOART | : | TZK01 |
| VIMI28 | SMENR | 1: CN | VIMI01 |
| VIMI28 | SWENR | 1: CN | VIOB01 |
| VIMI28 | SWHRKOND | 1: CN | TCURC |