Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

In Which table Cost Price of Items stored in SAP?

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?

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question