Read and OSS notes

[NAeda]

Hello all

How to get(download) the all Z reports from the system..i heard that by using Read statement we can download the report is int it?

What is OSS notes and How to apply OSS notes ?

[NAeda]

Hello all

How to get(download) the all Z reports from the system..i heard that by using Read statement we can download the report is int it?

What is OSS notes and How to apply OSS notes ?

[Former Member]

Hi,

Simply just do like this,

Go to T.code se11,

provide table name as TRDIR,

display and excute,

in the selection screen set maximum no of hits like 100000

then exute,

now output u can downlaod to excel sheet.

seshu.

[Former Member]

Hi,

For downloading reports check this link

http://www.dalestech.com/products/massdownload.htm

For oss notes

OSS notes are used by SAP to issue corrections to known bugs to the application/system.

If you experience problems with the way SAP is working you can search OSS notes to see if the problem you are having is known to SAP. If it is then you can implement the fix (usually through code corrections) that SAP have provided.

If the problem is not listed you are able to raise a call with SAP to inform them of the problem, they should then get back to you with suggestions and/or solutions.

Implementing an OSS Note

You can search for SAP Notes in www.services.sap.com. You have to search with your problem category and from the list of SAP notes listed, try to find out the one which is for the problem that you have encountered. Each SAP note will contain the Problem description, solution and the programs affected. Get the Note number from here and in SAP system, goto transaction SNOTE and check if the Note number is already existing. If note, use the Download option to download the OSS Note to the system. Select the note number and click on Execute Button. Note will be implemented!!

APPLYING.

The transaction code SNOTE is used to implement OSS Notes. With the SNOTE

transaction, it is no longer necessary to register ABAP objects such as report function

modules etc. manually. But data dictionary objects such as screens, tables need to

be modified manually by registering them in OSS system.

In order to use the transaction code SNOTE, the relevant transport which implement

this transaction in the system need to be transported. Please refer to the SNOTE

guide available at http://service.sap.com

this pdf will be helpful

http://www.sappoint.com/basis/snote.pdf

Regards

[kiran_k8]

Aeda,

The following program wil get you all the zobjects with their latest TR.

REPORT zobjects no standard page heading .

TABLES:TADIR,TSTC,V_USERNAME,VRSD.

TYPE-POOLS:slis,VRM.

TYPES: BEGIN OF ittemp,

object LIKE tadir-object,

obj_name LIKE tadir-obj_name,

text LIKE trdirt-text,

author LIKE tadir-author,

devclass like tadir-devclass,

name_text LIKE v_username-name_text,

tcode like tstc-tcode,

korrnum like vrsd-korrnum,

END OF ittemp.

DATA: itfinal TYPE STANDARD TABLE OF ittemp WITH HEADER LINE,

wafinal TYPE ittemp.

DATA : name TYPE vrm_id,

list TYPE vrm_values,

value LIKE LINE OF list.

DATA:itfieldcat TYPE slis_t_fieldcat_alv WITH HEADER LINE.

DATA:itrepid TYPE sy-repid.

itrepid = sy-repid.

DATA:itevent TYPE slis_t_event.

DATA:itlistheader TYPE slis_t_listheader.

DATA:walistheader LIKE LINE OF itlistheader.

DATA:itlayout TYPE slis_layout_alv.

DATA:top TYPE slis_formname.

DATA:itsort TYPE slis_t_sortinfo_alv WITH HEADER LINE.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

PARAMETER: PACKAGE LIKE TADIR-DEVCLASS.

SELECTION-SCREEN END OF BLOCK B1.

START-OF-SELECTION.

PERFORM getdata.

PERFORM alv.

&----

---

*& Form GETDATA

&----

---

• text

----

---

FORM getdata.

• read the repository object table and link with username if found

SELECT tadir~object

tadir~obj_name

trdirt~text

tadir~author

tadir~devclass

v_username~name_text

INTO TABLE itfinal

FROM tadir

LEFT JOIN v_username

ON tadir_{author = v_username}bname

LEFT JOIN trdirt

ON tadir_{obj_name = trdirt}name

WHERE tadir~devclass = PACKAGE

"'$TMP'

AND ( tadir_{obj_name LIKE 'Z%' OR tadir}obj_name LIKE 'Y%' ).

CHECK sy-subrc EQ 0.

loop at itfinal.

*TCODE FROM TSTC

select single tcode from tstc into (itfinal-tcode) where pgmna =

itfinal-obj_name.

