SAP VISCCNPART Settlement Participation for Service Charge Settlement Table
Overview
VISCCNPART is a standard SAP S/4HANA table that stores Settlement Participation for Service Charge Settlement data. There are total 24 fields in the VISCCNPART table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCCNPART belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Settlement Participation (RE_SC_SP).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCCNPART to other SAP tables and standard CDS views available based on VISCCNPART table in S/4HANA 2020.
Techincal Settings of VISCCNPART
Below are technical details of the table VISCCNPART
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCCNPART Fields
The following table gives you an overview of the fields available in VISCCNPART
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SU_OBJNR | Object Number of Settlement Unit | RESCSUOBJNR | * | CHAR | 22 |
| CN_OBJNR | Object Number of Real Estate Contract (REC) | RESCCNOBJNR | * | CHAR | 22 |
| RO_OBJNR | Object Number of Rental Object | RESCROOBJNR | * | CHAR | 22 |
| VALIDTO | Assignment Is Valid to This Date | RESCVALIDTO | DATS | 8 | |
| VALIDFROM | Date from when assignment is valid | DGULTAB | DATS | 8 | |
| PARTTYPE | Type of Service Charge Settlement Participation | RESCPARTTYPE | CHAR | 1 | |
| PTENANT | Tenant Share per SU as Percentage | RESCPTENANT | DEC | 5 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| MAXCOSTSU | Maximum Costs Value per Settlement Unit for SCS | RESCSMAXCOSTSU | CURR | 15 | |
| BASE | Basis for Calculation of All-Inclusive Rent | RESCSBASE | CHAR | 1 | |
| BASEAMOUNT | Basis Amount for Part-Inclusive Rent | RESCSBASEAMOUNT | CURR | 15 | |
| BASEDATE | Date of Base Year Settlement | RESCSBASEDATE | DATS | 8 | |
| 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 |
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 VISCCNPART
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCCNPART | CONDTYPE | : | TIVCDCONDTYPE |