topic Re: invalid entries in Application Development and Automation Discussions

invalid entries

Former Member — Fri, 14 Sep 2007 09:57:39 GMT

dear all,

i am uploading data from flat file to Intrenal table . In this flat file there is one field is Currency Key

my requirment is that whatever Currency key in my flat file or internal table it must be valid .

if in flat file or itab , i am maintaing invalid entreis like SDZ insted of "USD" then message should come invalid entries. please check your currency Key.

How to do that ?

Re: invalid entries

Former Member — Fri, 14 Sep 2007 10:07:32 GMT

Hi,

After uploading the data to your internal table.Write aread statement as follows,

Read table itab with key currency key <> 'USD'.

If sy-subrc = 0.

Message("please check your currency Key")

Endif.

Message was edited by:

Alvaro Tejada Galindo

Re: invalid entries

former_member189629 — Fri, 14 Sep 2007 10:10:18 GMT

while appending values into your itab, check at the field position for currency. if u uploading the flat file line as a string into itab and using offsets to segregate data, use exact offset and add conditions like

IF i_STRING80(3) <> 'USD' or i_STRING80(3) <> 'INR'.

MESSAGE E001." Invalid currency

ENDIF.

Message was edited by:

Karthik

Message was edited by:

Alvaro Tejada Galindo

Re: invalid entries

former_member404244 — Fri, 14 Sep 2007 10:10:51 GMT

hi,

ucan do like this

loop at itab.

if itab- currency key <> 'USD'.

Message e001.

Endif.

endloop.

Regards,

Nagaraj

Re: invalid entries

Former Member — Fri, 21 Sep 2007 05:06:07 GMT

Thanks Karthik, and all,

Point has been given