1. SAP Tutorial
  2. Real Estate Management

VIRAADVPAYPROC SAP table for – Advance Payments per Settlement

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

SAP VIRAADVPAYPROC table

Table VIRAADVPAYPROC technical data

TableVIRAADVPAYPROC
Data storingAdvance Payments per Settlement
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_RA_AP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADVPAYPROCGUID : GUID for Advance Payments per Settlement
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Advance Payments per Settlement: Key Fields
  • OBJGUID : GUID of Account Assignment Object, Assigned by Process
    Its data type is RAW (Byte string) with field length 16
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • CDSPLITNO : Number of Condition Split
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VALIDTO : Date: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Advance Payments per Settlement: Non-Key Fields
  • VALIDFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTFCCURRKEY : Foreign Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • 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
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • 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
  • 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
  • TERMNOPY : Number of Posting Term
    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
  • 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
  • CTFCPOST : Post in Foreign Currency
    Its data type is CHAR (Character String) with field length 1
  • 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
  • INFOCOND : Statistical or Informational Condition
    Its data type is CHAR (Character String) with field length 1
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • HASLEGACYDATA : Uses Legacy Data
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Status of Process Step
    Its data type is CHAR (Character String) with field length 1
  • CDGUIDINVALID : CONDGUID Invalid – Data Record Is Summarized
    Its data type is CHAR (Character String) with field length 1
  • ENTRYTYPE : Entry Is Used For
    Its data type is CHAR (Character String) with field length 2

    • VIRAADVPAYPROC related tables

    • VIRAADVPAYEXT : Advance Payment – Legacy Data Transfer
    • VIRAADVPAYPROC : Advance Payments per Settlement
    • VIRAADVPAYSPLIT : Split Advance Payments
    • VIRAADVPAY : OBSOLETE: Advance Payment
    • VIRAADVPAYCFREF : Link Between AP and Cash Flow

    Related References

    Related Tutorials

    VIRAADVPAYSPLIT SAP table for – Split Advance Payments

    VIRAADVPAYSPLIT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIRAADVPAY SAP table for – OBSOLETE: Advance Payment

    VIRAADVPAY table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIRAADVPAYEXT SAP table for – Advance Payment – Legacy Data Transfer

    VIRAADVPAYEXT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCRECEIVABLE SAP table for – Receivables from Settlement

    VISCRECEIVABLE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISRCALCCTFC SAP table for – Amounts in Foreign Currency

    VISRCALCCTFC table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISRCALCADVPAY SAP table for – Reference to Advance Payment Used

    VISRCALCADVPAY table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISRMODIRESULT SAP table for – Changed Sales-Based Settlement Results

    VISRMODIRESULT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »