CMS_RE_OBJ_SPC - Space Details to describe a real estate object
Space Details to describe a real estate object information is stored in SAP table CMS_RE_OBJ_SPC.
It is part of development package CMS_RE in software component FS-CMS-MD-RE. This development package consists of objects that can be grouped under "Collateral Management System: Real Esate".
It is part of development package CMS_RE in software component FS-CMS-MD-RE. This development package consists of objects that can be grouped under "Collateral Management System: Real Esate".
Fields for table CMS_RE_OBJ_SPC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | X | CMS_RE_STR_SPACE_PKY | 0 | |||
| SPC_GUID | GUID for Spaces in Real Estate | X | CMS_RE_DTE_SPC_GUID | RAW | 16 | |
| .INCLUDE | CMS_RE_STR_OBJECT_LKY | 0 | ||||
| OBJ_GUID | GUID for Real Estate Object | CMS_RE_DTE_OBJ_GUID | RAW | 16 | CMS_RE_OBJ | |
| .INCLUDE | CMS_RE_STR_SPC_DETAILS | 0 | ||||
| .INCLUDE | CMS_RE_STR_SPC_DESC | 0 | ||||
| SPACE_TYPE | Building Part Type ID | CMS_RE_DTE_SPC_TYP | CHAR | 12 | TCMS_RE_SP_TYP | |
| SPACE_COND | Condition ID | CMS_RE_DTE_OBJ_COND | CHAR | 12 | TCMS_RE_COND | |
| USAGE_TYPE | Usage Type | CMS_RE_DTE_USG_TYP | CHAR | 12 | TCMS_RE_U_TYP | |
| BLD_STR_TYPE | Real Estate Building Structure ID | CMS_RE_DTE_BLD_STR_TYP | CHAR | 12 | TCMS_RE_STR | |
| SPACE_DESC | Description of Building Part | CMS_RE_DTE_SPC_DESC | CHAR | 60 | ||
| .INCLUDE | CMS_RE_STR_SPC_SUMMARY | 0 | ||||
| NO_UNITS | No of units in real estate object | CMS_RE_DTE_NO_UNIT | INT4 | 4 | ||
| NO_PARK_UNITS | Number of Parking Units | CMS_RE_DTE_NO_PARK_UNIT | INT4 | 4 | ||
| NO_GARAGES | No of Garages in Real Estate Object | CMS_RE_DTE_NO_GAR | INT4 | 4 | ||
| .INCLUDE | CI_CMS_RE_STR_SPC_SUMMARY | 0 | ||||
| .INCLUDE | CMS_RE_STR_SIZE_DETAILS | 0 | ||||
| AREA | Total Area of the Real Estate Object | CMS_RE_DTE_AREA | QUAN | 7 | ||
| AREA_UOM | Unit of Measure for Area | CMS_RE_DTE_AREA_UOM | UNIT | 6 | * | |
| VOLUME | Volume of Real Estate Object | CMS_RE_DTE_VOL | QUAN | 7 | ||
| VOLUME_UOM | Unit of Measure for Volume of Real Estate | CMS_RE_DTE_VOL_UOM | UNIT | 6 | * | |
| .INCLUDE | CMS_RE_STR_AREA_OF_VALUE | 0 | ||||
| AREA_VALUE | Area in the Real Estate which has Collateral Value | CMS_RE_DTE_AREA_VAL | QUAN | 7 | ||
| AREA_VALUE_UOM | Unit of Measure for Area | CMS_RE_DTE_AREA_UOM | UNIT | 6 | * | |
| VOLUME_VAL | Volume of Real Estate which has Collateral Value | CMS_RE_DTE_VOLUME_VAL | QUAN | 7 | ||
| VOLUME_VALUE_UOM | Unit of Measure for Volume of Real Estate | CMS_RE_DTE_VOL_UOM | UNIT | 6 | * | |
| .INCLUDE | CI_CMS_RE_STR_SPACE_OTHERS | 0 | ||||
| .INCLUDE | CHG_HISTORY | CMS_RE_STR_HIST | 0 | |||
| CREATED_BY | Real Estate Add-On User | CMS_RE_DTE_CR_BY | CHAR | 24 | ||
| CREATED_DATE | Created On | CMS_RE_DTE_CR_ON | DATS | 16 | ||
| CREATED_TIME | Created At | CMS_RE_DTE_CR_AT | TIMS | 12 | ||
| ENTRY_SRC | Sorce of Initial entry | CMS_RE_DTE_SRC_INIT | CHAR | 64 | ||
| LAST_CHG_BY | Last Changed By | CMS_RE_DTE_CHG_BY | CHAR | 24 | ||
| LAST_CHG_DATE | Last Changed On | CMS_RE_DTE_CHG_ON | DATS | 16 | ||
| LAST_CHG_TIME | Last Changed At | CMS_RE_DTE_CHG_AT | TIMS | 12 | ||
| PROCESSING_SRC | Processing Source | CMS_RE_DTE_PRC_SRC | CHAR | 64 | ||
| .INCLUDE | CI_CMS_RE_STR_SPC_OTHERS | 0 |