SAP VISCS_SU_SUM Sum of All Costs and Measurement Amounts for Settlment Unit Table
Overview
VISCS_SU_SUM is a standard SAP S/4HANA table that stores Sum of All Costs and Measurement Amounts for Settlment Unit data. There are total 47 fields in the VISCS_SU_SUM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCS_SU_SUM belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Settlement Hierarchy (RE_SC_SH).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCS_SU_SUM to other SAP tables and standard CDS views available based on VISCS_SU_SUM table in S/4HANA 2020.
Techincal Settings of VISCS_SU_SUM
Below are technical details of the table VISCS_SU_SUM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCS_SU_SUM Fields
The following table gives you an overview of the fields available in VISCS_SU_SUM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SCS_SU_GUID | SU within SCS for a Period and Measurement Type | RESCSUGUID | RAW | 16 | |
| SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | VISCSETTL | RAW | 16 |
| OBJTYPE | Object Type | RECAOBJTYPE | * | CHAR | 2 |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| PTO | Period End Date | RECAPERIODTO | DATS | 8 | |
| PURPOSE | Purpose of Apportionment | RESCFORPURPOSE | TIVSCPURPOSE | CHAR | 3 |
| MEAS | Measurement Type | REBDMEAS | TIVBDMEAS | CHAR | 4 |
| PLENGTH | Number of Days | VVATAGE | NUMC | 6 | |
| CC_OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| IS_MEAS_REF | Is Reference for Other SUs with Same RO + Measurement | RESCISMEASREF | CHAR | 1 | |
| REF2EQUAL_SU | GUID on Entries of SU with Same RO and Measurement | RESCEQUALMEASSU | VISCS_SU_SUM | RAW | 16 |
| REF2SIM_SU | GUID on Entries of SU for Measurement Type for Simulation | RESCREFSIMSU | VISCS_SU_SUM | RAW | 16 |
| REF2REST_SU | GUID for Entries of a SU for Remaining Apportionment | RESCREFRESTSU | VISCS_SU_SUM | RAW | 16 |
| REF2MSUSEGUID | Settlement GUID of Separate Master SU Settlement | RESCREF2MSUSEGUID | VISCSETTL | RAW | 16 |
| REF2MSUSESUGUID | SU GUID in Separate Master SU Settlement | RESCREF2MSUSESUGUID | VISCS_SU_SUM | RAW | 16 |
| MEASUSEDALT | Alternative Measurement Type | RESCMEASUSEDALT | TIVBDMEAS | CHAR | 4 |
| APPORTVALUE | Reference Factor | RESCAPPORTVALUE | DEC | 20 | |
| APPORTVALUEOPT | Part of the Reference Factor that Opts | RESCAPPORTVALUEOPTING | DEC | 20 | |
| SHARE_PERCENT | Share of Apportionment as Percentage | RESCSHAREPERCENT | DEC | 5 | |
| AFCMETHOD | Calculation Method for Reference Factor | RESCAFCMETHOD | CHAR | 4 | |
| LOC_KEY | Regional Location Key for Heating Value Days | RESCLOCKEY | TIVA2 | CHAR | 10 |
| VACANCY_PERCENT | Vacancy Percentage Rate Responsibility of Landlord | RESCVACANCYPERCENT | DEC | 5 | |
| SUM_EQUINUM | Equivalence Number | RESCEQUIVNUM_SUM | DEC | 20 | |
| SUM_EQUINUMUNIT | Measurement Unit for Assignment of Participating SUs | RESCSUMEQUINUMUNIT | * | UNIT | 3 |
| SUM_PERCENT | Percentage rate predistribution cross settlement unit | VVUAEPROZ | DEC | 5 | |
| HOW_DISTRIBUTE | Type of Predistribution | RESCHOWDISTRIBUTE | CHAR | 1 | |
| REST_OBJECT | Obj. number for posting remaining amount for master SU | RESCRESTOBJECT | * | CHAR | 22 |
| RESTNEGALLOWED | Negative Consumption Remainder Allowed | RESCRESTNEGALLOWED | CHAR | 1 | |
| HAS_CHILD | Is Settlement Unit a Master Settlement Unit | RESCHASCHILD | CHAR | 1 | |
| HAS_PARENT | Settlement Unit Has Superordinate Settlement Unit | RESCHASPARENT | CHAR | 1 | |
| HAS_RESTOBJ | Remainder Object Was Defined for Master SU | RESCHASRESTOBJ | CHAR | 1 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| NETAMOUNT | Net Amount | RESCNETAMOUNT | DEC | 22 | |
| NONDEDTAXAMT | Non-Deductible Tax Amount | RESCNONDEDTAXAMT | DEC | 22 | |
| DEDTAXAMOUNT | Deductible Tax Amount | RESCDEDTAXAMT | DEC | 22 | |
| HAS_COSTS | Costs Were Posted on the Object | RESCHASCOSTS | CHAR | 1 | |
| HEATING_SYS | Data Exchange Settlement Unit (Currently Not Used) | RESCHEATING_SYS | * | CHAR | 13 |
| ACCFIRM | Settlement company indicator | SKABRF | TIV50 | CHAR | 3 |
| IS_CREDITSSU | Is SU a Credit-Side Settlement Unit | RESCIS_CREDITSSU | CHAR | 1 | |
| IS_ONLY4MEAS | Settlement Unit Data Record for Retrieval of Measurement | RESCISONLY4MEAS | CHAR | 1 | |
| IS_ONLY4OPTRATE | Settlement Unit Data Record for Retrieving Option Rate | RESCISONLY4OPTRATE | CHAR | 1 | |
| IS_ROOT_SU | Is Root Settlement Unit | RESCISROOTSU | CHAR | 1 | |
| IS_RESTOBJ | Object Is Remainder Object | RESCISRESTOBJ | CHAR | 1 | |
| REASONFORENTRY | Reason for Entry | RESCREASONFORENTRY | CHAR | 3 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 |
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 VISCS_SU_SUM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCS_SU_SUM | ACCFIRM | : | TIV50 |
| VISCS_SU_SUM | HEATING_SYS | : | * |
| VISCS_SU_SUM | LOC_KEY | : | TIVA2 |
| VISCS_SU_SUM | MEAS | : | TIVBDMEAS |
| VISCS_SU_SUM | MEASUSEDALT | : | TIVBDMEAS |
| VISCS_SU_SUM | PURPOSE | 1: CN | TIVSCPURPOSE |
| VISCS_SU_SUM | REF2EQUAL_SU | : | VISCS_SU_SUM |
| VISCS_SU_SUM | REF2MSUSEGUID | 1: CN | VISCSETTL |
| VISCS_SU_SUM | REF2MSUSESUGUID | 1: CN | VISCS_SU_SUM |
| VISCS_SU_SUM | REF2REST_SU | 1: CN | VISCS_SU_SUM |
| VISCS_SU_SUM | REF2SIM_SU | 1: CN | VISCS_SU_SUM |
| VISCS_SU_SUM | SETTL_GUID | 1: CN | VISCSETTL |