VISCS_RO_CN SAP (Costs and Measurement Amounts for REC + RO (Lease-Out View)) Table details
Description: Costs and Measurement Amounts for REC + RO (Lease-Out View)
Table field list including key, data, relationships and ABAP select examples
VISCS_RO_CN is a standard SAP Table which is used to store Costs and Measurement Amounts for REC + RO (Lease-Out View) data and is available within R/3 SAP systems depending on the version and release level.
The VISCS_RO_CN table consists of various fields, each holding specific information or linking keys about Costs and Measurement Amounts for REC + RO (Lease-Out View) data available in SAP. These include SCS_ROCN_GUID (Rental Object or Contract, Depending on Rental), SCS_RO_GUID (Rental Object for an SU, Period and Measurement Type), OBJTYPE (Object Type), OBJNR (Object Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VISCS_RO_CN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SCS_ROCN_GUID | Rental Object or Contract, Depending on Rental | RESCROCNGUID | RAW | 16 | RECAGUID | ||||
SCS_RO_GUID | Rental Object for an SU, Period and Measurement Type | RESCROGUID | RAW | 16 | VISCS_SU_RO | RECAGUID | |||
OBJTYPE | Object Type | RECAOBJTYPE | CHAR | 2 | Assigned to domain | J_OBART | RECAOBJTYPE | ||
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
ADD_OBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | RECADATEBEG | ||||
PTO | Period End Date | RECAPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
PURPOSE | Purpose of Apportionment | RESCFORPURPOSE | CHAR | 3 | TIVSCPURPOSE | RESCFORPURPOSE | RESCPURPOSE | ||
MEAS | Measurement Type | REBDMEAS | CHAR | 4 | TIVBDMEAS | ALPHA | REBDMEAS | REBDMEAS | REBDMEAS |
SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | Assigned to domain | RECAGUID | |||
CNTRIGGER_GUID | Which Object (Usually RO) is Trigger for This Entry | RESCTRIGGERGUID | RAW | 16 | RECAGUID | ||||
PLENGTH | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | TIVCDCONDTYPE | ALPHA | RECDCONDTYPE | ||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
SCS_PERIOD_GUID | Rental Periods | RESCPERIODGUID | RAW | 16 | VISCS_RENT | RECAGUID | |||
PERIODOTHERGUID | Other, Different Rental Period | RESCPERIODOTHERGUID | RAW | 16 | RECAGUID | ||||
APPORTVALUE | Reference Factor | RESCAPPORTVALUE | DEC | 20(8) | RESCAPPORTVALUE | ||||
APPORTVALUEOPT | Part of the Reference Factor that Opts | RESCAPPORTVALUEOPTING | DEC | 20(8) | RESCAPPORTVALUE | ||||
APPORTVALUERO | Sum of Reference Factors of Lower-Level Objects | RESCAPPORTVALUESUM | DEC | 20(8) | RESCAPPORTVALUE | ||||
APPORTVALUEOPTRO | Sum of Opting Reference Factors of Lower-Level Objects | RESCAPPORTVALUEOPTINGSUM | DEC | 20(8) | RESCAPPORTVALUE | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NETAMOUNT | Net Amount | RESCNETAMOUNT | DEC | 22(8) | RESCSHCURR | ||||
NONDEDTAXAMT | Non-Deductible Tax Amount | RESCNONDEDTAXAMT | DEC | 22(8) | RESCSHCURR | ||||
DEDTAXAMOUNT | Deductible Tax Amount | RESCDEDTAXAMT | DEC | 22(8) | RESCSHCURR | ||||
HAS_COSTS | Costs Were Posted on the Object | RESCHASCOSTS | CHAR | 1 | RECABOOL | ||||
HASCOP | Uses Current Occupancy Principle | RESCHASCOP | CHAR | 1 | RECABOOL | ||||
PARTTYPE | Type of Service Charge Settlement Participation | RESCPARTTYPE | CHAR | 1 | RESCPARTTYPE | ||||
TENANT_SHARE | Tenant Share per SU as Percentage | RESCPTENANT | DEC | 5(2) | PANTEIL | ||||
OWNER_SHARE | Share of Owner, per Service Charge Key, as Percent | RESCPOWNER | DEC | 5(2) | PANTEIL | ||||
HAS_LIMITATION | Limitation of Settlement Participation | RESCHASLIMITATION | CHAR | 1 | RECABOOL | ||||
NET_AMOUNT_REAL | Net Amount | RESCNETAMOUNTREAL | DEC | 22(8) | RESCSHCURR | ||||
DEDUCT_TAX_REAL | Non-Deductible Tax Amount | RESCNONITAXREAL | DEC | 22(8) | RESCSHCURR | ||||
MAXCOSTSU | Maximum Costs Value per Settlement Unit for SCS | RESCSMAXCOSTSU | CURR | 15(2) | RECACURR | ||||
BASE | Basis for Calculation of All-Inclusive Rent | RESCSBASE | CHAR | 1 | RESCSBASE | ||||
BASEAMOUNT | Basis Amount for Part-Inclusive Rent | RESCSBASEAMOUNT | CURR | 15(2) | RECACURR | ||||
BASEDATE | Date of Base Year Settlement | RESCSBASEDATE | DATS | 8 | DATS | ||||
IS_TAX | Value added tax indicator | JMWST | CHAR | 1 | JANE | ||||
TOTAL_NETAMOUNT | Net Amount Without Special Agreement | RESCNETAMOUNTTOTAL | CURR | 15(2) | RECACURR | ||||
TOTAL_DEDTAXAMT | Deductible Tax Amount Without Special Agreement | RESCDEDTAXAMTTOTAL | CURR | 15(2) | RECACURR | ||||
TOTAL_NONDEDTAX | Non-Deductible Tax Amount Without Special Agreement | RESCNONDEDTAXAMTTOTAL | CURR | 15(2) | RECACURR | ||||
CHRGPERC | Percentage Surcharge Added to Settlement Result | RESCCHRGPERC | DEC | 5(2) | RECAPROZ3_2 | ||||
CHRGDETLEVEL | Level of Determining Surcharge | RESCCHRGDETLEVEL | CHAR | 2 | RESCCHRGDETLEVEL | ||||
FIXFITCHARACT | Fixtures and Fittings Characteristic | REBDFIXFITCHARACT | CHAR | 6 | Assigned to domain | ALPHA | REBDFIXFITCHARACT | ||
CHRGNETAMOUNT | Net Surcharge Amount | RESCCHRGNETAMOUNT | CURR | 15(2) | RECACURR |
Key field | Non-key field |
How do I retrieve data from SAP table VISCS_RO_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VISCS_RO_CN to SELECT all data from the tableDATA: WA_VISCS_RO_CN TYPE VISCS_RO_CN.
SELECT SINGLE *
FROM VISCS_RO_CN
INTO CORRESPONDING FIELDS OF WA_VISCS_RO_CN
WHERE...
How to access SAP table VISCS_RO_CN
Within an ECC or HANA version of SAP you can also view further information about VISCS_RO_CN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects