Skip to Content

DTW Upload - Budget

Jan 06, 2017 at 06:23 AM


avatar image

I am attempting to upload a budget for one of my customers using DTW. The files upload without error. However, the monthly values in the BGT1 file are being loaded incorrectly. Below is a section of the BGT1 file I am using for the upload. The LineNum column refers to the Line Number of the Budget Item Details screen, beginning with 0 = January, etc.

Numerator 4 in the file above corresponds with the account shown in the image below. Notice that the value for LineNum 0 (should be January) got loaded to September. The value for LineNum 10 (should be September) got loaded to May. None of the values ended up where they were supposed to be. Same is true for all other accounts that I checked. I have uploaded the file more than once and the months are different each time.

I've queried the SQL table and the values, of course, match what is shown in the Budget Item Details screen.

Does anyone have any insight into why this would be happening this way. Any ideas on how to solve it?

Randy Davis
Denver, CO

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jitin Chawla
Jan 06, 2017 at 06:39 AM


Check SAP Note No. : 2385423 is relevant and related to your issue.



10 |10000 characters needed characters left characters exceeded
Gonzalo Gomez Jan 09, 2017 at 08:38 AM

The number of line you have to mark only in the colum Line_id, leave blank linememo


captura.jpg (73.0 kB)
10 |10000 characters needed characters left characters exceeded