VIVW01 SAP (Management contract: General data) Table details
Dictionary Type: Table
Description: Management contract: General data
Description: Management contract: General data
Table field list including key, data, relationships and ABAP select examples
VIVW01 is a standard SAP Table which is used to store Management contract: General data data and is available within R/3 SAP systems depending on the version and release level.
The VIVW01 table consists of various fields, each holding specific information or linking keys about Management contract: General data data available in SAP. These include BUKRS (Company code of property manager), SVWNR (Management Contract Number), IMKEY (Internal Key for Real Estate Object), INTRENO (Internal Real Estate Master Data Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP VIVW01 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company code of property manager | VVBUKRSVW | CHAR | 4 | T001 | BUKRS | BVW | ||
SVWNR | Management Contract Number | VVSVWNR | CHAR | 13 | ALPHA | VVSVWNR | VWV | MCVW | |
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
J_OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
DVWBEG | Date of contract start | VVDVWBEG | DATS | 8 | DDAT | ||||
DVWEND | Date of contract end | VVDVWEND | DATS | 8 | DDAT | ||||
LAUFZ | Management contract term | VVLAUFZ | NUMC | 4 | NUMC4 | ||||
LZEINS | Time unit | VVZEINS | NUMC | 1 | VVZEINS | ||||
VERL | Renewal of management contract (automatically) | VVVERL | NUMC | 4 | NUMC4 | ||||
VZEINS | Time unit | VVZEINS | NUMC | 1 | VVZEINS | ||||
AKUEFR | Management contract notice period | VVAKUEFR | NUMC | 4 | NUMC4 | ||||
KZEINS | Time unit | VVZEINS | NUMC | 1 | VVZEINS | ||||
KUEFR | Type of notice period | SKUEFR | NUMC | 1 | SKUEFR | ||||
DKUEAM | Notice given on management contract on | VVDKUEAM | DATS | 8 | DATS | ||||
DKUEZUM | Notice given on management contract per | VVDKUEZU | DATS | 8 | DATS | ||||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | JLOESCH | ||||
XVWTEXT | Management contract description | VVXVWTEXT | CHAR | 30 | XMBEZ | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
DVWSOLL | Date of last management contract debit position | VVDVWSOLL | DATS | 8 | DATS | ||||
DVWABR | Date of last management costs settlement | VVDVWABR | DATS | 8 | DATS | ||||
BUKRSPRT | Company code of contract partner | VVBUKRSPRT | CHAR | 4 | Assigned to domain | BUKRS | |||
GSBERPRT | Business area of contract partner | VVGSBERPRT | CHAR | 4 | Assigned to domain | GSBER | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
BUKRS_OBJ | Management contract: Company code of managed objects | VVBUKRSOBJ | CHAR | 4 | T001 | BUKRS | |||
KUNNR | Customer no. in company code of management contract | VVKUNNRVW | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
ZLSCH_DEB | Payment method for postings to customer accounts | VVZLSCHDEB | CHAR | 1 | Assigned to domain | ZLSCH | |||
ZAHLS_DEB | Management contract: Block ind. for payment (customer) | VVZAHLSDEB | CHAR | 1 | T008 | ZAHLS | |||
LIFNR | Vendor no. of manager in object company code | VVLIFNRVW | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
ZLSCH_KRED | Payment method for postings to vendor accounts | VVZLSCHKRE | CHAR | 1 | Assigned to domain | ZLSCH | |||
ZAHLS_KRED | Management contract: Block ind. for payment (vendor) | VVZAHLSKRE | CHAR | 1 | T008 | ZAHLS | |||
NO_OBJEKT | Management contr.: Object-related fees not permitted yes/no | VVNOOBJEKT | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | DATUM | ||||
NO_OWNER | Management contract: No owner posting yes/no | VVNOOWNER | CHAR | 1 | XFELD | ||||
NO_MANAG | Management contract: No manager posting yes/no | VVNOMANAG | CHAR | 1 | XFELD | ||||
HBKID_DEB | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
HBKID_KRED | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
KOEIGR | Account determination key for account determination | VVWERTN_ADV | CHAR | 10 | TIVC7 | VVWERTN_ADV | |||
BERGRP | Authorization group | VVBERGRP | CHAR | 40 | VVBERGRP | ||||
KZHBKID_EIG | Activate account determination | VVKZHBKID | CHAR | 1 | JANE | ||||
HBKID_EIG | House bank of owner | VVHBKID_EIG | CHAR | 5 | T012 | HBKID | |||
KZESR | Activation of POR functions | VVKZESR | CHAR | 1 | JANE | ||||
ESRNR_EIG | POR participant number of owner | VVESRNR_EIG | NUMC | 9 | TIV9I | NUM9 | |||
ESRKUID_EIG | POR customer identification number | VVESRKUID_EIG | CHAR | 15 | TIV9I | CHAR15 | |||
KZMWST | Activate VAT functions | VVKZMWST | CHAR | 1 | JANE | ||||
MWSTNR_EIG | Value-added tax of owner | VVMWSTNR_EIG | CHAR | 20 | STCEG | ||||
KZEIGGKT | Cash account control for owner | VVKZEIGGKT | CHAR | 1 | VVKZEIGGKT | ||||
BUKRS_GKT | Object and account CoCd | VVBUKRS_GKT | CHAR | 4 | Assigned to domain | BUKRS |
Key field | Non-key field |
How do I retrieve data from SAP table VIVW01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIVW01 to SELECT all data from the tableDATA: WA_VIVW01 TYPE VIVW01.
SELECT SINGLE *
FROM VIVW01
INTO CORRESPONDING FIELDS OF WA_VIVW01
WHERE...
How to access SAP table VIVW01
Within an ECC or HANA version of SAP you can also view further information about VIVW01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects