topic Re: how to write the syntax in Application Development and Automation Discussions

how to write the syntax

Former Member — Mon, 02 Mar 2009 10:02:07 GMT

hi,

can anybody provide me the what is the syntax for below description??

If the sales order is not at offer date, then table z03_sd_idx_ccli and z03_sd_data_ccli must not be updated. (If they were updatings, they could not be chosen again)

thanks

navketan

Re: how to write the syntax

Former Member — Mon, 02 Mar 2009 10:21:25 GMT

Hi Navketan,

You can write your logic something like this.

If sales_order eq offer_date

update z03_sd_idx_ccli and z03_sd_data_ccli

endif.

Much Regards,

Amuktha.

Re: how to write the syntax

Former Member — Mon, 02 Mar 2009 11:15:27 GMT

can somebody send more elaborately

Re: how to write the syntax

Former Member — Mon, 02 Mar 2009 11:28:25 GMT

If salesorder eq offerdate

modify z03_sd_idx_ccli and z03_sd_data_ccli

endif.

if u use modify statement then system itself checks in the table that the partcicular entry is already exist or not.if this entry doest exist then only it will create the entry.

Re: how to write the syntax

Sathya_Gunasekaran — Tue, 03 Mar 2009 04:15:53 GMT

Hello,

Instead of telling " if both the dates are not equal.....do not update."

You can write " If both the dates are equal...then update".

If date1 = date2.

Update statement.

endif.

Re: how to write the syntax

Former Member — Wed, 04 Mar 2009 07:01:16 GMT

Hi,

If So_date = Offer_date.

modify z03_sd_idx_ccli from wa.

modify z03_sd_data_ccli from wa1.

endif.

if sy-subrc = 0.

write code for next time could not be chosen again.

endif.

Re: how to write the syntax

Former Member — Wed, 04 Mar 2009 13:35:55 GMT

hi nayar , try this logic

if (<sales_order-field name> NQ <offer_date-field name> and flag = 1.)
exit.
else.
INSERT into <z03_sd_idx_ccli> from < source_name>.
INSERT into <z03_sd_data_ccli> from < source_name>.
if sy-subrc eq 0.
 flag = 1.
endif.