topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Fri, 21 May 2010 12:36:56 GMT

Hi all,

After spending some hours I wrote a query which is needed for my project.There are some problems in the query and Iam not 100 % sure wheather it will work.Thats why the post here.(some of the field names wont be exactly right)

FORM BOM_Test.
data: lv_cdpos_cond type string.     
lv_cdpos_cond = 'cdpos~feldname = '.
concatenate lv_cdpos_cond  'Fmenge'
'and cdpos~chngid = ' 'I'
'OR cdpos~chngid = '  'U'
  'OR cdpos~chngid = ' 'D'
  'and cdpos~tabname = ' 'stpos' INTO lv_cdpos_cond SEPARATED BY space.
  select cdhdr~username cdhdr~udate cdpos~changeid cdpos~valuenew
         cdpos~valueold cdpos~tabname cdpos~feldname stpos~stlr
         stpos~stlr stpos~position stpos~component mast~material
          mara~mattxt into CORRESPONDING FIELDS OF TABLE gt_ditab
         from cdhdr
         INNER JOIN cdpos on cdhdr~OBJECTCLAS = cdpos~OBJECTCLAS
          and cdhdr~changenr = cdpos~changenr
        INNER JOIN stpos on cdpos~tabkey = stpos~(
            mandt+bomtype+bom+nodetype+counter)
        INNER join mast on stpos~stlnr = mast~stlnr
        INNER JOIN mara on mast~matnr = mara~matnr
        where cdhdr~objectclas = 'stue'
        and cdhdr~udate in so_date
        and lv_cdpos_cond and lv_stpos_cond
        and mast~matnr in so_matrange
        and mara-matnr = mast~matnr.
Endform.

I have to select some data from 5 different tables(CDHDR,CDPOS,stpos.mast and mara). As Iam trying it on a test machine from home.Anyway its still not a compilable select query as there are still some holes to plug in.The purpose of this query is to get the changed BOM data.Iam using 1 string in my Select query lv_cdpos_cond to make the query readable. But the strings inside the strings like 'I','U' or 'D' is not concateneted as a string.How could it be done .Also will the "OR " condition in the string lv_cdpos_cond work(if it is used directly in the select query) in the sql query.

The innerJoin " INNER JOIN stpos on cdpos_{tabkey = stpos}( mandtbomtypebomnodetypecounter)" :Here the cdpos~tabkey is a concateneted value from the fields(mandtbomtypebomnodetypecounter) in stpos. how to make a join condition here.

Will this query work :).Will it be a performant query.Would be nice if some one could post a edited query if there are problems in my the query.(spend 2 hrs to write this,Thats why )

Thanks kOH

Edited by: Kohinoor72 on May 21, 2010 2:47 PM

Re: Select Query

Former Member — Fri, 21 May 2010 13:38:29 GMT

Let's see:

> some of the field names wont be exactly right

> its still not a compilable select query

> there are still some holes to plug

> Would be nice if some one could post a edited query if there are problems in my the query

And you want the forum to fix it for you?

Maybe you should work on it a bit more yourself.

Rob

Re: Select Query

Former Member — Fri, 21 May 2010 13:59:59 GMT

Hi Rob,

Sorry if I have offended you with my statement.

As said I worked on this query for 2 hours...(am a beginner in abap )

I could proceed on my own only if someone could help me on the inner join and the string question.

Iam stuck there.

Re: Select Query

Former Member — Fri, 21 May 2010 14:21:06 GMT

No offense taken - but you have to realize that this is not a forum for beginners. You should provide code that has a specific problem and then ask a specific question about it.

Also, Please read and and [Asking Good Questions in the Forums to get Good Answers|/people/rob.burbank/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers] before posting again.

Rob

Re: Select Query

Former Member — Fri, 21 May 2010 14:21:54 GMT

Hi Kohinoor72

maybe you shoult try to do more then a select.....and not only one with the inner join...it will be more clear.

best regards

Marco

Re: Select Query

Former Member — Fri, 21 May 2010 14:29:19 GMT

Thanks Rob.Then I will close this thread as my question was a bit wierd and open another thread with my specific questions.

Re: Select Query

Former Member — Fri, 21 May 2010 14:46:07 GMT

Perfect!

Rob