topic Re: writing alias query with casting in Application Development and Automation Discussions

writing alias query with casting

Former Member — Mon, 27 Apr 2009 13:14:53 GMT

Dear Experts,

i want to excute a query which have a condition that needs some casting. the table is MSEG the users are entering the reffrencing article document in the item text field. now all i need is to excute a query which have the mseg aliased and the joining condition should be mblnr with sgtxt

i imagine it should be something like this

select * from recmseg,supmseg where supmseg.mblnr=cast(recmseg.sgtxt as blnr)

recmseg is alias mseg for the recieving site

supmseg is alias Mseg for suplying site

so please can you tell me where i can write it and how to excute it and correct the syntax also

Re: writing alias query with casting

Former Member — Mon, 27 Apr 2009 13:38:28 GMT

Hi Ebrahime ,

Please try this code ---

DATA : t_itab LIKE TABLE OF  mseg.
SELECT mblnr sgtxt FROM mseg
               INTO CORRESPONDING FIELDS
                               OF TABLE t_itab.

Regards

Pinaki

Re: writing alias query with casting

Former Member — Mon, 27 Apr 2009 13:47:04 GMT

thank you for your immediate reply. can you tell me where i can excute this query also i am not finding the joining condition in the query i want to join sgtxt with mblnr

Re: writing alias query with casting

Former Member — Mon, 27 Apr 2009 13:52:17 GMT

Hi,

I have modified the previous code a bit to join that by CONCATENATE statement.

Check the changes -

DATA : t_itab LIKE TABLE OF  mseg,
       fs_itab TYPE mseg.
DATA : w_string TYPE string.
SELECT mblnr sgtxt FROM mseg
               INTO CORRESPONDING FIELDS
                               OF TABLE t_itab.

LOOP AT t_itab INTO fs_itab.
  CONCATENATE fs_itab-mblnr fs_itab-sgtxt INTO w_string.
  WRITE : / w_string.
ENDLOOP.

Thanks and regards

Pinaki

Re: writing alias query with casting

Former Member — Tue, 28 Apr 2009 11:05:09 GMT

hi,

let me explain more i want to write a join condition statement the condition is mblnr=sgtxt thats all not to concatenate the 2 fields. in other words to make copy of the table mseg 2 times and compare sgtxt in the first copy with mblnr in the second copy and if a match happen select that.

Re: writing alias query with casting

Former Member — Tue, 28 Apr 2009 11:57:23 GMT

i found it


REPORT  ZMM_TRANSFER.
DATA : 
       fs_itab TYPE mseg,rs_itab LIKE TABLE OF mseg.

   
   
   select MSEG2~mblnr MSEG1~sgtxt 
     INTO CORRESPONDING FIELDS
                               OF TABLE rs_itab
     from MSEG as MSeg1
    inner JOIN
      MSEG as mseg2
                  on
       mseg2~MBLNR = MSEG1~sgtxt.
                                                                                LOOP AT rs_itab into fs_itab.
  
  WRITE : / fs_itab-sgtxt,fs_itab-mblnr.
ENDLOOP.