2007 Sep 26 9:18 PM
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
2007 Oct 01 4:02 PM
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
2009 Oct 08 4:57 AM
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
2010 Jun 07 4:06 PM
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
2021 Feb 26 6:22 PM
Please, read my Blog post on said topic.. I hope it will help.