cancel
Showing results for 
Search instead for 
Did you mean: 

Revenue recognition report

Former Member
0 Kudos

Hi SAP gurus,

I am developing a deferred revenue report in revenue recognition. Can any one please explain the best process to capture the data from relevant tables?

Thanks,

Raj

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Using trx SARP (with SD01) you can select any available report.

This is a full report catalogue.

Regards

Gabriel

Former Member
0 Kudos

Hi

Try to create a SQVI query for this, where you can join the tables and get all the Information at once.

Pull the required fields from the Tables like VBAK, VBRK, VBRP, KNA1, LIKP, TVRO as per your requirements.

You can also export the Report that you get in an ALV form to an excel sheet later on.

You might want to also take help from an ABAPer for this.

Best Regards

Former Member
0 Kudos

Hi

There was 1 report required for our customer to see deffered revenues , i have given following functional requirements.

Tables and fields used in our report.

u2022 VBERVE u2013 BDJPOPER, PRCTR, GSBER, VBELN_N, WRBTR, SAKRV, WRBTR, BELNR.

u2022 VBAKu2013 KUNNR.

u2022 VBAP u2013 VBELN, MATNR, ARKTX, POSNR, PSTYV, NETPR, PS_PSP_PNR,

u2022 KNA1- Name1, ADRNR.

u2022 ADRC- COUNTRY, REGION.

u2022 BKPF u2013 AWKEY, HWAER, HWAE2, BUKRS.

u2022 LIPS - LFIMG, VBELN

Step 1:

u2022 From table VBREVE, get all sales order nos. (VBREVE- VBELN) where the subsequent document category VBREVE- VBTYP_N = u2018Ju2019.

u2022 VBERVE u2013 BDJPOPER, PRCTR, GSBER, VBELN_N, WRBTR, SAKRV, WRBTR, BELNR.

Step 2:

u2022 With VBREVE-VBELN, go to VBAP where VBREVE-VBELN = VBAP-VBELN

u2022 Get all sales order line items VBELN, MATNR, ARKTX, POSNR, PSTYV, NETPR, PS_PSP_PNR, and VBELN_N from VBAP.

.

Step 3: Concatenate SAMMG & REFFLD in VBREVE and put in BKPF-AWKEY join BKPF.

Step 4: Currency key

Document curr = bkpf-waers.

local curr = bkpf-hwaer.

group curr = bkpf-hwae2.

Step 5: Exchange rate

lexch = bkpf-kursf. (local currency)

gexch = bkpf-kurs2. (group currency)

Amount

VBREVE-WRBTR = amount in doc currency

damount = amount in doc currency

lamount = amount in local currency

gamount = amount in group currency.

Account = g/l account.

damount = -1 * vbreve-wrbtr.

IF lexch LT 0.

lexch = -1 * lexch.

lamount = damount / lexch.

ELSEIF lexch IS INITIAL.

lamount = damount.

ELSE.

lamount = damount * lexch.

ENDIF.

IF gexch LT 0.

gexch = -1 * gexch.

gamount = lamount / gexch.

ELSEIF gexch IS INITIAL.

gamount = lamount.

ELSE.

gamount = lamount * gexch.

ENDIF.

account = vbreve-sakrv.

Step 6: Get KUNNR from VBAK.

Step 7: Join KNA1 and VBAK to get customer name Name1 with KUNNR.

Step 8: Join KNA1 table with ADRC to get country and region with joining column ADNR.

Step 9: Join LIPS table with VBELN to get LFIMG for delivered Qty

I have pasted FS document prepared by me for this report, hope this helps u.

Former Member
0 Kudos

Hi,

Check std report VF45.

Also check FM's in this [thread|;

Regards,

Amit