cancel
Showing results for 
Search instead for 
Did you mean: 

Automatically Generate a Purchase Order using the results of a SQL Query

0 Kudos

Good Afternoon Experts,

My SAP knowledge is growing thanks to this great forum however this one is beating me.

I want a button on the BP that runs an SQL Query and then automatically puts the results onto a PO for that business partner.

I believe it can be done, or i think it should be able to be done, by a macro :-! but i'm lost.

Grateful and thankful in advance for any help!

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi Laurent,

Apologies, you've just confused me! (Not sure what classic scenario is).

I have a SQL query that returns a list of products based on stock levels, I then want to put the results of this query directly onto a PO automatically. I think it may be possible using a Macro with @Store and Transfer but I don't know how. I can then assign this to a Button on the BP

I will then review this on the PO and send to the supplier manually.

Regards,

Simon

laurent_burtaire
Active Contributor
0 Kudos

Hello Simon,

still do not understand your request.

Sending a PO to a supplier means a Requester ask to a vendor to provide him items: either those items are available (at supplier side) or not.

Stock you are talking about seem to be at Company level (the one making the purchase).

It seems you want to reinvent the MRP and the Stock Transfer...

I advise you to challenge your functional consultant.

Regards.

Laurent.

0 Kudos

Hi Laurent,

Thanks for your reply.

It's a functional requirement - raising daily Purchase Orders automatically from SQL script results.

It would be against a supplier BP - to then raise the PO to them.

Thanks

laurent_burtaire
Active Contributor
0 Kudos

Hello Simon,

do not understand your request.Sending PO to Supplier is a standard process in SRM for an Extended Classic Scenario.

In Classic Scenario, PO output is managed in ECC.

Regards.

Laurent.

laurent_burtaire
Active Contributor
0 Kudos

Hello,

what is your need: is it a technical one or a functional one?

Which kind of Business Partner are you talking about: Requester, Goods Recipient, Supplier...?

In which SRM transaction you would like to have this functionality?

Regards.

Laurent.