SAP CMS_RE_PRT_DOC Real Estate Document details Table data and field list

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

The CMS_RE_PRT_DOC table consists of various fields, each holding specific information or linking keys about Real Estate Document details data available in SAP. These include PRT_DOC_GUID (GUID for part Document), OBJ_PRT_GUID (GUID for Object part), PART_ID (Part ID for the Object), DOC_REFERENCEID (Reference Document ID)... 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_DOC 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_DOC 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_DOC 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_DOC_GUIDGUID for part Document CMS_RE_DTE_PRT_DOC_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
DOC_REFERENCEIDReference Document ID CMS_DTE_REF_DOCIDCHAR64CMS_REFID
DOC_TYPEDocument Type CMS_DTE_DOC_TYPCHAR6TCMS_DOC_TYPCMS_DOC_TYPCMS_DOC_TYP
DOC_DATEDocument Date CMS_DTE_DOC_DATEDATS8CMS_DATE
PHYSICAL_LOCNPhysical Location of Document CMS_DTE_DOC_ATT_ID_TY_DOC001CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
DOC_VALID_FROMDate on which the Document came into effect CMS_RE_DTE_DOC_VALID_FROMNUMC15TSTPSTZNTSTMPSL
DOC_VALID_TODate until which the Document stands valid CMS_RE_DTE_DOC_VALID_TONUMC15TSTPSTZNTSTMPSL
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_DOC using ABAP code

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

SELECT SINGLE *
FROM CMS_RE_PRT_DOC
INTO CORRESPONDING FIELDS OF WA_CMS_RE_PRT_DOC
WHERE...

How to access SAP table CMS_RE_PRT_DOC

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

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