VIAJEXPENSE SAP table for – Current Expenses

Here we would like to draw your attention to VIAJEXPENSE 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). VIAJEXPENSE is a SAP standard transp table used for storing Current Expenses related data in SAP. It comes under the package RE_AJ_BD.

SAP VIAJEXPENSE table

Table VIAJEXPENSE technical data

TableVIAJEXPENSE
Data storingCurrent Expenses
ModuleRE
Sub ModuleRE-FX-AJ
SAP PackageRE_AJ_BD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIAJEXPENSE 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 VIAJEXPENSE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Current Expenses: Key Fields
    Its a key field.
  • EXPPOSGUID : Generic Key of Expense Plan Item
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Current Expenses: Non-Key Fields
  • .INCLUDE : Current Expenses: Secondary Key Fields
  • INTRENO : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • EXPPOS : Expense Item
    Its data type is CHAR (Character String) with field length 8
  • EXPPOSNO : Sequence Number of Expense Item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • EXPPOSVALIDFROM : Current Expense Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXPPOSVALIDTO : Current Expense Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXPPOSINFO : Informational Expense Item
    Its data type is CHAR (Character String) with field length 1
  • CALCRRL : Calculate Risk of Rent Loss
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Current Expenses: Cost of Capital
  • FINPOSGUID : Generic Key of Financing Plan Item
    Its data type is RAW (Byte string) with field length 16
  • FINPOSAMOUNT : Amount of Financing Plan Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • FINPOSREPAY : Repayment Rate of Financing Plan Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • FINPOSINTEREST : Interest Rate of Financing Plan Position
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • FINPOSPROVIDER : Financing Provider for Financing Plan Item
    Its data type is CHAR (Character String) with field length 60
  • FINPOSLOANNO : Loan Number of Financing Plan Item
    Its data type is CHAR (Character String) with field length 30
  • FINPOSREFLOAN : Reference to Loan
    Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Current Expenses: Management Costs
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CALCRULE : Calculation Formula
    Its data type is CHAR (Character String) with field length 4
  • CALCRULEPARA1 : Parameter for Calculation Formula
    Its data type is CHAR (Character String) with field length 30
  • CALCRULEPARA2 : Parameter for Calculation Formula
    Its data type is CHAR (Character String) with field length 30
  • NOMINALAMOUNT : Nominal Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19