pricing report

[Former Member]

Hi,

In sales order condition tab ZTAX condition type (which is a tax cond type) has got picked up TWICE Ie., 2 lines are coming as

ZTAX 5%  100

ZTAX 5%    50

i need to extract a report to find all the orders having double ZTAX condition types picked up at sales order Header level

Can you pls. let me know is there any report for this or from which tables i can extract this data for sales order header?

pls. suggest.

[Former Member]

Hello

Simply ...You can create the SAP Query in directly in the production through transaction code : SQVI with Logical data based "VAV" you can choose the condition type in the input..

Regards

Sohan Bhavsar

[Former Member]

Hello Sapper,

Just try this, In VBAK table give your Sales Document in VBELN field and get KNUMV from there. Now pass this value of KNUMV in KONV table in order to fetch the condition value from KWERT and condition type from KSCHL. Also, you can trying developing an Z-report by using this FM CONDITION_RECORD_READ with the help of your developer. Hope this helps. Thanks and ve a good day.

[former_member216345]

If the condition is a header condition than it must be a manual entry, since condition records cannot be created for header conditions. You can go to pricing tab and click on analysis buttton where each condition type will be shown with a detail analysis view.

Please check and let me know if this was  helpful.

[Former Member]

for each sales order condition record number (vbak-knumv) you can check if table KONV has double entries for cond. type ZTAX. im not sure about standard report but its not a big task to develop such custom report in ABAP. pls consult with your technical team for same.

Rgds

[kyusufzai]

Hi

  There is no std report available however you can use  below tables.

Fetch  sales order and their KNUMV(Doc. condition) from table VBAK

insert KNUMV found in above step into KNUMV Field of KONV table.

You can easily consolidate them in excel sheet by VLOOKUP function.

Please let me know if you need anything else.

Reward if useful.

Thanks

Kashif