The CMS_LR_DE_2 table in SAP ERP or S/4HANA stores Grundbuch – Section II data. There are total 15 fields in CMS_LR_DE_2 table. The Grundbuch – Section II table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_LR_DE_2 table. It is in Land register (CMS_RE_LR) ABAP package and is part of the Land Register (FS-CMS-MD-LR) module.
SAP CMS_LR_DE_2 Table Fields
Following is the list of fields that are available in SAP CMS_LR_DE_2 table. The primary key fields of the table are MANDT (Client), SEC2_GUID (GUID for Table CMS_LR_DE_2).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| SEC2_GUID | GUID for Table CMS_LR_DE_2 | CMS_DTE_LR_DE_SEC2_GUID | RAW (16) | |
| SECA_GUID | GUID for Table CMS_LR_DE_A | CMS_DTE_LR_DE_SECA_GUID | RAW (16) | |
| SERIAL_NO | Serial No | CMS_DTE_LR_DE_SERIAL_NUM | CHAR (32) | |
| SERIAL_NO_B | Serial number of the Property List Number | CMS_DTE_LR_DE_SECB_SR_NO | CHAR (4) | |
| PRIORITY | Priority of the Charge | CMS_DTE_LR_DE_PRIORITY | NUMC (4) | |
| CHG_RES_TYP | Section II Charge/Restriction Type | CMS_DTE_LR_DE_CHG_RES_TYP | * | CHAR (6) |
| VALUE | Value of the Charge/Restriction | CMS_DTE_LR_DE_VALUE | CURR (17) | |
| CURR | Currency of the Charge | CMS_DTE_LR_DE_CURR | TCURC | CUKY (5) |
| DESCRIPTION | Description | CMS_DTE_LR_DE_DESC | CHAR (60) | |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR (12) | |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC (15) | |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR (12) | |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) | |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR (32) |
