SAP VISCSUREL Master Settlement Unit: Participating Settlement Units Table
Overview
VISCSUREL is a standard SAP S/4HANA table that stores Master Settlement Unit: Participating Settlement Units data. There are total 17 fields in the VISCSUREL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCSUREL belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Settlement Unit (RE_SC_SU).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCSUREL to other SAP tables and standard CDS views available based on VISCSUREL table in S/4HANA 2020.
Techincal Settings of VISCSUREL
Below are technical details of the table VISCSUREL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCSUREL Fields
The following table gives you an overview of the fields available in VISCSUREL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENOSRC | Internal Object Number for RE Objects (Source) | REBDINTRENOSRC | VISCSU | CHAR | 13 |
| INTRENOTRG | Internal Object Number for RE Object (Target) | REBDINTRENOTRG | VISCSU | CHAR | 13 |
| VALIDFROM | Date: Valid From | REBDVALIDFROM | DATS | 8 | |
| EQUIVNUM | Equivalence Number | RESCEQUIVNUM | DEC | 20 | |
| 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 | |
| FUELTYPE | Fuel type | RESCFUELTYPE | 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 | |
| MEAS | Measurement Type | REBDMEAS | * | CHAR | 4 |
| METERFROMRO | Consumption Is Determined Using Assigned Rental Object | RESCMETERFROMRO | CHAR | 1 |
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 VISCSUREL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCSUREL | FUELTYPE | : | TIV54 |
| VISCSUREL | INTRENOSRC | : | VISCSU |
| VISCSUREL | INTRENOTRG | : | VISCSU |