TCMS_RE_OBJ_PRT SAP table for – Real Estate object type – Building Parts relationship

Here we would like to draw your attention to TCMS_RE_OBJ_PRT 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). TCMS_RE_OBJ_PRT is a SAP standard transp table used for storing Real Estate object type – Building Parts relationship related data in SAP. It comes under the package CMS_RE.

SAP TCMS_RE_OBJ_PRT table

Table TCMS_RE_OBJ_PRT technical data

TableTCMS_RE_OBJ_PRT
Data storingReal Estate object type – Building Parts relationship
ModuleFS
Sub ModuleFS-CMS-MD-RE
SAP PackageCMS_RE
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FINSERV
Table CategoryTRANSP

SAP TCMS_RE_OBJ_PRT 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 TCMS_RE_OBJ_PRT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Strcuture for primary key for Object type
    Its a key field.
  • OBJECT_TYPE : Real Estate Object Type ID
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Strcuture for Object Part Type Primary key
    Its a key field.
  • BLD_PART_TYPE : Attribute Indicator Type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Object – building part data
  • SUB_AST_CREATE : Indicates whether a Sub-asset is created for Building Part
    Its data type is CHAR (Character String) with field length 1
  • FSTAT_VAR : Object Screen (Field Status Variant)
    Its data type is CHAR (Character String) with field length 10
  • UNIT_VALN_FREQ : Indicator : Valuation Period
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VALN_FREQ : Period of revaluation for a real estate
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SFTY_DSCNT : Safety discount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Lending rates
  • LENDING_RATE1 : Lending rate 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE2 : Lending rate 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE3 : Lending rate 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE4 : Lending rate 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE5 : Lending rate 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10