VK13 - Price Conditions. How to export data ?

[Former Member]

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

[Former Member]

Hi

Try to use fm CONDITION_TABLE_ARRAY_READ

Max

[ferry_lianto]

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

[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.

[Former Member]

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.

[Former Member]

Thank you guys !

The V/LD transaction seems to solve the problem.

I'm checknig how exactly customizing a report.

Very thanks,

Sidney