CMS_RE_OBJ_PRT SAP table for – Real Estate Object part details

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

SAP CMS_RE_OBJ_PRT table

Table CMS_RE_OBJ_PRT technical data

TableCMS_RE_OBJ_PRT
Data storingReal Estate Object part 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_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 CMS_RE_OBJ_PRT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for Object part
    Its a key field.
  • OBJ_PRT_GUID : GUID for Object part
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for the real estate object
  • OBJ_GUID : GUID for Real Estate Object
    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 Basic Part Details
  • BLD_PART_TYPE : Building Part Type
    Its data type is CHAR (Character String) with field length 6
  • PART_COND : Object condition
    Its data type is CHAR (Character String) with field length 6
  • MAIN_USAGE : Usage Type
    Its data type is CHAR (Character String) with field length 6
  • ADD_USAGE_1 : Additional Usage 1
    Its data type is CHAR (Character String) with field length 6
  • ADD_USAGE_2 : Additional Usage 2
    Its data type is CHAR (Character String) with field length 6
  • BLD_METHOD_ROOF : Building method – Roof
    Its data type is CHAR (Character String) with field length 6
  • BLD_METHOD_BODY : Building method – Body
    Its data type is CHAR (Character String) with field length 6
  • BLD_METD_CELLAR : Building method – Cellar
    Its data type is CHAR (Character String) with field length 6
  • UTILIZATION : Utilization of the Object
    Its data type is CHAR (Character String) with field length 6
  • PART_DESC : Description of Building Part
    Its data type is CHAR (Character String) with field length 30
  • COMM_USAGE_PCT : Commercial Usage as a Percentage of Total Usage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • OTHER_USG_FLG : Indicates if Usages in addition to Main Usage are Possible
    Its data type is CHAR (Character String) with field length 1
  • REF_OBJ_PRT_GUID : Reference Object Part GUID
    Its data type is RAW (Byte string) with field length 16
  • IS_SUB_AST_CREA : Indicates whether a Sub-asset is created for Building Part
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure for Part Size Details
  • USEFUL_AREA : Usable Area
    Its data type is QUAN (Quantity field) with field length 13
  • USBL_AREA_UOM : Unit of Measure for Usable Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • USEFUL_AREA_REN : Rented Usable Area
    Its data type is QUAN (Quantity field) with field length 13
  • USBL_AR_REN_UOM : Unit of Measure for Usable Rented Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • USEFUL_VOL : Usable Volume of Real Estate Building Parts
    Its data type is QUAN (Quantity field) with field length 13
  • USBL_VOL_UOM : Unit of Measure for Usable Volume of Real Estate
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • USEFUL_VOL_REN : Usable Volume of the Rented Portions of Real Estate
    Its data type is QUAN (Quantity field) with field length 13
  • USBL_VL_REN_UOM : Unit of measure for usable volume of Rented Parts
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RESIDENTIAL_AREA : Residential Area
    Its data type is QUAN (Quantity field) with field length 13
  • RES_AR_UOM : Unit of Measure for Residential Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SECONDARY_AREA : Secondary Area
    Its data type is QUAN (Quantity field) with field length 13
  • SEC_AREA_UOM : Unit of Measure for Secondary Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OTHER_AREA : Other Area
    Its data type is QUAN (Quantity field) with field length 13
  • OTH_AREA_UOM : Unit of Measure for Other Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Structure for Part Unit Details
  • NO_PRT_UNIT : Number of building part units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PRT_UNIT_REN : Number of building part units rented
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for dates
  • CONS_START_DATE : Start Date of Construction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PERMSN_APPL_DATE : Building Permssion applied date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PERMSN_OBTD_DATE : Building Permssion obtained date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OCCY_DATE : Occupancy Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COMP_DATE : Completion Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FINAL_INSP_DATE : Date of Final Inspection
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for Part Rent Details
  • RENT_AMT_PLANNED : Planned Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • RENT_AMT_ACTUAL : Actual Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • RENT_PLAN_CURR : Planned Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RENT_ACT_CURR : Actual Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BASE_PERIOD : Base period for the rent
    Its data type is CHAR (Character String) with field length 1
  • BASE_MEASURE : Base Measure
    Its data type is CHAR (Character String) with field length 1
  • VACANT_POSN_PCT : Ratio of Real Estate not rented to Total Real Estate Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • RES_RENT_IND : Indicator for Net or Gross Rent
    Its data type is CHAR (Character String) with field length 1
  • COMP_RENT_RES : Comparative Rent (Residential)
    Its data type is CURR (Currency Field) with field length 17
  • COM_REN_RES_CURR : Comparative Rent Currency – Residential
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Structure for Land Area & UOM
  • LAND_AREA : Land Area of the Real Estate
    Its data type is QUAN (Quantity field) with field length 13
  • LAND_AREA_UOM : Unit of Measure of Land Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LAND_AREA_REN : Land Area of the Real Estate which is Rented
    Its data type is QUAN (Quantity field) with field length 13
  • LAND_AR_REN_UOM : Land area unit of measure(rented)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Structure for General Details
  • NO_OF_UNITS : No of units in real estate object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_OF_FLOORS : Number of Floors
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_GARAGES : No of Garages in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_GARAGES_REN : No of Garages Rented in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PARK_UNIT : Number of Parking Units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PARK_UNIT_REN : Number of Parking Units Rented
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PARK_UG : Number of Underground Parking Units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PARK_UG_REN : Number of Rented Underground Parking Units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for Residential Details
  • NO_CUR_UNITS : No of current units in real estate object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_CUR_UNITS_REN : No of Current Units Rented in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_OLD_UNITS : No of old units in real estate object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_OLD_UNITS_REN : No of Old Units Rented in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_NEW_UNITS : No of new units in real estate object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_NEW_UNITS_REN : No of New units Rented in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for Number of Units in Office
  • NO_ACCESS_STR : No of Access Structures
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for Number of Sales level in Commericial Building
  • NO_SALE_LEVEL : No of Sale levels in commercial building
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for Number of Rooms in the hotel/clinic
  • NO_OF_ROOMS : No of rooms in the hotel/clinic
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for Number of rooms in the clinic/nursing home
  • NO_OF_BEDS : No of beds in the clinic/nursing home
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for Commericial Details
  • COMM_ENV_DESC : Description of the commercial environment
    Its data type is CHAR (Character String) with field length 30
  • ACCESS_STR_DESC : Description of the Access Structures
    Its data type is CHAR (Character String) with field length 30
  • BLD_SECTION_DESC : Building Section
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for Hotel Details
  • PRICE_CATEGORY : Price Category
    Its data type is CHAR (Character String) with field length 6
  • AVG_PRICE : Average Price per Day
    Its data type is CURR (Currency Field) with field length 17
  • AVG_PRICE_CURR : Average Price Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for Other Details in RE Object
  • OCCUPANCY_PCT : Occupancy specified in Percentage Terms
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • TURNOVER_AMT : Total Amount of Turnover
    Its data type is CURR (Currency Field) with field length 17
  • TURNOVER_CURR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RENTAL_AGMT_TYP : Rental Agreement Type
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Building Construction Progress
  • LAST_REPORT_DATE : Date of Last Constuction Report
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLD_PROGRESS_AMT : Amount Disbursed for Construction based on Building Progress
    Its data type is CURR (Currency Field) with field length 17
  • BLD_AMT_CURR : Building Progress Amount Curreny
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PCT_COMPLETED : Degree of Completion of Construction
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Insurance details
  • INSURANCE_TYPE : Insurance Type
    Its data type is CHAR (Character String) with field length 6
  • INSURANCE_AMT : Insurance Amount
    Its data type is CURR (Currency Field) with field length 17
  • INSURANCE_CURR : Insurance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INS_VALIDITY : Date until which the Insurance Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Other Costs
  • RATIONING_COST : Residential Rationing Cost
    Its data type is CURR (Currency Field) with field length 17
  • RTN_CST_PCT : Percentage of Residential Rationing Cost
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • EXT_LAYOUT_COST : External Layout Cost
    Its data type is CURR (Currency Field) with field length 17
  • EXT_LAY_CST_PCT : External Layout Cost as Percentage of Total Cost
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • RTN_CST_CURR : Rationing cost currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXT_RTN_CST_CURR : External Layout cost currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RTN_CST_COM : Commercial Rationing Cost
    Its data type is CURR (Currency Field) with field length 17
  • RTN_CST_COM_CURR : Rationing cost currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RTN_CST_COM_PCT : Percentage of Commercial Rationing Cost
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Other rents
  • GROSS_COLD_RENT : Gross Cold Rent
    Its data type is CURR (Currency Field) with field length 17
  • GROSS_RENT_CURR : Gross Cold Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • NET_COLD_RENT : Net Cold Rent
    Its data type is CURR (Currency Field) with field length 17
  • NET_RENT_CURR : Net Cold Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Valuation Bases(Com)
  • NO_OF_YEARS_COM : No of years since Last Valuation of Commercial Real Estate
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • INT_RATE_COM : Interest rate (Com)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Valuation Bases
  • NO_OF_YEARS : No. of Years since Real Estate was last Valued
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • INT_RATE : Interest rate used in Valuation of Residential Real Estate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Structure for Part Rent Details
  • RENT_PLANNED_COM : Planned Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • RENT_ACTUAL_COM : Actual Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • PLAN_CURR_COM : Planned Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACT_CURR_COM : Actual Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BASE_PERIOD_COM : Base period for the rent
    Its data type is CHAR (Character String) with field length 1
  • BASE_MEAS_COM : Base Measure
    Its data type is CHAR (Character String) with field length 1
  • COM_RENT_IND : Indicator for Rent Type
    Its data type is CHAR (Character String) with field length 1
  • COMP_RENT_COM : Comparative Rent (Commercial)
    Its data type is CURR (Currency Field) with field length 17
  • COMP_REN_COM_CUR : Comparative Rent Currency (Commercial)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Structure for Land Rent details
  • PLAN_RENT_LAND : Planned Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • ACTUAL_RENT_LAND : Actual Rent Amount
    Its data type is CURR (Currency Field) with field length 17
  • PLAN_RENT_CURR : Planned Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACTUAL_RENT_CURR : Actual Rent Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BASE_PERIOD_LAND : Base period for the rent
    Its data type is CHAR (Character String) with field length 1
  • BASE_MEAS_LAND : Base Measure
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Depriciation
  • DEPR : Depriciation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Land Costs
  • LAND_COST : Land Cost Amount
    Its data type is CURR (Currency Field) with field length 17
  • LAND_COST_CURR : Land Cost Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DEV_COST : Development Cost Amount
    Its data type is CURR (Currency Field) with field length 17
  • DEV_COST_CURR : Dev Cost Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • LAND_CST_BASE : Base measure of Land
    Its data type is CHAR (Character String) with field length 1
  • DEV_CST_BASE : Base measure of Land
    Its data type is CHAR (Character String) with field length 1
  • ADD_LAND_CST : Additional Land Cost Amount
    Its data type is CURR (Currency Field) with field length 17
  • ADD_CST_CURR : Additional Land Cost Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ADD_CST_BASE : Base measure of Land
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Construction Costs for Buildings
  • CONST_COST : Construction Cost
    Its data type is CURR (Currency Field) with field length 17
  • CONST_COST_CURR : Construction cost currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BASE_MEAS : Base Measure
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Yearly Gross Profit for Commercial Real Estate
  • GRS_PROFIT : Yearly Gross Profit
    Its data type is CURR (Currency Field) with field length 17
  • GRS_PROFIT_CURR : Yearly Gross Profit Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5