This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
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 | * |