This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table CMS_RE_OBJ_PRT (Real Estate Object part details) is a standard table in SAP ERP. It belongs to the package CMS_RE.
Table | CMS_RE_OBJ_PRT |
Short Text | Real Estate Object part details |
Package | CMS_RE |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
OBJ_PRT_GUID | ✔ | GUID for Object part | CMS_RE_DTE_OBJ_PRT_GUID | RAW | 16 | |
OBJ_GUID | GUID for Real Estate Object | CMS_RE_DTE_OBJ_GUID | RAW | 16 | CMS_RE_OBJ | |
PART_ID | Part ID for the Object | CMS_RE_DTE_PART_ID | NUMC | 10 | ||
BLD_PART_TYPE | Building Part Type | CMS_RE_DTE_ATT_ID_TY_REO006 | CHAR | 6 | TCMS_ATT_ID_TY | |
PART_COND | Object condition | CMS_RE_DTE_ATT_ID_TY_REO001 | CHAR | 6 | TCMS_ATT_ID_TY | |
MAIN_USAGE | Usage Type | CMS_RE_DTE_USG_TYP | CHAR | 6 | TCMS_RE_U_TYP | |
ADD_USAGE_1 | Additional Usage 1 | CMS_RE_DTE_ADD1_USG_TYP | CHAR | 6 | TCMS_RE_U_TYP | |
ADD_USAGE_2 | Additional Usage 2 | CMS_RE_DTE_ADD2_USG_TYP | CHAR | 6 | TCMS_RE_U_TYP | |
BLD_METHOD_ROOF | Building method - Roof | CMS_RE_DTE_ATT_ID_TY_REO007 | CHAR | 6 | TCMS_ATT_ID_TY | |
BLD_METHOD_BODY | Building method - Body | CMS_RE_DTE_ATT_ID_TY_REO008 | CHAR | 6 | TCMS_ATT_ID_TY | |
BLD_METD_CELLAR | Building method - Cellar | CMS_RE_DTE_ATT_ID_TY_REO009 | CHAR | 6 | TCMS_ATT_ID_TY | |
UTILIZATION | Utilization of the Object | CMS_RE_DTE_PRT_UTILIZATION | CHAR | 6 | ||
PART_DESC | Description of Building Part | CMS_RE_DTE_SPC_DESC | CHAR | 30 | ||
COMM_USAGE_PCT | Commercial Usage as a Percentage of Total Usage | CMS_RE_DTE_COM_USE_PCT | DEC | 10 | ||
OTHER_USG_FLG | Indicates if Usages in addition to Main Usage are Possible | CMS_RE_DTE_OTH_USE_FLG | CHAR | 1 | ||
REF_OBJ_PRT_GUID | Reference Object Part GUID | CMS_RE_DTE_REF_OBJ_PRT_GUID | RAW | 16 | ||
IS_SUB_AST_CREA | Indicates whether a Sub-asset is created for Building Part | CMS_RE_DTE_CREATE_SUB_AST_FLG | CHAR | 1 | ||
USEFUL_AREA | Usable Area | CMS_RE_DTE_AREA_USEFUL | QUAN | 13 | ||
USBL_AREA_UOM | Unit of Measure for Usable Area | CMS_RE_DTE_USBL_AREA_UOM | UNIT | 3 | * | |
USEFUL_AREA_REN | Rented Usable Area | CMS_RE_DTE_AREA_USEFUL_REN | QUAN | 13 | ||
USBL_AR_REN_UOM | Unit of Measure for Usable Rented Area | CMS_RE_DTE_USBL_AREA_REN_UOM | UNIT | 3 | * | |
USEFUL_VOL | Usable Volume of Real Estate Building Parts | CMS_RE_DTE_VOL_USEFUL | QUAN | 13 | ||
USBL_VOL_UOM | Unit of Measure for Usable Volume of Real Estate | CMS_RE_DTE_USBL_VOL_UOM | UNIT | 3 | * | |
USEFUL_VOL_REN | Usable Volume of the Rented Portions of Real Estate | CMS_RE_DTE_VOL_USEFUL_REN | QUAN | 13 | ||
USBL_VL_REN_UOM | Unit of measure for usable volume of Rented Parts | CMS_RE_DTE_USBL_VOL_REN_UOM | UNIT | 3 | * | |
RESIDENTIAL_AREA | Residential Area | CMS_RE_DTE_AREA_RESIDENTIAL | QUAN | 13 | ||
RES_AR_UOM | Unit of Measure for Residential Area | CMS_RE_DTE_RES_AREA_UOM | UNIT | 3 | * | |
SECONDARY_AREA | Secondary Area | CMS_RE_DTE_AREA_SECONDARY | QUAN | 13 | ||
SEC_AREA_UOM | Unit of Measure for Secondary Area | CMS_RE_DTE_SEC_AREA_UOM | UNIT | 3 | * | |
OTHER_AREA | Other Area | CMS_RE_DTE_AREA_OTHER | QUAN | 13 | ||
OTH_AREA_UOM | Unit of Measure for Other Area | CMS_RE_DTE_OTH_AREA_UOM | UNIT | 3 | * | |
NO_PRT_UNIT | Number of building part units | CMS_RE_DTE_NO_PRT_UNIT | INT4 | 10 | ||
NO_PRT_UNIT_REN | Number of building part units rented | CMS_RE_DTE_NO_PRT_UNIT_REN | INT4 | 10 | ||
CONS_START_DATE | Start Date of Construction | CMS_RE_DTE_OBJ_CONS_ST_DATE | DATS | 8 | ||
PERMSN_APPL_DATE | Building Permssion applied date | CMS_RE_DTE_OBJ_PMSN_APPL_DATE | DATS | 8 | ||
PERMSN_OBTD_DATE | Building Permssion obtained date | CMS_RE_DTE_OBJ_PMSN_OBTD_DATE | DATS | 8 | ||
OCCY_DATE | Occupancy Date | CMS_RE_DTE_OBJ_OCCY_DATE | DATS | 8 | ||
COMP_DATE | Completion Date | CMS_RE_DTE_OBJ_COMP_DATE | DATS | 8 | ||
FINAL_INSP_DATE | Date of Final Inspection | CMS_RE_DTE_OBJ_FINAL_INSP_DATE | DATS | 8 | ||
RENT_AMT_PLANNED | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CURR | 17 | ||
RENT_AMT_ACTUAL | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CURR | 17 | ||
RENT_PLAN_CURR | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | CUKY | 5 | TCURC | |
RENT_ACT_CURR | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | CUKY | 5 | TCURC | |
BASE_PERIOD | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CHAR | 1 | ||
BASE_MEASURE | Base Measure | CMS_RE_DTE_BASE_MEAS | CHAR | 1 | ||
VACANT_POSN_PCT | Ratio of Real Estate not rented to Total Real Estate Value | CMS_RE_DTE_VACANT_POS_PCT | DEC | 10 | ||
RES_RENT_IND | Indicator for Net or Gross Rent | CMS_RE_DTE_RES_IND | CHAR | 1 | ||
COMP_RENT_RES | Comparative Rent (Residential) | CMS_RE_DTE_RENT_LEVEL | CURR | 17 | ||
COM_REN_RES_CURR | Comparative Rent Currency - Residential | CMS_RE_DTE_COMP_RENT_RES_CURR | CUKY | 5 | TCURC | |
LAND_AREA | Land Area of the Real Estate | CMS_RE_DTE_LAND_AREA | QUAN | 13 | ||
LAND_AREA_UOM | Unit of Measure of Land Area | CMS_RE_DTE_LAND_AREA_UOM | UNIT | 3 | T006 | |
LAND_AREA_REN | Land Area of the Real Estate which is Rented | CMS_RE_DTE_LAND_AREA_REN | QUAN | 13 | ||
LAND_AR_REN_UOM | Land area unit of measure(rented) | CMS_RE_DTE_LAND_AREA_REN_UOM | UNIT | 3 | * | |
NO_OF_UNITS | No of units in real estate object | CMS_RE_DTE_NO_UNIT | INT4 | 10 | ||
NO_OF_FLOORS | Number of Floors | CMS_RE_DTE_NO_FLOOR | INT4 | 10 | ||
NO_GARAGES | No of Garages in Real Estate Object | CMS_RE_DTE_NO_GAR | INT4 | 10 | ||
NO_GARAGES_REN | No of Garages Rented in Real Estate Object | CMS_RE_DTE_NO_GAR_REN | INT4 | 10 | ||
NO_PARK_UNIT | Number of Parking Units | CMS_RE_DTE_NO_PARK_UNIT | INT4 | 10 | ||
NO_PARK_UNIT_REN | Number of Parking Units Rented | CMS_RE_DTE_NO_PARK_UNIT_REN | INT4 | 10 | ||
NO_PARK_UG | Number of Underground Parking Units | CMS_RE_DTE_NO_PARK_UNIT_UG | INT4 | 10 | ||
NO_PARK_UG_REN | Number of Rented Underground Parking Units | CMS_RE_DTE_NO_PARK_UNIT_UG_REN | INT4 | 10 | ||
NO_CUR_UNITS | No of current units in real estate object | CMS_RE_DTE_NO_CUR_UNIT | INT4 | 10 | ||
NO_CUR_UNITS_REN | No of Current Units Rented in Real Estate Object | CMS_RE_DTE_NO_CUR_UNIT_REN | INT4 | 10 | ||
NO_OLD_UNITS | No of old units in real estate object | CMS_RE_DTE_NO_OLD_UNIT | INT4 | 10 | ||
NO_OLD_UNITS_REN | No of Old Units Rented in Real Estate Object | CMS_RE_DTE_NO_OLD_UNIT_REN | INT4 | 10 | ||
NO_NEW_UNITS | No of new units in real estate object | CMS_RE_DTE_NO_NEW_UNIT | INT4 | 10 | ||
NO_NEW_UNITS_REN | No of New units Rented in Real Estate Object | CMS_RE_DTE_NO_NEW_UNIT_REN | INT4 | 10 | ||
NO_ACCESS_STR | No of Access Structures | CMS_RE_DTE_NO_ACCESS_STR | INT4 | 10 | ||
NO_SALE_LEVEL | No of Sale levels in commercial building | CMS_RE_DTE_NO_SALE_LEVEL | INT4 | 10 | ||
NO_OF_ROOMS | No of rooms in the hotel/clinic | CMS_RE_DTE_NO_ROOMS | INT4 | 10 | ||
NO_OF_BEDS | No of beds in the clinic/nursing home | CMS_RE_DTE_NO_BEDS | INT4 | 10 | ||
COMM_ENV_DESC | Description of the commercial environment | CMS_RE_DTE_COMM_ENV_DESC | CHAR | 30 | ||
ACCESS_STR_DESC | Description of the Access Structures | CMS_RE_DTE_ACCESS_STR_DESC | CHAR | 30 | ||
BLD_SECTION_DESC | Building Section | CMS_RE_DTE_ATT_ID_TY_REO015 | CHAR | 6 | TCMS_ATT_ID_TY | |
PRICE_CATEGORY | Price Category | CMS_RE_DTE_ATT_ID_TY_REO013 | CHAR | 6 | TCMS_ATT_ID_TY | |
AVG_PRICE | Average Price per Day | CMS_RE_DTE_AVG_PRICE | CURR | 17 | ||
AVG_PRICE_CURR | Average Price Currency | CMS_RE_DTE_AVG_PRICE_CURR | CUKY | 5 | TCURC | |
OCCUPANCY_PCT | Occupancy specified in Percentage Terms | CMS_RE_DTE_OCCY_PCT | DEC | 10 | ||
TURNOVER_AMT | Total Amount of Turnover | CMS_RE_DTE_TURNOVER_AMOUNT | CURR | 17 | ||
TURNOVER_CURR | Currency | CMS_RE_DTE_TURNOVER_CURR | CUKY | 5 | TCURC | |
RENTAL_AGMT_TYP | Rental Agreement Type | CMS_RE_DTE_ATT_ID_TY_REO014 | CHAR | 6 | TCMS_ATT_ID_TY | |
LAST_REPORT_DATE | Date of Last Constuction Report | CMS_RE_DTE_LAST_CONST_REP_DATE | DATS | 8 | ||
BLD_PROGRESS_AMT | Amount Disbursed for Construction based on Building Progress | CMS_RE_DTE_AMT_BLD_PROGRESS | CURR | 17 | ||
BLD_AMT_CURR | Building Progress Amount Curreny | CMS_RE_DTE_BLD_PROGRESS_CURR | CUKY | 5 | * | |
PCT_COMPLETED | Degree of Completion of Construction | CMS_RE_DTE_DEGREE_COMPLETE | DEC | 10 | ||
INSURANCE_TYPE | Insurance Type | CMS_RE_DTE_ATT_ID_TY_REO011 | CHAR | 6 | TCMS_ATT_ID_TY | |
INSURANCE_AMT | Insurance Amount | CMS_RE_DTE_INSURANCE_AMOUNT | CURR | 17 | ||
INSURANCE_CURR | Insurance Currency | CMS_RE_DTE_INSURANCE_CURR | CUKY | 5 | TCURC | |
INS_VALIDITY | Date until which the Insurance Stands Valid | CMS_RE_DTE_INS_VALID_TILL | DATS | 8 | ||
RATIONING_COST | Residential Rationing Cost | CMS_RE_DTE_RAT_COST_AMT | CURR | 17 | ||
RTN_CST_PCT | Percentage of Residential Rationing Cost | CMS_RE_DTE_RAN_COST_PCT | DEC | 10 | ||
EXT_LAYOUT_COST | External Layout Cost | CMS_RE_DTE_EXT_LAYOUT_COST | CURR | 17 | ||
EXT_LAY_CST_PCT | External Layout Cost as Percentage of Total Cost | CMS_RE_DTE_EXT_LAYOUT_COST_PCT | DEC | 10 | ||
RTN_CST_CURR | Rationing cost currency | CMS_RE_DTE_RTN_CST_CURR | CUKY | 5 | * | |
EXT_RTN_CST_CURR | External Layout cost currency | CMS_RE_DTE_EXT_LAYOUT_CST_CURR | CUKY | 5 | * | |
RTN_CST_COM | Commercial Rationing Cost | CMS_RE_DTE_RAT_COST_AMT_COM | CURR | 17 | ||
RTN_CST_COM_CURR | Rationing cost currency | CMS_RE_DTE_RTN_CST_CURR_COM | CUKY | 5 | * | |
RTN_CST_COM_PCT | Percentage of Commercial Rationing Cost | CMS_RE_DTE_RAN_COST_PCT_COM | DEC | 10 | ||
GROSS_COLD_RENT | Gross Cold Rent | CMS_RE_DTE_YRLY_GROSS_COLD_REN | CURR | 17 | ||
GROSS_RENT_CURR | Gross Cold Rent Currency | CMS_RE_DTE_GROSS_RENT_CURR | CUKY | 5 | TCURC | |
NET_COLD_RENT | Net Cold Rent | CMS_RE_DTE_YRLY_NET_COLD_REN | CURR | 17 | ||
NET_RENT_CURR | Net Cold Rent Currency | CMS_RE_DTE_NET_RENT_CURR | CUKY | 5 | TCURC | |
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 | ||
NO_OF_YEARS_COM | No of years since Last Valuation of Commercial Real Estate | CMS_RE_DTE_VAL_NO_YEARS_COM | INT1 | 3 | ||
INT_RATE_COM | Interest rate (Com) | CMS_RE_DTE_VAL_INT_RATE_COM | DEC | 10 | ||
NO_OF_YEARS | No. of Years since Real Estate was last Valued | CMS_RE_DTE_VALUATION_NO_YEARS | INT1 | 3 | ||
INT_RATE | Interest rate used in Valuation of Residential Real Estate | CMS_RE_DTE_VALUATION_INT_RATE | DEC | 10 | ||
RENT_PLANNED_COM | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CURR | 17 | ||
RENT_ACTUAL_COM | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CURR | 17 | ||
PLAN_CURR_COM | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | CUKY | 5 | TCURC | |
ACT_CURR_COM | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | CUKY | 5 | TCURC | |
BASE_PERIOD_COM | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CHAR | 1 | ||
BASE_MEAS_COM | Base Measure | CMS_RE_DTE_BASE_MEAS | CHAR | 1 | ||
COM_RENT_IND | Indicator for Rent Type | CMS_RE_DTE_COM_IND | CHAR | 1 | ||
COMP_RENT_COM | Comparative Rent (Commercial) | CMS_RE_DTE_RENT_LEVEL_COM | CURR | 17 | ||
COMP_REN_COM_CUR | Comparative Rent Currency (Commercial) | CMS_RE_DTE_COMP_RENT_COM_CURR | CUKY | 5 | TCURC | |
PLAN_RENT_LAND | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CURR | 17 | ||
ACTUAL_RENT_LAND | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CURR | 17 | ||
PLAN_RENT_CURR | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | CUKY | 5 | TCURC | |
ACTUAL_RENT_CURR | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | CUKY | 5 | * | |
BASE_PERIOD_LAND | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CHAR | 1 | ||
BASE_MEAS_LAND | Base Measure | CMS_RE_DTE_BASE_MEAS | CHAR | 1 | ||
DEPR | Depriciation | CMS_RE_DTE_DEPR | DEC | 10 | ||
LAND_COST | Land Cost Amount | CMS_RE_DTE_LAND_COST | CURR | 17 | ||
LAND_COST_CURR | Land Cost Currency | CMS_RE_DTE_LAND_COST_CURR | CUKY | 5 | * | |
DEV_COST | Development Cost Amount | CMS_RE_DTE_DEV_COST | CURR | 17 | ||
DEV_COST_CURR | Dev Cost Currency | CMS_RE_DTE_DEV_COST_CURR | CUKY | 5 | * | |
LAND_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CHAR | 1 | ||
DEV_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CHAR | 1 | ||
ADD_LAND_CST | Additional Land Cost Amount | CMS_RE_DTE_ADD_LAND_COST | CURR | 17 | ||
ADD_CST_CURR | Additional Land Cost Currency | CMS_RE_DTE_ADD_LAND_COST_CURR | CUKY | 5 | * | |
ADD_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CHAR | 1 | ||
CONST_COST | Construction Cost | CMS_RE_DTE_CONS_COST | CURR | 17 | ||
CONST_COST_CURR | Construction cost currency | CMS_RE_DTE_CONS_COST_CURR | CUKY | 5 | * | |
BASE_MEAS | Base Measure | CMS_RE_DTE_BASE_MEAS | CHAR | 1 | ||
GRS_PROFIT | Yearly Gross Profit | CMS_RE_DTE_GRS_PROFIT | CURR | 17 | ||
GRS_PROFIT_CURR | Yearly Gross Profit Currency | CMS_RE_DTE_GRS_PROFIT_CURR | CUKY | 5 | * |