SAP VIRAADVPAY OBSOLETE: Advance Payment Table
Overview
VIRAADVPAY is a standard SAP S/4HANA table that stores OBSOLETE: Advance Payment data. There are total 40 fields in the VIRAADVPAY table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAADVPAY 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 VIRAADVPAY to other SAP tables and standard CDS views available based on VIRAADVPAY table in S/4HANA 2020.
Techincal Settings of VIRAADVPAY
Below are technical details of the table VIRAADVPAY
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAADVPAY Fields
The following table gives you an overview of the fields available in VIRAADVPAY
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| ADD_OBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | * | CHAR | 22 |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| VALIDTO | Date: Valid To | RECADATETO | DATS | 8 | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | * | RAW | 16 |
| OBJGUID | GUID of Account Assignment Object Assigned by Process | RERAOBJGUID | RAW | 16 | |
| VALIDFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | 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 | |
| TERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | CHAR | 4 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | |
| CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | |
| HASLEGACYDATA | Uses Legacy Data | RECAHASLEGACYDATA | CHAR | 1 | |
| PROCESSMODE | Execution Mode of Process | RECAPROCESSMODE | CHAR | 1 | |
| STATUS | Status of Advance Payment Relevant to SCS | RERASEAPSTATUS | CHAR | 1 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| 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 | |
| CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 |
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 VIRAADVPAY
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAADVPAY | CONDTYPE | : | TIVCDCONDTYPE |
| VIRAADVPAY | FLOWTYPE | : | TIVCDFLOWTYPE |
| VIRAADVPAY | PROCESSGUID | 1: CN | * |
| VIRAADVPAY | TAXGROUP | : | TIVRATAXGROUP |
| VIRAADVPAY | TAXTYPE | : | TIVRATAXTYPE |
| VIRAADVPAY | TERMTYPE | : | TIVTMTERMTYPE |