2 Replies Latest reply: Jan 25, 2012 6:01 AM by Kiruthigadevi RSS

    If then else with load

    Sravan Puppala

      Hi Guys,

       

      why does not this work? It must here load from PARTNER_HIST_FR.qvd because month <> 2. It still loads from PARTNER_FR.qvd

      (qvd);

       

      why?

       

       

      if month(today()=2) then

      table:

      LOAD MANDANT,

           ID_PARTNER,

           PARTNER_ROLLE,

           PARTNER_KURZBEZ,

           ARCHIV_KZ,

           SACHB_KZ,

           AEN_DATUM

      PARTNER_FR.qvd

      (qvd);

       

      else

      table:

      LOAD MANDANT,

           ID_PARTNER,

           GUELTIG_VON,

           GUELTIG_BIS,

           PARTNER_BEZ,

           ID_PERSON,

           DEBITORNUMMER,

           KREDITORNUMMER,

           EXTID_PARTNER,

           ARCHIV_KZ,

           SACHB_KZ,

           AEN_DATUM

      FROM

      PARTNER_HIST_FR.qvd

      (qvd);

       

      end if