data store when we execute TCODE CO11N and CO15.

[Former Member]

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.

[RichHeilman]

This is production order comfirmation right? Check table AFRU.

Regards,

Rich Heilman

[Former Member]

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.

[Former Member]

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.

[RichHeilman]

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