| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SPC_GUID | GUID for Spaces in Real Estate | varbinary | 16 | 0 | RAW | | No | | CMS_RE_DTE_SPC_GUID | |
| 3 | OBJ_GUID | GUID for Real Estate Object | varbinary | 16 | 0 | RAW | | Yes | CMS_RE_OBJ | CMS_RE_DTE_OBJ_GUID | |
| 4 | SPACE_TYPE | Building Part Type ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_RE_SP_TYP | CMS_RE_DTE_SPC_TYP | Allow NULL? |
| 5 | SPACE_COND | Condition ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_RE_COND | CMS_RE_DTE_OBJ_COND | Allow NULL? |
| 6 | USAGE_TYPE | Usage Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_RE_U_TYP | CMS_RE_DTE_USG_TYP | Allow NULL? |
| 7 | BLD_STR_TYPE | Real Estate Building Structure ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_RE_STR | CMS_RE_DTE_BLD_STR_TYP | Allow NULL? |
| 8 | SPACE_DESC | Description of Building Part | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_RE_DTE_SPC_DESC | Allow NULL? |
| 9 | NO_UNITS | No of units in real estate object | int | 10 | 0 | INT4 | ((0)) | Yes | | CMS_RE_DTE_NO_UNIT | Allow NULL? |
| 10 | NO_PARK_UNITS | Number of Parking Units | int | 10 | 0 | INT4 | ((0)) | Yes | | CMS_RE_DTE_NO_PARK_UNIT | Allow NULL? |
| 11 | NO_GARAGES | No of Garages in Real Estate Object | int | 10 | 0 | INT4 | ((0)) | Yes | | CMS_RE_DTE_NO_GAR | Allow NULL? |
| 12 | AREA | Total Area of the Real Estate Object | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_RE_DTE_AREA | |
| 13 | AREA_UOM | Unit of Measure for Area | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CMS_RE_DTE_AREA_UOM | Allow NULL? |
| 14 | VOLUME | Volume of Real Estate Object | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_RE_DTE_VOL | |
| 15 | VOLUME_UOM | Unit of Measure for Volume of Real Estate | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CMS_RE_DTE_VOL_UOM | Allow NULL? |
| 16 | AREA_VALUE | Area in the Real Estate which has Collateral Value | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_RE_DTE_AREA_VAL | |
| 17 | AREA_VALUE_UOM | Unit of Measure for Area | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CMS_RE_DTE_AREA_UOM | Allow NULL? |
| 18 | VOLUME_VAL | Volume of Real Estate which has Collateral Value | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_RE_DTE_VOLUME_VAL | |
| 19 | VOLUME_VALUE_UOM | Unit of Measure for Volume of Real Estate | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CMS_RE_DTE_VOL_UOM | Allow NULL? |
| 20 | CREATED_BY | Real Estate Add-On User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_RE_DTE_CR_BY | Allow NULL? |
| 21 | CREATED_DATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_RE_DTE_CR_ON | Allow NULL? |
| 22 | CREATED_TIME | Created At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CMS_RE_DTE_CR_AT | Allow NULL? |
| 23 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CMS_RE_DTE_SRC_INIT | Allow NULL? |
| 24 | LAST_CHG_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_RE_DTE_CHG_BY | Allow NULL? |
| 25 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_RE_DTE_CHG_ON | Allow NULL? |
| 26 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CMS_RE_DTE_CHG_AT | Allow NULL? |
| 27 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CMS_RE_DTE_PRC_SRC | Allow NULL? |
