SAP VILMEM Rights and Easements - Header Entry Table
Overview
VILMEM is a standard SAP S/4HANA table that stores Rights and Easements - Header Entry data. There are total 21 fields in the VILMEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILMEM belongs to Land Use Management (RE-FX-LM) module and is located in the package RE: Land Register (RE_LM_LR).
In addition, following links provide an overview of foreign key relationships, if any, that link VILMEM to other SAP tables and standard CDS views available based on VILMEM table in S/4HANA 2020.
Techincal Settings of VILMEM
Below are technical details of the table VILMEM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILMEM Fields
The following table gives you an overview of the fields available in VILMEM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| SECTYPE | Type of Section in Land Register | RELMSECTYPE | CHAR | 1 | |
| SECNO | Land Register Section: Sequence Number of Entry | RELMSECNO | CHAR | 6 | |
| SECSUBNO | Section in Land Register: Subentry | RELMSECSUBNO | NUMC | 4 | |
| ENTRYDATE | Date of Entry | RELMENTRYDATE | DATS | 8 | |
| CANCELDATE | Date of Cancellation of Entry | RELMCANCELDATE | DATS | 8 | |
| APPLICATIONDATE | Date of Application | RELMAPPLICATIONDATE | DATS | 8 | |
| APPROVALDATE | Date of Consent | RELMAPPROVALDATE | DATS | 8 | |
| ENCVALIDTO | End Date of a Limited Encumbrance | RELMENCVALIDTO | DATS | 8 | |
| ENCUMBRANCETYPE | Encumbrance Type | RELMENCUMBRANCETYPE | TIVLMENCTYPE | CHAR | 8 |
| RANKINGNO | Ranking Number | RELMRANKINGNO | NUMC | 4 | |
| RANKSECTYPE | Section for Rank | RELMRANKSECTYPE | CHAR | 1 | |
| RANKBEFSECNO | Rank Before Sequence Number in Section | RELMRANKBEFSECNO | CHAR | 6 | |
| RANKFORSECNO | Add Rank to Current Section Number | RELMRANKFORSECNO | CHAR | 6 | |
| PROCESSINGNO | Processing Number | RELMPROCESSINGNO | CHAR | 12 | |
| LANDCHRGCERT | Number of Real Property Loan Certificate | RELMLANDCHRGCERT | CHAR | 12 | |
| LANDCHRGINTRATE | Interest Rate for Loan Secured by Real Property | RELMLANDCHRGINTRATE | DEC | 10 | |
| ENCVALUE | Total Amount of Encumbrance Entered in Section III | RELMENCVALUE | CURR | 15 | |
| ENCCURRENCY | Currency of Total Amount | RELMENCCURRENCY | TCURC | CUKY | 5 |
| XCOMMENT | Comment | RELMXCOMMENT | CHAR | 80 |
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 VILMEM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILMEM | ENCCURRENCY | C: CN | TCURC |
| VILMEM | ENCUMBRANCETYPE | 1: CN | TIVLMENCTYPE |