SAP VISCS_RO_CN Costs and Measurement Amounts for REC + RO (Lease-Out View) Table
Overview
VISCS_RO_CN is a standard SAP S/4HANA table that stores Costs and Measurement Amounts for REC + RO (Lease-Out View) data. There are total 45 fields in the VISCS_RO_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCS_RO_CN 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_RO_CN to other SAP tables and standard CDS views available based on VISCS_RO_CN table in S/4HANA 2020.
Techincal Settings of VISCS_RO_CN
Below are technical details of the table VISCS_RO_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCS_RO_CN Fields
The following table gives you an overview of the fields available in VISCS_RO_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SCS_ROCN_GUID | Rental Object or Contract Depending on Rental | RESCROCNGUID | RAW | 16 | |
| SCS_RO_GUID | Rental Object for an SU Period and Measurement Type | RESCROGUID | VISCS_SU_RO | RAW | 16 |
| OBJTYPE | Object Type | RECAOBJTYPE | * | CHAR | 2 |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| ADD_OBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | * | 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 |
| SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | * | RAW | 16 |
| CNTRIGGER_GUID | Which Object (Usually RO) is Trigger for This Entry | RESCTRIGGERGUID | RAW | 16 | |
| PLENGTH | Number of Days | VVATAGE | NUMC | 6 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| SCS_PERIOD_GUID | Rental Periods | RESCPERIODGUID | VISCS_RENT | RAW | 16 |
| PERIODOTHERGUID | Other Different Rental Period | RESCPERIODOTHERGUID | RAW | 16 | |
| APPORTVALUE | Reference Factor | RESCAPPORTVALUE | DEC | 20 | |
| APPORTVALUEOPT | Part of the Reference Factor that Opts | RESCAPPORTVALUEOPTING | DEC | 20 | |
| APPORTVALUERO | Sum of Reference Factors of Lower-Level Objects | RESCAPPORTVALUESUM | DEC | 20 | |
| APPORTVALUEOPTRO | Sum of Opting Reference Factors of Lower-Level Objects | RESCAPPORTVALUEOPTINGSUM | DEC | 20 | |
| 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 | |
| HASCOP | Uses Current Occupancy Principle | RESCHASCOP | CHAR | 1 | |
| PARTTYPE | Type of Service Charge Settlement Participation | RESCPARTTYPE | CHAR | 1 | |
| TENANT_SHARE | Tenant Share per SU as Percentage | RESCPTENANT | DEC | 5 | |
| OWNER_SHARE | Share of Owner per Service Charge Key as Percent | RESCPOWNER | DEC | 5 | |
| HAS_LIMITATION | Limitation of Settlement Participation | RESCHASLIMITATION | CHAR | 1 | |
| NET_AMOUNT_REAL | Net Amount | RESCNETAMOUNTREAL | DEC | 22 | |
| DEDUCT_TAX_REAL | Non-Deductible Tax Amount | RESCNONITAXREAL | DEC | 22 | |
| 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 | |
| IS_TAX | Value added tax indicator | JMWST | CHAR | 1 | |
| TOTAL_NETAMOUNT | Net Amount Without Special Agreement | RESCNETAMOUNTTOTAL | CURR | 15 | |
| TOTAL_DEDTAXAMT | Deductible Tax Amount Without Special Agreement | RESCDEDTAXAMTTOTAL | CURR | 15 | |
| TOTAL_NONDEDTAX | Non-Deductible Tax Amount Without Special Agreement | RESCNONDEDTAXAMTTOTAL | CURR | 15 | |
| CHRGPERC | Percentage Surcharge Added to Settlement Result | RESCCHRGPERC | DEC | 5 | |
| CHRGDETLEVEL | Level of Determining Surcharge | RESCCHRGDETLEVEL | CHAR | 2 | |
| FIXFITCHARACT | Fixtures and Fittings Characteristic | REBDFIXFITCHARACT | * | CHAR | 6 |
| CHRGNETAMOUNT | Net Surcharge Amount | RESCCHRGNETAMOUNT | CURR | 15 |
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_RO_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCS_RO_CN | CONDTYPE | : | TIVCDCONDTYPE |
| VISCS_RO_CN | FLOWTYPE | : | TIVCDFLOWTYPE |
| VISCS_RO_CN | MEAS | : | TIVBDMEAS |
| VISCS_RO_CN | PURPOSE | 1: CN | TIVSCPURPOSE |
| VISCS_RO_CN | SCS_PERIOD_GUID | 1: CN | VISCS_RENT |
| VISCS_RO_CN | SCS_RO_GUID | 1: CN | VISCS_SU_RO |
| VISCS_RO_CN | SETTL_GUID | : | * |