| 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 Real Estate Master Data Code | nvarchar | 13 | 0 | CHAR | (N' ') | No | | VVINTRENO | Allow NULL? |
| 3 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | J_OBJNR | Allow NULL? |
| 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | CHAR | (N' ') | No | TIV05 | SNKSL | Allow NULL? |
| 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DGULTAB | Allow NULL? |
| 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TZK01 | SKOART | Allow NULL? |
| 7 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIA01 | ABRVAR | Allow NULL? |
| 8 | RECNKOART | Real Estate Contract: Cost Element of Landlord | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RECNKOART | Allow NULL? |
| 9 | SABRG | Apportionment unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIV07 | SABRG | Allow NULL? |
| 10 | ABREART | Settlement type for service charges | char | 1 | 0 | CHAR | (N' ') | Yes | | ABREART | Allow NULL? |
| 11 | RECNPLANDLORD | Landlord's Share Per Service Charge Key, in Percent | decimal | 5 | 2 | DEC | ((0)) | Yes | | RECNPLANDLORD | |
| 12 | AE_INTRENO | Internal Real Estate Master Data Code | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | VVINTRENO | Allow NULL? |
| 13 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 14 | MAXCOST1 | Maximum costs value per service charge key for SCS | decimal | 13 | 2 | CURR | ((0)) | Yes | | VVMAXCOST1 | |
| 15 | MAXCOST2 | Maximum costs value per condition type for SCS | decimal | 13 | 2 | CURR | ((0)) | Yes | | VVMAXCOST2 | |
| 16 | RECNSCSTOAE | No Pass-On to Settlement Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | RECNSCSTOAE | Allow NULL? |
