Skip to Content
avatar image
Former Member

Pricing data based on Customer, product hierarchy, customer and material

Dear all,

My client works on SD Pricing and rebates and the Condition types are based on Customer hierarchy, Product hierarchy, Customer and Material. I have to extract the current pricing data from the system.. Please let me know what are the tables and links between them to extract the data..

Plz explain what is meant by Pricing set up based on Pricing level and Material/ Sales BOM level.

Award pts for useful answers..

Thanks

C Mehra..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 18, 2007 at 02:25 AM

    Hi,

    Do you already have pricing determined for each material?

    If so, check VK13 to see what kind of access sequence is used for determining the price.

    I assume that access sequence of 'Customer Hierachy/Product Hierachy/Customer/Material' should exist.

    Then go to SPRO to check its access sequence number.

    To check, you need to know

    1. Condition type used for your pricing.

    2. See detail of its condition type

    3. Check access sequence type assigned for its condition type

    4. Check access sequence number.

    1. SPRO>SD>Basic Functions>Pricing>Price Control>Define Condition Type>Maintain Condition Type

    2. Choose the condition type you use

    3. See the detail

    4. Note access sequence

    5. Go to SPRO>SD>Basic Functions>Pricing>Price Control>Define Access Sequence>Maintain Access Sequence

    6. Choose the access sequence you found in price condition type

    7. Find the number assigned in 'Tab'. If thee number you found is 10, that means table number is 010.

    8. Go to transaction SE16

    9. Enter table name by adding 'A' in front of the number you found on step 7. For example, if the tab number you found was 10, the table number in SE16 is A010.

    You should see all existing date with Customer hierarchy, Product hierarchy, Customer and Material, and price included.

    Let me know if this statisfied your needs.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Continue from the previous one....

      Click on the folder 10 for example, you should see which keys are determining the price. (Maybe you also know this?)

      Or if you have an access to SQVI or SQ01 and create query?

      Let me know if you could solve this problem by this way....

      Regards,

  • avatar image
    Former Member
    Dec 18, 2007 at 08:24 PM

    hi

    check tables for customer hierarchy "A064 AND A065' AND

    for product hierarchy "A148" A146

    AND THE FIELDS ARE

    KSCHL FOR CONDITION TYPE

    VKORG FOR SALES ORGANISATION

    VTWEG FOR DISTRIBUTION CHANNEL

    KNUMH CONDITION RECORD NO

    Edited by: Prashanth Goud on Dec 19, 2007 2:01 AM

    Add comment
    10|10000 characters needed characters exceeded