SAP VISCAJROSU Adjustment Record SCSE per RO and SU Table
Overview
VISCAJROSU is a standard SAP S/4HANA table that stores Adjustment Record SCSE per RO and SU data. There are total 40 fields in the VISCAJROSU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCAJROSU belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Adjustment (RE_SC_AJ).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCAJROSU to other SAP tables and standard CDS views available based on VISCAJROSU table in S/4HANA 2020.
Techincal Settings of VISCAJROSU
Below are technical details of the table VISCAJROSU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCAJROSU Fields
The following table gives you an overview of the fields available in VISCAJROSU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| METHREFSUGUID | Reference to Process-Specific Data for Adjustment Record | REAJMETHREFGUID | RAW | 16 | |
| METHREFGUID | Adjustment Record for Adj.Record with This GUID | RESCADJMGUID | * | RAW | 16 |
| METHREFROGUID | Adjustment Record for Adj.Record with This GUID | RESCADJMGUID | * | RAW | 16 |
| SCS_ROCN_GUID | Rental Object or Contract Depending on Rental | RESCROCNGUID | RAW | 16 | |
| SETTLGUID | Generic Key of Process | RECAPROCESSGUID | * | RAW | 16 |
| SCS_SU_GUID | SU within SCS for a Period and Measurement Type | RESCSUGUID | RAW | 16 | |
| SUOBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| PFROM | Start of Settlement Period | RESCSETTLEVALIDFROM | DATS | 8 | |
| PTO | End of Settlement Period | RESCSETTLEVALIDTO | DATS | 8 | |
| SCS_PERIOD_GUID | Rental Periods | RESCPERIODGUID | RAW | 16 | |
| ACTUALPFROM | Start of Current Settlement Period | RESCACTUALVALIDFROM | DATS | 8 | |
| ACTUALPTO | End of Current Settlement Period | RESCACTUALVALIDTO | DATS | 8 | |
| CNOBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| AVERAGECOSTSSU | Average Costs of a Settlement Period | RESCACOSTSSETTLEMENT | CURR | 15 | |
| APPORTVALUERO | Reference Factor of Rental Object | RESCAPPORTVALUERO | DEC | 20 | |
| APPORTVALUESU | Overall Reference Factor of Settlement Unit | RESCAPPORTVALUESU | DEC | 20 | |
| MEASAVERAGE | Measurement Type | REBDMEAS | TIVBDMEAS | CHAR | 4 |
| TENANTPARTOLD | Tenant Share per SU as Percentage | RESCPTENANT | DEC | 5 | |
| AVERPARTICCOSTS | Proportional Average Costs | RESCAVERPARTICCOSTS | CURR | 15 | |
| COSTSSETTLEMENT | Costs of a Settlement Period | RESCCOSTSSETTLEMENT | CURR | 15 | |
| LOC_KEY | Regional Location Key for Heating Value Days | RESCLOCKEY | TIVA2 | CHAR | 10 |
| HEATINGVALUEDAYS | Heating value percentage rate | VVHEIZWRT | DEC | 5 | |
| BASE | Basis Amount for Part-Inclusive Rent | RESCSBASEAMOUNT | CURR | 15 | |
| COSTSPERYEAR | Costs Projected for One Year | RESCCOSTSPERYEAR | DEC | 22 | |
| COSTSCHANGE | Change to Costs in Percentage | RESCCOSTSCHANGE | DEC | 5 | |
| CHANGEPRICE | Change Amount Due to Cost Change | RESCCHANGEPRICE | DEC | 22 | |
| COSTSAFTERCHANGE | Costs After Consideration of Percentage Cost Change | RESCCOSTSCOSTSCHANGE | DEC | 22 | |
| APPORTVALUEOLD | Reference Factor of Rental Object in Settlement Period | RESCAPPORTVALUEOLD | DEC | 20 | |
| APPORTVALUENEW | Reference Factor of RO in Current Settlement Period | RESCAPPORTVALUENEW | DEC | 20 | |
| MEASCHANGE | Measurement Type | REBDMEAS | TIVBDMEAS | CHAR | 4 |
| COSTSAPPORTCHG | Costs Taking Change in Measurement into Consideration | RESCCOSTSAPPORTCHANGE | DEC | 22 | |
| TENANTPARTNEW | Tenant Share per SU as Percentage | RESCPTENANT | DEC | 5 | |
| COSTSTENANTPART | Costs after Consideration of Tenant Share | RESCCOSTSTENANTPART | DEC | 22 | |
| MAXCOSTSNEW | Maximum Costs Value per Settlement Unit for SCS | RESCSMAXCOSTSU | CURR | 15 | |
| COSTSMAXCOSTS | Costs Taking Maximum Costs into Consideration | RESCCOSTSMAXCOSTS | DEC | 22 | |
| BASENEW | Basis Amount for Part-Inclusive Rent | RESCSBASEAMOUNT | CURR | 15 | |
| COSTSBASE | Costs After Consideration of Part-Inclusive Rent | RESCCOSTSBASE | DEC | 22 | |
| COSTSFORSU | Costs of Settlement Unit for a Rental Object | RESCCOSTSFORSU | DEC | 22 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
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 VISCAJROSU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCAJROSU | LOC_KEY | : | TIVA2 |
| VISCAJROSU | MEASAVERAGE | : | TIVBDMEAS |
| VISCAJROSU | MEASCHANGE | : | TIVBDMEAS |
| VISCAJROSU | METHREFGUID | : | * |
| VISCAJROSU | METHREFROGUID | : | * |
| VISCAJROSU | SETTLGUID | : | * |