Datasource for PS tables

[Former Member]

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

[former_member28818]

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.

[former_member388328]

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

[former_member206568]

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!