| 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 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | CHAR | (N' ') | No | | IMKEY | Allow NULL? |
| 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | TZK01 | SKOART | Allow NULL? |
| 4 | DGABANRT | Date as from when the adjustment type is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VVDGABANRT | Allow NULL? |
| 5 | SINDART | Index series for replacement values | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T094A | WBIND | Allow NULL? |
| 6 | YBASISJ | Index series base year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | T094B | BASJHR | Allow NULL? |
| 7 | BINDPKT | Index marker status at last rent adjustment | decimal | 8 | 3 | DEC | ((0)) | Yes | | BINDPKT | |
| 8 | BPKTERH | Absolute change of index points for rent adjustment | decimal | 4 | 0 | DEC | ((0)) | Yes | | BPKTERH | |
| 9 | PPKTERH | Minimum change of index series change in percentage terms | decimal | 5 | 2 | DEC | ((0)) | Yes | | PPKTERH | |
| 10 | PERHPROZ | Rent adjustment percentage rate increase | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERHPROZ | |
| 11 | DANPAB | Date of first lease-out adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANPAB | Allow NULL? |
| 12 | DANPLETZ | Date of last index adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANPLETZ | Allow NULL? |
| 13 | JINDLOCK | Index block indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JINDLOCK | Allow NULL? |
| 14 | DANPRYTH | Adjustment frequency of rental adjustment in months | decimal | 2 | 0 | DEC | ((0)) | Yes | | DANPRYTH | |
| 15 | DANPNXT | Date of next rental adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANPNXT | Allow NULL? |
| 16 | JINDANP | Ind. whether approval of tenant is necessary for adjustment | char | 1 | 0 | CHAR | (N' ') | Yes | | JINDANP | Allow NULL? |
| 17 | MANPVERZ | Adjustment delay in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MANPVERZ | Allow NULL? |
| 18 | BINDPKT1 | Index status as base for first rental adjustment | decimal | 8 | 3 | DEC | ((0)) | Yes | | BINDPKT1 | |
| 19 | BINDDAT1 | Date on which the markers for 1st adjustment are used | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BINDDAT1 | Allow NULL? |
| 20 | DGENLZB | Date of approval of lease-out by SCB | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DGENLZB | Allow NULL? |
| 21 | JIXANPOB | Rent can only be adjusted on an upward basis (indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | JIXANPOB | Allow NULL? |
| 22 | DANTLZB | Date of application at SCB | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDLZBANT | Allow NULL? |
| 23 | ISKL | Index-Adjusted Lease-Out: Index or Spread Clause | char | 1 | 0 | NUMC | (N'0') | Yes | | VVJISKL | Allow NULL? |
| 24 | JERHSTD | Use the specified pass-on percentage rate? | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJERHSTD | Allow NULL? |
