Skip to Content

TK13 down load list of Freight condition Records with Price

Hi,

Requirement: Want to down load the total condition records maintained for a Freight Condition type in to Excel.

Tried in TK13 by following way but system is not showing the price of condition record. It's displaying only the below fields in Excel.

if i click in each line item and click on details then able to view.

If i want to have the price along with the above fields. As per my understanding we can achieve this only with help of ABAP.

I've tried in google, but it did not help me.

Please advise if you think this can be done in another way also?

Thanks!

Capture.GIF (89.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2016 at 01:20 PM

    Hi Rakesh,

    Your requirement seems to be possible with pricing report v/la. Create your pricing report through V/LA and execute it through V/LD. Follow the below thread for creating pricing report.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90637622-7289-2c10-a3bb-f94d9fa4a5e8?QuickLink=index&…

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 16, 2016 at 11:25 AM

    Hi,

    The fastest way for a one-time solution should be: Import the contents of your table A778 form SE16 with a filter of condition type to an Excel file. Take condition record numbers (KNUMH) and fetch the records from table KONP from SE16 into another Excel. Do a simple VLOOKUP and you have your data.

    If this is a repeating requirement, you can build a simple query about this.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Thanks for your input!

      Business doesn't have access to SE16/SE16N table. Business wants to execute this report on regular basis. If it's one time requirement yes we can down load and send to business users.

      May be as you said SAP Query or ABAP report we need to develop.

      Thanks!

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.