VIAKHO20 SAP () Table details
Dictionary Type: Table
Description:
Description:
Table field list including key, data, relationships and ABAP select examples
VIAKHO20 is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.
The VIAKHO20 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include BUKRS (Company Code), SMIVE (), SWENR (Site Number), SMENR (Number of Rental Unit).. 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 VIAKHO20 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 |
| MAND | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| SMIVE | REHOCNNR | CHAR | 13 | ALPHA | RECNNR | ||||
| SWENR | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
| SMENR | Number of Rental Unit | SMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | MEH | MCME |
| SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
| DVONPER | Period start date | DVONPER | DATS | 8 | DATUM | ||||
| NPERSOND | Special period to post follow-up costs | VVNPERSOND | NUMC | 2 | NUMC2 | ||||
| SNKSL | Service Charge Key | SNKSL | CHAR | 4 | Assigned to domain | ALPHA | SNKSL | NKL | REFXCLSNKSL |
| HOVERSN | REHOVERSN | CHAR | 3 | Assigned to domain | REHOVERSN | REHOVERSN | |||
| DBISPER | Date of settlement period end | DBISPER | DATS | 8 | DATUM | ||||
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
| VVBKOPTG | Average costs per day for a condition type | VVBKOPTG | CURR | 13(2) | WRTV7 | ||||
| BNETTO | Net amount | BNETTO | CURR | 13(2) | WRTV7 | ||||
| BSTEUER | Tax amount | BSTEUER | CURR | 13(2) | WRTV7 | ||||
| BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
| BGUFO | Credit memo/receivable amount | BGUFO | CURR | 13(2) | WRTV7 | ||||
| BMWST | Value-added tax amount included | BMWST | CURR | 13(2) | WRTV7 | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| DVZNEU | Valid-as-from date for new advance payment | DVZNEU | DATS | 8 | DDAT | ||||
| BVZNEU | New advance payment amount | BVZNEU | CURR | 13(2) | WRTV7 | ||||
| BKONDALT | Previous condition amount | BKONDALT | CURR | 13(2) | WRTV7 | ||||
| VVSKVZA | Reason why advance payment adjustment not carried out | VVSKVZA | CHAR | 1 | VVSKVZA | ||||
| DABRECH | Settlement date | DABRECH | DATS | 8 | DDAT | ||||
| VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | VVABBLN1 | CHAR | 16 | XBLNR1 | IAB | |||
| DMBTR | Amount of advance payments made for SCS | VVGELVZ | CURR | 13(2) | WERT7 | ||||
| MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
| BNAVST | Amount of non-deductible input tax share | VVBNAVST | CURR | 13(2) | WRTV7 | ||||
| BSTBAS | Base amount for tax calculation in incid.expenses sttlmnt | VVBSTBAS | CURR | 13(2) | WRTV7 | ||||
| BSTBTR | Output tax for customer posting in service charge settlement | VVBSTBTR | CURR | 13(2) | WRTV7 | ||||
| PERHVZ | Percentage of additional advance payment increase | VVPERHVZ | DEC | 4(2) | DEC2_2V | ||||
| BSTKORR | Tax adjustment for tenant service charge settlement | VVBSTKORR | CURR | 13(2) | WERTV7 | ||||
| ABREART | Settlement type for service charges after settlement perfor. | VVABREART | CHAR | 1 | VVABREART | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| MAXCOST | Maximum costs value for service charge settlement | VVMAXCOST | CURR | 13(2) | WERT7 | ||||
| REBKOPTG | Average costs per day for a condition type | REBKOPTG | DEC | 13(6) | |||||
| BNETTO_REAL | Net amount, original amount | REBNETTO_REAL | CURR | 13(2) | WRTV7 | ||||
| BSTBAS_REAL | Basic amount for tax calculation for SCS, orig. value | REBSTBAS_REAL | CURR | 13(2) | WRTV7 | ||||
| BSTBTR_REAL | Output tax for customer posting for SCS, original value | REBSTBTR_REAL | CURR | 13(2) | WRTV7 |
| Key field | Non-key field |
How do I retrieve data from SAP table VIAKHO20 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIAKHO20 to SELECT all data from the tableDATA: WA_VIAKHO20 TYPE VIAKHO20.
SELECT SINGLE *
FROM VIAKHO20
INTO CORRESPONDING FIELDS OF WA_VIAKHO20
WHERE...
How to access SAP table VIAKHO20
Within an ECC or HANA version of SAP you can also view further information about VIAKHO20 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