how to write the syntax

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

can somebody send more elaborately

[Former Member]

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.

[Sathya_Gunasekaran]

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.

[Former Member]

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.

[Former Member]

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.