Skip to Content

Function to get the standard sales price

Dear all,

is there a bapi/function I can call to get the standard sales price of an article?

Kind regards

Roman

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 01:39 AM

    Hi~ Roman

    There is a fuction for it.

        CALL FUNCTION 'PRICING'
             EXPORTING
                  COMM_HEAD_I      = TKOMK
                  COMM_ITEM_I      = TKOMP
                  CALCULATION_TYPE = PREISFINDUNGSART
             IMPORTING
                  COMM_HEAD_E      = TKOMK
                  COMM_ITEM_E      = TKOMP
             TABLES
                  TKOMV            = XKOMV
                  SVBAP            = UVBAP.

    this fuction is standard function. you can find it when you debug T-code 'VA01'.

    it returns like this.

    table tkomv

    100 000010 011 01 V <b>ZU01</b> 2005.10.16 C 10.00 11.80 KRW 1.00000 1 EA 1 1 X A 30 0021410014 01

    100 000010 100 01 V <b>NETW</b> 2005.10.16 G 10.00 0.00 KRW 1.00000 1 EA 0 0 L A 00 00

    100 000010 915 01 V <b>MWST</b> 2005.10.16 A 11.80 100.00 0 0 0 D A X 10 0000006903 01

    100 000010 940 01 V <b>VPRS</b> 2005.10.16 C 10.00 9,900.00 KRW 1.00000 1,000 EA 1 1 G X A 00 00

    as you can see condition type zu01, netw, mwst, vprs has it's own prices.

    Try to debug it.

    <b>With program : SAPFV45P
         include : FV45PF0P_PREISFINDUNG
         fuction : PRICING</b>

    and look at parameters.

    I wish I could help you.

    good luck

    Regards

    Kyung Woo.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Roman Becker

      Hi~ Roman.

      maybe, looks like your issue is mass uploading or downloading.

      In that case, I don't think there is function for it.

      maybe, you have to find price using your own made RFC Function module.

      My company provide web service( kind of order system).

      my customers connect web and order some items.

      SAP system and web system has it's own Database. so I have to export material master and prising infomation from SAP to web.

      so I made a RFC function module.

      it import condition type and export price(in my case, condition type 'ZU01'). it scan tables(prising table).

      and returns prices.

      In case of condition 'PR00'(you have to check your IMG(pricing procedure), access sequence is 'PR02'(in my case).

      it's table scan order is A305, A306, A304.

      - read knumh and find it in table KONP.

      if your systems is same to me, your code will be like this.

      1) SELECT SINGLE KNUMH INTO L_KNUMH
                 FROM A305 
                WHERE KAPPL = 'V'
                  AND KSCHL = 'PR00'
                  AND VKORG = sales organzation
                  AND VTWEG = distribution channel
                  AND KUNNR = customer code
                  AND MATNR = material code
                  AND KFRST = ' '
                  AND DATBI >= delivery date
                  AND DATAB <= delivery date.
         and scan A306, and scan A304
      2) find price in table KONP
        SELECT SINGLE KBETR KPEIN KMEIN
          INTO .....
          FROM KONP 
         WHERE KNUMH = 
           AND LOEVM_KO ne 'X'.  "check whether it was deleted or not.

      I wish I could help you

      good luck

      Best regards

      Kyung Woo

  • Posted on Oct 12, 2005 at 05:32 PM

    I don't know if there is something like a standard sales price? There is the standard price of an article(material) and then there will be the sales price which cannot be determined until a sales order is created.

    Which one are you looking for? If you see it in some transaction, which transaction do you see it in?

    Please let us know.

    Srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2005 at 09:37 PM

    If this is about a catalogue try this 'BAPI_PRICECATALOGUE_GETDETAIL'

    Add a comment
    10|10000 characters needed characters exceeded

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.