| 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 | * | MANDT | Allow NULL? |
| 2 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | CHAR | (N' ') | No | | RECAINTRENO | Allow NULL? |
| 3 | RRID | RE Search Request Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | REORRRID | Allow NULL? |
| 4 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 5 | CREATIONTYPE | How the Object Was Created | char | 1 | 0 | CHAR | (N' ') | Yes | | RECACREATIONTYPE | Allow NULL? |
| 6 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 7 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 8 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 9 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 10 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 11 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 12 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 13 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 14 | RESPONSIBLE | Person Responsible | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | RECARESPONSIBLE | Allow NULL? |
| 15 | USEREXCLUSIVE | User with Exclusive Change Authorization | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | RECAUSEREXCLUSIVE | Allow NULL? |
| 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RECAAUTHGRP | Allow NULL? |
| 17 | RRCNBEG | Requested Contract Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORRRCNBEG | Allow NULL? |
| 18 | RRCNEND | Requested Contract End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORRRCNEND | Allow NULL? |
| 19 | RRCNBEGLATER | Later Contract Start Date Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | REORRRCNBEGLATER | Allow NULL? |
| 20 | RRTYPE | Type of RE Search Request | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVORRRTYPE | REORRRTYPE | Allow NULL? |
| 21 | ACQUISTYPE | Lease/Buy | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REORACQUISTYPE | Allow NULL? |
| 22 | XRR | Text for RE Search Request | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORXRR | Allow NULL? |
| 23 | SEARCHTERM | Text Search | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | REORSEARCHTERM | Allow NULL? |
| 24 | CDVALUETO01 | Maximum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETO | |
| 25 | CDVALUETOL01 | Maximum Condition Amount Including Tolerance Limit | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOL | |
| 26 | CDCURR01 | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 27 | CDVALUEFROM01 | Minimum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUEFROM | |
| 28 | CDVALUETOLFROM01 | Minimum Condition Amount Including Tolerance | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOLFROM | |
| 29 | CDVALUETO02 | Maximum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETO | |
| 30 | CDVALUETOL02 | Maximum Condition Amount Including Tolerance Limit | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOL | |
| 31 | CDCURR02 | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 32 | CDVALUEFROM02 | Minimum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUEFROM | |
| 33 | CDVALUETOLFROM02 | Minimum Condition Amount Including Tolerance | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOLFROM | |
| 34 | CDVALUETO03 | Maximum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETO | |
| 35 | CDVALUETOL03 | Maximum Condition Amount Including Tolerance Limit | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOL | |
| 36 | CDCURR03 | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 37 | CDVALUEFROM03 | Minimum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUEFROM | |
| 38 | CDVALUETOLFROM03 | Minimum Condition Amount Including Tolerance | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOLFROM | |
| 39 | CDVALUETO04 | Maximum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETO | |
| 40 | CDVALUETOL04 | Maximum Condition Amount Including Tolerance Limit | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOL | |
| 41 | CDCURR04 | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 42 | CDVALUEFROM04 | Minimum Condition Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUEFROM | |
| 43 | CDVALUETOLFROM04 | Minimum Condition Amount Including Tolerance | decimal | 15 | 2 | CURR | ((0)) | Yes | | REORCDVALUETOLFROM | |
| 44 | MSVALUEFROM01 | Minimum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUEFROM | |
| 45 | MSVALUETO01 | Maximum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETO | |
| 46 | MSVALUETOLFROM01 | Minimum Measurement Including Tolerance Limit | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLFROM | |
| 47 | MSVALUETOLTO01 | Maximum Measurement Including Tolerance | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLTO | |
| 48 | MSUNIT01 | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 49 | MSVALUEFROM02 | Minimum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUEFROM | |
| 50 | MSVALUETO02 | Maximum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETO | |
| 51 | MSVALUETOLFROM02 | Minimum Measurement Including Tolerance Limit | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLFROM | |
| 52 | MSVALUETOLTO02 | Maximum Measurement Including Tolerance | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLTO | |
| 53 | MSUNIT02 | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 54 | MSVALUEFROM03 | Minimum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUEFROM | |
| 55 | MSVALUETO03 | Maximum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETO | |
| 56 | MSVALUETOLFROM03 | Minimum Measurement Including Tolerance Limit | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLFROM | |
| 57 | MSVALUETOLTO03 | Maximum Measurement Including Tolerance | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLTO | |
| 58 | MSUNIT03 | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 59 | MSVALUEFROM04 | Minimum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUEFROM | |
| 60 | MSVALUETO04 | Maximum Measurement | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETO | |
| 61 | MSVALUETOLFROM04 | Minimum Measurement Including Tolerance Limit | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLFROM | |
| 62 | MSVALUETOLTO04 | Maximum Measurement Including Tolerance | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REORMSVALUETOLTO | |
| 63 | MSUNIT04 | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 64 | RRFLOORSTR | Floor | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRFLOORSTR | Allow NULL? |
| 65 | RRREGLOCSTR | Regional Location | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRREGLOCSTR | Allow NULL? |
| 66 | RRLOCATIONSTR | Location | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRLOCATIONSTR | Allow NULL? |
| 67 | RRLOCATIONNESTR | Location | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRLOCATIONSTR | Allow NULL? |
| 68 | RRDISTLOCSTR | District Location | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRDISTLOCSTR | Allow NULL? |
| 69 | RRTRANSPCONNSTR | Transport Connections | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORRRTRANSPCONNSTR | Allow NULL? |
| 70 | BUILDAGEFROM | Building Age From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORBUILDAGEFROM | Allow NULL? |
| 71 | BUILDAGETO | Building Age To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORBUILDAGETO | Allow NULL? |
| 72 | RRCHARACTSTR | Fixtures and Fittings Characteristic String | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | REORRRCHARACTSTR | Allow NULL? |
| 73 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 74 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 75 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 76 | CITY1 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 77 | CITY2 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 78 | STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 79 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 80 | NEIGHBORHOODSTR | Neighborhood | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REORNEIGHBORHOODSTR | Allow NULL? |
| 81 | EDITINDICATOR | Processing Indicator for RE Search Request | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVOREDITIND | REOREDITINDICATOR | Allow NULL? |
| 82 | EDITSTATUS | Processing Status for RE Search Request | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVOREDITSTAT | REOREDITSTATUS | Allow NULL? |
| 83 | PRESELECTION | Preselection Indicator for RE Search Request | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVORPRESELECT | REORPRESELECTION | Allow NULL? |
| 84 | INFLOWFROM | Source of Prospect | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVORINFLOWFROM | REORINFLOWFROM | Allow NULL? |
| 85 | INFLOWREASON | Reason for Search | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVORINFLOWREAS | REORINFLOWREASON | Allow NULL? |
| 86 | INFLOWWAY | Source of Inquiry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TIVORINFLOWWAY | REORINFLOWWAY | Allow NULL? |
| 87 | RRSEARCHPART | Participation in Search | char | 1 | 0 | CHAR | (N' ') | Yes | | REORRRSEARCHPART | Allow NULL? |
| 88 | AECEXISTS | Accommodation Entitlement Certificate Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | REORAECEXISTS | Allow NULL? |
| 89 | AECCLASSSTR | AEC Level String | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | REORAECCLASSSTR | Allow NULL? |
| 90 | AECDATEOFISSUE | Issue Date of Accommodation Entitlement Certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORAECDATEOFISSUE | Allow NULL? |
| 91 | AECVALIDTO | Accommodation Entitlement Certificate Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REORAECVALIDTO | Allow NULL? |
| 92 | AECPRIORITY | Priority for Accommodation Entitlement Certificate | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVORAECPRIO | REORAECPRIORITY | Allow NULL? |
| 93 | AECPERSONGROUP | Person Group for Accommodation Entitlement Certificate | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVORAECPERSON | REORAECPERSONGROUP | Allow NULL? |
| 94 | AECINFO | Additional Info for Accommodation Entitlement Certificate | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVORAECINFO | REORAECINFO | Allow NULL? |
