Skip to Content
avatar image
Former Member

VK13 - Price Conditions. How to export data ?

Hi,

The VK13 display price condition records. After enter the type condition, a popup window appear to choose the key combination.

Then, the condition list is generated in a table control.

I need to export this values to Excel, but the program don't have this option.

Another user request is to choose more then one key combination in the popup list.

I wanna know the best way to do that... creating a report for this values ?

Can I use some BAPI, FM to get price conditions ?

Thanks !

Sidney

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 10, 2006 at 06:57 PM

    Hi Sidney,

    You can use FM CONDITION_RECORD_READ.

    Also have you looked standard pricing report (transaction V/LD)?

    Hope this will help.

    Regards,

    Ferry Lianto

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      You can use transaction V/LD to generate a pricing report that can be saved to local file. You can also use this to send pricing condition IDocs to external systems under Edit->Send conditions.

  • avatar image
    Former Member
    Nov 10, 2006 at 06:48 PM

    Hi

    Try to use fm CONDITION_TABLE_ARRAY_READ

    Max

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2006 at 07:21 PM

    I think you'll need to write your own report.

    You will need to determine which access sequence your condition type is assigned to (table t685), then you'll need all condition tables assigned to this access sequence (table t682i). Then for each condition table you'll need to determine key fields (either from t685z or from dictionary). Then you can build your selection screen when user can provide values for different key combinations.

    You can find how SAP selects from these tables in the FM mentioned by Max.

    NOTE: if you need to write a program which can be used for any condition type you'll have to use dynamic logic which should be able to work for any condition type as you don't know in advance neither the number of condition tables nor the key fields combination.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2006 at 07:26 PM

    Thank you guys !

    The V/LD transaction seems to solve the problem.

    I'm checknig how exactly customizing a report.

    Very thanks,

    Sidney

    Add comment
    10|10000 characters needed characters exceeded