SAP CMS_LR_DE_B Grundbuch - Section B Table data and field list

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

The CMS_LR_DE_B table consists of various fields, each holding specific information or linking keys about Grundbuch - Section B data available in SAP. These include SECB_GUID (GUID for Table CMS_LR_DE_B), SECA_GUID (GUID for Table CMS_LR_DE_A), SERIAL_NO (Serial number of the Property List Number), LOCATION (Location / Parish)... 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_B 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_B 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_B 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
SECB_GUID	GUID for Table CMS_LR_DE_B	CMS_DTE_LR_DE_SECB_GUID	RAW	16			SYSUUID
SECA_GUID	GUID for Table CMS_LR_DE_A	CMS_DTE_LR_DE_SECA_GUID	RAW	16			SYSUUID
SERIAL_NO	Serial number of the Property List Number	CMS_DTE_LR_DE_SECB_SR_NO	CHAR	4		ALPHA	CMS_LR_DE_SERIAL_NO
LOCATION	Location / Parish	CMS_DTE_LR_DE_SECB_LOC	CHAR	60			CMS_LR_DE_TEXT60
AREA	Area	CMS_DTE_LR_DE_AREA	QUAN	13(3)			CMS_LR_DE_AREA
AREA_UOM	Unit of Measure	CMS_DTE_LR_DE_AREA_UOM	UNIT	3	T006	CUNIT	MEINS		CMS_ELM_SURFACE_UOM
FLUR	Flur	CMS_DTE_LR_DE_FLUR	CHAR	10			CMS_LR_DE_FLUR
FLURSTUECK	Parcel of the land. Flurstueck in German	CMS_DTE_LR_DE_FLURSTUECK	CHAR	60			CMS_LR_DE_TEXT60
CREATED_BY	Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12			CMS_USER
CREATED_AT	Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15			TZNTSTMPS
CHANGED_BY	Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12			CMS_USER
CHANGED_AT	Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15			TZNTSTMPS
SOURCEOFENTRY	Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32			CMS_SOURCE

Key field

Non-key field

< CMS_LR_DE_A - Grundbuch - Section A CMS_MESSAGE_CRM - >

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

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

SELECT SINGLE *
FROM CMS_LR_DE_B
INTO CORRESPONDING FIELDS OF WA_CMS_LR_DE_B
WHERE...

How to access SAP table CMS_LR_DE_B

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

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