SAP VIRADOCITEM RE Document Item Table
Overview
VIRADOCITEM is a standard SAP S/4HANA table that stores RE Document Item data. There are total 88 fields in the VIRADOCITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRADOCITEM belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Cross Application Rental Accounting (RE_RA_CA).
In addition, following links provide an overview of foreign key relationships, if any, that link VIRADOCITEM to other SAP tables and standard CDS views available based on VIRADOCITEM table in S/4HANA 2020.
Techincal Settings of VIRADOCITEM
Below are technical details of the table VIRADOCITEM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRADOCITEM Fields
The following table gives you an overview of the fields available in VIRADOCITEM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| DOCGUID | GUID: Unique Internal Key for RE Document | RERADOCGUID | VIRADOC | RAW | 16 |
| ITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | |
| REFITEMNO | Reference to Other Item Number of Document | RERAREFITEMNO | NUMC | 10 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| ITEMTYPE | Item Category | RERAITEMTYPE | CHAR | 2 | |
| REFDATE | Reference date for settlement | DABRBEZ | DATS | 8 | |
| PROCESS | Process | RECAPROCESS | * | CHAR | 4 |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | |
| CLEARINGSTATUS | Clearing status | RERACLEARINGSTATUS | CHAR | 2 | |
| CLEARNGPROCESSID | Process Identification -> Accounting Reference Number | RECAPROCESSID | CHAR | 16 | |
| PAYEDSTATUS | Payment Status | RERAPAYEDSTATUS | CHAR | 2 | |
| DUNNINGSTATUS | Dunning Status | RERADUNNINGSTATUS | CHAR | 2 | |
| REFGUIDORIGIN | Source of GUID | RERAGUIDORIGIN | CHAR | 4 | |
| REFGUID | Reference GUID | RERAREFGUID | RAW | 16 | |
| OBJNR | Account Assignment: Object Number | RERAOBJNR | * | CHAR | 22 |
| PFROM | Start of Calculation Period | DBERVON | DATS | 8 | |
| PTO | End of Calculation Period | DBERBIS | DATS | 8 | |
| BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| ORIGDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| ISADVANCEPAYMENT | Condition Is Advance Payment Condition | RECDADVANCEPAYMENT | CHAR | 1 | |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| DCINDICATOR | Debit/Credit Indicator | RERADCINDICATOR | CHAR | 1 | |
| TAXGROUPID | Group Indicator for Tax Line Items | RERATAXGROUPID | NUMC | 3 | |
| TAXDATE | Date of Tax Calculation | RERATAXDATE | DATS | 8 | |
| TERMNOOA | Term Number | RETMTERMNO | CHAR | 4 | |
| GSBER | Business Area | GSBER | * | CHAR | 4 |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| ADDOBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | * | CHAR | 22 |
| FUND | Fund | RERAFUND | CHAR | 24 | |
| FUNDSCENTER | Funds Center | RERAFUNDSCENTER | CHAR | 24 | |
| COMMITMENTITEM | Commitment Item | RERACOMMITMENTITEM | * | CHAR | 24 |
| FUNCTIONALAREA | Functional Area | RERAFUNCTIONALAREA | CHAR | 24 | |
| GRANTNUMBER | Grant | RERAGRANTNUMBER | CHAR | 24 | |
| MEASURE | Program in Funds Management | RERAMEASURE | CHAR | 24 | |
| BUDGETPERIOD | FM: Budget Period | RERABUDGETPERIOD | CHAR | 24 | |
| TERMNOPY | Term Number | RETMTERMNO | CHAR | 4 | |
| CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | |
| PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | |
| PYMTMETHCRMO | Payment Method for Credit Memos | RERAPYMTMETHCRMO | CHAR | 4 | |
| PYMTBLOCK | Payment block key | RERAPYMTBLOCK | CHAR | 4 | |
| PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | |
| HOUSEBKID | Key for House Bank | RERAHOUSEBKID | CHAR | 15 | |
| HOUSEBKACC | Key for House Bank Account | RERAHOUSEBKACC | CHAR | 15 | |
| BANKDETAILID | Bank Details ID | RERABANKDETAILID | CHAR | 15 | |
| NOTETOPAYEE | Note to Payee | RERANOTETOPAYEE | CHAR | 25 | |
| DUNNAREA | Dunning Area | RERADUNNAREA | CHAR | 4 | |
| DUNNKEY | Dunning Keys | RERADUNNKEY | CHAR | 4 | |
| DUNNBLOCK | Dunning Block | RERADUNNBLOCK | CHAR | 4 | |
| ACCDETKEY | Account Determination Value | RERAACCDETKEY | * | CHAR | 10 |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| TAXCOUNTRY | Alternative Tax Reporting Country | RERATAXCOUNTRY | * | CHAR | 3 |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| ISPARTNERBLOCKED | Lock of Partner Data in Posting Term | RERAISPARTNERBLOCKED | CHAR | 1 | |
| SEPAMNDID | SEPA Mandate: Unique Reference to Mandate per Vendor | RETMSEPAMNDID | CHAR | 35 | |
| SEPARECCRDID | SEPA Mandate: Creditor ID | RETMSEPARECCRDID | CHAR | 35 | |
| TERMNOWT | Term Number | RETMTERMNO | CHAR | 4 | |
| ACCTYPE | Account Type | RERAACCTYPE | CHAR | 1 | |
| GLACCSYMB | Account Determination: Account Symbols | RERAGLACCSYMB | * | CHAR | 15 |
| GLACCOUNT | General Ledger Account | RERAGLACCOUNT | CHAR | 10 | |
| AMOUNT | Amount in Transaction Currency | RERAAMOUNT | CURR | 15 | |
| GROSSAMOUNT | Gross Amount in Transaction Currency | RERAGROSSAMOUNT | CURR | 15 | |
| NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| CTLCAMOUNT | Amount in Local Currency | RECACTLCAMOUNT | CURR | 15 | |
| CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| CTLCCURRKEY | Local Currency | RECACTLCCURRKEY | * | CUKY | 5 |
| CTFCAMOUNT | Amount in Foreign Currency | RECACTFCAMOUNT | CURR | 15 | |
| CTFCGROSSAMOUNT | Gross Amount in Foreign Currency | RECACTFCGROSSAMOUNT | CURR | 15 | |
| CTFCNETAMOUNT | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15 | |
| CTFCTAXAMOUNT | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15 | |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| TAXRATE | Tax Rate | RERATAXRATE | DEC | 7 | |
| ASSETOBJNR | Object Number - Asset | RECEASOBJNR | * | CHAR | 22 |
| ASSETVALUEDATE | Reference date | BF_BZDAT | DATS | 8 | |
| ASSETPROCEDURE | Asset Process | RECEASPROCEDURE | CHAR | 1 | |
| ISCOMPLETERETIREMENT | Complete Retirement? | RECEISCOMPLETERETIREMENT | CHAR | 1 | |
| REDUCTION_PERCENTAGE | Asset retirement: Percentage rate | PROZS | DEC | 5 |
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 VIRADOCITEM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRADOCITEM | CONDTYPE | 1: CN | TIVCDCONDTYPE |
| VIRADOCITEM | DOCGUID | 1: CN | VIRADOC |
| VIRADOCITEM | FLOWTYPE | 1: CN | TIVCDFLOWTYPE |
| VIRADOCITEM | TAXGROUP | C: CN | TIVRATAXGROUP |
| VIRADOCITEM | TAXTYPE | C: CN | TIVRATAXTYPE |