topic Re: data store when we execute TCODE CO11N and CO15. in Application Development and Automation Discussions

data store when we execute TCODE CO11N and CO15.

Former Member — Mon, 09 Mar 2009 19:02:33 GMT

Hi All,

Can you please tell me when we execute the transaction CO11N and CO15 where the data stores.Mean in Which table it stores all the value.

Thanks in Advance.

Re: data store when we execute TCODE CO11N and CO15.

RichHeilman — Mon, 09 Mar 2009 19:05:08 GMT

This is production order comfirmation right? Check table AFRU.

Regards,

Rich Heilman

Re: data store when we execute TCODE CO11N and CO15.

Former Member — Mon, 09 Mar 2009 19:08:29 GMT

May be you can try SQL Tarce ST05 ON and execute the transactions. You will get the name of all tables the get updated in background.

Re: data store when we execute TCODE CO11N and CO15.

Former Member — Mon, 09 Mar 2009 19:09:02 GMT

May be you can try SQL Tarce ST05 ON and execute the transactions. You will get the name of all tables the get updated in background.

Re: data store when we execute TCODE CO11N and CO15.

RichHeilman — Mon, 09 Mar 2009 19:09:30 GMT

You can join to AFRU from the AFVC table using the RUECK field. Here is a join from one of my programs.

clear iaf. refresh iaf.
  select afko~aufnr aufk~werks aufk~auart afko~gltrp
         afpo~matnr afpo~cuobj
         afvc~aufpl afvc~vornr afvc~rueck afru~iedd
         afru~iedz  afru~gmnga afru~ernam afru~pernr
           into corresponding fields of table iaf
            from afko
              inner join aufk
                      on afko~aufnr = aufk~aufnr
              inner join afpo
                      on aufk~aufnr = afpo~aufnr
              inner join afvc
                      on afko~aufpl = afvc~aufpl
              inner join afru
                      on afvc~rueck = afru~rueck
                       where afko~gltrp in s_gltrp
                         and afko~dispo <> 'COL'
                         and aufk~auart in s_auart
                         and aufk~werks in s_werks
                         and aufk~loekz = ' '
                         and aufk~idat2 = '00000000'
                         and afvc~vornr in s_vornr
                         and afru~ernam in s_ernam
                         and afru~iedd  in s_iedd
                         and afru~iedz  in s_iedz
                         and afru~pernr in s_pernr.

Regards,

Rich Heilman