Upload data from Excel file to SOP using t-code MCSZ .

[former_member416443]

Hello.

I have following problem. I want to upload data from Excel file to SOP.

I know that it can be done using enhancement RMCAF000 and function module EXIT_RMCAF000_001 and include ZXMCDU01.

In include ZXMCDU01 i set BREAK-POINT.

Using transaction MCSZ i try to run this functionality but i can't activate pushbutton "External data".

User Exit is activated but BREAK-POINT is not reached.

What i should do, to import data from Excel file in following format:

material; plant ; version ; period ; sales qty;

I want to import this data to the table S076 - Sales & Operations Planning

In transaction MCSZ i can only choose the source info structure, but i don't see field with name "Path for Excel file"

Could anybody help me?

Regards

Bogdan

[Former Member]

I had "extremely" big problems getting this working a few years ago.  I don't have any documentation available for you.  But since you know about "breakpoints" then put the breakpoint where the button is pressed in the "dialog program".  I think the origial issue is after the upload it all works in background so the userexit won't stop at the breakpoint.

Hope it helps.

Waza