topic join query help in Application Development and Automation Discussions

join query help

Former Member — Fri, 02 Jul 2010 07:42:43 GMT

i am encountering error like the values not getting populated in internal table though values are in dbtable...so if u can help me out in the join query it will be of gr8 help

SELECT a1~guid a1~posting_date a1~process_type
       b1~sales_org b1~division b1~dis_channel
       INTO CORRESPONDING FIELDS OF TABLE it_ordel
       FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid  = c1~guid_hi )
                INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid )
       WHERE c1~objtype_hi = '05'
       AND   c1~objtype_set = '21'.
    AND   a1~process_type IN so_prst
       AND   a1~posting_date IN so_podt
       AND   b1~division     IN so_div.

thnx

Re: join query help

Former Member — Fri, 02 Jul 2010 08:07:37 GMT

For a start, you are best to stop using the a1_....b1. Use the actual table name instead. It makes the SQL easier to read.

Re: join query help

Former Member — Fri, 02 Jul 2010 08:32:32 GMT

SELECT a1~guid a1~posting_date a1~process_type
       b1~sales_org b1~division b1~dis_channel
       INTO CORRESPONDING FIELDS OF TABLE it_ordel
       FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid  = c1~guid_hi )
                INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid )
       WHERE c1~objtype_hi = '05'
       AND   c1~objtype_set = '21'.
    AND   a1~process_type IN so_prst
       AND   a1~posting_date IN so_podt
       AND   b1~division     IN so_div.

SELECT a1~guid a1~posting_date a1~process_type
       b1~sales_org b1~division b1~dis_channel
       INTO CORRESPONDING FIELDS OF TABLE it_ordel
       FROM ( ( crmd_orderadm_h AS a1 INNER JOIN crmd_link AS c1 ON a1~guid  = c1~guid_hi )
                INNER JOIN crmd_orgman AS b1 ON c1~guid_hi = b1~guid )
       WHERE c1~objtype_hi = '05'
       AND   c1~objtype_set = '21'    ".              delete that period its wrong
    AND   a1~process_type IN so_prst
       AND   a1~posting_date IN so_podt
       AND   b1~division     IN so_div.

Re: join query help

Former Member — Fri, 02 Jul 2010 09:23:05 GMT

Hey why do you have . after first AND. is it not giving u sysntax error.

Regards,

Uma Dave

Edited by: UmaDave on Jul 2, 2010 11:23 AM