cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to copy Data from Excel sheet to SAP

Former Member
0 Kudos

Hi Experts,

Usually, I do create Purchase order for 100 line items repeatedly.

So I maintain all Part Numbers,Qty.... for all 100 line items in Excel sheet, so that when i create purchase order, I will copy from excel sheet and just paste to avoid manual entries (to save time).

It was working fine till last week.

This week, when i tried to copy... it is copying only the first (part number ) line item instead of all part numbers.

Though it is not related with SAP, if anybody has faced such problem, Please suggest me with ur inputs..

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

It's a normal functionality, it seems that the excel entries are not copied.

First copy the entries in excel and paste in another excel sheet & check..

then check in ME21N

Thx

Raju

Former Member
0 Kudos

I tried your suggestion. It didn't work out.

Please help..

former_member201758
Contributor
0 Kudos

Hi,

Please look into "excel in place" functionality. I did not worked on this. But you can do it. Please read note 548409 too.

Otherwise I would recommed BAPI in this case.

Sanjeev

Former Member
0 Kudos

hi,

Why do not you copy previous purchsae order thru SAP?

This is standard way.

Regards

Kedar

Former Member
0 Kudos

I can copy from earlier PO, if I am going to create similar PO

Suppose if I am creating new PO for more than 500 items, it is always better to copy (ctrl c) part numbers and paste it (ctrl v) in SAP, to save time

But my question is, why I am not able to copy from excel sheet to SAP all of a sudden..? Is there any seetings missed out..?