VISCS_SU_SUM SAP (Sum of All Costs and Measurement Amounts for Settlment Unit) Table details
Description: Sum of All Costs and Measurement Amounts for Settlment Unit
Table field list including key, data, relationships and ABAP select examples
VISCS_SU_SUM is a standard SAP Table which is used to store Sum of All Costs and Measurement Amounts for Settlment Unit data and is available within R/3 SAP systems depending on the version and release level.
The VISCS_SU_SUM table consists of various fields, each holding specific information or linking keys about Sum of All Costs and Measurement Amounts for Settlment Unit data available in SAP. These include SCS_SU_GUID (SU within SCS, for a Period and Measurement Type), SETTL_GUID (Unique Key of Settlement), 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_SU_SUM 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_SU_GUID | SU within SCS, for a Period and Measurement Type | RESCSUGUID | RAW | 16 | RECAGUID | ||||
SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | VISCSETTL | 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 | ||
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 |
PLENGTH | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
CC_OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
IS_MEAS_REF | Is Reference for Other SUs with Same RO + Measurement | RESCISMEASREF | CHAR | 1 | RECABOOL | ||||
REF2EQUAL_SU | GUID on Entries of SU with Same RO and Measurement | RESCEQUALMEASSU | RAW | 16 | VISCS_SU_SUM | RECAGUID | |||
REF2SIM_SU | GUID on Entries of SU for Measurement Type for Simulation | RESCREFSIMSU | RAW | 16 | VISCS_SU_SUM | RECAGUID | |||
REF2REST_SU | GUID for Entries of a SU for Remaining Apportionment | RESCREFRESTSU | RAW | 16 | VISCS_SU_SUM | RECAGUID | |||
REF2MSUSEGUID | Settlement GUID of Separate Master SU Settlement | RESCREF2MSUSEGUID | RAW | 16 | VISCSETTL | RECAGUID | |||
REF2MSUSESUGUID | SU GUID in Separate Master SU Settlement | RESCREF2MSUSESUGUID | RAW | 16 | VISCS_SU_SUM | RECAGUID | |||
MEASUSEDALT | Alternative Measurement Type | RESCMEASUSEDALT | CHAR | 4 | TIVBDMEAS | ALPHA | REBDMEAS | ||
APPORTVALUE | Reference Factor | RESCAPPORTVALUE | DEC | 20(8) | RESCAPPORTVALUE | ||||
APPORTVALUEOPT | Part of the Reference Factor that Opts | RESCAPPORTVALUEOPTING | DEC | 20(8) | RESCAPPORTVALUE | ||||
SHARE_PERCENT | Share of Apportionment as Percentage | RESCSHAREPERCENT | DEC | 5(2) | DEC3_2 | ||||
AFCMETHOD | Calculation Method for Reference Factor | RESCAFCMETHOD | CHAR | 4 | RESCAFCMETHOD | ||||
LOC_KEY | Regional Location Key for Heating Value Days | RESCLOCKEY | CHAR | 10 | TIVA2 | ETH10 | RESCLOCKEY | ||
VACANCY_PERCENT | Vacancy Percentage Rate, Responsibility of Landlord | RESCVACANCYPERCENT | DEC | 5(2) | DEC3_2 | ||||
SUM_EQUINUM | Equivalence Number | RESCEQUIVNUM_SUM | DEC | 20(8) | RESCAPPORTVALUE | ||||
SUM_EQUINUMUNIT | Measurement Unit for Assignment of Participating SUs | RESCSUMEQUINUMUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SUM_PERCENT | Percentage rate predistribution cross settlement unit | VVUAEPROZ | DEC | 5(2) | VVPROZE | ||||
HOW_DISTRIBUTE | Type of Predistribution | RESCHOWDISTRIBUTE | CHAR | 1 | RESCHOWDISTRIBUTE | ||||
REST_OBJECT | Obj. number for posting remaining amount for master SU | RESCRESTOBJECT | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RESTNEGALLOWED | Negative Consumption Remainder Allowed | RESCRESTNEGALLOWED | CHAR | 1 | RECABOOL | ||||
HAS_CHILD | Is Settlement Unit a Master Settlement Unit | RESCHASCHILD | CHAR | 1 | RECABOOL | ||||
HAS_PARENT | Settlement Unit Has Superordinate Settlement Unit | RESCHASPARENT | CHAR | 1 | RECABOOL | ||||
HAS_RESTOBJ | Remainder Object Was Defined for Master SU | RESCHASRESTOBJ | CHAR | 1 | RECABOOL | ||||
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 | ||||
HEATING_SYS | Data Exchange Settlement Unit (Currently Not Used) | RESCHEATING_SYS | CHAR | 13 | Assigned to domain | CHAR13 | |||
ACCFIRM | Settlement company indicator | SKABRF | CHAR | 3 | TIV50 | SKABRF | |||
IS_CREDITSSU | Is SU a Credit-Side Settlement Unit | RESCIS_CREDITSSU | CHAR | 1 | RECABOOL | ||||
IS_ONLY4MEAS | Settlement Unit Data Record for Retrieval of Measurement | RESCISONLY4MEAS | CHAR | 1 | RECABOOL | ||||
IS_ONLY4OPTRATE | Settlement Unit Data Record for Retrieving Option Rate | RESCISONLY4OPTRATE | CHAR | 1 | RECABOOL | ||||
IS_ROOT_SU | Is Root Settlement Unit | RESCISROOTSU | CHAR | 1 | RECABOOL | ||||
IS_RESTOBJ | Object Is Remainder Object | RESCISRESTOBJ | CHAR | 1 | RECABOOL | ||||
REASONFORENTRY | Reason for Entry | RESCREASONFORENTRY | CHAR | 3 | RESCREASONFORENTRY | ||||
PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | RECAGUID |
Key field | Non-key field |
How do I retrieve data from SAP table VISCS_SU_SUM using ABAP code
The following ABAP code Example will allow you to do a basic selection on VISCS_SU_SUM to SELECT all data from the tableDATA: WA_VISCS_SU_SUM TYPE VISCS_SU_SUM.
SELECT SINGLE *
FROM VISCS_SU_SUM
INTO CORRESPONDING FIELDS OF WA_VISCS_SU_SUM
WHERE...
How to access SAP table VISCS_SU_SUM
Within an ECC or HANA version of SAP you can also view further information about VISCS_SU_SUM 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