| 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 | SECTYPE | Type of Section in Land Register | char | 1 | 0 | CHAR | (N' ') | No | | RELMSECTYPE | Allow NULL? |
| 4 | SECNO | Land Register Section: Sequence Number of Entry | nvarchar | 6 | 0 | CHAR | (N' ') | No | | RELMSECNO | Allow NULL? |
| 5 | SECSUBNO | Section in Land Register: Subentry | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RELMSECSUBNO | Allow NULL? |
| 6 | ENCADDTYPE | Type of Assignment of Land for Rights and Easements | char | 1 | 0 | CHAR | (N' ') | No | | RELMLRENCADDTYPE | Allow NULL? |
| 7 | ENTRYNO | Sequence Number of Entry | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RELMLRENTRYNO | Allow NULL? |
| 8 | ENTRYDATE | Date of Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RELMENTRYDATE | Allow NULL? |
| 9 | CANCELDATE | Date of Cancellation of Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RELMCANCELDATE | Allow NULL? |
| 10 | LRREGNO | Number in Real Estate Register to Which Addition Is Made | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | RELMLRREGNOADD | Allow NULL? |
| 11 | LRREGSUBNO | RE Register Subentry to Which Addition Is Made | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RELMLRREGSUBNOADD | Allow NULL? |
| 12 | PLEXTIDENTKEY | ID of External Parcel - OBSOLETE | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | RELMLRPLEXTIDENTKEY | Allow NULL? |
| 13 | PLOBJNR | Object Number of Assigned Parcel | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RELMLRPLOBJNR | Allow NULL? |
| 14 | LRDISTRICT | Land Register District | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RELMLRDISTRICT | Allow NULL? |
| 15 | LRVOLUMENO | Number of Land Register Volume | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | RELMLRVOLUMENO | Allow NULL? |
| 16 | LRPAGENO | Page Number in Land Register | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | RELMLRPAGENO | Allow NULL? |
| 17 | SECTYPEADD | Type of Section in Land Register | char | 1 | 0 | CHAR | (N' ') | Yes | | RELMSECTYPE | Allow NULL? |
| 18 | SECNOADD | Land Register Section: Sequence Number of Entry | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | RELMSECNO | Allow NULL? |