Deferred Revenue for student accounting

[Former Member]

Hi to all

We are trying to implement the deferred revenue functionality for FICA so we can recognize revenue each month that the students fees expire. I have been reading and I understood that this functionality is related to a user exit.

Does anyone have documentation of this issue? I can not find it anywhere.

Have anyone done this before that could help me?

Thank you very much

Sergio Artiñano

[Former Member]

Hi, again I have found the answer for my question and I wanted to publish it, in case someone finds him self in the same situation.

You have to go to FQEVENTS and search for th event 1140, In there you have to create a Zfkk_event_1140 and insert abap coding and make it active. Besides this you have to configure posting area PC05

After this all the fee calculation documents will have the option of deferred revenue. And the transaction FPDR can be used.

THIS IS THE CODING WE ARE GOING TO USE

function z_fkk_event_1140_by_month.

*"----

---

""Interfase local

*" IMPORTING

*" REFERENCE(I_FKKKO) TYPE FKKKO

*" TABLES

*" IT_FKKOP STRUCTURE FKKOP

*" IT_FKKOPK STRUCTURE FKKOPK

*" ET_FKKDEFREV_DATES STRUCTURE FKKDEFREV_DATES

*"----

---

***********************************************************************

• Neo Consulting : 03/JUL/2006. *

• *

• Programmer name : Unknown *

• *

• developement Ref : *

• *

• SAP Module : FI-CA *

• *

• Description : Deferred values determined from Fee *

• calculation. *

• *

***********************************************************************

***********************************************************************

• REPAIRS *

• ------- *

• Name Correction Description Trace *

• Alfonso Ventura DCDK902263 AVS0001+ *

• Correct data collection *

• of previous business *

• partners. *

***********************************************************************

tables tfk033d.

data: h_betrw like fkkop-betrw,

h_diff like fkkop-betrw,

h_date like fkkop-faedn,

h_tfk033d like tfk033d,

h_applk like fkkop-applk,

v_count type i,

v_stobjid like cmacbpst-stobjid, " Student ID.

e_st_info like piq_student_info. " Student info for fee calc.

refresh et_fkkdefrev_dates. " AVS001+

clear v_count.

loop at it_fkkop.

clear et_fkkdefrev_dates.

v_count = v_count + 1.

on change of it_fkkop-vtref.

• Determine initial date (posting date of the current document).

• h_date = i_fkkko-budat.

endon.

• In order to determine the G/L account line item, the following data is

• required:

• Application Area

• Posting Area

• Chart of Accounts

• Student Group

• Student Fee Category

• Get Applicaton Area.

call function 'FKK_GET_APPLICATION'

importing

e_applk = h_applk

exceptions

no_appl_selected = 1

others = 2.

if sy-subrc <> 0.

• It is not possible to determine deferred values.

exit.

endif.

• Get chart of accounts.

perform bukrsdata_read using it_fkkop-bukrs.

• Get related G/L account

read table it_fkkopk with key psgrp = it_fkkop-psgrp.

if sy-subrc ne 0.

exit.

endif.

• Verify that the account can be determined for posting area PC05.

select * up to 1 rows

from tfk033d

where applk = h_applk

and buber = 'PC05'

and ktopl = t001-ktopl

and fun01 = it_fkkopk-hkont.

endselect.

if sy-subrc ne 0.

exit.

endif.

• Net Due Date is used as a basis for the date calculation.

h_date = it_fkkop-faedn.

• Use day 1 of the net due month/year.

h_date+6(02) = '01'.

• Deferred value date cannot be lower than posting date in original document.

if h_date < i_fkkko-budat.

h_date = i_fkkko-budat.

endif.

et_fkkdefrev_dates-opupk = it_fkkopk-opupk.

• et_fkkdefrev_dates-opupk = it_fkkop-opupk.

et_fkkdefrev_dates-pdate = h_date.

et_fkkdefrev_dates-betrw = it_fkkop-betrw * -1.

et_fkkdefrev_dates-waers = i_fkkko-waers.

• ADD et_fkkdefrev_dates-betrw TO h_betrw.

• append et_fkkdefrev_dates.

collect et_fkkdefrev_dates.

• ADD 30 TO h_date.

endloop.

endfunction.

Message was edited by:

Alvaro Rivero Morales

[Former Member]

Hi

I am having an issue posting the deferred revenue for student bookings (SLCM)

I have activated the event and inserted the correct code and maintainted the posting area (PC05) however the event 1140 is not called when the fee calculation is run

Any suggestions on how to check what Event is being called when the document is created ?

Regards

Simon

[Former Member]

Alvaro, Simon, can you give more details on how you built the deferred revenues?, I mean for example customizig of posting are P001 is directed to th final revenue account? or to the defered revenue account? the same for posting ara PC05 here yo enter the final revenue account or the deferred revenue account?

Best regards.

Edited by: BPX PARTNERS on Jun 7, 2010 6:11 PM

[muhammadfahad_raza]

Please, read my Blog post on said topic.. I hope it will help.

https://blogs.sap.com/2021/02/26/time-based-deferred-revenue-postings-sap-contract-accounts-receivab...