1. SAP Tutorial
  2. Real Estate Management

VISCS_SU_SUM SAP table for – Sum of All Costs and Measurement Amounts for Settlment Unit

Here we would like to draw your attention to VISCS_SU_SUM 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). VISCS_SU_SUM is a SAP standard transp table used for storing Sum of All Costs and Measurement Amounts for Settlment Unit related data in SAP. It comes under the package RE_SC_SH.

SAP VISCS_SU_SUM table

Table VISCS_SU_SUM technical data

TableVISCS_SU_SUM
Data storingSum of All Costs and Measurement Amounts for Settlment Unit
ModuleRE
Sub ModuleRE-FX-SC
SAP PackageRE_SC_SH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISCS_SU_SUM 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 VISCS_SU_SUM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SCS_SU_GUID : SU within SCS, for a Period and Measurement Type
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Key Fields of Table VISCS_SU_SUM
  • .INCLUDE : Key Fields of SU per Period and Measurement
  • SETTL_GUID : Unique Key of Settlement
    Its data type is RAW (Byte string) with field length 16
  • OBJTYPE : Object Type
    Its data type is CHAR (Character String) with field length 2
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • PFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTO : Period End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of VISCSHAREOUT – Include for Other Tables
  • PURPOSE : Purpose of Apportionment
    Its data type is CHAR (Character String) with field length 3
  • MEAS : Measurement Type
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Non-Key Fields of Table VISCS_SU_SUM
  • PLENGTH : Number of days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CC_OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • IS_MEAS_REF : Is Reference for Other SUs with Same RO + Measurement
    Its data type is CHAR (Character String) with field length 1
  • REF2EQUAL_SU : GUID on Entries of SU with Same RO and Measurement
    Its data type is RAW (Byte string) with field length 16
  • REF2SIM_SU : GUID on Entries of SU for Measurement Type for Simulation
    Its data type is RAW (Byte string) with field length 16
  • REF2REST_SU : GUID for Entries of a SU for Remaining Apportionment
    Its data type is RAW (Byte string) with field length 16
  • REF2MSUSEGUID : Settlement GUID of Separate Master SU Settlement
    Its data type is RAW (Byte string) with field length 16
  • REF2MSUSESUGUID : SU GUID in Separate Master SU Settlement
    Its data type is RAW (Byte string) with field length 16
  • MEASUSEDALT : Alternative Measurement Type
    Its data type is CHAR (Character String) with field length 4
  • APPORTVALUE : Reference Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 20
  • APPORTVALUEOPT : Part of the Reference Factor that Opts
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 20
  • .INCLUDE : Basic Properties of Apportionment Rule
  • SHARE_PERCENT : Share of Apportionment as Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • .INCLUDE : Parameters for Calculating Reference Factors
  • AFCMETHOD : Calculation Method for Reference Factor
    Its data type is CHAR (Character String) with field length 4
  • LOC_KEY : Regional Location Key for Heating Value Days
    Its data type is CHAR (Character String) with field length 10
  • VACANCY_PERCENT : Vacancy Percentage Rate, Responsibility of Landlord
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SUM_EQUINUM : Equivalence Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 20
  • SUM_EQUINUMUNIT : Measurement Unit for Assignment of Participating SUs
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SUM_PERCENT : Percentage rate predistribution cross settlement unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • HOW_DISTRIBUTE : Type of Predistribution
    Its data type is CHAR (Character String) with field length 1
  • REST_OBJECT : Obj. number for posting remaining amount for master SU
    Its data type is CHAR (Character String) with field length 22
  • RESTNEGALLOWED : Negative Consumption Remainder Allowed
    Its data type is CHAR (Character String) with field length 1
  • HAS_CHILD : Is Settlement Unit a Master Settlement Unit
    Its data type is CHAR (Character String) with field length 1
  • HAS_PARENT : Settlement Unit Has Superordinate Settlement Unit
    Its data type is CHAR (Character String) with field length 1
  • HAS_RESTOBJ : Remainder Object Was Defined for Master SU
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • NETAMOUNT : Net Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 22
  • NONDEDTAXAMT : Non-Deductible Tax Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 22
  • DEDTAXAMOUNT : Deductible Tax Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 22
  • HAS_COSTS : Costs Were Posted on the Object
    Its data type is CHAR (Character String) with field length 1
  • HEATING_SYS : Data Exchange Settlement Unit (Currently Not Used)
    Its data type is CHAR (Character String) with field length 13
  • ACCFIRM : Settlement company indicator
    Its data type is CHAR (Character String) with field length 3
  • IS_CREDITSSU : Is SU a Credit-Side Settlement Unit
    Its data type is CHAR (Character String) with field length 1
  • IS_ONLY4MEAS : Settlement Unit Data Record for Retrieval of Measurement
    Its data type is CHAR (Character String) with field length 1
  • IS_ONLY4OPTRATE : Settlement Unit Data Record for Retrieving Option Rate
    Its data type is CHAR (Character String) with field length 1
  • IS_ROOT_SU : Is Root Settlement Unit
    Its data type is CHAR (Character String) with field length 1
  • IS_RESTOBJ : Object Is Remainder Object
    Its data type is CHAR (Character String) with field length 1
  • REASONFORENTRY : Reason for Entry
    Its data type is CHAR (Character String) with field length 3
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16

    • VISCS_SU_SUM related tables

    • VISCS_MSU_SU : Distribution of Master SU to Participating SUs
    • VISCS_MSU_REST : Distribution of Master SU to Remaining Objects
    • VISCS_SU_RO : Sum of All Costs and Measurement Amounts for a Rental Object
    • VISCS_SU_SUM : Sum of All Costs and Measurement Amounts for Settlment Unit
    • VISCMAPPROCSCS : Mapping Process to Settlement Hierarchy
    • VISCS_RENT : Rental period
    • VISCS_RO_CN : Costs and Measurement Amounts for REC + RO (Lease-Out View)

    Related References

    Related Tutorials

    VISCS_SU_RO SAP table for – Sum of All Costs and Measurement Amounts for a Rental Object

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

    VISCS_RO_CN SAP table for – Costs and Measurement Amounts for REC + RO (Lease-Out View)

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

    VIAJATOBJ SAP table for – Object and Costs for Adjustment Measure

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

    VISCSMEAS SAP table for – Measurement Amount Used

    VISCSMEAS 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...

    VISCS_MSU_SU SAP table for – Distribution of Master SU to Participating SUs

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

    VISCS_MEAS SAP table for – OBSOLETE: Measurement Amount (Replaced by VISCSMEAS)

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

    «
    »