topic Re: Problem using Select... different tables in different systems (MANDT)... in Application Development and Automation Discussions

Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 16:47:13 GMT

Hi guys,

My problem is that SAP create different tables in DEV, QAS and PRD. My program runs well in DEV, but when i transported it to QAS,it gave a dump, error the table is not found. Correct, that's why SAP created the table in QAS with another name... why¿? no idea.

I was thinking to do sth like this.


      case sy-mandt.
      when '0100'.
        select single target1 into wa1-fipex
        from FMFMOADCC1000034                 " table used in DEV
        where sour1_from = wa1-hkont and sour1_to = wa1-hkont.
      when '0200'.
        select single target1 into wa1-fipex
        from FMFMOATCC2000012                " table used in QAS
        where sour1_from = wa1-hkont and sour1_to = wa1-hkont.

      endcase.

but it doesnt work, because the table of QAS doesnt exit in DEV. , but how can i do it??

Can i create a dynamic select? or any ideas, how to solve that problem???

Thanks

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 16:58:58 GMT

Hi,

Whats the issue you are facing with the code you have used? since you are selecting based on the sy-mandt it will pick the appropriate select statement.

Vikranth

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:00:56 GMT

What creates these tables(tcode, process)?

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:02:45 GMT

SAP created those tables in FMDERIVER

SAP gives different names in different systems. Crazy..

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:04:38 GMT

Hi,

nop, because in DEV, SAP gave me an error, the table FMFMOATCC2000012 doesnt exit. It is correct, in mandt 100, that table doesnt exit, but in 200 exits. and opposite.

?¿?¿ Any idea.

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:23:12 GMT

You have to call the function module ABADR_DRULE_TABLENAMES_GET and get the tablename and change your select statement to be a dynamic table select.

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:24:45 GMT

Ok but if the client number of DEV is 0100, the control wont even go to the select of 0200 i,e the table FMFMOATCC2000012 . Then how are you getting this error?

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:27:31 GMT

yes, it is correct.

Try to make a select using a table that it doesnt exit in SAP, it gives u an error

TABLE NAME is not defined in the ABAP Dictionary as a table, projection view, or database view.

So it is not possible to use it.

Thanks

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:36:04 GMT

Yes i understood now. I thought you were getting a dump. but the select wont even pass the syntax check.

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 17:52:14 GMT

One more option could be as follows,

the table DD02T stores all the table names. You could make a select on this table and frame your actual select query dynamically



data: w_tabname type dd02t-tabname.

select single tabname 
from dd02t
into w_tabname
where tabname = 'FMFMOADCC1000034' OR
            tabname = 'FMFMOATCC2000012 '.

if sy-subrc = 0.

select single target1 
into wa1-fipex
from ( w_tabname )               
where sour1_from = wa1-hkont and 
            sour1_to = wa1-hkont.
endif.

Vikranth

Re: Problem using Select... different tables in different systems (MANDT)...

SuhaSaha — Thu, 08 Oct 2009 18:16:33 GMT

Hello,

I dont know why you are doing this but a simple hack will solve your woes


    DATA: DYNTAB TYPE TABNAME.
 
    case sy-mandt.
      when '0100'.
         dyntab = 'FMFMOADCC1000034'.
      when '0200'.
         dyntab = 'FMFMOATCC2000012'.
      endcase.

        select single target1 into wa1-fipex
        from (dyntab)                " table used in QAS
        where sour1_from = wa1-hkont and sour1_to = wa1-hkont.

I think this should suffice ...

BR,

Suhas

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 18:27:05 GMT

Thanks.

That was the answer that i was looking for.

Regards to all.

Re: Problem using Select... different tables in different systems (MANDT)...

Former Member — Thu, 08 Oct 2009 18:39:04 GMT

[Note 1231815|https://websmp206.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=1231815&_NLANG=E] gives the proper solution.

Rob