SAP CMS_RE_PRT_VAL Real Estate Part value details Table data and field list

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

The CMS_RE_PRT_VAL table consists of various fields, each holding specific information or linking keys about Real Estate Part value details data available in SAP. These include PRT_VAL_GUID (GUID for part value), OBJ_PRT_GUID (GUID for Object part), PART_ID (Part ID for the Object), VAL_TYPE (Value Calculation Method)... 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_VAL 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: Can be enhanced (character-type or numeric)


SAP CMS_RE_PRT_VAL 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_VAL 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_VAL_GUIDGUID for part value CMS_RE_DTE_PRT_VAL_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
VAL_TYPEValue Calculation Method CMS_DTE_VAL_RESULT_IDCHAR10TCMS_VAL_RESCMS_VAL_ID
CALC_AMOUNTCalculated Value CMS_RE_DTE_CALC_VAL_AMOUNTCURR17(2) CMS_RE_AMOUNT
CALC_AMT_CURRCalculated value Currency CMS_RE_DTE_CALC_VAL_CURRCUKY5TCURCWAERS
ENTERED_AMOUNTEntered Value CMS_RE_DTE_ENTERED_VAL_AMOUNTCURR17(2) CMS_RE_AMOUNT
ENT_AMT_CURREntered value Currency CMS_RE_DTE_ENTERED_VAL_CURRCUKY5Assigned to domainWAERS
VAL_VALID_FROMDate from which Real Estate Value stands Valid CMS_RE_DTE_VAL_VALID_FROMDATS8DATUM
VAL_VALID_TODate unitl which Real Estate Value stands Valid CMS_RE_DTE_VAL_VALID_TODATS8DATUM
VAL_DATEDate on which Real Estate Valuation was Performed CMS_RE_DTE_VAL_DATEDATS8CMS_RE_DATE
VAL_ORIGINOrigin of Value CMS_RE_DTE_ATT_ID_TY_REO016CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
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_VAL using ABAP code

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

SELECT SINGLE *
FROM CMS_RE_PRT_VAL
INTO CORRESPONDING FIELDS OF WA_CMS_RE_PRT_VAL
WHERE...

How to access SAP table CMS_RE_PRT_VAL

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

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