The CMS_RE_PRT_CST table in SAP ERP or S/4HANA stores Real Estate Part Cost details data. There are total 26 fields in CMS_RE_PRT_CST table. The Real Estate Part Cost details table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_RE_PRT_CST table. It is in Collateral Management System: Real Esate (CMS_RE) ABAP package and is part of the Real Estate (FS-CMS-MD-RE) module.
SAP CMS_RE_PRT_CST Table Fields
Following is the list of fields that are available in SAP CMS_RE_PRT_CST table. The primary key fields of the table are MANDT (Client), PRT_CST_GUID (GUID for part cost).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| PRT_CST_GUID | GUID for part cost | CMS_RE_DTE_PRT_CST_GUID | RAW (16) | |
| OBJ_PRT_GUID | GUID for Object part | CMS_RE_DTE_OBJ_PRT_GUID | RAW (16) | |
| PART_ID | Part ID for the Object | CMS_RE_DTE_PART_ID | NUMC (10) | |
| COST_TYPE | Cost Type | CMS_RE_DTE_ATT_ID_TY_REO012 | TCMS_ATT_ID_TY | CHAR (6) |
| COST_DESC | Description of the cost | CMS_RE_DTE_CST_DESC | CHAR (30) | |
| COST_DATE | Date on which the Cost was Incurred | CMS_RE_DTE_CST_DATE | DATS (8) | |
| COST_AMT | Actual Cost Amount | CMS_RE_DTE_CST_AMOUNT | CURR (17) | |
| COST_CURR | Cost Currency | CMS_RE_DTE_CST_CURR | TCURC | CUKY (5) |
| COST_BASE_MEAS | Base Measure | CMS_RE_DTE_BASE_MEAS | CHAR (1) | |
| PLAN_COST_AMT | Plan Cost Amount | CMS_RE_DTE_PLAN_CST_AMOUNT | CURR (17) | |
| PLAN_COST_CURR | Cost currency | CMS_RE_DTE_PLAN_CST_CURR | * | CUKY (5) |
| IND_VAL_MAINTAIN | Indicator – Value Enhancing/ Increasing | CMS_RE_DTE_VAL_MAINTAIN | CHAR (2) | |
| CST_MEASURE | Modernization or Renovation Measure | CMS_RE_DTE_ATT_ID_TY_REO017 | TCMS_ATT_ID_TY | CHAR (6) |
| FLG_DEDUCT_COST | Flag – Allowable Costs | CMS_RE_DTE_FLG_DEDUCT_COST | CHAR (1) | |
| DEDUCT_CST_AMT | Allowable Cost Amount | CMS_RE_DTE_DEDUCT_CST_AMT | CURR (17) | |
| DEDUCT_CST_CURR | Allowable Cost Currency | CMS_RE_DTE_DEDUCT_CST_CURR | * | CUKY (5) |
| DEDUCT_CST_PCT | Allowable Cost In Percentage | CMS_RE_DTE_DEDUCT_CST_PCT | DEC (10) | |
| CREATED_BY | Real Estate Add-On User | CMS_RE_DTE_CR_BY | CHAR (12) | |
| CREATED_DATE | Created On | CMS_RE_DTE_CR_ON | DATS (8) | |
| CREATED_TIME | Created At | CMS_RE_DTE_CR_AT | TIMS (6) | |
| ENTRY_SRC | Sorce of Initial entry | CMS_RE_DTE_SRC_INIT | CHAR (32) | |
| LAST_CHG_BY | Last Changed By | CMS_RE_DTE_CHG_BY | CHAR (12) | |
| LAST_CHG_DATE | Last Changed On | CMS_RE_DTE_CHG_ON | DATS (8) | |
| LAST_CHG_TIME | Last Changed At | CMS_RE_DTE_CHG_AT | TIMS (6) | |
| PROCESSING_SRC | Processing Source | CMS_RE_DTE_PRC_SRC | CHAR (32) |
