VIAKHO20 SAP table for – WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung

Here we would like to draw your attention to VIAKHO20 table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIAKHO20 is a SAP standard transp table used for storing WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung related data in SAP. It comes under the package RE_MI_HO.

SAP VIAKHO20 table

Table VIAKHO20 technical data

TableVIAKHO20
Data storingWEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_MI_HO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIAKHO20 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIAKHO20 table.

  • MAND : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SMIVE : Vertragsnummer eines Hausgeldvertrages
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • SWENR : Business Entity Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • SMENR : Number of Rental Unit
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • SBEWART : Flow Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DVONPER : Period start date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NPERSOND : Special period to post follow-up costs
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • SNKSL : Service Charge Key
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • HOVERSN : WEG-Verwaltung: Version für Wirtschaftsplan Eigentümer
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung
  • DBISPER : Date of settlement period end
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKOART : Condition Type (Smallest Subdivision of Condition Records)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VVBKOPTG : Average costs per day for a condition type
    Its data type is CURR (Currency Field) with field length 13
  • BNETTO : Net amount
    Its data type is CURR (Currency Field) with field length 13
  • BSTEUER : Tax amount
    Its data type is CURR (Currency Field) with field length 13
  • BHWHR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • BGUFO : Credit memo/receivable amount
    Its data type is CURR (Currency Field) with field length 13
  • BMWST : Value-added tax amount included
    Its data type is CURR (Currency Field) with field length 13
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • DVZNEU : Valid-as-from date for new advance payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BVZNEU : New advance payment amount
    Its data type is CURR (Currency Field) with field length 13
  • BKONDALT : Previous condition amount
    Its data type is CURR (Currency Field) with field length 13
  • VVSKVZA : Reason why advance payment adjustment not carried out
    Its data type is CHAR (Character String) with field length 1
  • DABRECH : Settlement date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VVABBLN : Settlement Identification ->Accounting Ref. Doc.Number
    Its data type is CHAR (Character String) with field length 16
  • DMBTR : Amount of advance payments made for SCS
    Its data type is CURR (Currency Field) with field length 13
  • MWSTS : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BNAVST : Amount of non-deductible input tax share
    Its data type is CURR (Currency Field) with field length 13
  • BSTBAS : Base amount for tax calculation in incid.expenses sttlmnt
    Its data type is CURR (Currency Field) with field length 13
  • BSTBTR : Output tax for customer posting in service charge settlement
    Its data type is CURR (Currency Field) with field length 13
  • PERHVZ : Percentage of additional advance payment increase
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • BSTKORR : Tax adjustment for tenant service charge settlement
    Its data type is CURR (Currency Field) with field length 13
  • ABREART : Settlement type for service charges after settlement perfor.
    Its data type is CHAR (Character String) with field length 1
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • MAXCOST : Maximum costs value for service charge settlement
    Its data type is CURR (Currency Field) with field length 13
  • REBKOPTG : Average costs per day for a condition type
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • BNETTO_REAL : Net amount, original amount
    Its data type is CURR (Currency Field) with field length 13
  • BSTBAS_REAL : Basic amount for tax calculation for SCS, orig. value
    Its data type is CURR (Currency Field) with field length 13
  • BSTBTR_REAL : Output tax for customer posting for SCS, original value
    Its data type is CURR (Currency Field) with field length 13