topic Re: Upload Program in Application Development and Automation Discussions

Upload Program

Former Member — Wed, 02 Sep 2009 13:28:51 GMT

Hai Friends,

I have to upload a .txt file. This file updates the Z table. End users have the data in excel and save it to a .txt file and upload the data. The user has to enter the date only in YYYYMMDD format without any separator. How can i check this before uploading?. i want to give a message also if it was maintained in the wrong format.

My Z table has the following fields,

MANDT

POSNR

MATERIAL

DATE

How can i upload a consecutive number for POSNR. it should start from 1,2,3........... and the MANDT field should be 900.?

Thanks.

Re: Upload Program

Former Member — Wed, 02 Sep 2009 13:37:59 GMT

What exactly is your question?

Rob

Re: Upload Program

Former Member — Wed, 02 Sep 2009 13:40:14 GMT

i want to validate the date format before uploading.

i want a consecutive number to be maintained in the POSNR field.

Re: Upload Program

Former Member — Wed, 02 Sep 2009 13:44:27 GMT

Search the forum for date validation examples.

You can create a number range for your posnr (also search the forum).

Rob

Re: Upload Program

Former Member — Wed, 02 Sep 2009 13:46:46 GMT

Hi,

Please find answers to your queries.

1. In your program use FM GUI_UPLOAD to upload the txt file from presentation server (your pc) to an internal table within the

program.

2. The internal table should have the same structure as the columns of the txt file.

3. To find out if the date contains any separator you can use the FIND command.

4. Identifying whether the date is strictly in YYYYMMDD format would be a lilttle difficult as there is no direct FM for it.

You will have to bulid some logic for it.

I could not understand your other queries. Please elaborate.

Regards,

Ankur Parab