SAP VIRAADVPAYEXT Advance Payment - Legacy Data Transfer Table
Overview
VIRAADVPAYEXT is a standard SAP S/4HANA table that stores Advance Payment - Legacy Data Transfer data. There are total 26 fields in the VIRAADVPAYEXT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAADVPAYEXT 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 VIRAADVPAYEXT to other SAP tables and standard CDS views available based on VIRAADVPAYEXT table in S/4HANA 2020.
Techincal Settings of VIRAADVPAYEXT
Below are technical details of the table VIRAADVPAYEXT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAADVPAYEXT Fields
The following table gives you an overview of the fields available in VIRAADVPAYEXT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| ADVPAYEXTGUID | GUID for Object and Period of Advance Payment | RERAADVPAYEXTGUID | RAW | 16 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| ADD_OBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | * | CHAR | 22 |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | |
| VALIDFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| PARTNER | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| VALIDTO | Date: Valid To | RECADATETO | 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 | |
| USESPECGLIND | Special G/L Indicator Is Used | RERAUSESPECGLIND | CHAR | 1 | |
| ACCSYSTEM | Definition of Accounting System | RERAACCSYSTEM | TIVRAACCSYSTEM | CHAR | 4 |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR | 10 |
| REFDOCTYPE | Reference to Document Class | RERAREFDOCTYPE | * | CHAR | 5 |
| REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | |
| REFITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | |
| NETAMOUNT | Legacy Data Transfer: Net Amount of Advanced Payment | RERAADVPAYNETEXT | CURR | 15 | |
| TAXAMOUNT | Legacy Data Transfer: Tax Amount of Advanced Payment | RERAADVPAYTAXEXT | CURR | 15 | |
| ISINCLINCF | Advance Payment Included in Cash Flow | RERAISINCLINCF | CHAR | 1 | |
| WHEREFROM | Origin of Data Record | RERAADVPAYWHEREFROM | 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 VIRAADVPAYEXT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAADVPAYEXT | ACCSYSTEM | : | TIVRAACCSYSTEM |
| VIRAADVPAYEXT | CONDTYPE | : | TIVCDCONDTYPE |
| VIRAADVPAYEXT | FLOWTYPE | : | TIVCDFLOWTYPE |
| VIRAADVPAYEXT | TAXGROUP | : | TIVRATAXGROUP |
| VIRAADVPAYEXT | TAXTYPE | : | TIVRATAXTYPE |