7 Replies Latest reply: Dec 23, 2014 5:02 AM by Sudhanshu Shrivas RSS

    please check script

    Sudhanshu Shrivas

      hi,

       

      I Have this script.

      Plz tell me where I am wrong.

       

      let vFromDATE = '20130101';
      let vToDATE= '20131231';

      [VBRK]:

      Load
        
        
         [VBELN] as [Billing Document_VBELN.VBRK],
         [FKDAT] as [Billing date_FKDAT.VBRK];
        
      SQL Select VBELN FKDAT from VBRK

      WHERE FKDAT >= '$(vFromDATE)'and FKDAT <= '$(vToDATE)'
      ;

      Left join([VBRK])


      [VBRP]:   // Billing Document: Item Data
      Load

         [VBELN] as [Billing Document_VBELN.VBRK].....
       
      SQL Select VBELN from VBRP
      ;
      STORE * FROM [VBRP] INTO F:\...............................\VBRP2013.QVD(qvd);
      DROP TABLE [VBRP];

       

      thanks