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