SAP CMS_RE_PRT_LR Real Estate Part LR details Table data and field list

CMS_RE_PRT_LR is a standard SAP Table which is used to store Real Estate Part LR details data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_RE_PRT_LR table consists of various fields, each holding specific information or linking keys about Real Estate Part LR details data available in SAP. These include PRT_LR_GUID (GUID for part LR), OBJ_PRT_GUID (GUID for Object part), PART_ID (Part ID for the Object), LR_ID (Link Key between RE and LR systems)... 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_RE_PRT_LR 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_RE_PRT_LR 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_RE_PRT_LR 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
PRT_LR_GUIDGUID for part LR CMS_RE_DTE_PRT_LR_GUIDRAW16SYSUUID
OBJ_PRT_GUIDGUID for Object part CMS_RE_DTE_OBJ_PRT_GUIDRAW16SYSUUID
PART_IDPart ID for the Object CMS_RE_DTE_PART_IDNUMC10CMS_RE_PRT_ID
LR_IDLink Key between RE and LR systems CMS_RE_DTE_LR_ID_LKYRAW16SYSUUID
CREATED_BYReal Estate Add-On User CMS_RE_DTE_CR_BYCHAR12CMS_RE_USER
CREATED_DATECreated On CMS_RE_DTE_CR_ONDATS8CMS_RE_DATE
CREATED_TIMECreated At CMS_RE_DTE_CR_ATTIMS6CMS_RE_TIME
ENTRY_SRCSorce of Initial entry CMS_RE_DTE_SRC_INITCHAR32CMS_RE_SOURCE
LAST_CHG_BYLast Changed By CMS_RE_DTE_CHG_BYCHAR12CMS_RE_USER
LAST_CHG_DATELast Changed On CMS_RE_DTE_CHG_ONDATS8CMS_RE_DATE
LAST_CHG_TIMELast Changed At CMS_RE_DTE_CHG_ATTIMS6CMS_RE_TIME
PROCESSING_SRCProcessing Source CMS_RE_DTE_PRC_SRCCHAR32CMS_RE_SOURCE

Key field Non-key field



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

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

SELECT SINGLE *
FROM CMS_RE_PRT_LR
INTO CORRESPONDING FIELDS OF WA_CMS_RE_PRT_LR
WHERE...

How to access SAP table CMS_RE_PRT_LR

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

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