topic Re: Upload program in Application Development and Automation Discussions

Upload program

Former Member — Mon, 07 Jan 2008 04:34:15 GMT

Hi Experts,

In my upload program output im having values like 0,-8,blank(no values).This is a quality field . the upload program should check on this paticular line and show message

e.g. “Line item with blank, zero or negative quantity” during the PRE upload check.

plz help me Experts with coding part.

Correct answers will be apprecialted.

Thanks & Regards

Sunita.

Re: Upload program

former_member156446 — Mon, 07 Jan 2008 04:36:52 GMT

put a condition in some loop of that table

loop at itab...

if itab-quant is initial.

mesage ....

endif.

endloop.

Re: Upload program

Former Member — Mon, 07 Jan 2008 04:53:02 GMT

hI Sunitha,

This is kiran kumar.G Actually at the time uploading data it can check the database filed values.

NEGATIVE VALUES:

That means if we give the negative value firse it can check that filed in the database is having negative values previously, If it is not having any negative values it doesnt take those values.

ZERO OR NEGATIVE QUANTITY: Genrally we can compulsory mention ZERO OR SOME VALUE in the Quantity filed otherwise it throws an error..

HOW TO RECOVER THESE PROBLEMS:

1.U DONT MENTION NEGATIVE VALUES.

2.U CAN COMPULSORY GIVE ZERO OR SOME VALUE IN THE QUANTITY FILED.

Award points if helpful.

Kiran Kumar.G

Have a Nice Day..

Re: Upload program

Former Member — Mon, 07 Jan 2008 05:06:05 GMT

Hi,

It is not possible to do PRE upload check.

First upload the data to internal table, then do the validation check.

Ex:

Use FM: GUI_UPLOAD to upload data from flat file to internal table (itab).

LOOP AT ITAB.

If ITAB-F1 is INITIAL.

Message .....

Continue. (to process next record)

endif.

If itab-f1 <= 0.

Message .....

Continue. (to process next record)

endif.

ENDLOOP.

Re: Upload program

Former Member — Mon, 07 Jan 2008 06:06:35 GMT

Hi Ramesh,

Thnx For ur reply,

Can u give me the actual coding for this.i will b very thankful.

Thanks & regards

Sunita