2 Replies Latest reply: Mar 25, 2014 4:16 AM by Daniel Zanders RSS

    Join on SAP table in qlikview

    Sumita Chawla

      Hi All,

       

      I am facing issue while joining two SAP table in qlikview my query is:

       

       

      sql select

          MSEG~MANDT

          MSEG~EBELN 

          MSEG~EBELP

          MSEG~MBLNR

      MSEG~MJAHR

      MSEG~ZEILE

      MSEG~LINE_ID

      MSEG~PARENT_ID

      MSEG~BWART

      MSEG~XAUTO

      MSEG~MATNR

      MSEG~WERKS

      MSEG~LGORT

      MSEG~CHARG

          MSEG~LIFNR

      MSEG~KUNNR

          MSEG~SHKZG

      MSEG~WAERS

      MSEG~BWTAR

      MSEG~MEINS

      MSEG~ERFME

      MSEG~KOSTL

          MSEG~AUFNR

      MSEG~GJAHR

      MSEG~UMMAT

      MSEG~UMWRK

      MSEG~UMLGO

      MSEG~UMCHA

      MSEG~KZZUG

      MSEG~BUKRS

      MSEG~SMBLN

      MSEG~SMBLP

      MSEG~SJAHR

      MSEG~GRUND

      MSEG~UMMAB

      MSEG~DMBTR

      MSEG~BNBTR

      MSEG~MENGE

      MSEG~ERFMG

      MSEG~PBAMG

      from MSEG join MKPF  on  ( MSEG~MBLNR  = MKPF~MBLNR )  and  ( MSEG~MJAHR  = MKPF~MJAHR ) 

      where MSEG~MANDT =  '100'  and

      (( MKPF~CPUDT >= '$(test)'  and   MKPF~AEDAT = '00000000' )

      OR  ( MKPF~CPUDT like '%' and MKPF~AEDAT >= '$(test)' ));

       

       

      Any help would be appreciated.