on 09-09-2009 6:32 AM
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
Hi
Using trx SARP (with SD01) you can select any available report.
This is a full report catalogue.
Regards
Gabriel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.