SAP VIWI02 Cost Efficiency Analysis Finance Plan Table
Overview
VIWI02 is a standard SAP S/4HANA table that stores Cost Efficiency Analysis Finance Plan data. There are total 95 fields in the VIWI02 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIWI02 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 VIWI02 to other SAP tables and standard CDS views available based on VIWI02 table in S/4HANA 2020.
Techincal Settings of VIWI02
Below are technical details of the table VIWI02
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIWI02 Fields
The following table gives you an overview of the fields available in VIWI02
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | * | CHAR | 8 |
| DATUM | Date of Cost Efficiency Analysis | VVWBDAT | DATS | 8 | |
| FREMD1_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD1_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD1_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD1_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD1_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD2_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD2_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD2_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD2_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD2_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD3_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD3_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD3_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD3_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD3_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD4_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD4_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD4_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD4_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD4_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD5_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD5_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD5_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD5_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD5_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD6_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD6_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD6_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD6_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD6_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD7_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD7_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD7_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD7_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD7_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD8_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD8_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD8_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD8_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD8_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| FREMD9_TXT | CEA: Finance plan outside funds description | VVWBFPF1TX | CHAR | 50 | |
| FREMD9_GES | CEA: Finance plan total outside funds | VVWBFPF1GE | CURR | 13 | |
| FREMD9_OW | CEA: Finance plan outside funds pub. auth. appartments | VVWBFPF1OW | CURR | 13 | |
| FREMD9_SW | CEA: Finance plan outside funds other apartments | VVWBFPF1SW | CURR | 13 | |
| FREMD9_SR | CEA: Financial plan outside funds other rooms | VVWBFPF1SR | CURR | 13 | |
| VERLBK_TXT | CEA: Finance plan lost constr. costs surcharge description | VVWBFPVBTX | CHAR | 50 | |
| VERLBK_GES | CEA: Finance plan lost constr. cost surcharge total | VVWBFPVBGE | CURR | 13 | |
| VERLBK_OW | CEA: Finance plan lost constr. cost surcharge total | VVWBFPVBOW | CURR | 13 | |
| VERLBK_SW | CEA: Finance plan lost constr. cost surcharge total | VVWBFPVBSW | CURR | 13 | |
| VERLBK_SR | CEA: Finance plan lost constr. cost surcharge total | VVWBFPVBSR | CURR | 13 | |
| EIGZI1_GES | CEA: Finance plan own substitute interest rate 1 total | VVWBFPZ1GE | CURR | 13 | |
| EIGZI1_OW | CEA: Finance plan own substitute interest rate 1 PA apart. | VVWBFPZ1OW | CURR | 13 | |
| EIGZI1_SW | CEA: Finance plan own substitute interest rate 1 other ap. | VVWBFPZ1SW | CURR | 13 | |
| EIGZI1_SR | CEA: Finance plan own substitute interest rate 1 other rooms | VVWBFPZ1SR | CURR | 13 | |
| EIGZI2_GES | CEA: Finance plan own substitute interest rate 2 total | VVWBFPZ2GE | CURR | 13 | |
| EIGZI2_OW | CEA: Finance plan own substitute interest rate 2 PA apart. | VVWBFPZ2OW | CURR | 13 | |
| EIGZI2_SW | CEA: Finance plan own substitute interest rate 2 other ap. | VVWBFPZ2SW | CURR | 13 | |
| EIGZI2_SR | CEA: Finance plan own substitute interest rate 2 other rooms | VVWBFPZ2SR | CURR | 13 | |
| EIGER1_GES | CEA: Finance plan own substitute total family loan | VVWBFPE1GE | CURR | 13 | |
| EIGER1_OW | CEA: Finance plan own substitute total family loan | VVWBFPE1OW | CURR | 13 | |
| EIGER1_SW | CEA: Finance plan own substitute total family loan | VVWBFPE1SW | CURR | 13 | |
| EIGER1_SR | CEA: Finance plan own substitute total family loan | VVWBFPE1SR | CURR | 13 | |
| EIGER2_GES | CEA: Finance plan own substitute total development loan | VVWBFPE2GE | CURR | 13 | |
| EIGER2_OW | CEA: Finance plan own substitute total development loan | VVWBFPE2OW | CURR | 13 | |
| EIGER2_SW | CEA: Finance plan own substitute total development loan | VVWBFPE2SW | CURR | 13 | |
| EIGER2_SR | CEA: Finance plan own substitute total development loan | VVWBFPE2SR | CURR | 13 | |
| EIGER3_GES | CEA: Finance plan own substitute total tenant loan | VVWBFPE3GE | CURR | 13 | |
| EIGER3_OW | CEA: Finance plan own substitute total tenant loan PA accom. | VVWBFPE3OW | CURR | 13 | |
| EIGER3_SW | CEA: Finance plan own substitute tenant loan other rooms | VVWBFPE3SW | CURR | 13 | |
| EIGER3_SR | CEA: Finance plan own substitute tenant loan other rooms | VVWBFPE3SR | CURR | 13 | |
| EIGER4_GES | CEA: Finance plan own substitute total others | VVWBFPE4GE | CURR | 13 | |
| EIGER4_OW | CEA: Finance plan own substitute other public auth. accom. | VVWBFPE4OW | CURR | 13 | |
| EIGER4_SW | CEA: Finance plan own substitute other apartments | VVWBFPE4SW | CURR | 13 | |
| EIGER4_SR | CEA: Finance plan own substitute total other rooms | VVWBFPE4SR | CURR | 13 | |
| EIGER4_TXT | CEA: Finance plan own substitute description others | VVWBFPETXT | CHAR | 50 | |
| SUMME_GES | CEA: Total financial plan | VVWBFPSUGE | CURR | 13 | |
| SUMME_OW | CEA: Total financial plan | VVWBFPSUOW | CURR | 13 | |
| SUMME_SW | CEA: Total financial plan | VVWBFPSUSW | CURR | 13 | |
| SUMME_SR | CEA: Total financial plan | VVWBFPSUSR | CURR | 13 | |
| EIG_GELDW | CEA: Financial plans own substitute financial means app | VVWBFPEIGW | CURR | 13 | |
| EIG_GELDG | CEA: Financial plans own substitute financial means app | VVWBFPEIGG | CURR | 13 | |
| EIG_SACHW | CEA: Financial plans own substitute financial means app. | VVWBFPEISW | CURR | 13 | |
| EIG_SACHG | CEA: Financial plans own substitute financial means app. | VVWBFPEISG | CURR | 13 | |
| EIG_BAUW | CEA: Financial plans own substitute financial means app.part | VVWBFPEIBW | CURR | 13 | |
| EIG_BAUG | CEA: Financial plans own substitute financial means app.part | VVWBFPEIBG | CURR | 13 | |
| EIG_GEBW | CEA: Finance plan own substitute used building part | VVWBFPEIVW | CURR | 13 | |
| EIG_GEBG | CEA: Finance plan own substitute used building part comm. | VVWBFPEIVG | CURR | 13 | |
| EIG_SUMW | CEA: Financial plans own substitute financial means app. | VVWBFPEISW | CURR | 13 | |
| EIG_SUMG | CEA: Financial plans own substitute financial means app. | VVWBFPEISG | CURR | 13 | |
| EIG_ZINS1 | CEA: Financial plan own substitute interest rate 1 | VVWBFPEIZ1 | DEC | 5 | |
| EIG_ZINS2 | CEA: Finance plan own substitute interest rate 2 | VVWBFPEIZ2 | DEC | 5 |
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 VIWI02