In Which table Cost Price of Items stored in SAP?

[Former Member]

Hi Friends,

I am extracting Items details using DI API.

I want the cost price of items purchased? In which table

the cost Prices stored? And What is the Price which is

displayed in SAP B1 Item master data?

[Former Member · Accepted solution]

Hi Sooriya,

There are three calculation metods in SBO.

You find Basic Init. under menu Administration | System Init...

1. Moving avarage

2. Standard

3. FIFO

If I understand you correctly - you need to find costprice per item in stock.

I think there is not such possibility - The only way to find such link between Sales Order/Purchase Order is that user generate PO when creating SO. This way Base/Target document link is established. You need to make a join query of Sales Order/Purchase Order to find the linked costprice of the item.

Value AvgPrice in item wareh.table is only a calculated or fixed value.

Hope this helps something.

-Regards,

Geir

[Former Member]

Hi Sooriya,

I´m not sure about this, but from the help file:

Items AvgStdPrice property: Sets or returns the Item Cost. (field name: AvgPrice).

In the item master data, the displayed price is alphabetically the first one.

Hope helps,

Ibai Peñ

[Former Member]

Hi Ibai,

Thanks for ur reply!

Yah i want to know what is that price listed,whether it is cost price or selling price in Item master data .

Please help me to know more about item cost price and selling price tables in SAP.