SAP VIVW09 Postings for management costs settlements Table
Overview
VIVW09 is a standard SAP S/4HANA table that stores Postings for management costs settlements data. There are total 27 fields in the VIVW09 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIVW09 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 VIVW09 to other SAP tables and standard CDS views available based on VIVW09 table in S/4HANA 2020.
Techincal Settings of VIVW09
Below are technical details of the table VIVW09
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIVW09 Fields
The following table gives you an overview of the fields available in VIVW09
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS_VW | Company code of property manager | VVBUKRSVW | * | CHAR | 4 |
| SVWNR | Management Contract Number | VVSVWNR | * | CHAR | 13 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| SEVNR | Event number | VVSEVNR | CHAR | 13 | |
| NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| DVWEVENT | Date which event took place | VVDVWEVENT | DATS | 8 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| SHOARTEX | External fee type | VVSHOARTEX | * | NUMC | 2 |
| BNETTO | Net amount | BNETTO | CURR | 13 | |
| BSTEUER | Tax amount | BSTEUER | CURR | 13 | |
| BBRUTTO | Gross amount | BBRUTTO | CURR | 13 | |
| DABRECH | Settlement date | DABRECH | DATS | 8 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| SXBLNR | Debit position identification -> Acctng reference doc. no. | SXBLNR1 | CHAR | 16 | |
| MWSKZ | Management contract: Sales tax code (posting to cust. acc.) | VVMWSKZUST | * | CHAR | 2 |
| KUNNR | Customer no. in company code of management contract | VVKUNNRVW | * | CHAR | 10 |
| ZLSCH_DEB | Payment method for postings to customer accounts | VVZLSCHDEB | * | CHAR | 1 |
| ZAHSL_DEB | Management contract: Block ind. for payment (customer) | VVZAHLSDEB | * | CHAR | 1 |
| LIFNR | Vendor no. of manager in object company code | VVLIFNRVW | * | CHAR | 10 |
| ZLSCH_KRED | Payment method for postings to vendor accounts | VVZLSCHKRE | * | CHAR | 1 |
| ZAHLS_KRED | Management contract: Block ind. for payment (vendor) | VVZAHLSKRE | * | CHAR | 1 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| J_OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| VWSTAT | Status of management settlement | VVVWSTAT | CHAR | 1 | |
| 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 VIVW09