| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | SWENR | Valid business entity | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SEMPSL | Settlement Unit | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | DGUELEMP | Valid from date of the assignment of the participating SUs | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TBUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | TSWENR | Site Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | TSNKSL | Service Charge Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | TSEMPSL | Settlement Unit | nvarchar | 5 | 0 | | | | Allow NULL? |
| 11 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | EQUINUM | Equivalence numbers | decimal | 10 | 0 | | | | |
| 13 | XEINHEIT | Measurement unit for assignment of participating SUs | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | PROZ | Percentage rate predistribution cross settlement unit | decimal | 5 | 2 | | | | |
| 15 | JDISTRIBUTE | Type of Predistribution (Apportionment Unit, Perc, Equ.Nos) | char | 1 | 0 | | | | Allow NULL? |
| 16 | VOLWATER | V = measured volume of consumed hot water in m3 | decimal | 15 | 2 | | | | |
| 17 | TEMPWATER | TW = Measured or estimated average temperature of hot water | decimal | 15 | 2 | | | | |
| 18 | HEATVALUE | HV = Heating value of consumed fuel | decimal | 15 | 2 | | | | |
| 19 | KBRART | Fuel type in RE | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | GCONSUMP | TotCons = Total consumption of heating units as entry value | decimal | 15 | 2 | | | | |
| 21 | QHEATAMOUNT | Q = heat consumption for hot water consumption | decimal | 15 | 2 | | | | |
| 22 | BCONSUMP | F = Fuel consumption | decimal | 15 | 2 | | | | |
| 23 | WHEATAMOUNT | H = heat consumed | decimal | 15 | 2 | | | | |
| 24 | WWPROZ | Percentage share for hot water consumption | decimal | 5 | 2 | | | | |
| 25 | HKVOTYP | Calculation type of heating cost formula | char | 1 | 0 | | | | Allow NULL? |
| 26 | RERF | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | DERF | First Entered on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | REHER | Source of initial entry | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | RBEAR | Employee ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | DBEAR | Last Edited on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | TBEAR | Last Edited at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | RBHER | Editing Source | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | OBJNR | Obj. number for posting remaining amount for master SU | nvarchar | 22 | 0 | | | | Allow NULL? |
| 35 | MEAS | Measurement Type | nvarchar | 4 | 0 | | | | Allow NULL? |
