Skip to Content
avatar image
Former Member

Datasource for PS tables

Hi All,

I have a requirement to read data based on below combination of fields which user is using SQ01 to generate their report in ECC side.

PROJ - SPSNR (Project Number)

PRPS - RSPNR(WBS Number)

RESB - RSNUM (Reservation Number)

MARA - MATNR (Material number)

RESB - BDMNG (Required quantity outstanding)

RESB - BDTER (Requirement date)

Can anybody advise the transactional datasource if any. if not please advise the relationship among the tables so that i'll go for generic data source. I prefer to use delta.

Once I load above data loading, I might need to combine with PO item data which is based on 2lis_02_item.

Regards

Smitha

Add comment
10|10000 characters needed characters exceeded

  • Thank you for coming to the SAP Community for answers. Before posting a question, however, please make sure you have searched all existing content -- as the answers may already be available.

    You can learn more in our official rules of engagement:http://www.sap.com/community/about/rules-of-engagement.html

    You can also get tips here:http://www.sap.com/community/about/questions-and-answers.html

    If you have searched for answers already, then apologies for making this request. To be safe, please make sure that your question outlines the steps you took to find information and create the question again. This way members will know that you searched and were unable to find what you needed.

    You may also want to include screenshots of what you're seeing, to help members further understand the issue. And provide some additional details, as the question is fairly short.

  • Get RSS Feed

2 Answers

  • Apr 13, 2017 at 09:49 AM

    Hi

    You can check the details of SAP delivered datasources for PS at the following link:

    https://help.sap.com/saphelp_nw75/helpdata/en/48/028653aa9a6159e10000000a174cb4/frameset.htm

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2017 at 09:56 AM

    Hi Smitha,

    If your user is already using SQ01 report. Then take the help abaper and copy program which generated in SQ01 for the respective report and create function module of it and create generic datasource using function module.

    Thanking you

    Vengaiah

    Add comment
    10|10000 characters needed characters exceeded