In Which table Cost Price of Items stored in SAP?
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?
There are three calculation metods in SBO.
You find Basic Init. under menu Administration | System Init...
1. Moving avarage
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.