CMS_LR_DE_2 SAP table for – Grundbuch – Section II

Here we would like to draw your attention to CMS_LR_DE_2 table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_LR_DE_2 is a SAP standard transp table used for storing Grundbuch – Section II related data in SAP. It comes under the package CMS_RE_LR.

SAP CMS_LR_DE_2 table

Table CMS_LR_DE_2 technical data

TableCMS_LR_DE_2
Data storingGrundbuch – Section II
ModuleFS
Sub ModuleFS-CMS-MD-LR
SAP PackageCMS_RE_LR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_LR_DE_2 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_LR_DE_2 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Structure for Section 2 – Primary key
    Its a key field.
  • SEC2_GUID : GUID for Table CMS_LR_DE_2
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Grundbuch – Section A – Link Key
  • SECA_GUID : GUID for Table CMS_LR_DE_A
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Section 2 data
  • SERIAL_NO : Serial No
    Its data type is CHAR (Character String) with field length 32
  • SERIAL_NO_B : Serial number of the Property List Number
    Its data type is CHAR (Character String) with field length 4
  • PRIORITY : Priority of the Charge
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CHG_RES_TYP : Section II Charge/Restriction Type
    Its data type is CHAR (Character String) with field length 6
  • VALUE : Value of the Charge/Restriction
    Its data type is CURR (Currency Field) with field length 17
  • CURR : Currency of the Charge
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DESCRIPTION : Description
    Its data type is CHAR (Character String) with field length 60
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32