SAP VIAK26 Master Settlement Unit: Participating Settlement Units Table
Overview
VIAK26 is a standard SAP S/4HANA table that stores Master Settlement Unit: Participating Settlement Units data. There are total 35 fields in the VIAK26 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIAK26 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIAK26 to other SAP tables and standard CDS views available based on VIAK26 table in S/4HANA 2020.
Techincal Settings of VIAK26
Below are technical details of the table VIAK26
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIAK26 Fields
The following table gives you an overview of the fields available in VIAK26
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Valid business entity | VVSWENRNKA | VIOB01 | CHAR | 8 |
| SNKSL | Service Charge Key | SNKSL | TIV05 | CHAR | 4 |
| SEMPSL | Settlement Unit | SEMPSL | VIAK03 | CHAR | 5 |
| DGUELEMP | Valid from date of the assignment of the participating SUs | VVDGUELEMP_SUM | * | DATS | 8 |
| TBUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| TSWENR | Business Entity Number | SWENR | * | CHAR | 8 |
| TSNKSL | Service Charge Key | SNKSL | TIV05 | CHAR | 4 |
| TSEMPSL | Settlement Unit | SEMPSL | * | CHAR | 5 |
| SABRG | Apportionment unit | SABRG | TIV07 | NUMC | 4 |
| EQUINUM | Equivalence numbers | VVEQUINUM | DEC | 10 | |
| XEINHEIT | Measurement unit for assignment of participating SUs | VVMSEHI | T006 | UNIT | 3 |
| PROZ | Percentage rate predistribution cross settlement unit | VVUAEPROZ | DEC | 5 | |
| JDISTRIBUTE | Type of Predistribution (Apportionment Unit Perc Equ.Nos) | VVJDISTRIBUTE | CHAR | 1 | |
| VOLWATER | V = measured volume of consumed hot water in m3 | VVVOLWATER | DEC | 15 | |
| TEMPWATER | TW = Measured or estimated average temperature of hot water | VVTEMPWATER | DEC | 15 | |
| HEATVALUE | HV = Heating value of consumed fuel | VVHEATVAL | DEC | 15 | |
| KBRART | Fuel type in RE | KBRART | TIV54 | NUMC | 2 |
| GCONSUMP | TotCons = Total consumption of heating units as entry value | VVGCONSUMP | DEC | 15 | |
| QHEATAMOUNT | Q = heat consumption for hot water consumption | VVQHEATAMOUNT | DEC | 15 | |
| BCONSUMP | F = Fuel consumption | VVBCONSUMP | DEC | 15 | |
| WHEATAMOUNT | H = heat consumed | VVWHEATAMOUNT | DEC | 15 | |
| WWPROZ | Percentage share for hot water consumption | VVWWPROZ | DEC | 5 | |
| HKVOTYP | Calculation type of heating cost formula | VVHKVOTYP | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| OBJNR | Obj. number for posting remaining amount for master SU | VVJ_OBJNR | * | CHAR | 22 |
| MEAS | Measurement Type | RESCMEAS | * | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIAK26
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIAK26 | BUKRS | : | T001 |
| VIAK26 | KBRART | : | TIV54 |
| VIAK26 | MANDT | : | T000 |
| VIAK26 | SABRG | : | TIV07 |
| VIAK26 | SEMPSL | : | VIAK03 |
| VIAK26 | SNKSL | : | TIV05 |
| VIAK26 | SWENR | : | VIOB01 |
| VIAK26 | TBUKRS | : | T001 |
| VIAK26 | TSNKSL | : | TIV05 |
| VIAK26 | XEINHEIT | : | T006 |