Upload program

[Former Member]

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.

[former_member156446]

put a condition in some loop of that table

loop at itab...

if itab-quant is initial.

mesage ....

endif.

endloop.

[Former Member]

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..

[Former Member]

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.

[Former Member]

Hi Ramesh,

Thnx For ur reply,

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

Thanks & regards

Sunita