SAP VISCS_MSU_SU Distribution of Master SU to Participating SUs Table
Overview
VISCS_MSU_SU is a standard SAP S/4HANA table that stores Distribution of Master SU to Participating SUs data. There are total 20 fields in the VISCS_MSU_SU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCS_MSU_SU 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_MSU_SU to other SAP tables and standard CDS views available based on VISCS_MSU_SU table in S/4HANA 2020.
Techincal Settings of VISCS_MSU_SU
Below are technical details of the table VISCS_MSU_SU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCS_MSU_SU Fields
The following table gives you an overview of the fields available in VISCS_MSU_SU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SCS_MSU_GUID | Link to Data Record with Master Settlement Unit | RESCMSUGUID | VISCS_SU_SUM | RAW | 16 |
| SCS_SU_GUID | SU within SCS for a Period and Measurement Type | RESCSUGUID | VISCS_SU_SUM | RAW | 16 |
| SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | VISCSETTL | RAW | 16 |
| SCS_SU_MEAS_GUID | Link to Data Record with Measurement Needed for SU | RESCSUMEASGUID | RAW | 16 | |
| APPORTVALUE | Reference Factor | RESCAPPORTVALUE | DEC | 20 | |
| APPORTVALUEOPT | Part of the Reference Factor that Opts | RESCAPPORTVALUEOPTING | DEC | 20 | |
| APPORTVALUEMSU | Sum of Reference Factors of Lower-Level Objects | RESCAPPORTVALUESUM | DEC | 20 | |
| APPORTVALMSUOPT | Sum of Opting Reference Factors of Lower-Level Objects | RESCAPPORTVALUEOPTINGSUM | DEC | 20 | |
| PURPOSE | Purpose of Apportionment | RESCFORPURPOSE | TIVSCPURPOSE | CHAR | 3 |
| MEAS | Measurement Type | REBDMEAS | TIVBDMEAS | CHAR | 4 |
| SU_MEAS | Measurement Type of Sub-Settlement Unit | RESCSUMEAS | TIVBDMEAS | CHAR | 4 |
| 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 | |
| OPTRATE | Calculated Option Rate | REITOPTRATECALC | DEC | 9 | |
| 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 | |
| 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 VISCS_MSU_SU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCS_MSU_SU | MEAS | : | TIVBDMEAS |
| VISCS_MSU_SU | MSU_SEMPSL | 1: CN | * |
| VISCS_MSU_SU | PURPOSE | 1: CN | TIVSCPURPOSE |
| VISCS_MSU_SU | SCS_MSU_GUID | 1: CN | VISCS_SU_SUM |
| VISCS_MSU_SU | SCS_SU_GUID | 1: CN | VISCS_SU_SUM |
| VISCS_MSU_SU | SEMPSL | 1: CN | * |
| VISCS_MSU_SU | SETTL_GUID | 1: CN | VISCSETTL |
| VISCS_MSU_SU | SU_MEAS | : | TIVBDMEAS |