program name for transaction s_alr_87013611

[Former Member]

hi expert

i need to create one report like  s_alr_87013611.

is any program exists for this t-code.?

which tables used in this transaction?

best regards

[PeterJonker]

Execute the program, go to the menubar and click system / status. Now you will see the program name in the field Program

In my case the program name for this transaction is: GP4QLQKH46VZJ3P1A40A23S3HJG200

But I don't know, maybe it has been generated by SAP and therefore has a different name in another system. That is possible.

[Former Member]

Hi,

    Goto transaction Se93 and enter your T-code.

Regardsm

Praveen

[raymond_giuseppi]

Look at the transaction definition via SE93, you should see transaction START_REPORT is called with a type of "RW" "Report Writer" -> Start with some documentation like Report Painter / Report Writer

To identify database table, use tools like ST05 "SQL Trace" or SAT (or old SE30) "Abap Trace".

Regards,

Raymond

[former_member184611]

Hi maryam,

The program behind the Tcode s_alr_87013611 is  GP4QLQKH46VZJ3P1A40A23S3HJG800. To find the program for a Tcode, just run the Tcode and select systems>>status from the menu. The program name will be displayed there.

Some tables used in this program are

COSP  

COSS  

COSPP 

COSSP 

COSL  

COSR  

CCR1S 

CCSS  

CCR1Z.

Thanks and Regards,

Abyson Joseph

[Former Member]

hi Abyson Joseph

thank you for  your help.

i need to find field act cost .i use this query

select "SINGLE

sum( wtg006 )   as zwtg006_110010

cosp~kstar as kstar  csku~ltext as ltext

into

  corresponding fields of table it_tmp

"(wa_detail-zwtg006_150020

", wa_detail-kstar,wa_detail-ltext)

from csks

inner join cskt   on csks~kostl = cskt~kostl

inner join  cosp   on csks~objnr = cosp~objnr

inner join csku on cosp~kstar = csku~kstar

"inner join coep on coep~lednr = cosp~lednr

  "     and coep~objnr = cosp~objnr

  "  and coep~gjahr = cosp~gjahr

  "  and coep~wrttp = cosp~wrttp

  "  and coep~versn = cosp~versn

  "  and coep~kstar  = cosp~kstar



where  csks~kokrs eq zkokrs

  and cosp~gjahr eq  zgjahr

  and cosp~versn eq zversn

  "AND csks~kostl  IN zkostl

  and cosp~kstar in  zkstar

  and csks~datbi > sy-datum

  and cosp~wtg006 ne 0

  and cskt~datbi > sy-datum

  and  csks~kostl = '0000110010'

    "and coep~perio in zperiod

group by cosp~kstar csku~ltext .

but my answer does'nt ok.

[Former Member]

hi .thank you so much

i need cost center group and cost element group and link between cost center and cost group.

[raymond_giuseppi]

Perform some search on FM like G_SET_LIST_SELECT, G_SET_GET_INFO, G_SET_GET_ID_FROM_NAME and G_SET_TREE_IMPORT.

Regards,

Raymond