SAP Table VIVW01
Management contract: General data
VIVW01 (Management contract: General data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VIVW01 to other SAP tables.
VIVW01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| BUKRS | Company code of property manager | VVBUKRSVW | T001 | CHAR | 4 | 0 | ||||||||||||||||
| SVWNR | Management Contract Number | VVSVWNR | CHAR | 13 | 0 | |||||||||||||||||
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | 0 | |||||||||||||||||
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | 0 | |||||||||||||||||
| J_OBJNR | Object number | J_OBJNR | CHAR | 22 | 0 | |||||||||||||||||
| DVWBEG | Date of contract start | VVDVWBEG | DATS | 8 | 0 | |||||||||||||||||
| DVWEND | Date of contract end | VVDVWEND | DATS | 8 | 0 | |||||||||||||||||
| LAUFZ | Management contract term | VVLAUFZ | NUMC | 4 | 0 | |||||||||||||||||
| LZEINS | Time unit | VVZEINS | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| VERL | Renewal of management contract (automatically) | VVVERL | NUMC | 4 | 0 | |||||||||||||||||
| VZEINS | Time unit | VVZEINS | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| AKUEFR | Management contract notice period | VVAKUEFR | NUMC | 4 | 0 | |||||||||||||||||
| KZEINS | Time unit | VVZEINS | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| KUEFR | Type of notice period | SKUEFR | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| DKUEAM | Notice given on management contract on | VVDKUEAM | DATS | 8 | 0 | |||||||||||||||||
| DKUEZUM | Notice given on management contract per | VVDKUEZU | DATS | 8 | 0 | |||||||||||||||||
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | 0 | |||||||||||||||||
| XVWTEXT | Management contract description | VVXVWTEXT | CHAR | 30 | 0 | |||||||||||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||
| DVWSOLL | Date of last management contract debit position | VVDVWSOLL | DATS | 8 | 0 | |||||||||||||||||
| DVWABR | Date of last management costs settlement | VVDVWABR | DATS | 8 | 0 | |||||||||||||||||
| BUKRSPRT | Company code of contract partner | VVBUKRSPRT | CHAR | 4 | 0 | |||||||||||||||||
| GSBERPRT | Business area of contract partner | VVGSBERPRT | CHAR | 4 | 0 | |||||||||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||||||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||||||||||||||||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||||||||||||||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||||||||||||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||||||||||||||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||||||||||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||||||||||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||||||||||||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||||||||||||||||
| BUKRS_OBJ | Management contract: Company code of managed objects | VVBUKRSOBJ | T001 | CHAR | 4 | 0 | ||||||||||||||||
| KUNNR | Customer no. in company code of management contract | VVKUNNRVW | KNA1 | CHAR | 10 | 0 | ||||||||||||||||
| ZLSCH_DEB | Payment method for postings to customer accounts | VVZLSCHDEB | CHAR | 1 | 0 | |||||||||||||||||
| ZAHLS_DEB | Management contract: Block ind. for payment (customer) | VVZAHLSDEB | T008 | CHAR | 1 | 0 | ||||||||||||||||
| LIFNR | Vendor no. of manager in object company code | VVLIFNRVW | LFA1 | CHAR | 10 | 0 | ||||||||||||||||
| ZLSCH_KRED | Payment method for postings to vendor accounts | VVZLSCHKRE | CHAR | 1 | 0 | |||||||||||||||||
| ZAHLS_KRED | Management contract: Block ind. for payment (vendor) | VVZAHLSKRE | T008 | CHAR | 1 | 0 | ||||||||||||||||
| NO_OBJEKT | Management contr.: Object-related fees not permitted yes/no | VVNOOBJEKT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||||||||||||
| DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | 0 | |||||||||||||||||
| NO_OWNER | Management contract: No owner posting yes/no | VVNOOWNER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| NO_MANAG | Management contract: No manager posting yes/no | VVNOMANAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| HBKID_DEB | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||||||||||||
| HBKID_KRED | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||||||||||||
| KOEIGR | Account determination key for account determination | VVWERTN_ADV | TIVC7 | CHAR | 10 | 0 | ||||||||||||||||
| BERGRP | Authorization group | VVBERGRP | CHAR | 40 | 0 | |||||||||||||||||
| KZHBKID_EIG | Activate account determination | VVKZHBKID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| HBKID_EIG | House bank of owner | VVHBKID_EIG | T012 | CHAR | 5 | 0 | ||||||||||||||||
| KZESR | Activation of POR functions | VVKZESR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| ESRNR_EIG | POR participant number of owner | VVESRNR_EIG | TIV9I | NUMC | 9 | 0 | ||||||||||||||||
| ESRKUID_EIG | POR customer identification number | VVESRKUID_EIG | TIV9I | CHAR | 15 | 0 | ||||||||||||||||
| KZMWST | Activate VAT functions | VVKZMWST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| MWSTNR_EIG | Value-added tax of owner | VVMWSTNR_EIG | CHAR | 20 | 0 | |||||||||||||||||
| KZEIGGKT | Cash account control for owner | VVKZEIGGKT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| BUKRS_GKT | Object and account CoCd | VVBUKRS_GKT | CHAR | 4 | 0 | |||||||||||||||||
VIVW01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VIVW01 | BUKRS | VIVW01 | MANDT | T001 | Company Codes | MANDT |
| VIVW01 | BUKRS | VIVW01 | BUKRS | T001 | Company Codes | BUKRS |
| VIVW01 | BUKRS_OBJ | VIVW01 | BUKRS_OBJ | T001 | Company Codes | BUKRS |
| VIVW01 | BUKRS_OBJ | VIVW01 | MANDT | T001 | Company Codes | MANDT |
| VIVW01 | ESRKUID_EIG | VIVW01 | MANDT | TIV9I | RE: Owner POR Data (Switzerland) | MANDT |
| VIVW01 | ESRKUID_EIG | VIVW01 | ESRNR_EIG | TIV9I | RE: Owner POR Data (Switzerland) | TEILN |
| VIVW01 | ESRKUID_EIG | VIVW01 | ESRKUID_EIG | TIV9I | RE: Owner POR Data (Switzerland) | KUNID |
| VIVW01 | ESRKUID_EIG | VIVW01 | BUKRS_OBJ | TIV9I | RE: Owner POR Data (Switzerland) | BUKRS |
| VIVW01 | ESRNR_EIG | VIVW01 | MANDT | TIV9I | RE: Owner POR Data (Switzerland) | MANDT |
| VIVW01 | ESRNR_EIG | VIVW01 | ESRNR_EIG | TIV9I | RE: Owner POR Data (Switzerland) | TEILN |
| VIVW01 | ESRNR_EIG | VIVW01 | ESRKUID_EIG | TIV9I | RE: Owner POR Data (Switzerland) | KUNID |
| VIVW01 | ESRNR_EIG | VIVW01 | BUKRS_OBJ | TIV9I | RE: Owner POR Data (Switzerland) | BUKRS |
| VIVW01 | GSBER | VIVW01 | MANDT | TGSB | Business Areas | MANDT |
| VIVW01 | GSBER | VIVW01 | GSBER | TGSB | Business Areas | GSBER |
| VIVW01 | HBKID_DEB | VIVW01 | BUKRS | T012 | House Banks | BUKRS |
| VIVW01 | HBKID_DEB | VIVW01 | HBKID_DEB | T012 | House Banks | HBKID |
| VIVW01 | HBKID_DEB | VIVW01 | MANDT | T012 | House Banks | MANDT |
| VIVW01 | HBKID_EIG | VIVW01 | MANDT | T012 | House Banks | MANDT |
| VIVW01 | HBKID_EIG | VIVW01 | BUKRS_OBJ | T012 | House Banks | BUKRS |
| VIVW01 | HBKID_EIG | VIVW01 | HBKID_EIG | T012 | House Banks | HBKID |
| VIVW01 | HBKID_KRED | VIVW01 | MANDT | T012 | House Banks | MANDT |
| VIVW01 | HBKID_KRED | VIVW01 | BUKRS_OBJ | T012 | House Banks | BUKRS |
| VIVW01 | HBKID_KRED | VIVW01 | HBKID_KRED | T012 | House Banks | HBKID |
| VIVW01 | KOEIGR | VIVW01 | KOEIGR | TIVC7 | Accnt determination key for management ctrct accnt determ. | KOEIGR |
| VIVW01 | KOEIGR | VIVW01 | MANDT | TIVC7 | Accnt determination key for management ctrct accnt determ. | MANDT |
| VIVW01 | KUNNR | VIVW01 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| VIVW01 | KUNNR | VIVW01 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| VIVW01 | LIFNR | VIVW01 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| VIVW01 | LIFNR | VIVW01 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| VIVW01 | MANDT | VIVW01 | MANDT | T000 | Clients | MANDT |
| VIVW01 | PRCTR | SYST | DATUM | CEPC | Profit Center Master Data Table | DATBI |
| VIVW01 | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| VIVW01 | PRCTR | VIVW01 | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| VIVW01 | PRCTR | VIVW01 | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| VIVW01 | WAERS | VIVW01 | MANDT | TCURC | Currency Codes | MANDT |
| VIVW01 | WAERS | VIVW01 | WAERS | TCURC | Currency Codes | WAERS |
| VIVW01 | ZAHLS_DEB | VIVW01 | MANDT | T008 | Blocking Reasons for Automatic Payment Transcations | MANDT |
| VIVW01 | ZAHLS_DEB | VIVW01 | ZAHLS_DEB | T008 | Blocking Reasons for Automatic Payment Transcations | ZAHLS |
| VIVW01 | ZAHLS_KRED | VIVW01 | MANDT | T008 | Blocking Reasons for Automatic Payment Transcations | MANDT |
| VIVW01 | ZAHLS_KRED | VIVW01 | ZAHLS_KRED | T008 | Blocking Reasons for Automatic Payment Transcations | ZAHLS |
