1. SAP Tutorial
  2. Real Estate Management

VIRAADVPAYSPLIT SAP table for – Split Advance Payments

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

SAP VIRAADVPAYSPLIT table

Table VIRAADVPAYSPLIT technical data

TableVIRAADVPAYSPLIT
Data storingSplit Advance Payments
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_RA_AP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADVPAYSPLITGUID : GUID for Cash Flow Record and Calculation Period
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Split Advance Payments: Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CFGUID : Link to Cash Flow
    Its data type is RAW (Byte string) with field length 16
  • WHEREFROM : Origin of Data Record
    Its data type is CHAR (Character String) with field length 1
  • VALIDFROM : Date: Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Split Advance Payments: Non-Key Fields
  • VALIDTO : Date: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDDAYS : Period in Days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • CONDTYPE : Condition Type
    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
  • CDSPLITNO : Number of Condition Split
    Its data type is NUMC (Character String with Digits Only) 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
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • NETAMOUNT : Net Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMOUNT : Tax Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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
  • ISPAYED : Item Was Already Paid
    Its data type is CHAR (Character String) with field length 1
  • USEDBYPROCESS : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • USEDUNPAIDAP : Leave Unpaid Advance Payments Open (Planned Principle)?
    Its data type is CHAR (Character String) with field length 1
  • USEDFROM : Valid-From Date of Current Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USEDTO : Valid-To Date of Current Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USEDDAYS : Period in Days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • USEDNETAMOUNT : Net Amount of Current Period
    Its data type is CURR (Currency Field) with field length 15
  • USEDTAXAMOUNT : Tax Amount of Current Period
    Its data type is CURR (Currency Field) with field length 15
  • RESTFROM : Valid-From Date for Calculating Remaining Share
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RESTTO : Valid-To Date for Calculating Remaining Share
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RESTNETAMOUNT : Net Amount of Remaining Share
    Its data type is CURR (Currency Field) with field length 15
  • RESTTAXAMOUNT : Tax Amount of Remaining Share
    Its data type is CURR (Currency Field) with field length 15
  • REFGUID : Reference GUID
    Its data type is RAW (Byte string) with field length 16
  • RESTREFGUID : Reference GUID
    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
  • 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
  • USEDCTFCNETAMT : Net Amount of Advance Payment in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • USEDCTFCTAXAMT : Tax Amount of Advance Payment in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • RESTCTFCNETAMT : Net Amount of Advance Payment in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • RESTCTFCTAXAMT : Tax Amount of Advance Payment 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
  • CALCMETHPER : Calculation Method for Time-Dependent Periods
    Its data type is CHAR (Character String) with field length 1
  • USECF4POST : Use Periodic Posting Run for Posting
    Its data type is CHAR (Character String) with field length 1

    • VIRAADVPAYSPLIT 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

    VIRAADVPAYPROC SAP table for – Advance Payments per Settlement

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

    VISCCRSPLIT SAP table for – Split Receivable

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

    VISRCRSPLIT SAP table for – Split Receivable

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

    VISRMOSPLIT SAP table for – Split Receivable

    VISRMOSPLIT 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...

    «
    »