SAP VICEQUERY Leasing Questionnaire Table
Overview
VICEQUERY is a standard SAP S/4HANA table that stores Leasing Questionnaire data. There are total 13 fields in the VICEQUERY table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VICEQUERY belongs to Flexible Real Estate Management (RE-FX) module and is located in the package RE: Terms CE (Evaluation Term) (RE_CE_TM).
In addition, following links provide an overview of foreign key relationships, if any, that link VICEQUERY to other SAP tables and standard CDS views available based on VICEQUERY table in S/4HANA 2020.
Techincal Settings of VICEQUERY
Below are technical details of the table VICEQUERY
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VICEQUERY Fields
The following table gives you an overview of the fields available in VICEQUERY
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| QUERYGUID | GUID for Questionnaire | RECEQUERYGUID | RAW | 16 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| CECATALOG | Identification of Catalog | RECECECATALOG | * | CHAR | 10 |
| ABSOLUTEBEGIN | Absolute Start | RECEABSOLUTEBEGIN | DATS | 8 | |
| ABSOLUTEEND | Absolute End | RECEABSOLUTEEND | DATS | 8 | |
| PROBABLEEND | Probable End | RECEPROBABLEEND | DATS | 8 | |
| ENDOFUSAGE | End of Usage | RECEENDOFUSAGE | DATS | 8 | |
| INTERESTRATE | Interest Rate | RECEINTERESTRATE | DEC | 15 | |
| MARKETVALUE | Market Value | RECEMARKETVALUE | CURR | 23 | |
| NPV | Present Value | RECENPV | CURR | 15 | |
| CURRENCY | Valuation Currency | RECECURR | * | CUKY | 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 VICEQUERY