AVISRCALCSUM SAP (Change Doc.Structure for Calculation Results per Sales Rule) Structure details
Description: Change Doc.Structure for Calculation Results per Sales Rule
Structure field list including key, data, relationships and ABAP select examples
AVISRCALCSUM 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 Doc.Structure for Calculation Results per Sales Rule" 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_AVISRCALCSUM TYPE AVISRCALCSUM.
The AVISRCALCSUM table consists of various fields, each holding specific information or linking keys about Change Doc.Structure for Calculation Results per Sales Rule data available in SAP. These include MANDT (Client), OBJGUID (Reference Within Results Tables), INTRENO (Internal Key of Real Estate Object), TERMTYPE (Term Category).. 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 AVISRCALCSUM 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 | |||
OBJGUID | Reference Within Results Tables | RESRSBRESULTGUID | RAW | 16 | VISRSTATUS | RECAGUID | |||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
TERMTYPE | Term Category | RETMTERMTYPE | CHAR | 4 | TIVTMTERMTYPE | RETMTERMTYPE | |||
TERMNO | Term Number | RETMTERMNO | CHAR | 4 | VITMTERM | ALPHA | RETMTERMNO | ||
RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | CHAR | 4 | ALPHA | RESRRHYTHMTYPE | |||
PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | RECADATEBEG | ||||
PTO | Period End Date | RECAPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
VERSION | Version of Calculation | RESRCLVERSION | CHAR | 3 | RESRVERSION | ||||
PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | VICAPROCESSID | RECAGUID | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | TIVCDCONDTYPE | ALPHA | RECDCONDTYPE | ||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
CREDITPAYBACK | Credits Withing Cumulative Settlement Are Paid | RESRCREDITPAYBACK | CHAR | 1 | RECABOOL | ||||
SALESCURR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TERMNOPY | Term Number of Posting Rule | RERATMPYTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | TIVRATAXTYPE | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | TIVRATAXGROUP | RERATAXGROUP | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TAXDATE | Date for defining tax rates | TXDAT | DATS | 8 | DATUM | ||||
SALESRENTNET | Net Amount of Sales-Based Rent | RESRSALESRENTNET | CURR | 15(2) | RECACURR | ||||
SALESRENTTAX | Tax Amount of Sales-Based Rent | RESRSALESRENTTAX | CURR | 15(2) | RECACURR | ||||
ADVPAYNET | Net Amount of Advanced Payment | RERAADVPAYNET | CURR | 15(2) | RECACURR | ||||
ADVPAYTAX | Tax Amount of Advance Payment | RERAADVPAYTAX | CURR | 15(2) | RECACURR | ||||
PAYNET | Net Amount of Payments Already Made | RESRPAYNET | CURR | 15(2) | RECACURR | ||||
PAYTAX | Tax Amount from Payments Already Made | RESRPAYTAX | CURR | 15(2) | RECACURR | ||||
MINRENTNET | Net Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTNET | CURR | 15(2) | RECACURR | ||||
MINRENTTAX | Tax Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTTAX | CURR | 15(2) | RECACURR | ||||
MAXRENTNET | Net Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTNET | CURR | 15(2) | RECACURR | ||||
MAXRENTTAX | Tax Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTTAX | CURR | 15(2) | RECACURR | ||||
RECEIVABLENET | Net Amount of Receivable | RESRRECEIVENET | CURR | 15(2) | RECACURR | ||||
RECEIVABLETAX | Tax Amount of Receivable | RESRRECEIVETAX | CURR | 15(2) | RECACURR | ||||
BALANCENET | Net Amount of Balance | RESRBALANCENET | CURR | 15(2) | RECACURR | ||||
BALANCETAX | Tax Amount of Balance | RESRBALANCETAX | CURR | 15(2) | RECACURR | ||||
PREVBALANCENET | Net Amount of Balance from Prior Settlement | RESRPREVBALANCENET | CURR | 15(2) | RECACURR | ||||
PREVBALANCETAX | Tax Amount of Balance from Prior Settlement | RESRPREVBALANCETAX | CURR | 15(2) | RECACURR | ||||
PREVPAYNET | Net Amount of Payment from Previous Period | RESRPREVPAYNET | CURR | 15(2) | RECACURR | ||||
PREVPAYTAX | Tax Amount of Payment from Previous Period | RESRPREVPAYTAX | CURR | 15(2) | RECACURR | ||||
PREVADVPAYNET | Net Amount of Advance Payments from Previous Period | RESRPREVADVPAYNET | CURR | 15(2) | RECACURR | ||||
PREVADVPAYTAX | Tax Amount of Advance Payments from Previous Period | RESRPREVADVPAYTAX | CURR | 15(2) | RECACURR | ||||
PREVMINRENTNET | Net Amount of Minimum Rent from Previous Period | RESRPREVMINRENTNET | CURR | 15(2) | RECACURR | ||||
PREVMINRENTTAX | Tax Amount of Minimum Rent from Previous Period | RESRPREVMINRENTTAX | CURR | 15(2) | RECACURR | ||||
PREVMAXRENTNET | Net Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTNET | CURR | 15(2) | RECACURR | ||||
PREVMAXRENTTAX | Tax Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTTAX | CURR | 15(2) | RECACURR | ||||
ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | RECABOOL | ||||
INFOCOND | Statistical or Informational Condition | RECDINFOCOND | CHAR | 1 | RECABOOL | ||||
ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | RECABOOL | ||||
CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCCURRKEY | Local Currency | RECACTLCCURRKEY | CUKY | 5 | Assigned to domain | WAERS | |||
CTRULE | Currency Translation Rule | RECACTRULE | CHAR | 20 | Assigned to domain | RECACTRULE | |||
CTRATE | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTLCPOST | Post in Local Currency | RECACTLCPOST | CHAR | 1 | RECABOOL | ||||
POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | RECABOOL | ||||
CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | RECAGUID | ||||
USECF4POST | Use Periodic Posting Run for Posting | RESRUSECF4POST | CHAR | 1 | RECABOOL | ||||
BASICFEENET | Net Amount of Base Fee | RESRBASICFEENET | CURR | 15(2) | RECACURR | ||||
BASICFEETAX | Tax Amount of Base Fee | RESRBASICFEETAX | CURR | 15(2) | RECACURR | ||||
PREVBASICFEENET | Net Amount of Base Fee from Previous Period | RESRPREVBASICFEENET | CURR | 15(2) | RECACURR | ||||
PREVBASICFEETAX | Tax Amount of Base Fee from Previous Period | RESRPREVBASICFEETAX | CURR | 15(2) | RECACURR | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
Key field | Non-key field |
How do I retrieve data from SAP structure AVISRCALCSUM using ABAP code?
As AVISRCALCSUM 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 AVISRCALCSUM as there is no data to select.How to access SAP table AVISRCALCSUM
Within an ECC or HANA version of SAP you can also view further information about AVISRCALCSUM 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