Solved: reporting scenarios

Former Member · ‎11-29-2007

Hello gurus

can anyone plz send me some reports scenario in bw taking the modules SD, MM, FI & CO, say for example what kind of general reports will have taking the mentioned modules in BW

points rewaraded

thanks in advance

Former Member · ‎11-30-2007

Hi ,

Check the below link for FI-GL Queries and extractor:

http://help.sap.com/saphelp_nw04/helpdata/en/53/dd153c4eb5d82ce10000000a114084/content.htm

In the same way you can check BI Content for each application:

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/content.htm

Find below some of FI(AP) queries....

1.Accounts Receivable: Payment History -0FIAR_C05_Q0001

2.Accounts Receivable: Overdue Analysis -0FIAR_C03_Q0005

3.Accounts Receivable: Days Agreed / Days Taken -0FIAR_C03_Q0001

you can find some queries in help.sap.com

I don;t remember the queries used for other modules...you can refer the below link and identify the queries most usefull for your requirements...

help.sap.com/bw

Check these links on SD:This PDF is really helpful:

https://websmp104.sap-ag.de/~sapidb/011000358700002719062002E/EXTRSDTRANSDATA_new1.pdf

http://help.sap.com/saphelp_nw04/helpdata/en/09/a7b339688d2453e10000000a114084/frameset.htm

http://help.sap.com/bp_biv235/BI_EN/index.htm

http://help.sap.com/saphelp_nw04/helpdata/en/09/a7b339688d2453e10000000a114084/frameset.htm

BW-MM:

Refer this link:

http://help.sap.com/saphelp_nw04/helpdata/en/96/df293581dc1f79e10000009b38f889/frameset.htm

Some FI reports:

http://help.sap.com/saphelp_nw04/helpdata/en/2d/955a73da4d6d41a0a6128caf274ce8/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/37/ff4bcf4d306244be0be5f0345fd0d9/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9d/5d789265d211d3971c006094b969cf/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/6a/9a6f3b49992f60e10000000a11402f/content.htm

Some MM reports:

http://help.sap.com/saphelp_nw04/helpdata/en/fd/e2b3bc39614e46b74264137105bea4/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/87/ef4528f0c17945a23fabb82ded095d/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/7d/f07037a2cb2473e10000009b38f8cf/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/42/5959394ddcdd46bc73ea9b58930a4e/content.htm

Sales and Distribution

http://help.sap.com/saphelp_nw04/helpdata/en/04/47a46e4e81ab4281bfb3bbd14825ca/frameset.htm

CRM

http://help.sap.com/saphelp_nw04/helpdata/en/04/47a46e4e81ab4281bfb3bbd14825ca/frameset.htm

http://help.sap.com/bp_biv235/BI_EN/html/bw.htm

http://help.sap.com/bp_biv135/html/BW/SalesAnalysis.htm

http://help.sap.com/bp_biv235/BI_EN/index.htm

Check this for MM-

http://help.sap.com/saphelp_nw04/helpdata/en/e9/62073c44564d59e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e1/0047bdedc730418885794128115f10/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/aa/8212962f2f934bba74b4eb811cdcc1/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/37/bfac83849ab54fa97208b3a4b7a192/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ea/bc6f3b22980b5fe10000000a11402f/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cb/e11540bf1af72ee10000000a1550b0/frameset.htm

Former Member · ‎12-01-2007

Hi,

This is a generic question, anyways check out the example quoted and the links provided..

You records sales related transactions in R/3 ( such as order, invoices, billing, dues, receivables , etc) and you extract this data from R/3 and store them in BW.

IN BW you hold this data in a data target for reporting. In Bex, depending on how the cube is designed, you can write reports .

If you have specific questions then let us know...

You can also refer the following threads for more information:

http://help.sap.com/saphelp_nw04s/helpdata/en/26/cde241aa8e9d39e10000000a155106/frameset.htm

And also for more on Reporting go thru:

bex query designer, web reporting to mobile bi etc ...

http://help.sap.com/saphelp_bw33/helpdata/en/5b/30d43b0527a17be10000000a114084/content.htm

http://help.sap.com/saphelp_bw33/helpdata/en/a2/06a83a4bd5a27ae10000000a11402f/frameset.htm

also there is 'bw reporting made easy' book/cd

http://www.amazon.com/gp/product/1893570665/102-9958356-5476147?v=glance&n=283155

web reporting, javascript etc

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/13dc9190-0201-0010-71a4-a9f...