1. SAP Tutorial
  2. Real Estate Management

VISCSU SAP table for – Settlement unit

Here we would like to draw your attention to VISCSU table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VISCSU is a SAP standard transp table used for storing Settlement unit related data in SAP. It comes under the package RE_SC_SU.

SAP VISCSU table

Table VISCSU technical data

TableVISCSU
Data storingSettlement unit
ModuleRE
Sub ModuleRE-FX-SC
SAP PackageRE_SC_SU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISCSU Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VISCSU table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Settlement Unit: Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SWENR : Valid Business Entity
    Its data type is CHAR (Character String) with field length 8
  • SNKSL : Service Charge Key
    Its data type is CHAR (Character String) with field length 4
  • SEMPSL : Settlement Unit
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : Settlement Unit: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • IMKEY : Internal Key of Real Estate Object (FI)
    Its data type is CHAR (Character String) with field length 8
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • VALIDFROM : Valid-From Date of Settlement Unit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : End of the Validity of Settlement Unit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SUTYPE : Type of Settlement Unit
    Its data type is CHAR (Character String) with field length 2
  • XSU : Name of settlement unit
    Its data type is CHAR (Character String) with field length 60
  • TENANCYLAW : Tenancy law
    Its data type is CHAR (Character String) with field length 5
  • HASCOSTOBJECT : Cost Object SUs Can Be Assigned to the SU
    Its data type is CHAR (Character String) with field length 1
  • NOTAXCORR : No Input Tax Adjustment in the Service Charge Settlement
    Its data type is CHAR (Character String) with field length 1
  • EXCHANGETYPE : Type of Data Exchange
    Its data type is CHAR (Character String) with field length 2
  • SETTLADVPAY : Settlement by settlement company
    Its data type is CHAR (Character String) with field length 1
  • PERHEATING : Percentage of Basic Heating Costs
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PERHOTWATER : Percentage of hot water basic costs
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • MSUCROSSOVERCC : Company-Code-Independent Master Settlement Unit Allowed
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Localization Spain: Additional fields Settlement Unit
  • .INCLUDE : Country-Specific Fields for Spain – Settlement Unit
  • CORRSU : Settlement Unit for Correction
    Its data type is CHAR (Character String) with field length 1
  • CORRINTRENO : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • CORRVALIDFROM : Start of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CORRVALIDTO : End of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : Localization Japan: Additional fields Settlement Unit
  • .INCLUDE : Settlement Based on Fixed Unit Prices
  • SUEXTFORSCS : Flag for SCS Based on Fixed Unit Prices
    Its data type is CHAR (Character String) with field length 1

    • VISCSU related tables

    • VISCSUREL : Master Settlement Unit: Participating Settlement Units
    • VISCSHAREOUT : Split settlement factors for settlement variant
    • TIVSCSUDEFAULT : Defaults for Creating SU per SC Key
    • VISCSURH : Allocation of Settlement Variants to Settlement Unit
    • VISCSUSE : Settings per Settlement Purpose
    • TIVSCPURPOSE : Purpose of Apportionment
    • VISCSU : Settlement unit
    • TIVSCPURPOSET : What Is the Purpose of the Data Record (Text)

    VISCSU related transaction codes under SAP package RE_SC_SU

    • RESCSU0012 : SU: Field Modification Criteria
    • RESCSU0022 : SU: Where-Used List: Structure
    • RESCSU0102 : SU: Authorization Types
    • RESCZK : Purpose
    • RESCSU0103 : SU: Field Grops for Authorization
    • RESCSU0013 : SU: Role Categories
    • RESCSU0009 : SU: CUA Additional Functions
    • RESCSU0019 : SU: Field Mod. per Activity (Control
    • RESCSU0105 : SU: Field Mod. per Non-SAP Applic.
    • RESCSU0002 : SU: Field Groups
    • RESCSU0104 : SU: Screen Configuration
    • RESCSU0011 : SU: Assignment Screen Fld->DB Field
    • RESCSU0107 : SU: Where-Used List: Views
    • RESCSU0106 : SU: Assigment Obj.Part –> Memo ID
    • RESCSU0018 : SU: Activities
    • RESCSU0100 : SU: Field Modification per Activity
    • RESCSUBYBE : Collective Creation of SUs
    • RESCSUAR : Archive Settlement Units
    • RESCSU0003 : SU: Views
    • RESCSESTATUSPER : Settlement Periods of SU

    Related References

    Related Tutorials

    VISCSURH SAP table for – Allocation of Settlement Variants to Settlement Unit

    VISCSURH table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCSUREL SAP table for – Master Settlement Unit: Participating Settlement Units

    VISCSUREL table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCCNPART SAP table for – Settlement Participation for Service Charge Settlement

    VISCCNPART table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCSHAREOUT SAP table for – Split settlement factors for settlement variant

    VISCSHAREOUT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVSCCHRGSU SAP table for – Calculation of Surcharges Dependent on Settlement Unit

    TIVSCCHRGSU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    RESCSU SAP tcode for – Edit Settlement Unit

    RESCSU tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Edit Settlement...

    RESCSUSHAREOUT SAP tcode for – Allocation Rules of Settlement Unit

    RESCSUSHAREOUT tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Allocation Rules...

    «
    »