SAP VIRAADVPAYSPLIT Split Advance Payments Table
Overview
VIRAADVPAYSPLIT is a standard SAP S/4HANA table that stores Split Advance Payments data. There are total 49 fields in the VIRAADVPAYSPLIT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAADVPAYSPLIT 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 VIRAADVPAYSPLIT to other SAP tables and standard CDS views available based on VIRAADVPAYSPLIT table in S/4HANA 2020.
Techincal Settings of VIRAADVPAYSPLIT
Below are technical details of the table VIRAADVPAYSPLIT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAADVPAYSPLIT Fields
The following table gives you an overview of the fields available in VIRAADVPAYSPLIT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| ADVPAYSPLITGUID | GUID for Cash Flow Record and Calculation Period | RERAADVPAYSPLITGUID | RAW | 16 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| CFGUID | Link to Cash Flow | RERAADVPAYCFGUID | RAW | 16 | |
| WHEREFROM | Origin of Data Record | RERAADVPAYWHEREFROM | CHAR | 1 | |
| VALIDFROM | Date: Valid From | RECADATEFROM | DATS | 8 | |
| VALIDTO | Date: Valid To | RECADATETO | DATS | 8 | |
| VALIDDAYS | Period in Days | RERAVALIDDAYS | NUMC | 6 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | |
| CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 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 |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15 | |
| 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 | |
| ISPAYED | Item Was Already Paid | RERAISPAYED | CHAR | 1 | |
| USEDBYPROCESS | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | |
| USEDUNPAIDAP | Leave Unpaid Advance Payments Open (Planned Principle)? | RERATAKEOPENAP | CHAR | 1 | |
| USEDFROM | Valid-From Date of Current Period | RERAADVPAYUSEDFROM | DATS | 8 | |
| USEDTO | Valid-To Date of Current Period | RERAADVPAYUSEDTO | DATS | 8 | |
| USEDDAYS | Period in Days | RERAUSEDDAYS | NUMC | 6 | |
| USEDNETAMOUNT | Net Amount of Current Period | RERAADVPAYUSEDNETAMOUNT | CURR | 15 | |
| USEDTAXAMOUNT | Tax Amount of Current Period | RERAADVPAYUSEDTAXAMOUNT | CURR | 15 | |
| RESTFROM | Valid-From Date for Calculating Remaining Share | RERAADVPAYRESTFROM | DATS | 8 | |
| RESTTO | Valid-To Date for Calculating Remaining Share | RERAADVPAYRESTTO | DATS | 8 | |
| RESTNETAMOUNT | Net Amount of Remaining Share | RERAADVPAYRESTNETAMOUNT | CURR | 15 | |
| RESTTAXAMOUNT | Tax Amount of Remaining Share | RERAADVPAYRESTTAXAMOUNT | CURR | 15 | |
| REFGUID | Reference GUID | RERAREFGUID | RAW | 16 | |
| RESTREFGUID | Reference GUID | RERARESTREFGUID | RAW | 16 | |
| OBJGUID | GUID of Account Assignment Object Assigned by Process | RERAOBJGUID | RAW | 16 | |
| 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 | |
| USEDCTFCNETAMT | Net Amount of Advance Payment in Foreign Currency | RERAAPCTFCNETAMOUNT | CURR | 15 | |
| USEDCTFCTAXAMT | Tax Amount of Advance Payment in Foreign Currency | RERAAPCTFCTAXAMOUNT | CURR | 15 | |
| RESTCTFCNETAMT | Net Amount of Advance Payment in Foreign Currency | RERAAPCTFCNETAMOUNT | CURR | 15 | |
| RESTCTFCTAXAMT | Tax Amount of Advance Payment in Foreign Currency | RERAAPCTFCTAXAMOUNT | CURR | 15 | |
| CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 | |
| CALCMETHPER | Calculation Method for Time-Dependent Periods | RERACALCMETHPER | CHAR | 1 | |
| USECF4POST | Use Periodic Posting Run for Posting | RERAUSECF4POST | 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 VIRAADVPAYSPLIT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAADVPAYSPLIT | CONDTYPE | : | TIVCDCONDTYPE |
| VIRAADVPAYSPLIT | FLOWTYPE | : | TIVCDFLOWTYPE |
| VIRAADVPAYSPLIT | TAXGROUP | : | TIVRATAXGROUP |
| VIRAADVPAYSPLIT | TAXTYPE | : | TIVRATAXTYPE |