Where is the Price Table?

[Former Member]

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.

[Former Member]

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

[Former Member]

Try looking at A005, A990 for Sales Orders and

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

[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.

[Former Member]

try MBEW table for Material Valuation.

(I suppose you are talking about materil price.)

[Former Member]

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.

[Former Member]

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

[Former Member]

Dorian,

Is the VISIO flow chart already available for download? Please advise.

David, Alberto y el otro colega, son Espanoles?

Message was edited by: Francisco Verdesoto

[Former Member]

Efectivamente... de BCN concretamente

saludos desde la playita:-),

David R.

[Former Member]

Me gustaria adventurar por España algun dia en el ambiente SAP, ¿ me lo recomiendas? ¿Tienes mensagero?

[Former Member]

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

[Former Member]

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.

[Former Member]

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