*LATEST TRANSPORT REQUEST NUMBER FROM VRSD

select single korrnum from vrsd into (itfinal-korrnum) where objname =

itfinal-obj_name.

modify itfinal.

endloop.

delete itfinal where korrnum is INITIAL.

SORT itfinal BY author object.

ENDFORM. "GETDATA

&----

---

*& Form ALV

&----

---

• text

----

---

FORM alv.

IF itfinal[] IS INITIAL.

MESSAGE 'No Values exist for the Selection.' TYPE 'S'.

STOP.

ENDIF.

DEFINE m_fieldcat.

itfieldcat-fieldname = &1.

itfieldcat-col_pos = &2.

itfieldcat-seltext_l = &3.

itfieldcat-do_sum = &4.

itfieldcat-outputlen = &5.

append itfieldcat to itfieldcat.

clear itfieldcat.

END-OF-DEFINITION.

m_fieldcat 'OBJECT' '' 'OBJECT' '' 04 .

m_fieldcat 'OBJ_NAME' '' 'PROGRAM NAME' '' 40 .

m_fieldcat 'TCODE' '' 'TCODE' '' 20 .

m_fieldcat 'TEXT' '' 'DESCRIPTION' '' 70 .

m_fieldcat 'AUTHOR' '' 'AUTHOR' '' 80 .

m_fieldcat 'DEVCLASS' '' 'PACKAGE' '' 30 .

m_fieldcat 'KORRNUM' '' 'LATEST TRANSPORT REQUEST' '' 20 .

itlayout-zebra = 'X'.

itlayout-colwidth_optimize = 'X'.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = sy-repid

is_layout = itlayout

i_callback_user_command = 'LIST1'

i_callback_top_of_page = 'TOP'

it_fieldcat = itfieldcat[]

i_save = 'A'

• is_variant = ITVARIANT

it_events = itevent[]

• is_print = ITPRINTPARAMS

it_sort = itsort[]

TABLES

t_outtab = itfinal

EXCEPTIONS

program_error = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

ENDFORM. "ALV

&----

---

*& Form TOP

&----

---

• Top of page for ALV Report

----

---

FORM top.

DATA:STRING1(70),

STRING2(70),

title1(100),

title2(100),

count(10).

describe table itfinal lines count.

CALL FUNCTION 'REUSE_ALV_EVENTS_GET'

EXPORTING

i_list_type = 0

IMPORTING

et_events = itevent

• EXCEPTIONS

• LIST_TYPE_WRONG = 1

• OTHERS = 2

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

string1 = 'List of Objects in Development Class'.

concatenate string1 ':' itfinal-devclass into title1.

walistheader-typ = 'H'.

walistheader-info = title1.

APPEND walistheader TO itlistheader.

string2 = 'Total No.of Objects'.

concatenate string2 ':' count into title2.

walistheader-typ = 'H'.

walistheader-info = title2.

APPEND walistheader TO itlistheader.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

it_list_commentary = itlistheader

• I_LOGO = ''.

• I_END_OF_LIST_GRID =

.

• ENDIF.

CLEAR itlistheader.

• ENDIF.

ENDFORM. "TOP

&----

---

*& Form list1

&----

---

• ALV Interactive-

----

---

• -->R_UCOMM text

• -->RS_SELFIELDtext

----

---

FORM list1 USING r_ucomm LIKE sy-ucomm rs_selfield TYPE slis_selfield.

CASE r_ucomm.

WHEN '&IC1'.

IF rs_selfield-fieldname = 'OBJ_NAME'.

READ TABLE itfinal INDEX rs_selfield-tabindex.

SET PARAMETER ID 'RID' FIELD itfinal-OBJ_NAME.

CALL TRANSACTION 'SE38' AND SKIP FIRST SCREEN.

ELSEIF rs_selfield-fieldname = 'TCODE'.

READ TABLE itfinal INDEX rs_selfield-tabindex.

SET PARAMETER ID 'TCD' FIELD itfinal-TCODE.

CALL TRANSACTION 'SESSION_MANAGER' AND SKIP FIRST SCREEN.

ENDIF.

ENDCASE.

ENDFORM.

***********************

OSS notes can be implmented using SNOTE Transaction.

K.Kiran.

[NAeda]

Hello frnd..!

Please let me know about SNOTE Transation and Details os OSS Notes..

What is the purpose of OSS notes..?

when can we apply oss notes..?

how can we apply oss notes..?

Thnks

Regards

Aeda