Skip to Content
avatar image
Former Member

Doubt in Report generated at epdev/irj/portal

Hi,

I would be thankful if anyone can help in knowing that what are the ECC tables ( how to know that from which table the data has been taken) from where the data has been pulled to develop SAP BW report and hence generate it on epdev/irj/portal. For details please refer the below screen shot of one of the reports generated in the epdev/irj/portal.

Thanks and Regards

Ranendra

2.JPG (44.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 05, 2015 at 06:17 AM

    Hi Ranendra,

    This report screenshot seems to be Purchase Requisition Details and you can refer the tables,

    EBAN and EKBN.

    Also check out the flow..as to cube->DSO->DS and this DS refers to which table.

    Rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 06:20 AM

    Hi Ranendra,

    This report screenshot seems to be Purchase Requisition Details and you can refer the tables,

    EBAN and EKBN.

    Also check out the flow..as to cube->DSO->DS and this DS refers to which table.

    Rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ranendra,

      I assume you have access to RSA1.

      From Query ..goto the infopovider in the Query Designer.

      In BW system, Pass that Infoprovider in RSA1..and then drilldown on the flow till PSA/DS or Right click on the MP and display dataflow...this will give the entire Dataflow.

      In ECC , you can check the data in LBWE or as we know that its related to Purchase Requisition..the tables for that are known..if you its Sales Related data then the Tables are VBAK/VBAP/VBRK..etc..

      So Purchase Req tables are EKBN and EBAN...

      rgds

      SVU

  • avatar image
    Former Member
    Jan 05, 2015 at 06:47 AM

    click on the multiprovider and select from context menu:
    right click---> dataflow--> both downward and upward
    see which datasources are bringing the data
    and then check which tables the datasources are accessing.


    If LO datasources you can directly go to source system (if ECC) go to Tcode  LBWE and click maintenance and see for yourself the tables and table fields in the selection list of the datasources.

    Add comment
    10|10000 characters needed characters exceeded