VIWI05 SAP (Cost Efficiency Analysis Current Expenditure) Table details
Dictionary Type: Table
Description: Cost Efficiency Analysis Current Expenditure
Description: Cost Efficiency Analysis Current Expenditure
Table field list including key, data, relationships and ABAP select examples
VIWI05 is a standard SAP Table which is used to store Cost Efficiency Analysis Current Expenditure data and is available within R/3 SAP systems depending on the version and release level.
The VIWI05 table consists of various fields, each holding specific information or linking keys about Cost Efficiency Analysis Current Expenditure data available in SAP. These include BUKRS (Company Code), SWENR (Site Number), DATUM (Date of Cost Efficiency Analysis), FRKAPTOW1 (CEA: Repayment outside capital amount publicly subsid.accom.).. 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: Not classified
SAP VIWI05 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 | Assigned to domain | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| SWENR | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
| DATUM | Date of Cost Efficiency Analysis | VVWBDAT | DATS | 8 | DDAT | ||||
| FRKAPTOW1 | CEA: Repayment outside capital amount publicly subsid.accom. | VVKAPTOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTSW1 | CEA: Repayment outside capital amount other accommodation | VVKAPTSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTP1 | CEA: Repayment % outside capital | VVKAPTP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPZOW1 | CEA: Interest outside capital amount publicly subsid.accomm | VVKAPZOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZSW1 | CEA: Interest outside capital amount other accommodation | VVKAPZSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZP1 | CEA: Interest % outside capital | VVKAPZP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPTOW2 | CEA: Repayment outside capital amount publicly subsid.accom. | VVKAPTOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTSW2 | CEA: Repayment outside capital amount other accommodation | VVKAPTSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTP2 | CEA: Repayment % outside capital | VVKAPTP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPZOW2 | CEA: Interest outside capital amount publicly subsid.accomm | VVKAPZOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZSW2 | CEA: Interest outside capital amount other accommodation | VVKAPZSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZP2 | CEA: Interest % outside capital | VVKAPZP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPTOW3 | CEA: Repayment outside capital amount publicly subsid.accom. | VVKAPTOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTSW3 | CEA: Repayment outside capital amount other accommodation | VVKAPTSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTP3 | CEA: Repayment % outside capital | VVKAPTP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPZOW3 | CEA: Interest outside capital amount publicly subsid.accomm | VVKAPZOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZSW3 | CEA: Interest outside capital amount other accommodation | VVKAPZSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZP3 | CEA: Interest % outside capital | VVKAPZP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPTOW4 | CEA: Repayment outside capital amount publicly subsid.accom. | VVKAPTOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTSW4 | CEA: Repayment outside capital amount other accommodation | VVKAPTSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTP4 | CEA: Repayment % outside capital | VVKAPTP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPZOW4 | CEA: Interest outside capital amount publicly subsid.accomm | VVKAPZOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZSW4 | CEA: Interest outside capital amount other accommodation | VVKAPZSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZP4 | CEA: Interest % outside capital | VVKAPZP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPTOW5 | CEA: Repayment outside capital amount publicly subsid.accom. | VVKAPTOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTSW5 | CEA: Repayment outside capital amount other accommodation | VVKAPTSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPTP5 | CEA: Repayment % outside capital | VVKAPTP | DEC | 5(2) | DEC3_2 | ||||
| FRKAPZOW5 | CEA: Interest outside capital amount publicly subsid.accomm | VVKAPZOW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZSW5 | CEA: Interest outside capital amount other accommodation | VVKAPZSW | CURR | 13(2) | WRTV7 | ||||
| FRKAPZP5 | CEA: Interest % outside capital | VVKAPZP | DEC | 5(2) | DEC3_2 | ||||
| EIKAPZP1 | CEA: Interest % own funds | VVWBEKPZP | DEC | 5(2) | DEC3_2 | ||||
| EIKAPZOW1 | CEA:Interest amount own funds publicly subsid.accomm. | VVWBEKPZO | CURR | 13(2) | WRTV7 | ||||
| EIKAPZSW1 | CEA: Interest amount own funds other accommodation | VVWBEKPZS | CURR | 13(2) | WRTV7 | ||||
| EIKAPZP2 | CEA: Interest % own funds | VVWBEKPZP | DEC | 5(2) | DEC3_2 | ||||
| EIKAPZOW2 | CEA:Interest amount own funds publicly subsid.accomm. | VVWBEKPZO | CURR | 13(2) | WRTV7 | ||||
| EIKAPZSW2 | CEA: Interest amount own funds other accommodation | VVWBEKPZS | CURR | 13(2) | WRTV7 | ||||
| EEKAPTOW1 | CEA: Own substitute - Repayment for pub. auth. accommod. | VVWBEEKPTO | CURR | 13(2) | WRTV7 | ||||
| EEKAPTSW1 | CEA: Own substitute - Repayment for other accommod. | VVWBEEKPTS | CURR | 13(2) | WRTV7 | ||||
| EEKAPTP1 | CEA: Compensated own fund repayment % | VVWBEEKPTP | DEC | 5(2) | DEC3_2 | ||||
| EEKAPZOW1 | CEA: Own substitute - Interest for pub. auth. accommod. | VVWBEEKPZO | CURR | 13(2) | WRTV7 | ||||
| EEKAPZSW1 | CEA: Own substitute - Interest for other accommod. | VVWBEEKPZS | CURR | 13(2) | WRTV7 | ||||
| EEKAPZP1 | CEA: Expenses own substitute insterest % | VVWBEEKPZP | DEC | 5(2) | DEC3_2 | ||||
| EEKAPTOW2 | CEA: Own substitute - Repayment for pub. auth. accommod. | VVWBEEKPTO | CURR | 13(2) | WRTV7 | ||||
| EEKAPTSW2 | CEA: Own substitute - Repayment for other accommod. | VVWBEEKPTS | CURR | 13(2) | WRTV7 | ||||
| EEKAPTP2 | CEA: Compensated own fund repayment % | VVWBEEKPTP | DEC | 5(2) | DEC3_2 | ||||
| EEKAPZOW2 | CEA: Own substitute - Interest for pub. auth. accommod. | VVWBEEKPZO | CURR | 13(2) | WRTV7 | ||||
| EEKAPZSW2 | CEA: Own substitute - Interest for other accommod. | VVWBEEKPZS | CURR | 13(2) | WRTV7 | ||||
| EEKAPZP2 | CEA: Expenses own substitute insterest % | VVWBEEKPZP | DEC | 5(2) | DEC3_2 | ||||
| TSUMME | CEA: Repayment amount costs | VVWBTILSUM | CURR | 13(2) | WRTV7 | ||||
| ABSCHREI | CEA: Expense depreciation | VVWBABSCHR | CURR | 13(2) | WRTV7 | ||||
| ERBBAUM2 | CEA: Expenses ground rights area in AU | VVWBEBM2 | QUAN | 14(4) | VVBFLART | ||||
| ERBBAUBETR | CEA: Expenses: Ground rights amount per AU | VVWBEBBETR | CURR | 13(2) | WRTV7 | ||||
| ERBBAUSOW | CEA: Expenses ground rights total | VVWBEBSUM | CURR | 13(2) | WRTV7 | ||||
| ERBBAUSSW | CEA: Expenses ground rights total | VVWBEBSUM | CURR | 13(2) | WRTV7 | ||||
| ABSGEB_OW | CEA: Admin costs depreciation bldg subsidized apartment | VVWBLAAGOW | CURR | 13(2) | WRTV7 | ||||
| ABSGEB_SW | CEA: Admin costs depreciation building other apartments | VVWBLAAGSW | CURR | 13(2) | WRTV7 | ||||
| ABSANL_OW | CEA: Admin. costs depreciation of grounds/facilities pub. ap | VVWBLAAAOW | CURR | 13(2) | WRTV7 | ||||
| ABSANL_SW | CEA: Admin. costs deprec. of grounds & facilities other aps | VVWBLAAASW | CURR | 13(2) | WRTV7 | ||||
| ABSCHR_GOW | Amount | VVWBLAASOW | CURR | 13(2) | WRTV7 | ||||
| ABSCHR_GSW | Amount | VVWBLAASSW | CURR | 13(2) | WRTV7 | ||||
| VERW_WOHN | CEA: Administration costs number of apartments | VVWBLAVWO | DEC | 3 | DEC3 | ||||
| VERW_WBETR | CEA: Depreciation costs of total interest of other apart. | VVWBLAVWOB | CURR | 13(2) | WRTV7 | ||||
| VERW_GARA | CEA: Administration costs Garage no. | VVWBLAVGA | DEC | 3 | DEC3 | ||||
| VERW_GBETR | CEA: Depreciation costs of total interest of other apart. | VVWBLAVGAB | CURR | 13(2) | WRTV7 | ||||
| VERW_WBGES | CEA: Administration costs apartments | VVWBLAVWBG | CURR | 13(2) | WRTV7 | ||||
| VERW_WBSOW | CEA: Depreciation costs of total interest of other apart. | VVWBLAVWBO | CURR | 13(2) | WRTV7 | ||||
| VERW_WBSSW | CEA: Depreciation costs of total interest of other apart. | VVWBLAVWBS | CURR | 13(2) | WRTV7 | ||||
| VERW_GBGES | CEA: Administration costs garage | VVWBLAVGBG | CURR | 13(2) | WRTV7 | ||||
| VERW_GBSOW | CEA: Depreciation costs of total interest of other apart. | VVWBLAVGBO | CURR | 13(2) | WRTV7 | ||||
| VERW_GBSSW | CEA: Depreciation costs of total interest of other apart. | VVWBLAVGBS | CURR | 13(2) | WRTV7 | ||||
| BETR_GSTOW | CEA: Depreciation costs of total interest of other apart. | VVWBLABEGO | CURR | 13(2) | WRTV7 | ||||
| BETR_GSTSW | CEA: Depreciation costs of total interest of other apart. | VVWBLABEGS | CURR | 13(2) | WRTV7 | ||||
| BETR_WM2 | CEA: Administration costs/operating costs living area | VVWBLABEWM | QUAN | 14(4) | VVBFLART | ||||
| BETR_WM2BE | CEA: Admin costs/operating costs amount per m2/living area | VVWBLABEWB | CURR | 13(2) | WRTV7 | ||||
| BETR_NM2 | CEA: Administration costs/operating costs usable area | VVWBLABENM | QUAN | 14(4) | VVBFLART | ||||
| BETR_NM2BE | CEA: Admin. costs/operating costs amount per M2 usable area | VVWBLABENB | CURR | 13(2) | WRTV7 | ||||
| BETR_GM2 | CEA: Admin costs/operating costs usable area - garage area | VVWBLABEGM | QUAN | 14(4) | VVBFLART | ||||
| BETR_GM2BE | CEA: Admin costs/oper. costs amount per M2 usage/garage area | VVWBLABEGB | CURR | 13(2) | WRTV7 | ||||
| BETR_S1OW | CEA: Depreciation costs of total interest of other apart. | VVWBLABS1O | CURR | 13(2) | WRTV7 | ||||
| BETR_S1SW | CEA: Depreciation costs of total interest of other apart. | VVWBLABS1S | CURR | 13(2) | WRTV7 | ||||
| BETR_S2OW | CEA: Depreciation costs of total interest of other apart. | VVWBLABS2O | CURR | 13(2) | WRTV7 | ||||
| BETR_S2SW | CEA: Depreciation costs of total interest of other apart. | VVWBLABS2S | CURR | 13(2) | WRTV7 | ||||
| INST_WM2 | CEA: Administration costs/maintenance costs living area | VVWBLAINWM | QUAN | 14(4) | VVBFLART | ||||
| INST_WM2BE | CEA: Depreciation costs of total interest of other apart. | VVWBLAINWB | CURR | 13(2) | WRTV7 | ||||
| INST_NM2 | CEA: Administration and maintenance costs of usage area | VVWBLAINNM | QUAN | 14(4) | VVBFLART | ||||
| INST_NM2BE | CEA: Depreciation costs of total interest of other apart. | VVWBLAINNB | CURR | 13(2) | WRTV7 | ||||
| INST_S1OW | CEA: Depreciation costs of total interest of other apart. | VVWBLAIS1O | CURR | 13(2) | WRTV7 | ||||
| INST_S1SW | CEA: Depreciation costs of total interest of other apart. | VVWBLAIS1S | CURR | 13(2) | WRTV7 | ||||
| INST_GM2 | CEA: Admin costs/maintenance costs usable area or garage | VVWBLAIMGM | QUAN | 14(4) | VVBFLART | ||||
| INST_GM2BE | CEA: Depreciation costs of total interest of other apart. | VVWBLAINGB | CURR | 13(2) | WRTV7 | ||||
| INST_S2OW | CEA: Depreciation costs of total interest of other apart. | VVWBLAIS2O | CURR | 13(2) | WRTV7 | ||||
| INST_S2SW | CEA: Depreciation costs of total interest of other apart. | VVWBLAIS2S | CURR | 13(2) | WRTV7 | ||||
| MIET_WOGE | CEA: Depreciation costs of total interest of other apart. | VVWBLAMWOG | CURR | 13(2) | WRTV7 | ||||
| MIET_GAGE | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGAG | CURR | 13(2) | WRTV7 | ||||
| MIET_GWGE | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGWG | CURR | 13(2) | WRTV7 | ||||
| MIET_GWPR | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGWP | DEC | 5(2) | DEC3_2 | ||||
| MIET_WOAOW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMWOO | CURR | 13(2) | WRTV7 | ||||
| MIET_WOASW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMWOS | CURR | 13(2) | WRTV7 | ||||
| MIET_GAAOW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGAO | CURR | 13(2) | WRTV7 | ||||
| MIET_GAASW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGAS | CURR | 13(2) | WRTV7 | ||||
| MIET_GWAOW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGWO | CURR | 13(2) | WRTV7 | ||||
| MIET_GWASW | CEA: Depreciation costs of total interest of other apart. | VVWBLAMGWS | CURR | 13(2) | WRTV7 | ||||
| SUMME_OW | CEA: Depreciation costs of total interest of other apart. | VVWBLASUOW | CURR | 13(2) | WRTV7 | ||||
| SUMME_SW | CEA: Depreciation costs of total interest of other apart. | VVWBLASUSW | CURR | 13(2) | WRTV7 |
| Key field | Non-key field |
How do I retrieve data from SAP table VIWI05 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIWI05 to SELECT all data from the tableDATA: WA_VIWI05 TYPE VIWI05.
SELECT SINGLE *
FROM VIWI05
INTO CORRESPONDING FIELDS OF WA_VIWI05
WHERE...
How to access SAP table VIWI05
Within an ECC or HANA version of SAP you can also view further information about VIWI05 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