Skip to Content
author's profile photo Former Member
Former Member

How to find the table names and Data types for the S_ALR_87013611 report

Hi SAP Experts,

I need/customer wants summary report by Cost Element i.e

SKFActual(SKF Qty)Cost CenterCostElementDollars+Report Currency.

First 2 fields (SKF+Actual - SKF Qty) we got from S_ALR_87013611 report. Then we double clicked on SKF then it will take to KSB1 transaction code there we got the rest of the fields.

Currently we are developing the same Custom Report but it should show by summary i.e by Cost Element.

It should show in 1 report the above 6 fileds.

Could you please tell me what Tables and Data types I need to refer? Also Could you please tell how to see the table names and fields used for the above report.

Thanks for your help in advace.

Thanking you

Regards,

Raj

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Apr 09, 2008 at 02:32 PM

    use table cosp you can derive fields controlling area and cost centre from field objnr

    A.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 03:09 PM

    Hi David,

    Try the following tables:

    COSP, COSS, COSPP, COSSP, COSL, COSR, CCR1S, CCSS, CCR1Z

    This S_ALR_87013611 is a Report Writer report. These kind of reports are not created using SE38 / SE80. There are certain TCodes using which you create / change / display these kind of reports.

    1. First Execute the TCode - GRR3.

    2. It will display you the Library and Description columns.

    3. Under Library open 1VK (Cost Centers: Absorption Costing)

    4. Double click on 1SIP-001. This is the report which gets executed when you run S_ALR_87013611.

    5. You can also try 1SO1-003 which consists of Cost Element.

    Hope this is useful to you. Reward accordingly.

    Thanks and Regards,

    Maddineni Bharath.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.