Skip to Content
author's profile photo Former Member
Former Member

Where is the Price Table?

Hi, people look i need to make one program to display the Material-Price-Customer of each Customer of 3 division, for the SD module, but iam locking for the table that have the price for each customer, im think that for this i going top need a join, iam new on sap, and dont know what tables are going to play in this program. I search the web but dont find nothing yet, if some knows and can help me or knows about some site where i can learn i will apreciate. Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 08:05 AM

    Alberto,

    SAP has lots of tables where its data is stored. I'm not sure which table youre looking for. Since youre new to SAP I recommend you learn HOW to find tables containing the data you require.

    There are several ways. Here's three of them:

    - Have the speccer tell you which fields you should use.

    - The data you require is also used in standard SAP transactions (programs). By selecting the field on the screen and pressing help you MAY be able to find the fieldname thus the table name.

    - Start a SQL trace. Run the standard SAP transactions (programs). Stop the SQL trace and analyse the trace.

    There are other ways as well.

    Good luck!

    Harald

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 08:45 AM

    Alberto.

    Te contesto en español porque creo que por tu nombre me entenderas.

    Lo que te han pedido es una locura ( si es que creo entender lo que te piden ), veo por lo que dices que eres nuevo en SAP pero el que te ha pedido los precios de material por cliente debiera saber que esto depende de muchas cosas y no son fijos, a no ser que quiera otra cosa...

    El consultor de SD debe ver los informes standar de SAP que den respuesta a esto, que los hay.

    En cualquier caso si tú caso fuese el más fácil posible date una vuelta por las tablas A0* ( A005 )y las tablas KON* ( KONK Y KONP ) que se relacionan por el campo KNUMH que es el registro de condición. Pero bueno esto es lo básico vas a tener que dar muchas vueltas y aún así difícilmente saldrá todo bien.

    Ya te digo que hacer un programa que acierte al 100% con esto es una locura ( a lo mejor vuestro sistema de ventas es de lo más sencillo y es posible ), si no, pásale la pelota al consultor que es su trabajo dar respuesta a esto.

    Salu2.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 10:29 AM

    Try to use BAPI_SALESORDER_SIMULATE,

    it simulates the creation of a sales order (pedido de venta) and returns prices of each item of the order.

    But that it is not easy to use, you need a functional

    consultant that should help you

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 01:47 PM

    I know is offtopic but I can't avoid it!!!

    Alberto,

    Tienes mas razón QUE UN SANTO!!!

    Hay por ahí consultores funcionales con más morro que espalda que no tienen ni pt idea de que hablan pero encima tienen la jeta de ir vacilando a los desarrolladores pidiendo estupideces!!!!

    (ufff! Que a gusto me he quedado)!!!

    Once again Mr. Moderator, excuse the offtopic.

    regards to everybody,

    David Rodríguez

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 04:30 PM

    Guys:

    Unfortunately, it's not that simple!

    Ultimately, actual prices are stored in the following tables (Note: R/3 only - CRM tables are different!):

    KONH is the header table for price per unit item;

    KONP is the detail table for price per unit item;

    KONM is the modified quantity scale price;

    KONW is the modified value scale price;

    KONV is the "actual" document line item price.

    However, to get to the correct records in these tables, you need to run through a pricing process. At a high level, you start with a pricing procedure. the pricing procedure points you to several pricing condition types. the condition types in turn point you to a set of access sequence tables, which in turn contain pointers to records in KONH / KONP / KONM / KONW. The records in these tables are read and data used to calculate a price; this calculated price is then written to KONV. The key to KONV is written back to VBAK / VBAP document data.

    This is the process as I understand it - I may have missed something! I have submitted a Visio flow-chart of the above process to the SDN download page; this should be available shortly.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2004 at 07:23 AM

    try MBEW table for Material Valuation.

    (I suppose you are talking about materil price.)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2004 at 06:28 AM

    Try looking at A005, A990 for Sales Orders and

    A906, A908, A966, A967 and A997 for Sales Contracts

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Buenas,

      Alberto no se como acabó tu historia, pero yo estoy utilizando la BAPI a traves del Business Connector y en teoria me devuelve los precios a traves de la ORDERS_ITEM_OUT y de la ORDER_CONDITION_EX. No se si esto te servira de algo. En cuanto a la ORDER_INCOMPLETE no se cual es su mision, pero me informa de unos datos en la VBAP sobre el Precio Neto, aunque es imposible recuperar algun dato coherente de esta tabla sobre el pedido simulado. Alguien sabe algo de esto??

      Gracias.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 04:42 PM

    Hi,

    Pricing in SD can be maintained in various combinations like:

    Material

    Customer/Material

    Division/Customer

    and likewise.

    You can use the transaction V/05 and press F4 to have a look at how many condition tables have been created.

    Basically these condition tables are used to store pricing in various combinations and the pricing gets picked up as per the price determination procedure defined in the customizing.

    These are all A series tables i.e. if you want Customer/Material Table (table no. 5) then you have to go to se16 and look into A005.

    I hope this gives you fair idea of how to get the required data.

    regards,

    Satyadev Dutta

    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.