Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Change log for AUSP?

Former Member
0 Kudos

Hi All,

I need to get the change log for AUSP table values (ATWRT field). I have checked in CDPOS, it is not capturing AUSP table. Is there any table or FM or any other way to get the change log of AUSP? Your help would be highly appreciated.

Thanks in advance,

Srilakshmi.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Srilakshmi,

AUSP changes will be logged in CDPOS. Please recheck again.

OBJECTCLAS - CLASSIFY

TABNAME - ABAUSP

FNAME - ATWRT

Please check once and let us know.

Regards,

Gautham Paspala

6 REPLIES 6

Former Member
0 Kudos

Hello

Changes what object you want to find ?

Former Member
0 Kudos

Hi Srilakshmi,

AUSP changes will be logged in CDPOS. Please recheck again.

OBJECTCLAS - CLASSIFY

TABNAME - ABAUSP

FNAME - ATWRT

Please check once and let us know.

Regards,

Gautham Paspala

0 Kudos

Hi Gautham,

You are correct, CDPOS is having AUSP change log in the tablename of ABAUSP. Thanks for this.

Now i need to get the relation for AUSP using this CDPOS entries. Could please let me know how we can relate CDPOS to AUSP?

Thanks,

Srilakshmi.

0 Kudos

Hi,

Please try this way and see if this works for you... Correct me if iam wrong in understanding



SELECT objectid  changenr FROM cdhdr
                INTO CORRESPONDING FIELDS OF TABLE git_cdhdr
           WHERE objectclas = c_classify
           AND   udate      IN s_date.

IF NOT git_cdhdr[] IS INITIAL.

    SELECT cuobj
           objek
           FROM inob
           INTO CORRESPONDING FIELDS OF TABLE git_inob
           FOR ALL ENTRIES IN git_cdhdr
           WHERE cuobj = git_cdhdr-id
           AND   klart = c_klart
           AND   obtab = c_mch1.

    Perform get_material_plant.
    IF sy-subrc EQ 0.
      LOOP AT git_inob INTO wa_inob.
        clear: lv_sytabix.
        lv_sytabix = sy-tabix.
        wa_inob-objek1 = wa_inob-cuobj.
        wa_inob-matnr  = wa_inob-objek+0(18).
        wa_inob-charg  = wa_inob-objek+18(10).
* added the code to  check that the  material belongs to selected company code or not
        read table git_mara_marc into gwa_mara_marc with key matnr = wa_inob-matnr.
        if sy-subrc = 0.
          MODIFY git_inob FROM wa_inob index lv_sytabix.
        else.
          DELETE git_inob index lv_sytabix.
        endif.
      ENDLOOP.
    ENDIF.

  ENDIF.


IF NOT git_inob[] IS INITIAL.

    SELECT objek
           atinn
           atwrt
           atflv
           FROM ausp
           INTO TABLE git_ausp
           FOR ALL ENTRIES IN git_inob
           WHERE objek = git_inob-objek1.
  ENDIF.
 IF NOT git_ausp[] IS INITIAL.

    SELECT atinn
           atnam
           reffldname
           FROM cabn
           INTO TABLE git_cabn
           FOR ALL ENTRIES IN git_ausp
           WHERE atinn = git_ausp-atinn.

  ENDIF.

Regards,

Nagaraj

Former Member
0 Kudos

Hi Lakshmi,

There are 2 ways to find the relation.

1. CDPOS-OBJECTID is the combination of AUSP-OBJEK and AUSP-MAFID.

2. CDPOS-TABKEY is the combination of AUSP-OBJEK, AUSP-ATINN, AUSP-ATZHL and AUSP-MAFID.

Please check the performance and use the field you feel is right. But will give same result.

Regards,

Gautham Paspala

Subhankar
Active Contributor
0 Kudos

Hi ,

To get the log details first you need check the field LOG DATA CHANGES in the Technical Setting of the table AUSP.

Then Use the FM DBLOG_READ_TABLE to retrieve the changes based on date range.

Thanks

Subhankar