SAP VILMRG Real Estate Register - Entries Table
Overview
VILMRG is a standard SAP S/4HANA table that stores Real Estate Register - Entries data. There are total 27 fields in the VILMRG table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILMRG 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 VILMRG to other SAP tables and standard CDS views available based on VILMRG table in S/4HANA 2020.
Techincal Settings of VILMRG
Below are technical details of the table VILMRG
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILMRG Fields
The following table gives you an overview of the fields available in VILMRG
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| LRREGNO | Real Estate Register Number | RELMLRREGNO | CHAR | 6 | |
| LRREGSUBNO | RE Register Number: Subentry | RELMLRREGSUBNO | NUMC | 4 | |
| COOWNERNUM | Coownership: Numerator | RELMCOOWNERNUMERATOR | INT4 | 10 | |
| COOWNERDENOM | Coownership: Denominator | RELMCOOWNERDENOMINATOR | INT4 | 10 | |
| RPRGNO | Real Properties Register Number | RELMRPRGNO | NUMC | 6 | |
| LRMEASVALUE | Measurement Amount Relevant for Land Register | RELMLRMEASVALUE | QUAN | 17 | |
| MEASUNIT | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| APPLICATIONDATE | Date of Application | RELMAPPLICATIONDATE | DATS | 8 | |
| ENTRYDATE | Date of Entry | RELMENTRYDATE | DATS | 8 | |
| APPROVALDATE | Date of Consent | RELMAPPROVALDATE | DATS | 8 | |
| CANCELDATE | Date of Cancellation of Entry | RELMCANCELDATE | DATS | 8 | |
| XCOMMENT | Comment | RELMXCOMMENT | CHAR | 80 | |
| HERITLRDISTRICT | Land Lease Right: Land Register District | RELMHERITLRDISTRICT | TIVLMLRDIST | CHAR | 6 |
| HERITLRVOLUMENO | Land Lease Right: Volume Number of Land Register | RELMHERITLRVOLUMENO | CHAR | 15 | |
| HERITLRPAGENO | Land Lease Right: Page Number in Land Register | RELMHERITLRPAGENO | CHAR | 15 | |
| HERITSEC2NO | Land Lease Right: Sequence Number of Land Register Section 2 | RELMHERITSEC2NO | CHAR | 6 | |
| HERITOWNER | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| HERITFIXTERMDATE | Land Lease Right: End Date | RELMHERITFIXTERMDATE | DATS | 8 | |
| HERITTERM | Land Lease Right: Term in Years | RELMHERITTERM | NUMC | 3 | |
| ISDOMTENENTRY | Related Right in Real Estate Register | RELMISDOMTENENTRY | CHAR | 1 | |
| DOMTENENTRYDATE | End of Validity of Related Right | RELMDOMTENENTRYDATE | DATS | 8 | |
| ENCUMBRANCETYPE | Encumbrance Type | RELMENCUMBRANCETYPE | TIVLMENCTYPE | CHAR | 8 |
| PLEXTIDENTKEY | ID of External Parcel - OBSOLETE | RELMLRPLEXTIDENTKEY | CHAR | 45 | |
| PLOBJNR | Object Number of Assigned Parcel | RELMLRPLOBJNR | * | CHAR | 22 |
| PLEXTIDENTKEYL | ID of External Parcel | RELMLRPLEXTIDENTKEYL | CHAR | 60 |
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 VILMRG
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILMRG | ENCUMBRANCETYPE | C: CN | TIVLMENCTYPE |
| VILMRG | HERITLRDISTRICT | 1: CN | TIVLMLRDIST |
| VILMRG | MEASUNIT | 1: CN | T006 |