SAP VDHGRPF Encumbrances on real estate table Table
Overview
VDHGRPF is a standard SAP S/4HANA table that stores Encumbrances on real estate table data. There are total 52 fields in the VDHGRPF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDHGRPF belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDHGRPF to other SAP tables and standard CDS views available based on VDHGRPF table in S/4HANA 2020.
Techincal Settings of VDHGRPF
Below are technical details of the table VDHGRPF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDHGRPF Fields
The following table gives you an overview of the fields available in VDHGRPF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| RSICHER | Collateral reference number | RSICHER | NUMC | 8 | |
| SSICH | Collateral type | SSICH | TD01 | CHAR | 4 |
| SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | |
| BGRPFSUM | Alternative liability amount | BGRPFSUM | CURR | 13 | |
| SWHRGRPF | Currency | SWHR | CUKY | 5 | |
| SGRPFART | Encumbrance on real estate type | SGRPFART | CHAR | 1 | |
| SHYPART | Mortgage Type | SHYPART | CHAR | 1 | |
| SGRPFTYP | Form of encumbrance on real estate | SGRPFTYP | CHAR | 1 | |
| XBRIEFNR | Number of land charge certificate | XBRIEFNR | CHAR | 20 | |
| DURKBR | Document date/expert opinion date | DURK | DATS | 8 | |
| DGBMIT1 | Date of application for registration of land | DEINANT | DATS | 8 | |
| RABTRET | Assigned by | RABTRET | CHAR | 50 | |
| DABTRET | Date of assignment for collateral security | DABTRET | DATS | 8 | |
| DAUFLASS | Date of conveyance | DAUFLASS | DATS | 8 | |
| DGBMIT2 | Date of creation of release of a mortgage | DLOEANT | DATS | 8 | |
| PVSTRECK | Percent. rate enforceability of encumbrances on real estate | PVSTRECK | DEC | 10 | |
| BVSTRECK | Yearly repayment rate of enforceable official copy | BVSTRECK | CURR | 13 | |
| JGSGESAMT | Total encumbrance on real estate indicator | JGSRECHT | CHAR | 1 | |
| JTREU | Trustee approval indicator | JTREU | CHAR | 1 | |
| JREVALUT | Revaluating indicator | JREVALUT | CHAR | 1 | |
| DGBMIT | Date of land register notice | DGBMIT | DATS | 8 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RBELAST | Type of encumbrance in section 3 of land register | RBELAST | TIV02 | NUMC | 2 |
| SRANG | Ranking | VVSRANG | CHAR | 1 | |
| BDARLEH | Total amount of right registered in Section III | BDARLEH | CURR | 13 | |
| SNRABT3 | No. of entry in Section 3 of land register | SNRABT3 | NUMC | 3 | |
| XNRA3 | Section 3 number of entry | VVXNRA3 | CHAR | 6 | |
| KOMM1 | Name | XLBEZ | CHAR | 50 | |
| KOMM2 | Name | XLBEZ | CHAR | 50 | |
| REFSICHER | Collateral reference number | RSICHER | NUMC | 8 | |
| REFOBJ | Collateral object number | ROBJNR | NUMC | 10 | |
| BFREIIII | Previous release amount | VVBFREIIII | CURR | 13 | |
| DFREITL | Date of last partial release of an encumbrance on real est. | VVDFREITL | DATS | 8 | |
| BABTRAKT | Current assignment amount for encumbrance | BABTAKT | CURR | 13 | |
| SECNO | Land Register Section: Sequence Number of Entry | FVD_LR_SECNO | CHAR | 6 | |
| SECSUBNO | Section in Land Register: Subentry | FVD_LR_SECSUBNO | NUMC | 4 | |
| ENTRYDATE | Date of Entry | FVD_LR_ENTRYDATE | DATS | 8 | |
| ENCCURRENCY | Currency of Total Amount | FVD_LR_ENCCURRENCY | CUKY | 5 | |
| RANKINGNO | Ranking Number | FVD_LR_RANK | NUMC | 4 | |
| XCOMMENT | Comment | FVD_LR_XCOMMENT | CHAR | 80 | |
| APPROVALDATE | Date of Approval | FVD_LR_APPROVALDATE | DATS | 8 | |
| LANDCHRGINTRATE | Land charge interest rate | FVD_LR_LANDCHRGINTRATE | DEC | 10 |
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 VDHGRPF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDHGRPF | MANDT | 1: N | T000 |
| VDHGRPF | RBELAST | 1: CN | TIV02 |
| VDHGRPF | SSICH | 1: CN | TD01 |