AVISCS_SU_SUM SAP (Change Document Struct. Sum of All Costs and Meas. Amounts) Structure details
Dictionary Type: Structure
Description: Change Document Struct. Sum of All Costs and Meas. Amounts
Description: Change Document Struct. Sum of All Costs and Meas. Amounts
ABAP Code to SELECT data from AVISCS_SU_SUM
Related tables to AVISCS_SU_SUM
Access table AVISCS_SU_SUM
Related tables to AVISCS_SU_SUM
Access table AVISCS_SU_SUM
Structure field list including key, data, relationships and ABAP select examples
AVISCS_SU_SUM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Document Struct. Sum of All Costs and Meas. Amounts" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_AVISCS_SU_SUM TYPE AVISCS_SU_SUM.
The AVISCS_SU_SUM table consists of various fields, each holding specific information or linking keys about Change Document Struct. Sum of All Costs and Meas. Amounts data available in SAP. These include MANDT (Client), SCS_SU_GUID (SU within SCS, for a Period and Measurement Type), SETTL_GUID (Unique Key of Settlement), OBJTYPE (Object Type).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AVISCS_SU_SUM structure 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 | ||||
| KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
| Key field | Non-key field |
How do I retrieve data from SAP structure AVISCS_SU_SUM using ABAP code?
As AVISCS_SU_SUM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AVISCS_SU_SUM as there is no data to select.How to access SAP table AVISCS_SU_SUM
Within an ECC or HANA version of SAP you can also view further information about AVISCS_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