SAP Notes date implemented report

[Former Member]

Hi Gurus,

Is there a way on how to quickly get the dates when the SAP Notes were implemented?

We have tried

1. Using note browser - however, we need to click each notes then to the note log and get the date.

2. Using query tool - BUT we don't know the table for note log, any idea?

[ThomasZloch]

I did not find anything suitable in the CWBN* tables, the closest match I think is table SMODILOG, where you can find the note numbers in column MOD_NAME and a timestamp of the modification.

There is only entries in SMODILOG when development objects have been changed by the note implementation, and there can be many entries for a single note.

Thomas

[Former Member]

Check the below table

CWBNTMSG

Prabhudas

[RaymondGiuseppi]

SAP Notes implementations are transported, so

- Check table [E070A|http://www.sdn.sap.com/irj/scn/advancedsearch?query=e070a+] "Change & Transport System: Attributes of a Request" where ATTRIBUTE is "SAPNOTE" (development system)

- In E070-AS4DATE you will get the release date of the request.

- You can find log of transport date via FM [TR_READ_GLOBAL_INFO_OF_REQUEST|http://www.sdn.sap.com/irj/scn/advancedsearch?query=tr_read_global_info_of_request+] (quality and productive systems)

SNOTE has some tables to manage its log and process, check tables

- CWBNTSTXT Note Short Text

- CWBNTHEAD Header Table for Notes in Customer Systems

- CWBNTCUST Customer Attributes for a Note

- CWBNTMSG SAP Notes: Message Log (look SCWN message class to find suitable messages to track)

Also check FM like SCWB_NOTE_READ

Also don't forget that a Note can be deimplemented, and some notes contain only manual implementation task...

Regards,

Raymond

[shekhar_gupta3]

Thanks Raymond.

This information turned very useful.

Regards

shekhar

[Former Member]

I was searching for a way to find which notes have been implemented ordered by date and based on the helpful information provided by Raymond I put the following SQL statement together:

select ea.REFERENCE, e.AS4DATE, n.STEXT

FROM SAPSR3.E070 e JOIN SAPSR3.E070A ea ON e.TRKORR = ea.TRKORR

JOIN SAPSR3.CWBNTSTXT n ON n.NUMM = ea.REFERENCE

WHERE ea.ATTRIBUTE = 'SAPNOTE'

ORDER BY e.AS4DATE

Works on my Oracle and ASE test systems, for IBM the schema owner has to changed.

Sebastian