VIXCRAESRREFI SAP (Assignment of ISR Ref./Cash Flow Plan (Item)) Table details
Dictionary Type: Table
Description: Assignment of ISR Ref./Cash Flow Plan (Item)
Description: Assignment of ISR Ref./Cash Flow Plan (Item)
ABAP Code to SELECT data from VIXCRAESRREFI
Related tables to VIXCRAESRREFI
Access table VIXCRAESRREFI
Related tables to VIXCRAESRREFI
Access table VIXCRAESRREFI
Table field list including key, data, relationships and ABAP select examples
VIXCRAESRREFI is a standard SAP Table which is used to store Assignment of ISR Ref./Cash Flow Plan (Item) data and is available within R/3 SAP systems depending on the version and release level.
The VIXCRAESRREFI table consists of various fields, each holding specific information or linking keys about Assignment of ISR Ref./Cash Flow Plan (Item) data available in SAP. These include ESRREFIGUID (Generic Key of Assignment Item for Vendor Invoice), ESRREFHGUID (Generic Key of Vendor Invoice), OBJNR (Account Assignment: Object Number), CONDTYPE (Condition Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIXCRAESRREFI table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ESRREFIGUID | Generic Key of Assignment Item for Vendor Invoice | REXCRAESRREFIGUID | RAW | 16 | RECAGUID | ||||
| ESRREFHGUID | Generic Key of Vendor Invoice | REXCRAESRREFHGUID | RAW | 16 | VIXCRAESRREFI | RECAGUID | |||
| OBJNR | Account Assignment: Object Number | RERAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
| CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
| CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15(2) | RECACURR | ||||
| DATEFROM | Date: Valid From | RECADATEFROM | DATS | 8 | RECADATEBEG | ||||
| DATETO | Date: Valid To | RECADATETO | DATS | 8 | REDAT | RECADATEEND | |||
| ALLOCTYPE | Position Where the Item Was Assigned | REXCRAESRREFALLOCTYPE | NUMC | 1 | REXCRAESRREFALLOCTYPE | ||||
| NEWCONDTYPE | Create New Condition: One-Time Condition | REXCRAESRREFNEWCONDTYPE | CHAR | 1 | RECABOOL | ||||
| UNIQUECOND | Condition Is One-Time Condition | RECDUNIQUECOND | CHAR | 1 | RECABOOL | ||||
| DOCGUID | GUID: Unique Internal Key for RE Document | RERADOCGUID | RAW | 16 | VIRADOC | RECAGUID | |||
| ITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | POSNR_ACC | ||||
| REVERSAL | Reverse ID (1: reverse) | REVID_EBJP | NUMC | 1 | NUMC1 | ||||
| RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
| DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
| REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
| RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 |
| Key field | Non-key field |
How do I retrieve data from SAP table VIXCRAESRREFI using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIXCRAESRREFI to SELECT all data from the tableDATA: WA_VIXCRAESRREFI TYPE VIXCRAESRREFI.
SELECT SINGLE *
FROM VIXCRAESRREFI
INTO CORRESPONDING FIELDS OF WA_VIXCRAESRREFI
WHERE...
How to access SAP table VIXCRAESRREFI
Within an ECC or HANA version of SAP you can also view further information about VIXCRAESRREFI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects