| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | CHAR | (N' ') | No | | SMIVE | Allow NULL? |
| 4 | SWENR | Site Number | nvarchar | 8 | 0 | CHAR | (N' ') | No | VIOB01 | SWENR | Allow NULL? |
| 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | VIMI01 | SMENR | Allow NULL? |
| 6 | VERKT_MV | Lease-Out Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | SMIVE | Allow NULL? |
| 7 | VERKT_WE | Site Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | VIOB01 | SWENR | Allow NULL? |
| 8 | VERKT_ME | Number of Rental Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | VIMI01 | SMENR | Allow NULL? |
| 9 | DMIBEG | Rental start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMIBE | Allow NULL? |
| 10 | DMIEND | Rental end date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMIEN | Allow NULL? |
| 11 | DERZAHL | Date of 1st debit position | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERZA | Allow NULL? |
| 12 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIV26 | SMVART | Allow NULL? |
| 13 | SMVANART | Lease-Out Adjustment Type | char | 1 | 0 | CHAR | (N' ') | Yes | TIV27 | SMVAR | Allow NULL? |
| 14 | AINST | Lease-out interval status debit position | decimal | 2 | 0 | DEC | ((0)) | Yes | | AINST | |
| 15 | JMITA | Employee indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JMITA | Allow NULL? |
| 16 | XMITNR | Employee Number in Lease-Out | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | XMITNR | Allow NULL? |
| 17 | JKONZERN | Corporate group ID types | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TIV28 | JKONZ | Allow NULL? |
| 18 | DUNTBIS | Date provisional agreement from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DUNBI | Allow NULL? |
| 19 | BRSCH | Industry key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T016 | BRSCH | Allow NULL? |
| 20 | BKAUTION | Security deposit amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BKAUT | |
| 21 | SKAUTART | Type of Rental Collateral | char | 1 | 0 | CHAR | (N' ') | Yes | TIV18 | SKAUA | Allow NULL? |
| 22 | DEINKUE | Date of receipt of notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DEKUE | Allow NULL? |
| 23 | DKUEZU | Contract Notice Per | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DKUZU | Allow NULL? |
| 24 | SKUEART | Notice Type | char | 1 | 0 | CHAR | (N' ') | Yes | | SKUAR | Allow NULL? |
| 25 | XKUEGRU | Reason for notice | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | XKUGR | Allow NULL? |
| 26 | JMAHNSP | Dunning block indicator - no longer used! | char | 1 | 0 | CHAR | (N' ') | Yes | | JMASP | Allow NULL? |
| 27 | DANPS | Adjustment block as from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANPS | Allow NULL? |
| 28 | STECHEM | Heating expenses settlement company evaluation group | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | STECHEM | Allow NULL? |
| 29 | JRECHT | Court case indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JRECHT | Allow NULL? |
| 30 | ASCHLU1 | Number of keys 1 | decimal | 3 | 0 | DEC | ((0)) | Yes | | ASCHLU1 | |
| 31 | JMINDER | Rent reduction indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JMINDER | Allow NULL? |
| 32 | DMINDER | Date rent reduction introduced | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMINDER | Allow NULL? |
| 33 | DMINDAB | Rent reduction as from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMINDAB | Allow NULL? |
| 34 | JRATEN | Instalment indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JRATEN | Allow NULL? |
| 35 | BGESRATE | Total of the instalments still to be paid for the cash bond | decimal | 10 | 2 | DEC | ((0)) | Yes | | BGESRATE | |
| 36 | BRATE | Instalment amount | decimal | 10 | 2 | DEC | ((0)) | Yes | | BRATE | |
| 37 | DERSTRAT | Date of first instalment payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERSTRAT | Allow NULL? |
| 38 | BSUMMRAT | Total of instalments paid so far | decimal | 10 | 2 | DEC | ((0)) | Yes | | BSUMMRAT | |
| 39 | AMELDIN | Sales reporting interval | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AMELDIN | Allow NULL? |
| 40 | BUMSPROJ | Planned sales (Amount) | decimal | 13 | 2 | CURR | ((0)) | Yes | | BUMSPROJ | |
| 41 | BMINUMS | Monetary minimum sales in the settlement period | decimal | 13 | 2 | CURR | ((0)) | Yes | | BUMSATZ1 | |
| 42 | PPROZ0 | Minimum percentage rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | PPROZ0 | |
| 43 | STAMV | Status of data record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SSTATI | Allow NULL? |
| 44 | STALT | Status of data record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SSTATI | Allow NULL? |
| 45 | DSTAEN | Status change date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DSTAEN | Allow NULL? |
| 46 | DAKTV | Contract activation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DAKTV | Allow NULL? |
| 47 | JLOESCH | Real Estate Deletion Indicator/Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | JLOESCH | Allow NULL? |
| 48 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T001S | BUSAB | Allow NULL? |
| 49 | JVERL | Contract renewal | char | 1 | 0 | CHAR | (N' ') | Yes | | JVERL | Allow NULL? |
| 50 | JSKUEND | Special right of notice | char | 1 | 0 | CHAR | (N' ') | Yes | | JSKUEND | Allow NULL? |
| 51 | JKAUFOPT | Option to buy | char | 1 | 0 | CHAR | (N' ') | Yes | | JKAUFOPT | Allow NULL? |
| 52 | DKAUFOPT | Purchase option date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DKAUFOPT | Allow NULL? |
| 53 | SNKS | Service Charge Collector Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | SNKS | Allow NULL? |
| 54 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 55 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 56 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 57 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 58 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 59 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 60 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 61 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 62 | DKUEFR | Notice period in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DKUEFR | Allow NULL? |
| 63 | DMIETF | Adjustment block until | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMIETF | Allow NULL? |
| 64 | ANKUEN | Notification until (for renewal of contract) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ANKUEN | Allow NULL? |
| 65 | DABTR | Declaration of assignment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABTR | Allow NULL? |
| 66 | DFREIS | Exemption (bank) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DFREIS | Allow NULL? |
| 67 | DABLF | Expiration Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABLF | Allow NULL? |
| 68 | VERLG | Contract renewal by ... months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VERLG | Allow NULL? |
| 69 | ZUGHK | Employee | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TIV30 | VVZUGHK | Allow NULL? |
| 70 | ZSICH | Indicator that other collateral is available | char | 1 | 0 | CHAR | (N' ') | Yes | | VVZSICH | Allow NULL? |
| 71 | JBETRST | Security deposit granted | char | 1 | 0 | CHAR | (N' ') | Yes | | JBETRST | Allow NULL? |
| 72 | DBKERH | Cash deposit received on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBKERH | Allow NULL? |
| 73 | ABNNR | Identification of lease-out at settlement company | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ABNNR | Allow NULL? |
| 74 | ABNUNR | Customer subnumber | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABNUNR | Allow NULL? |
| 75 | BANKKS | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 76 | SKUEFR | Type of notice period | char | 1 | 0 | NUMC | (N'0') | Yes | | SKUEFR | Allow NULL? |
| 77 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | IMKEY | Allow NULL? |
| 78 | KUNNR | Customer number main contract partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | VVRDEBIHVP | Allow NULL? |
| 79 | SPARTNR | Alternative payer (partner number) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SPRT1 | VVRPARTABW | Allow NULL? |
| 80 | GSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZPA | VVSART | Allow NULL? |
| 81 | MADAT | Last dunned on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MADAT | Allow NULL? |
| 82 | MANST | Dunning level | char | 1 | 0 | NUMC | (N'0') | Yes | | MAHNS_D | Allow NULL? |
| 83 | JBKRZ | Cash deposit instalment payment | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJBKRZ | Allow NULL? |
| 84 | DEINZG | Move-in date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEINZG | Allow NULL? |
| 85 | DAUSZG | Move-out date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDAUSZG | Allow NULL? |
| 86 | JANPIB | Adjustment being processed (indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJANPIB | Allow NULL? |
| 87 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | PRCTR | Allow NULL? |
| 88 | MABER | Dunning Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T047M | MABER | Allow NULL? |
| 89 | PROFL | Settlement profile for costs | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TKB1A | VVAPROF | Allow NULL? |
| 90 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 91 | ZUSP | Subsidies available, indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VVZUSP | Allow NULL? |
| 92 | REFNR | Reference number for collateral securities | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VVREFNR | Allow NULL? |
| 93 | SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSBELEGNG | Allow NULL? |
| 94 | MANSP | Dunning block | char | 1 | 0 | CHAR | (N' ') | Yes | T040S | MANSP | Allow NULL? |
| 95 | DERSTDR | Date When the Lease-Out was First Printed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDERSTDR | Allow NULL? |
| 96 | DAENDDR | Date When the Lease-Out was Changed and Printed Out | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDAENDDR | Allow NULL? |
| 97 | JMFREI | Condition is not checked | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJMFREI | Allow NULL? |
| 98 | DVMUN | Contract signed by landlord | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVMUN | Allow NULL? |
| 99 | JRMSCHPR | Tenant service charge settlement? | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJRMSCHPR | Allow NULL? |
| 100 | TDNAME | Name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | TDOBNAME | Allow NULL? |
| 101 | KBK_PARTNR | Partner number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SPRT1 | SPARTNR | Allow NULL? |
| 102 | GERSTD | Jurisdiction | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | VVXGERSTD | Allow NULL? |
| 103 | NITRENO | Internal Real Estate Master Data Code | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | VVINTRENO | Allow NULL? |
