How to automate purchase requisition creation without script recording playback ?

[bipulkumar4]

Hi

I would like to automate PR ( Purchase Requisition ) using excel sheet. Without the help of *Script Recording and Playback..* I would be thankful if somebody suggest how to achieve this.

Thank you

Bipul kumar

[ImreMatyas]

Dear Bipul Kumar,

SAP MM does not have an entirely automated process for uploading excel file as-is. (In SRM, there is a functionality for this.)

On the other hand,

1. in t-code ME59n we process Purchase Requisitions to PO's in case some pre-settings are done: material + contract should be flagged as "automatic PO creation". See our Wiki: ME59n - troubleshooting guide

2. During migration projects we also use LTMC, which is a semi-automated process >> might be that You could customize such process to Your requirements.

3. In your case, however, it seems the most suitable would be an entire Z-t-code. That should be developed requiring heavy ABAP skills.

In that Z t-code You could have an input field asking for an excel file to upload >> then a subroutine: mapping Your input fields into BAPI format >> at last you should LOOP over the PO 's and call the BAPI function BAPI_PO_CREATE1 + subsequently the BAPI_TRANSACTION_COMMIT. For error handling , a rollback functionality should also exist, like BAPI_TRANSACTION_ROLLBACK.

4. You might also check other threads like https://answers.sap.com/questions/8365727/po-creation-from-excel-file.html

Hope I could help You to take a step forward to Your solution...

BR,

Imre