SAP VIWI05 Cost Efficiency Analysis Current Expenditure Table

Overview

VIWI05 is a standard SAP S/4HANA table that stores Cost Efficiency Analysis Current Expenditure data. There are total 108 fields in the VIWI05 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIWI05 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 VIWI05 to other SAP tables and standard CDS views available based on VIWI05 table in S/4HANA 2020.

Techincal Settings of VIWI05

Below are technical details of the table VIWI05

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VIWI05 Fields

The following table gives you an overview of the fields available in VIWI05

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
BUKRSCompany CodeBUKRS*CHAR4
SWENRBusiness Entity NumberSWENR*CHAR8
DATUMDate of Cost Efficiency AnalysisVVWBDATDATS8
FRKAPTOW1CEA: Repayment outside capital amount publicly subsid.accom.VVKAPTOWCURR13
FRKAPTSW1CEA: Repayment outside capital amount other accommodationVVKAPTSWCURR13
FRKAPTP1CEA: Repayment % outside capitalVVKAPTPDEC5
FRKAPZOW1CEA: Interest outside capital amount publicly subsid.accommVVKAPZOWCURR13
FRKAPZSW1CEA: Interest outside capital amount other accommodationVVKAPZSWCURR13
FRKAPZP1CEA: Interest % outside capitalVVKAPZPDEC5
FRKAPTOW2CEA: Repayment outside capital amount publicly subsid.accom.VVKAPTOWCURR13
FRKAPTSW2CEA: Repayment outside capital amount other accommodationVVKAPTSWCURR13
FRKAPTP2CEA: Repayment % outside capitalVVKAPTPDEC5
FRKAPZOW2CEA: Interest outside capital amount publicly subsid.accommVVKAPZOWCURR13
FRKAPZSW2CEA: Interest outside capital amount other accommodationVVKAPZSWCURR13
FRKAPZP2CEA: Interest % outside capitalVVKAPZPDEC5
FRKAPTOW3CEA: Repayment outside capital amount publicly subsid.accom.VVKAPTOWCURR13
FRKAPTSW3CEA: Repayment outside capital amount other accommodationVVKAPTSWCURR13
FRKAPTP3CEA: Repayment % outside capitalVVKAPTPDEC5
FRKAPZOW3CEA: Interest outside capital amount publicly subsid.accommVVKAPZOWCURR13
FRKAPZSW3CEA: Interest outside capital amount other accommodationVVKAPZSWCURR13
FRKAPZP3CEA: Interest % outside capitalVVKAPZPDEC5
FRKAPTOW4CEA: Repayment outside capital amount publicly subsid.accom.VVKAPTOWCURR13
FRKAPTSW4CEA: Repayment outside capital amount other accommodationVVKAPTSWCURR13
FRKAPTP4CEA: Repayment % outside capitalVVKAPTPDEC5
FRKAPZOW4CEA: Interest outside capital amount publicly subsid.accommVVKAPZOWCURR13
FRKAPZSW4CEA: Interest outside capital amount other accommodationVVKAPZSWCURR13
FRKAPZP4CEA: Interest % outside capitalVVKAPZPDEC5
FRKAPTOW5CEA: Repayment outside capital amount publicly subsid.accom.VVKAPTOWCURR13
FRKAPTSW5CEA: Repayment outside capital amount other accommodationVVKAPTSWCURR13
FRKAPTP5CEA: Repayment % outside capitalVVKAPTPDEC5
FRKAPZOW5CEA: Interest outside capital amount publicly subsid.accommVVKAPZOWCURR13
FRKAPZSW5CEA: Interest outside capital amount other accommodationVVKAPZSWCURR13
FRKAPZP5CEA: Interest % outside capitalVVKAPZPDEC5
EIKAPZP1CEA: Interest % own fundsVVWBEKPZPDEC5
EIKAPZOW1CEA:Interest amount own funds publicly subsid.accomm.VVWBEKPZOCURR13
EIKAPZSW1CEA: Interest amount own funds other accommodationVVWBEKPZSCURR13
EIKAPZP2CEA: Interest % own fundsVVWBEKPZPDEC5
EIKAPZOW2CEA:Interest amount own funds publicly subsid.accomm.VVWBEKPZOCURR13
EIKAPZSW2CEA: Interest amount own funds other accommodationVVWBEKPZSCURR13
EEKAPTOW1CEA: Own substitute - Repayment for pub. auth. accommod.VVWBEEKPTOCURR13
EEKAPTSW1CEA: Own substitute - Repayment for other accommod.VVWBEEKPTSCURR13
EEKAPTP1CEA: Compensated own fund repayment %VVWBEEKPTPDEC5
EEKAPZOW1CEA: Own substitute - Interest for pub. auth. accommod.VVWBEEKPZOCURR13
EEKAPZSW1CEA: Own substitute - Interest for other accommod.VVWBEEKPZSCURR13
EEKAPZP1CEA: Expenses own substitute insterest %VVWBEEKPZPDEC5
EEKAPTOW2CEA: Own substitute - Repayment for pub. auth. accommod.VVWBEEKPTOCURR13
EEKAPTSW2CEA: Own substitute - Repayment for other accommod.VVWBEEKPTSCURR13
EEKAPTP2CEA: Compensated own fund repayment %VVWBEEKPTPDEC5
EEKAPZOW2CEA: Own substitute - Interest for pub. auth. accommod.VVWBEEKPZOCURR13
EEKAPZSW2CEA: Own substitute - Interest for other accommod.VVWBEEKPZSCURR13
EEKAPZP2CEA: Expenses own substitute insterest %VVWBEEKPZPDEC5
TSUMMECEA: Repayment amount costsVVWBTILSUMCURR13
ABSCHREICEA: Expense depreciationVVWBABSCHRCURR13
ERBBAUM2CEA: Expenses ground rights area in AUVVWBEBM2QUAN14
ERBBAUBETRCEA: Expenses: Ground rights amount per AUVVWBEBBETRCURR13
ERBBAUSOWCEA: Expenses ground rights totalVVWBEBSUMCURR13
ERBBAUSSWCEA: Expenses ground rights totalVVWBEBSUMCURR13
ABSGEB_OWCEA: Admin costs depreciation bldg subsidized apartmentVVWBLAAGOWCURR13
ABSGEB_SWCEA: Admin costs depreciation building other apartmentsVVWBLAAGSWCURR13
ABSANL_OWCEA: Admin. costs depreciation of grounds/facilities pub. apVVWBLAAAOWCURR13
ABSANL_SWCEA: Admin. costs deprec. of grounds & facilities other apsVVWBLAAASWCURR13
ABSCHR_GOWAmountVVWBLAASOWCURR13
ABSCHR_GSWAmountVVWBLAASSWCURR13
VERW_WOHNCEA: Administration costs number of apartmentsVVWBLAVWODEC3
VERW_WBETRCEA: Depreciation costs of total interest of other apart.VVWBLAVWOBCURR13
VERW_GARACEA: Administration costs Garage no.VVWBLAVGADEC3
VERW_GBETRCEA: Depreciation costs of total interest of other apart.VVWBLAVGABCURR13
VERW_WBGESCEA: Administration costs apartmentsVVWBLAVWBGCURR13
VERW_WBSOWCEA: Depreciation costs of total interest of other apart.VVWBLAVWBOCURR13
VERW_WBSSWCEA: Depreciation costs of total interest of other apart.VVWBLAVWBSCURR13
VERW_GBGESCEA: Administration costs garageVVWBLAVGBGCURR13
VERW_GBSOWCEA: Depreciation costs of total interest of other apart.VVWBLAVGBOCURR13
VERW_GBSSWCEA: Depreciation costs of total interest of other apart.VVWBLAVGBSCURR13
BETR_GSTOWCEA: Depreciation costs of total interest of other apart.VVWBLABEGOCURR13
BETR_GSTSWCEA: Depreciation costs of total interest of other apart.VVWBLABEGSCURR13
BETR_WM2CEA: Administration costs/operating costs living areaVVWBLABEWMQUAN14
BETR_WM2BECEA: Admin costs/operating costs amount per m2/living areaVVWBLABEWBCURR13
BETR_NM2CEA: Administration costs/operating costs usable areaVVWBLABENMQUAN14
BETR_NM2BECEA: Admin. costs/operating costs amount per M2 usable areaVVWBLABENBCURR13
BETR_GM2CEA: Admin costs/operating costs usable area - garage areaVVWBLABEGMQUAN14
BETR_GM2BECEA: Admin costs/oper. costs amount per M2 usage/garage areaVVWBLABEGBCURR13
BETR_S1OWCEA: Depreciation costs of total interest of other apart.VVWBLABS1OCURR13
BETR_S1SWCEA: Depreciation costs of total interest of other apart.VVWBLABS1SCURR13
BETR_S2OWCEA: Depreciation costs of total interest of other apart.VVWBLABS2OCURR13
BETR_S2SWCEA: Depreciation costs of total interest of other apart.VVWBLABS2SCURR13
INST_WM2CEA: Administration costs/maintenance costs living areaVVWBLAINWMQUAN14
INST_WM2BECEA: Depreciation costs of total interest of other apart.VVWBLAINWBCURR13
INST_NM2CEA: Administration and maintenance costs of usage areaVVWBLAINNMQUAN14
INST_NM2BECEA: Depreciation costs of total interest of other apart.VVWBLAINNBCURR13
INST_S1OWCEA: Depreciation costs of total interest of other apart.VVWBLAIS1OCURR13
INST_S1SWCEA: Depreciation costs of total interest of other apart.VVWBLAIS1SCURR13
INST_GM2CEA: Admin costs/maintenance costs usable area or garageVVWBLAIMGMQUAN14
INST_GM2BECEA: Depreciation costs of total interest of other apart.VVWBLAINGBCURR13
INST_S2OWCEA: Depreciation costs of total interest of other apart.VVWBLAIS2OCURR13
INST_S2SWCEA: Depreciation costs of total interest of other apart.VVWBLAIS2SCURR13
MIET_WOGECEA: Depreciation costs of total interest of other apart.VVWBLAMWOGCURR13
MIET_GAGECEA: Depreciation costs of total interest of other apart.VVWBLAMGAGCURR13
MIET_GWGECEA: Depreciation costs of total interest of other apart.VVWBLAMGWGCURR13
MIET_GWPRCEA: Depreciation costs of total interest of other apart.VVWBLAMGWPDEC5
MIET_WOAOWCEA: Depreciation costs of total interest of other apart.VVWBLAMWOOCURR13
MIET_WOASWCEA: Depreciation costs of total interest of other apart.VVWBLAMWOSCURR13
MIET_GAAOWCEA: Depreciation costs of total interest of other apart.VVWBLAMGAOCURR13
MIET_GAASWCEA: Depreciation costs of total interest of other apart.VVWBLAMGASCURR13
MIET_GWAOWCEA: Depreciation costs of total interest of other apart.VVWBLAMGWOCURR13
MIET_GWASWCEA: Depreciation costs of total interest of other apart.VVWBLAMGWSCURR13
SUMME_OWCEA: Depreciation costs of total interest of other apart.VVWBLASUOWCURR13
SUMME_SWCEA: Depreciation costs of total interest of other apart.VVWBLASUSWCURR13

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 VIWI05

Other References