SAP CMS_LR_DE_A Grundbuch - Section A Table data and field list

CMS_LR_DE_A is a standard SAP Table which is used to store Grundbuch - Section A data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_LR_DE_A table consists of various fields, each holding specific information or linking keys about Grundbuch - Section A data available in SAP. These include SECA_GUID (GUID for Table CMS_LR_DE_A), DISTRICT (District Court), SUB_DISTRICT (Land Register District), VOLUME_NO (Volume Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_LR_DE_A table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMS_LR_DE_A table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_LR_DE_A table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
SECA_GUIDGUID for Table CMS_LR_DE_A CMS_DTE_LR_DE_SECA_GUIDRAW16SYSUUID
DISTRICTDistrict Court CMS_DTE_LR_DE_DISTRICTCHAR25CMS_LR_DE_TEXT25
SUB_DISTRICTLand Register District CMS_DTE_LR_DE_SUB_DISTRICTCHAR25CMS_LR_DE_TEXT25
VOLUME_NOVolume Number CMS_DTE_LR_DE_VOLUME_NOCHAR15CMS_LR_DE_TEXT15
PAGE_NOPage Number CMS_DTE_LR_DE_PAGE_NOCHAR15CMS_LR_DE_TEXT15
REG_TYPERegister Type CMS_DTE_LR_DE_REG_TYPCHAR6CMS_RE_TYP
OLD_REF_IDReference of Old Land Register, in case data was migrated CMS_DTE_LR_DE_OLD_REF_IDCHAR32CMS_LR_DE_OLD_REF_ID
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



How do I retrieve data from SAP table CMS_LR_DE_A using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_LR_DE_A to SELECT all data from the table
DATA: WA_CMS_LR_DE_A TYPE CMS_LR_DE_A.

SELECT SINGLE *
FROM CMS_LR_DE_A
INTO CORRESPONDING FIELDS OF WA_CMS_LR_DE_A
WHERE...

How to access SAP table CMS_LR_DE_A

Within an ECC or HANA version of SAP you can also view further information about CMS_LR_DE_A and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).