CMS_RE_PRT_VAL SAP table for – Real Estate Part value details

Here we would like to draw your attention to CMS_RE_PRT_VAL 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_RE_PRT_VAL is a SAP standard transp table used for storing Real Estate Part value details related data in SAP. It comes under the package CMS_RE.

SAP CMS_RE_PRT_VAL table

Table CMS_RE_PRT_VAL technical data

TableCMS_RE_PRT_VAL
Data storingReal Estate Part value details
ModuleFS
Sub ModuleFS-CMS-MD-RE
SAP PackageCMS_RE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_RE_PRT_VAL 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_RE_PRT_VAL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for Part value
    Its a key field.
  • PRT_VAL_GUID : GUID for part value
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for Object parts
  • OBJ_PRT_GUID : GUID for Object part
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Part ID
  • PART_ID : Part ID for the Object
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Structure for Valuation System (Data)
  • VAL_TYPE : Value Calculation Method
    Its data type is CHAR (Character String) with field length 10
  • CALC_AMOUNT : Calculated Value
    Its data type is CURR (Currency Field) with field length 17
  • CALC_AMT_CURR : Calculated value Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ENTERED_AMOUNT : Entered Value
    Its data type is CURR (Currency Field) with field length 17
  • ENT_AMT_CURR : Entered value Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VAL_VALID_FROM : Date from which Real Estate Value stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_VALID_TO : Date unitl which Real Estate Value stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_DATE : Date on which Real Estate Valuation was Performed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_ORIGIN : Origin of Value
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Structure for history
  • CREATED_BY : Real Estate Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ENTRY_SRC : Sorce of Initial entry
    Its data type is CHAR (Character String) with field length 32
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PROCESSING_SRC : Processing Source
    Its data type is CHAR (Character String) with field length 32