Skip to Content
avatar image
Former Member

pricing report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 03, 2013 at 03:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2013 at 03:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 03, 2013 at 04:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2013 at 05:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2013 at 12:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded