SAP VIRAINVITEM RE Invoice Item Table
Overview
VIRAINVITEM is a standard SAP S/4HANA table that stores RE Invoice Item data. There are total 56 fields in the VIRAINVITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAINVITEM belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Invoice for Rent (RE_RA_IV).
In addition, following links provide an overview of foreign key relationships, if any, that link VIRAINVITEM to other SAP tables and standard CDS views available based on VIRAINVITEM table in S/4HANA 2020.
Techincal Settings of VIRAINVITEM
Below are technical details of the table VIRAINVITEM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAINVITEM Fields
The following table gives you an overview of the fields available in VIRAINVITEM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INVGUID | GUID: Unique Internal Key for RE Invoice | RERAINVGUID | VIRAINV | RAW | 16 |
| ITEMNO | Item Number in RE Invoice | RERAINVITEMNO | NUMC | 10 | |
| OBJNR | Object Number of Contract for the Invoice Item | RERAINVOBJNR | * | CHAR | 22 |
| OBJNRCALC | Object Number for Calculation | RECDOBJNRCALC | * | CHAR | 22 |
| ITEMSRCIND | Source of Invoice Item | RERAINVITEMSRCIND | CHAR | 1 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| CALCFROM | Start of Calculation Period | DBERVON | DATS | 8 | |
| CALCTO | End of Calculation Period | DBERBIS | DATS | 8 | |
| ISADVANCEPAYMENT | Condition Is Advance Payment Condition | RECDADVANCEPAYMENT | CHAR | 1 | |
| CURRENCY | Local Currency | RECACTLCCURRKEY | * | CUKY | 5 |
| GROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| NETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | |
| PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | |
| XMACCTSHEETITEM | Name of Contract Account Sheet Item | RERAXLACCTSHEETITEM | CHAR | 60 | |
| DOCITEMID | Coded Key of FI Document Item for RE Internal Use | RERADOCITEMID | CHAR | 30 | |
| REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | |
| REFITEMNO | Reference to Other Item Number of Document | RERAREFITEMNO | NUMC | 10 | |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR | 10 |
| OBJ_TYPE | Reference procedure | AWTYP | * | CHAR | 5 |
| OBJ_KEY | Object key | AWKEY | CHAR | 20 | |
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | |
| DOCDATE | Document Date | RERADOCDATE | DATS | 8 | |
| CLEARINGDATE | Clearing Date | RERACLRNGDATE | DATS | 8 | |
| CLEARINGSTATUS | Clearing status | RERACLEARINGSTATUS | CHAR | 2 | |
| PROCESSID | Process Identification -> Accounting Reference Number | RECAPROCESSID | CHAR | 16 | |
| PSTNGPROCEDURE | Posting Procedure | RERAPROCEDURE | * | CHAR | 4 |
| XMACCTSHEETHDR | Name from Document Header | RERAXLACCTSHEETHDR | CHAR | 60 | |
| TAXRATE | Tax Rate | RERATAXRATE | DEC | 7 | |
| TAXDATE | Date of Tax Calculation | RERATAXDATE | DATS | 8 | |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| HOUSEBKID | Key for House Bank | RERAHOUSEBKID | CHAR | 15 | |
| HOUSEBKACC | Key for House Bank Account | RERAHOUSEBKACC | CHAR | 15 | |
| BANKDETAILID | Bank Details ID | RERABANKDETAILID | CHAR | 15 | |
| FCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| FCGROSSAMOUNT | Gross Amount in Foreign Currency | RECACTFCGROSSAMOUNT | CURR | 15 | |
| FCNETAMOUNT | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15 | |
| FCTAXAMOUNT | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTDATEREQ | Planned Translation Date | RECACTDATEREQ | DATS | 8 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | |
| TCCURRKEY | Document Currency (Transaction Currency) | RERATCCURRKEY | * | CUKY | 5 |
| TCGROSSAMOUNT | Gross Amount in Document Currency (Transaction Currency) | RERATCGROSSAMOUNT | CURR | 15 | |
| TCNETAMOUNT | Net Amount in Document Currency (Transaction Currency) | RERATCNETAMOUNT | CURR | 15 | |
| TCTAXAMOUNT | Tax Amount in Document Currency (Transaction Currency) | RERATCTAXAMOUNT | CURR | 15 | |
| SEPAMNDID | SEPA Mandate: Unique Reference to Mandate per Vendor | RETMSEPAMNDID | CHAR | 35 | |
| SEPARECCRDID | SEPA Mandate: Creditor ID | RETMSEPARECCRDID | CHAR | 35 | |
| RSGUID | GUID for Reservation | REORRSGUID | RAW | 16 |
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 VIRAINVITEM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAINVITEM | CONDTYPE | C: CN | TIVCDCONDTYPE |
| VIRAINVITEM | FLOWTYPE | C: CN | TIVCDFLOWTYPE |
| VIRAINVITEM | INVGUID | 1: N | VIRAINV |
| VIRAINVITEM | PSTNGPROCEDURE | 1: CN | * |
| VIRAINVITEM | TAXGROUP | 1: CN | TIVRATAXGROUP |
| VIRAINVITEM | TAXTYPE | 1: CN | TIVRATAXTYPE |