SAP VIRAADVPAYPROC Advance Payments per Settlement Table
Overview
VIRAADVPAYPROC is a standard SAP S/4HANA table that stores Advance Payments per Settlement data. There are total 44 fields in the VIRAADVPAYPROC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAADVPAYPROC belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Advance Payment (RE_RA_AP).
In addition, following links provide an overview of foreign key relationships, if any, that link VIRAADVPAYPROC to other SAP tables and standard CDS views available based on VIRAADVPAYPROC table in S/4HANA 2020.
Techincal Settings of VIRAADVPAYPROC
Below are technical details of the table VIRAADVPAYPROC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAADVPAYPROC Fields
The following table gives you an overview of the fields available in VIRAADVPAYPROC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| ADVPAYPROCGUID | GUID for Advance Payments per Settlement | RERAADVPAYPROCGUID | RAW | 16 | |
| OBJGUID | GUID of Account Assignment Object Assigned by Process | RERAOBJGUID | RAW | 16 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | |
| VALIDTO | Date: Valid To | RECADATETO | DATS | 8 | |
| VALIDFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | * | RAW | 16 |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| ADD_OBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | * | CHAR | 22 |
| CONDTYPE | Condition Type | RECDCONDTYPE | * | CHAR | 4 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| TERMTYPE | Term Category | RETMTERMTYPE | * | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | CHAR | 4 | |
| TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| NET_AMOUNT | Net Amount of Advanced Payment | RERAADVPAYNET | CURR | 15 | |
| TAX_AMOUNT | Tax Amount of Advance Payment | RERAADVPAYTAX | CURR | 15 | |
| NET_AMOUNT_PAY | Amount of Net Advance Payment Made (for Settlement) | RERAADVPAYNETAMOUNT | CURR | 15 | |
| TAX_AMOUNT_PAY | Tax Amount of Advance Payment Made (for Settlement) | RERAADVPAYTAXAMOUNT | CURR | 15 | |
| NET_AMOUNT_EXT | Legacy Data Transfer: Net Amount of Advanced Payment | RERAADVPAYNETEXT | CURR | 15 | |
| TAX_AMOUNT_EXT | Legacy Data Transfer: Tax Amount of Advanced Payment | RERAADVPAYTAXEXT | CURR | 15 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 | |
| CTFCNETAMOUNT | Net Amount of Advance Payment in Foreign Currency | RERAAPCTFCNETAMOUNT | CURR | 15 | |
| CTFCTAXAMOUNT | Tax Amount of Advance Payment in Foreign Currency | RERAAPCTFCTAXAMOUNT | CURR | 15 | |
| CTFCNETAMOUNTPAY | Net Amount of Advance Payment Made in Foreign Currency | RERAAPCTFCNETAMOUNTPAY | CURR | 15 | |
| CTFCTAXAMOUNTPAY | Tax Amount of Advance Payment Made in Foreign Currency | RERAAPCTFCTAXAMOUNTPAY | CURR | 15 | |
| CTFCNETAMOUNTEXT | Legacy Data Transfer: AP Net Amount in Foreign Currency | RERAAPCTFCNETAMOUNTEXT | CURR | 15 | |
| CTFCTAXAMOUNTEXT | Legacy Data Transfer: AP Tax Amount in Foreign Currency | RERAAPCTFCTAXAMOUNTEXT | CURR | 15 | |
| INFOCOND | Statistical or Informational Condition | RECDINFOCOND | CHAR | 1 | |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| HASLEGACYDATA | Uses Legacy Data | RECAHASLEGACYDATA | CHAR | 1 | |
| STATUS | Status of Process Step | RECASTEPSTATUS | CHAR | 1 | |
| CDGUIDINVALID | CONDGUID Invalid - Data Record Is Summarized | RERACDGUIDINVALID | CHAR | 1 | |
| ENTRYTYPE | Entry Is Used For | RERAADVPAYENTRYTYPE | CHAR | 2 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIRAADVPAYPROC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAADVPAYPROC | CONDTYPE | : | * |
| VIRAADVPAYPROC | FLOWTYPE | : | TIVCDFLOWTYPE |
| VIRAADVPAYPROC | PROCESSGUID | 1: CN | * |
| VIRAADVPAYPROC | TAXGROUP | : | TIVRATAXGROUP |
| VIRAADVPAYPROC | TAXTYPE | : | TIVRATAXTYPE |
| VIRAADVPAYPROC | TERMTYPE | : | * |