SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

CMS_RE_OBJ_PRT Table in SAP | Real Estate Object part details Table & Fields List

CMS_RE_OBJ_PRT is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_RE_OBJ_PRT in SAP.

  • Table description : Real Estate Object part details
  • Module : FS-CMS-MD-RE
  • Parent Module : FS
  • Package : CMS_RE
  • Software Component : EA-FINSERV
CMS_RE_OBJ_PRT table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP CMS_RE_OBJ_PRT Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
.INCLUDEPrimary key for Object part    
OBJ_PRT_GUIDGUID for Object partCMS_RE_DTE_OBJ_PRT_GUIDSYSUUID
.INCLUDELink structure for the real estate object    
OBJ_GUIDGUID for Real Estate ObjectCMS_RE_DTE_OBJ_GUIDSYSUUID
.INCLUDEStructure for Part ID    
PART_IDPart ID for the ObjectCMS_RE_DTE_PART_IDCMS_RE_PRT_ID
.INCLUDEStructure for Basic Part Details    
BLD_PART_TYPEBuilding Part TypeCMS_RE_DTE_ATT_ID_TY_REO006CMS_ATT_ID_TYP
PART_CONDObject conditionCMS_RE_DTE_ATT_ID_TY_REO001CMS_ATT_ID_TYP
MAIN_USAGEUsage TypeCMS_RE_DTE_USG_TYPCMS_RE_TYP
ADD_USAGE_1Additional Usage 1CMS_RE_DTE_ADD1_USG_TYPCMS_RE_TYP
ADD_USAGE_2Additional Usage 2CMS_RE_DTE_ADD2_USG_TYPCMS_RE_TYP
BLD_METHOD_ROOFBuilding method - RoofCMS_RE_DTE_ATT_ID_TY_REO007CMS_ATT_ID_TYP
BLD_METHOD_BODYBuilding method - BodyCMS_RE_DTE_ATT_ID_TY_REO008CMS_ATT_ID_TYP
BLD_METD_CELLARBuilding method - CellarCMS_RE_DTE_ATT_ID_TY_REO009CMS_ATT_ID_TYP
UTILIZATIONUtilization of the ObjectCMS_RE_DTE_PRT_UTILIZATIONCMS_RE_UTIL
PART_DESCDescription of Building PartCMS_RE_DTE_SPC_DESCCMS_RE_DESC
COMM_USAGE_PCTCommercial Usage as a Percentage of Total UsageCMS_RE_DTE_COM_USE_PCTCMS_RE_PCT
OTHER_USG_FLGIndicates if Usages in addition to Main Usage are PossibleCMS_RE_DTE_OTH_USE_FLGCMS_RE_OTH_USG_FLG
REF_OBJ_PRT_GUIDReference Object Part GUIDCMS_RE_DTE_REF_OBJ_PRT_GUIDSYSUUID
IS_SUB_AST_CREAIndicates whether a Sub-asset is created for Building PartCMS_RE_DTE_CREATE_SUB_AST_FLGCMS_RE_FLG
.INCLUDEStructure for Part Size Details    
USEFUL_AREAUsable AreaCMS_RE_DTE_AREA_USEFULCMS_RE_SIZE
USBL_AREA_UOMUnit of Measure for Usable AreaCMS_RE_DTE_USBL_AREA_UOMMEINS
USEFUL_AREA_RENRented Usable AreaCMS_RE_DTE_AREA_USEFUL_RENCMS_RE_SIZE
USBL_AR_REN_UOMUnit of Measure for Usable Rented AreaCMS_RE_DTE_USBL_AREA_REN_UOMMEINS
USEFUL_VOLUsable Volume of Real Estate Building PartsCMS_RE_DTE_VOL_USEFULCMS_RE_SIZE
USBL_VOL_UOMUnit of Measure for Usable Volume of Real EstateCMS_RE_DTE_USBL_VOL_UOMMEINS
USEFUL_VOL_RENUsable Volume of the Rented Portions of Real EstateCMS_RE_DTE_VOL_USEFUL_RENCMS_RE_SIZE
USBL_VL_REN_UOMUnit of measure for usable volume of Rented PartsCMS_RE_DTE_USBL_VOL_REN_UOMMEINS
RESIDENTIAL_AREAResidential AreaCMS_RE_DTE_AREA_RESIDENTIALCMS_RE_SIZE
RES_AR_UOMUnit of Measure for Residential AreaCMS_RE_DTE_RES_AREA_UOMMEINS
SECONDARY_AREASecondary AreaCMS_RE_DTE_AREA_SECONDARYCMS_RE_SIZE
SEC_AREA_UOMUnit of Measure for Secondary AreaCMS_RE_DTE_SEC_AREA_UOMMEINS
OTHER_AREAOther AreaCMS_RE_DTE_AREA_OTHERCMS_RE_SIZE
OTH_AREA_UOMUnit of Measure for Other AreaCMS_RE_DTE_OTH_AREA_UOMMEINS
.INCLUDEStructure for Part Unit Details    
NO_PRT_UNITNumber of building part unitsCMS_RE_DTE_NO_PRT_UNITCMS_RE_UNITS
NO_PRT_UNIT_RENNumber of building part units rentedCMS_RE_DTE_NO_PRT_UNIT_RENCMS_RE_UNITS
.INCLUDEStructure for dates    
CONS_START_DATEStart Date of ConstructionCMS_RE_DTE_OBJ_CONS_ST_DATECMS_RE_DATE
PERMSN_APPL_DATEBuilding Permssion applied dateCMS_RE_DTE_OBJ_PMSN_APPL_DATECMS_RE_DATE
PERMSN_OBTD_DATEBuilding Permssion obtained dateCMS_RE_DTE_OBJ_PMSN_OBTD_DATECMS_RE_DATE
OCCY_DATEOccupancy DateCMS_RE_DTE_OBJ_OCCY_DATECMS_RE_DATE
COMP_DATECompletion DateCMS_RE_DTE_OBJ_COMP_DATECMS_RE_DATE
FINAL_INSP_DATEDate of Final InspectionCMS_RE_DTE_OBJ_FINAL_INSP_DATECMS_RE_DATE
.INCLUDE   
.INCLUDEStructure for Part Rent Details    
RENT_AMT_PLANNEDPlanned Rent AmountCMS_RE_DTE_RENT_AMOUNTCMS_RE_AMOUNT
RENT_AMT_ACTUALActual Rent AmountCMS_RE_DTE_RENT_AMOUNT_ACTCMS_RE_AMOUNT
RENT_PLAN_CURRPlanned Rent CurrencyCMS_RE_DTE_RENT_PLANNED_CURRWAERS
RENT_ACT_CURRActual Rent CurrencyCMS_RE_DTE_RENT_ACTUAL_CURRWAERS
BASE_PERIODBase period for the rentCMS_RE_DTE_BASE_PERIODCMS_RE_BASE_PERIOD
BASE_MEASUREBase MeasureCMS_RE_DTE_BASE_MEASCMS_RE_BASE_MEAS
VACANT_POSN_PCTRatio of Real Estate not rented to Total Real Estate ValueCMS_RE_DTE_VACANT_POS_PCTCMS_RE_PCT
RES_RENT_INDIndicator for Net or Gross RentCMS_RE_DTE_RES_INDCMS_RE_RENT_FLG
COMP_RENT_RESComparative Rent (Residential)CMS_RE_DTE_RENT_LEVELCMS_RE_AMOUNT
COM_REN_RES_CURRComparative Rent Currency - ResidentialCMS_RE_DTE_COMP_RENT_RES_CURRWAERS
.INCLUDEStructure for Land Area & UOM    
LAND_AREALand Area of the Real EstateCMS_RE_DTE_LAND_AREACMS_RE_SIZE
LAND_AREA_UOMUnit of Measure of Land AreaCMS_RE_DTE_LAND_AREA_UOMMEINS
LAND_AREA_RENLand Area of the Real Estate which is RentedCMS_RE_DTE_LAND_AREA_RENCMS_RE_SIZE
LAND_AR_REN_UOMLand area unit of measure(rented)CMS_RE_DTE_LAND_AREA_REN_UOMMEINS
.INCLUDEStructure for General Details    
NO_OF_UNITSNo of units in real estate objectCMS_RE_DTE_NO_UNITCMS_RE_UNITS
NO_OF_FLOORSNumber of FloorsCMS_RE_DTE_NO_FLOORCMS_RE_UNITS
NO_GARAGESNo of Garages in Real Estate ObjectCMS_RE_DTE_NO_GARCMS_RE_UNITS
NO_GARAGES_RENNo of Garages Rented in Real Estate ObjectCMS_RE_DTE_NO_GAR_RENCMS_RE_UNITS
NO_PARK_UNITNumber of Parking UnitsCMS_RE_DTE_NO_PARK_UNITCMS_RE_UNITS
NO_PARK_UNIT_RENNumber of Parking Units RentedCMS_RE_DTE_NO_PARK_UNIT_RENCMS_RE_UNITS
NO_PARK_UGNumber of Underground Parking UnitsCMS_RE_DTE_NO_PARK_UNIT_UGCMS_RE_UNITS
NO_PARK_UG_RENNumber of Rented Underground Parking UnitsCMS_RE_DTE_NO_PARK_UNIT_UG_RENCMS_RE_UNITS
.INCLUDEStructure for Residential Details    
NO_CUR_UNITSNo of current units in real estate objectCMS_RE_DTE_NO_CUR_UNITCMS_RE_UNITS
NO_CUR_UNITS_RENNo of Current Units Rented in Real Estate ObjectCMS_RE_DTE_NO_CUR_UNIT_RENCMS_RE_UNITS
NO_OLD_UNITSNo of old units in real estate objectCMS_RE_DTE_NO_OLD_UNITCMS_RE_UNITS
NO_OLD_UNITS_RENNo of Old Units Rented in Real Estate ObjectCMS_RE_DTE_NO_OLD_UNIT_RENCMS_RE_UNITS
NO_NEW_UNITSNo of new units in real estate objectCMS_RE_DTE_NO_NEW_UNITCMS_RE_UNITS
NO_NEW_UNITS_RENNo of New units Rented in Real Estate ObjectCMS_RE_DTE_NO_NEW_UNIT_RENCMS_RE_UNITS
.INCLUDEStructure for Number of Units in Office    
NO_ACCESS_STRNo of Access StructuresCMS_RE_DTE_NO_ACCESS_STRCMS_RE_UNITS
.INCLUDEStructure for Number of Sales level in Commericial Building    
NO_SALE_LEVELNo of Sale levels in commercial buildingCMS_RE_DTE_NO_SALE_LEVELCMS_RE_UNITS
.INCLUDEStructure for Number of Rooms in the hotel/clinic    
NO_OF_ROOMSNo of rooms in the hotel/clinicCMS_RE_DTE_NO_ROOMSCMS_RE_UNITS
.INCLUDEStructure for Number of rooms in the clinic/nursing home    
NO_OF_BEDSNo of beds in the clinic/nursing homeCMS_RE_DTE_NO_BEDSCMS_RE_UNITS
.INCLUDE   
.INCLUDEStructure for Commericial Details    
COMM_ENV_DESCDescription of the commercial environmentCMS_RE_DTE_COMM_ENV_DESCCMS_RE_DESC
ACCESS_STR_DESCDescription of the Access StructuresCMS_RE_DTE_ACCESS_STR_DESCCMS_RE_DESC
BLD_SECTION_DESCBuilding SectionCMS_RE_DTE_ATT_ID_TY_REO015CMS_ATT_ID_TYP
.INCLUDE   
.INCLUDEStructure for Hotel Details    
PRICE_CATEGORYPrice CategoryCMS_RE_DTE_ATT_ID_TY_REO013CMS_ATT_ID_TYP
AVG_PRICEAverage Price per DayCMS_RE_DTE_AVG_PRICECMS_RE_AMOUNT
AVG_PRICE_CURRAverage Price CurrencyCMS_RE_DTE_AVG_PRICE_CURRWAERS
.INCLUDE   
.INCLUDEStructure for Other Details in RE Object    
OCCUPANCY_PCTOccupancy specified in Percentage TermsCMS_RE_DTE_OCCY_PCTCMS_RE_PCT
TURNOVER_AMTTotal Amount of TurnoverCMS_RE_DTE_TURNOVER_AMOUNTCMS_RE_AMOUNT
TURNOVER_CURRCurrencyCMS_RE_DTE_TURNOVER_CURRWAERS
RENTAL_AGMT_TYPRental Agreement TypeCMS_RE_DTE_ATT_ID_TY_REO014CMS_ATT_ID_TYP
.INCLUDEBuilding Construction Progress    
LAST_REPORT_DATEDate of Last Constuction ReportCMS_RE_DTE_LAST_CONST_REP_DATECMS_RE_DATE
BLD_PROGRESS_AMTAmount Disbursed for Construction based on Building ProgressCMS_RE_DTE_AMT_BLD_PROGRESSCMS_RE_AMOUNT
BLD_AMT_CURRBuilding Progress Amount CurrenyCMS_RE_DTE_BLD_PROGRESS_CURRWAERS
PCT_COMPLETEDDegree of Completion of ConstructionCMS_RE_DTE_DEGREE_COMPLETECMS_RE_PCT
.INCLUDEInsurance details    
INSURANCE_TYPEInsurance TypeCMS_RE_DTE_ATT_ID_TY_REO011CMS_ATT_ID_TYP
INSURANCE_AMTInsurance AmountCMS_RE_DTE_INSURANCE_AMOUNTCMS_RE_AMOUNT
INSURANCE_CURRInsurance CurrencyCMS_RE_DTE_INSURANCE_CURRWAERS
INS_VALIDITYDate until which the Insurance Stands ValidCMS_RE_DTE_INS_VALID_TILLCMS_RE_DATE
.INCLUDEOther Costs    
RATIONING_COSTResidential Rationing CostCMS_RE_DTE_RAT_COST_AMTCMS_RE_AMOUNT
RTN_CST_PCTPercentage of Residential Rationing CostCMS_RE_DTE_RAN_COST_PCTCMS_RE_PCT
EXT_LAYOUT_COSTExternal Layout CostCMS_RE_DTE_EXT_LAYOUT_COSTCMS_RE_AMOUNT
EXT_LAY_CST_PCTExternal Layout Cost as Percentage of Total CostCMS_RE_DTE_EXT_LAYOUT_COST_PCTCMS_RE_PCT
RTN_CST_CURRRationing cost currencyCMS_RE_DTE_RTN_CST_CURRWAERS
EXT_RTN_CST_CURRExternal Layout cost currencyCMS_RE_DTE_EXT_LAYOUT_CST_CURRWAERS
RTN_CST_COMCommercial Rationing CostCMS_RE_DTE_RAT_COST_AMT_COMCMS_RE_AMOUNT
RTN_CST_COM_CURRRationing cost currencyCMS_RE_DTE_RTN_CST_CURR_COMWAERS
RTN_CST_COM_PCTPercentage of Commercial Rationing CostCMS_RE_DTE_RAN_COST_PCT_COMCMS_RE_PCT
.INCLUDEOther rents    
GROSS_COLD_RENTGross Cold RentCMS_RE_DTE_YRLY_GROSS_COLD_RENCMS_RE_AMOUNT
GROSS_RENT_CURRGross Cold Rent CurrencyCMS_RE_DTE_GROSS_RENT_CURRWAERS
NET_COLD_RENTNet Cold RentCMS_RE_DTE_YRLY_NET_COLD_RENCMS_RE_AMOUNT
NET_RENT_CURRNet Cold Rent CurrencyCMS_RE_DTE_NET_RENT_CURRWAERS
.INCLUDEStructure for history    
CREATED_BYReal Estate Add-On UserCMS_RE_DTE_CR_BYCMS_RE_USER
CREATED_DATECreated OnCMS_RE_DTE_CR_ONCMS_RE_DATE
CREATED_TIMECreated AtCMS_RE_DTE_CR_ATCMS_RE_TIME
ENTRY_SRCSorce of Initial entryCMS_RE_DTE_SRC_INITCMS_RE_SOURCE
LAST_CHG_BYLast Changed ByCMS_RE_DTE_CHG_BYCMS_RE_USER
LAST_CHG_DATELast Changed OnCMS_RE_DTE_CHG_ONCMS_RE_DATE
LAST_CHG_TIMELast Changed AtCMS_RE_DTE_CHG_ATCMS_RE_TIME
PROCESSING_SRCProcessing SourceCMS_RE_DTE_PRC_SRCCMS_RE_SOURCE
.INCLUDE   
.INCLUDEValuation Bases(Com)    
NO_OF_YEARS_COMNo of years since Last Valuation of Commercial Real EstateCMS_RE_DTE_VAL_NO_YEARS_COMCMS_RE_INT1
INT_RATE_COMInterest rate (Com)CMS_RE_DTE_VAL_INT_RATE_COMCMS_RE_PCT
.INCLUDEValuation Bases    
NO_OF_YEARSNo. of Years since Real Estate was last ValuedCMS_RE_DTE_VALUATION_NO_YEARSCMS_RE_INT1
INT_RATEInterest rate used in Valuation of Residential Real EstateCMS_RE_DTE_VALUATION_INT_RATECMS_RE_PCT
.INCLUDEStructure for Part Rent Details    
RENT_PLANNED_COMPlanned Rent AmountCMS_RE_DTE_RENT_AMOUNTCMS_RE_AMOUNT
RENT_ACTUAL_COMActual Rent AmountCMS_RE_DTE_RENT_AMOUNT_ACTCMS_RE_AMOUNT
PLAN_CURR_COMPlanned Rent CurrencyCMS_RE_DTE_RENT_PLANNED_CURRWAERS
ACT_CURR_COMActual Rent CurrencyCMS_RE_DTE_RENT_ACTUAL_CURRWAERS
BASE_PERIOD_COMBase period for the rentCMS_RE_DTE_BASE_PERIODCMS_RE_BASE_PERIOD
BASE_MEAS_COMBase MeasureCMS_RE_DTE_BASE_MEASCMS_RE_BASE_MEAS
COM_RENT_INDIndicator for Rent TypeCMS_RE_DTE_COM_INDCMS_RE_RENT_FLG
COMP_RENT_COMComparative Rent (Commercial)CMS_RE_DTE_RENT_LEVEL_COMCMS_RE_AMOUNT
COMP_REN_COM_CURComparative Rent Currency (Commercial)CMS_RE_DTE_COMP_RENT_COM_CURRWAERS
.INCLUDEStructure for Land Rent details    
PLAN_RENT_LANDPlanned Rent AmountCMS_RE_DTE_RENT_AMOUNTCMS_RE_AMOUNT
ACTUAL_RENT_LANDActual Rent AmountCMS_RE_DTE_RENT_AMOUNT_ACTCMS_RE_AMOUNT
PLAN_RENT_CURRPlanned Rent CurrencyCMS_RE_DTE_RENT_PLANNED_CURRWAERS
ACTUAL_RENT_CURRActual Rent CurrencyCMS_RE_DTE_RENT_ACTUAL_CURRWAERS
BASE_PERIOD_LANDBase period for the rentCMS_RE_DTE_BASE_PERIODCMS_RE_BASE_PERIOD
BASE_MEAS_LANDBase MeasureCMS_RE_DTE_BASE_MEASCMS_RE_BASE_MEAS
.INCLUDEDepriciation    
DEPRDepriciationCMS_RE_DTE_DEPRCMS_RE_PCT
.INCLUDELand Costs    
LAND_COSTLand Cost AmountCMS_RE_DTE_LAND_COSTCMS_RE_AMOUNT
LAND_COST_CURRLand Cost CurrencyCMS_RE_DTE_LAND_COST_CURRWAERS
DEV_COSTDevelopment Cost AmountCMS_RE_DTE_DEV_COSTCMS_RE_AMOUNT
DEV_COST_CURRDev Cost CurrencyCMS_RE_DTE_DEV_COST_CURRWAERS
LAND_CST_BASEBase measure of LandCMS_RE_DTE_BASE_MEAS_LANDCMS_RE_BASE_MEAS_LAND
DEV_CST_BASEBase measure of LandCMS_RE_DTE_BASE_MEAS_LANDCMS_RE_BASE_MEAS_LAND
ADD_LAND_CSTAdditional Land Cost AmountCMS_RE_DTE_ADD_LAND_COSTCMS_RE_AMOUNT
ADD_CST_CURRAdditional Land Cost CurrencyCMS_RE_DTE_ADD_LAND_COST_CURRWAERS
ADD_CST_BASEBase measure of LandCMS_RE_DTE_BASE_MEAS_LANDCMS_RE_BASE_MEAS_LAND
.INCLUDEConstruction Costs for Buildings    
CONST_COSTConstruction CostCMS_RE_DTE_CONS_COSTCMS_RE_AMOUNT
CONST_COST_CURRConstruction cost currencyCMS_RE_DTE_CONS_COST_CURRWAERS
BASE_MEASBase MeasureCMS_RE_DTE_BASE_MEASCMS_RE_BASE_MEAS
.INCLUDEYearly Gross Profit for Commercial Real Estate    
GRS_PROFITYearly Gross ProfitCMS_RE_DTE_GRS_PROFITCMS_RE_AMOUNT
GRS_PROFIT_CURRYearly Gross Profit CurrencyCMS_RE_DTE_GRS_PROFIT_CURRWAERS

CMS_RE_OBJ_PRT related tables

TableNote
CMS_RE_OBJ_PRTReal Estate Object part details
CMS_RE_PRT_ACSReal Estate Part accessory details
CMS_RE_PRT_BPReal Estate Part BP details
CMS_RE_PRT_CSTReal Estate Part Cost details
CMS_RE_PRT_LRReal Estate Part LR details
CMS_RE_PRT_VALReal Estate Part value details
CMS_RE_OBJ_RLReal Estate Object role details
CMS_RE_OBJ_SPCSpace Details to describe a real estate object
CMS_RE_OBJReal estate header details
CMS_RE_PRT_DOCReal Estate Document details
BPOBIMMOBusiness Partner - Object Relationship: Real Estate
CHBTIV00Field status definitions for Real Estate object mgmt
TCMS_RE_OBJ_ACSReal Estate object type - Accessories relationship
TCMS_RE_OBJ_PRTReal Estate object type - Building Parts relationship
TIV00Field status definitions for Real Estate object mgmt
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com