Skip to Content
0
Former Member
Apr 23, 2008 at 10:25 PM

PCA Retraction - Excel-file Upload (T-code: 7KEX)

223 Views

Hi All,

We are trying to retract profit center data into R/3 from BW. I am using Excel-file upload (r/3 t-code 7KEX) for this purpose. Once i execute this, i keep getting an error ('Enter Numerical Value').

The steps I followed:

In BW, I exported results of query to an excel file and saved the results as a .txt file. The structure of the report is --- Profit Center, Jan amount, feb amount ... dec amount)

In R/3, I created a planning layout (Profit center, jan amount,feb amount...dec amount). I then created a planner profile and assigned the planning layout to the planner profile.

Is there any header that needs to be included in the .txt file? Please advise about how to resolve the issue.

Thanks