VIRAADVPAY SAP table for – OBSOLETE: Advance Payment

Here we would like to draw your attention to VIRAADVPAY 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). VIRAADVPAY is a SAP standard transp table used for storing OBSOLETE: Advance Payment related data in SAP. It comes under the package RE_RA_AP.

SAP VIRAADVPAY table

Table VIRAADVPAY technical data

TableVIRAADVPAY
Data storingOBSOLETE: Advance Payment
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_RA_AP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for Advance Payment (VIRAADVPAY)
    Its a key field.
  • OBJNR : Object Number
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • ADD_OBJNR : Object Number for Additional Account Assignment
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Key Fields: Advance Payments
    Its a key field.
  • CONDTYPE : Condition Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VALIDTO : Date: Valid To
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTNER : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Non-Key Fields of Table VIRAAPAYMENT
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • OBJGUID : GUID of Account Assignment Object, Assigned by Process
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Non-Key Fields: Advance Payments
  • VALIDFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TAXDATE : Date for defining tax rates
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NET_AMOUNT : Net Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • TAX_AMOUNT : Tax Amount of Advance Payment
    Its data type is CURR (Currency Field) with field length 15
  • NET_AMOUNT_PAY : Amount of Net Advance Payment Made (for Settlement)
    Its data type is CURR (Currency Field) with field length 15
  • TAX_AMOUNT_PAY : Tax Amount of Advance Payment Made (for Settlement)
    Its data type is CURR (Currency Field) with field length 15
  • NET_AMOUNT_EXT : Legacy Data Transfer: Net Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • TAX_AMOUNT_EXT : Legacy Data Transfer: Tax Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • TERMTYPE : Term Category
    Its data type is CHAR (Character String) with field length 4
  • TERMNO : Term Number
    Its data type is CHAR (Character String) with field length 4
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • TERMNOPY : Number of Posting Term
    Its data type is CHAR (Character String) with field length 4
  • CDSPLITNO : Number of Condition Split
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HASLEGACYDATA : Uses Legacy Data
    Its data type is CHAR (Character String) with field length 1
  • PROCESSMODE : Execution Mode of Process
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Status of Advance Payment Relevant to SCS
    Its data type is CHAR (Character String) with field length 1
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • CTRATE : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTFCCURRKEY : Foreign Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTFCNETAMOUNT : Net Amount of Advance Payment in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXAMOUNT : Tax Amount of Advance Payment in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCNETAMOUNTPAY : Net Amount of Advance Payment Made in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXAMOUNTPAY : Tax Amount of Advance Payment Made in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCNETAMOUNTEXT : Legacy Data Transfer: AP Net Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXAMOUNTEXT : Legacy Data Transfer: AP Tax Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCPOST : Post in Foreign Currency
    Its data type is CHAR (Character String) with field length 1