SAP ABAP Table VISRCALCSUM (Calculation Results per Sales Rule)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-SR (Application Component) Sales-Based Rent and Settlement
     ⤷ RE_SR_CL (Package) RE: Calculation

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VISRCALCSUM	Table Relationship Diagram
Short Description	Calculation Results per Sales Rule

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	OBJGUID	☑	RESRSBRESULTGUID	RECAGUID	RAW	16	0	Reference Within Results Tables	VISRSTATUS
3	.INCLUDE	☐				0	0	Key Fields of Table VISRCALCSUM
4	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
5	TERMTYPE	☐	RETMTERMTYPE	RETMTERMTYPE	CHAR	4	0	Term Category	TIVTMTERMTYPE
6	TERMNO	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number	VITMTERM
7	RHYTHMTYPE	☐	RESRRHYTHMTYPE	RESRRHYTHMTYPE	CHAR	4	0	Type of Frequency
8	PFROM	☐	RECAPERIODFROM	RECADATEBEG	DATS	8	0	Period Start Date
9	PTO	☐	RECAPERIODTO	RECADATEEND	DATS	8	0	Period End Date
10	VERSION	☐	RESRCLVERSION	RESRVERSION	CHAR	3	0	Version of Calculation
11	.INCLUDE	☐				0	0	Non-Key Fields of Table VISRCALCSUM
12	PROCESSGUID	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process	VICAPROCESSID
13	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
14	PARTNEROBJNR	☐	RETMPARTNEROBJNR	J_OBJNR	CHAR	22	0	Object Number for Internal Use	*
15	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
16	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
17	CREDITPAYBACK	☐	RESRCREDITPAYBACK	RECABOOL	CHAR	1	0	Credits Withing Cumulative Settlement Are Paid
18	SALESCURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	TERMNOPY	☐	RERATMPYTERMNO	RETMTERMNO	CHAR	4	0	Term Number of Posting Rule
20	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
21	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
22	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
23	TAXDATE	☐	TXDAT	DATUM	DATS	8	0	Date for defining tax rates
24	SALESRENTNET	☐	RESRSALESRENTNET	RECACURR	CURR	15	2	Net Amount of Sales-Based Rent
25	SALESRENTTAX	☐	RESRSALESRENTTAX	RECACURR	CURR	15	2	Tax Amount of Sales-Based Rent
26	ADVPAYNET	☐	RERAADVPAYNET	RECACURR	CURR	15	2	Net Amount of Advanced Payment
27	ADVPAYTAX	☐	RERAADVPAYTAX	RECACURR	CURR	15	2	Tax Amount of Advance Payment
28	PAYNET	☐	RESRPAYNET	RECACURR	CURR	15	2	Net Amount of Payments Already Made
29	PAYTAX	☐	RESRPAYTAX	RECACURR	CURR	15	2	Tax Amount from Payments Already Made
30	MINRENTNET	☐	RESRMINRENTNET	RECACURR	CURR	15	2	Net Amount of Minimum Rent for Sales-Based Rent Contracts
31	MINRENTTAX	☐	RESRMINRENTTAX	RECACURR	CURR	15	2	Tax Amount of Minimum Rent for Sales-Based Rent Contracts
32	MAXRENTNET	☐	RESRMAXRENTNET	RECACURR	CURR	15	2	Net Amount of Maximum Rent for Sales-Based Rent Contracts
33	MAXRENTTAX	☐	RESRMAXRENTTAX	RECACURR	CURR	15	2	Tax Amount of Maximum Rent for Sales-Based Rent Contracts
34	RECEIVABLENET	☐	RESRRECEIVENET	RECACURR	CURR	15	2	Net Amount of Receivable
35	RECEIVABLETAX	☐	RESRRECEIVETAX	RECACURR	CURR	15	2	Tax Amount of Receivable
36	BALANCENET	☐	RESRBALANCENET	RECACURR	CURR	15	2	Net Amount of Balance
37	BALANCETAX	☐	RESRBALANCETAX	RECACURR	CURR	15	2	Tax Amount of Balance
38	PREVBALANCENET	☐	RESRPREVBALANCENET	RECACURR	CURR	15	2	Net Amount of Balance from Prior Settlement
39	PREVBALANCETAX	☐	RESRPREVBALANCETAX	RECACURR	CURR	15	2	Tax Amount of Balance from Prior Settlement
40	PREVPAYNET	☐	RESRPREVPAYNET	RECACURR	CURR	15	2	Net Amount of Payment from Previous Period
41	PREVPAYTAX	☐	RESRPREVPAYTAX	RECACURR	CURR	15	2	Tax Amount of Payment from Previous Period
42	PREVADVPAYNET	☐	RESRPREVADVPAYNET	RECACURR	CURR	15	2	Net Amount of Advance Payments from Previous Period
43	PREVADVPAYTAX	☐	RESRPREVADVPAYTAX	RECACURR	CURR	15	2	Tax Amount of Advance Payments from Previous Period
44	PREVMINRENTNET	☐	RESRPREVMINRENTNET	RECACURR	CURR	15	2	Net Amount of Minimum Rent from Previous Period
45	PREVMINRENTTAX	☐	RESRPREVMINRENTTAX	RECACURR	CURR	15	2	Tax Amount of Minimum Rent from Previous Period
46	PREVMAXRENTNET	☐	RESRPREVMAXRENTNET	RECACURR	CURR	15	2	Net Amount of Maximum Rent from Previous Period
47	PREVMAXRENTTAX	☐	RESRPREVMAXRENTTAX	RECACURR	CURR	15	2	Tax Amount of Maximum Rent from Previous Period
48	ISCDSPLIT	☐	RETMISCDSPLIT	RECABOOL	CHAR	1	0	Condition Split
49	INFOCOND	☐	RECDINFOCOND	RECABOOL	CHAR	1	0	Statistical or Informational Condition
50	ISGROSS	☐	RECDISGROSS	RECABOOL	CHAR	1	0	Condition Amount Is Gross Amount
51	CTLCGROSSAMOUNT	☐	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
52	CTLCNETAMOUNT	☐	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
53	CTLCTAXAMOUNT	☐	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
54	CTLCCURRKEY	☐	RECACTLCCURRKEY	WAERS	CUKY	5	0	Local Currency	*
55	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
56	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
57	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
58	CTLCPOST	☐	RECACTLCPOST	RECABOOL	CHAR	1	0	Post in Local Currency
59	POSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
60	CONDGUID	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
61	USECF4POST	☐	RESRUSECF4POST	RECABOOL	CHAR	1	0	Use Periodic Posting Run for Posting
62	BASICFEENET	☐	RESRBASICFEENET	RECACURR	CURR	15	2	Net Amount of Base Fee
63	BASICFEETAX	☐	RESRBASICFEETAX	RECACURR	CURR	15	2	Tax Amount of Base Fee
64	PREVBASICFEENET	☐	RESRPREVBASICFEENET	RECACURR	CURR	15	2	Net Amount of Base Fee from Previous Period
65	PREVBASICFEETAX	☐	RESRPREVBASICFEETAX	RECACURR	CURR	15	2	Tax Amount of Base Fee from Previous Period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VISRCALCSUM	CONDTYPE	TIVCDCONDTYPE	CONDTYPE
2	VISRCALCSUM	FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE
3	VISRCALCSUM	OBJGUID	VISRSTATUS	OBJGUID		1	C
4	VISRCALCSUM	TAXGROUP	TIVRATAXGROUP	TAXGROUP
5	VISRCALCSUM	TAXTYPE	TIVRATAXTYPE	TAXTYPE
6	VISRCALCSUM	TERMNO	VITMTERM	INTRENO		1	CN
7	VISRCALCSUM	TERMTYPE	TIVTMTERMTYPE	TERMTYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in	200