VIRAADVPAYEXT SAP table for – Advance Payment – Legacy Data Transfer

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

SAP VIRAADVPAYEXT table

Table VIRAADVPAYEXT technical data

TableVIRAADVPAYEXT
Data storingAdvance Payment – Legacy Data Transfer
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_RA_AP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADVPAYEXTGUID : GUID for Object and Period of Advance Payment
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : AP – Legacy Data Transfer: Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • ADD_OBJNR : Object Number for Additional Account Assignment
    Its data type is CHAR (Character String) with field length 22
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • CONDVALIDFROM : Date from when condition is valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : AP – Legacy Data Transfer: Non-Key Fields
  • VALIDTO : Date: Valid To
    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
  • USESPECGLIND : Special G/L Indicator Is Used
    Its data type is CHAR (Character String) with field length 1
  • ACCSYSTEM : Definition of Accounting System
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Reference to Line Item
  • LOGSYSTEM : Logical System
    Its data type is CHAR (Character String) with field length 10
  • REFDOCTYPE : Reference to Document Class
    Its data type is CHAR (Character String) with field length 5
  • REFDOCID : Reference Key of Document
    Its data type is CHAR (Character String) with field length 20
  • REFITEMNO : Accounting Document Line Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • NETAMOUNT : Legacy Data Transfer: Net Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMOUNT : Legacy Data Transfer: Tax Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • ISINCLINCF : Advance Payment Included in Cash Flow
    Its data type is CHAR (Character String) with field length 1
  • WHEREFROM : Origin of Data Record
    Its data type is CHAR (Character String) with field length 1