List Order SAP report S_ALR_87012995

[deepak_dhamat]

Dear All  Experts  ,

i am Executing  List Order Report  S_ALR_87012995 : in this report  i am passing parameter  as given below 

Controlling Area : BFL

Fiscal Year   : 2011

From Period : 1

To Period     : 1

Plan Version : 0

Selection Group :

Order Group : BFLFCG_IO

Or value(s)

Cost Element Group : STORES

Or value(s)

After executing  report  i am getting output   but  i am not able to get from  where in program  & which table

those data comes   i.e  in columns Order the Grouping of Department is done  that TExt Field description we are getting from which table  .

such as  :**        Steel Cutting 1101  or **        Forge Shop 1102

you can check atached file  for reference  :

need help to find  the description and data from which table we get 

regards

Deepak.

[Former Member]

Dear Deepak ,

Which Tcode you have used for this List order .

Regards,

Rihan

[deepak_dhamat]

Dear  Rihan ,

i am using TCODE : S_ALR_87012995

i have done debugging  for the report  but could not find  Tables from where it gets data   .

regards

Deepak.

[deependra_shekhawat3]

Hi Deepak,

Check with SE30 or ST05 so you can get table hits while fetching data. Mainly COSP,COSS,COSSP used for fetch data.

Thanks

Deependra

[Former Member]

Dear Deepak ,

The table is COAS and filed is KTEXT      here you can get the object number (OBJNR)

and pass it to the table COSP and find the other values too.

Let me know if your requirement has been fulfilled.

Regards,

rihan

[Former Member]

Hi,

Plese check the program GPEPAUK36PL211KL4BEIGGDZGN3800.

the program is used below tables.

tables cosp                          .
tables coss                          .
tables cospp                         .
tables cossp                         .
tables ccr1s                         .
tables ccss                          .
tables ccr1z 

Let me check the exact table.

Thanks,

Kiran

[deepak_dhamat]

Hi  Kiran ,

Those are all  Structure  & not tables  .

regards

Deepak.

[deepak_dhamat]

Hi kiran ,

Out of all  tables  only   COSP,COSS have data   .

where as  the Grouping  details  i.e  Department  names where it is stored could not be found  .

regards
Deepak.

[Former Member]

let me check in detail.

Thanks,

Kiran

[Former Member]

Hi,

I agreed to Rihan, Even I have found the same situation with ST05 also.

[Former Member]

Hi Deepack,

Can you check on SE93

Regards,

Tunwiir

[deepak_dhamat]

Dear All ,

  Thanks  For your Support  .

  i have Got  the Tables used for order Grouping Description  i.e

  Setheader & setleaf   tables   .

Regards

Deepak.

[Former Member]

This message was moderated.