| 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 | INTRENO | Internal Real Estate Master Data Code | nvarchar | 13 | 0 | CHAR | (N' ') | No | VIRN01 | VVINTRENO | Allow NULL? |
| 3 | SRNWLFDNUM | Sequential number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | RECNSRNWLFDNUM | Allow NULL? |
| 4 | NRNWSORTNB | Sequential number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNSRNWLFDNUM | Allow NULL? |
| 5 | SRNWOPTION | Renewal Rule | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCN09 | RECNSRNWOPTION | Allow NULL? |
| 6 | NRNWJHR | Contract Renewed for Number of Years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNRNWYEARS | Allow NULL? |
| 7 | NRNWMON | Contract Renewed for Number of Months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNRNWMONTHS | Allow NULL? |
| 8 | NRNWTAG | Contract Renewed for Number of Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNRNWDAYS | Allow NULL? |
| 9 | SRNWDAYRND | Rounding Rule for Determined Renewal Date | char | 1 | 0 | CHAR | (N' ') | Yes | | RECNRNWDAYRND | Allow NULL? |
| 10 | NAMTJHR | Notification Must Be This No. of Years before Renewal Date | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNAMTYEARS | Allow NULL? |
| 11 | NAMTMON | Notification Must Be This No. of Months before Renewal Date | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNAMTMONTHS | Allow NULL? |
| 12 | NAMTTAG | Notification Must Be This No. of Days before Renewal Date | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RECNAMTDAYS | Allow NULL? |
| 13 | SAMTDAYRND | Rounding Rule for Determined Notification Date | char | 1 | 0 | CHAR | (N' ') | Yes | | RECNAMTDAYRND | Allow NULL? |
| 14 | DRNWDATE | Renewal date (new contract end date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDRNWDATE | Allow NULL? |
| 15 | DAMTDATE | Notification Date (Latest Date for Declaring Option) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDAMTDATE | Allow NULL? |
| 16 | DRNWACCOWN | Approval date for renewal (own) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDRNWACCOWN | Allow NULL? |
| 17 | DRNWACCPAR | Approval date for renewal (partner) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDRNWACCPAR | Allow NULL? |
| 18 | DRNWOPTACT | Date of activation of renewal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDRNWOPTACT | Allow NULL? |
| 19 | JRNWDCTINP | Renewal date added (no rule evaluation) | char | 1 | 0 | CHAR | (N' ') | Yes | | RECNJRNWDCTINP | Allow NULL? |
| 20 | XRNWINFTXT | Short text for renewal date | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | RECNXRNWINFTXT | Allow NULL? |
| 21 | SRNWSOURCE | Source of Renewal Date (Option or Automatic) | char | 1 | 0 | NUMC | (N'0') | Yes | | RECNSRNWSOURCE | Allow NULL? |
| 22 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 23 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 24 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 25 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 26 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 27 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 28 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 29 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
