Stock Overview In Sap Date Wise
SAP Production Planning Table. Demand Management. MMBE STOCK OVERVIEW. MMPV CLOSE PERIOD. OPPP Explode BOM by date.
How can I find what was the available stock on a specific date in the past?I know how to get OnHand for any date in the past: SELECT LocType, LocCode, ItemCode, SUM(InQty-OutQty) OnHandFrom OIVLWhere DocDate. CREATE FUNCTION dbo.ufnStockAndCostHistory(@EndDate DATETIME, @ItemCode NVARCHAR(255) = 'All')RETURNS TABLEASRETURN(WITH Cost AS (SELECTOINM.TransNum,OINM.ItemCode,OINM.Warehouse,OINM.Balance,OINM.CreateDateFROM OINM (NOLOCK)JOIN OITM (NOLOCK) ON OITM.ItemCode = OINM.ItemCodeJOIN OITB (NOLOCK) ON OITM.ItmsGrpCod=OITB.ItmsGrpCodWHERE OINM.CreateDate 0OR ISNULL(q.Qty,0) 0))Usage would look like: SELECT.FROM ufnStockAndCostHistory('9/15/2017','B107A-12HB').
AdvertisementLarge companies having many plants in different geographical locations commonly require stock movement from one plant to another. For this purpose, SAP ERP has a special process with SAP stock transport order (STO) that enables to move stock from one plant to another or between different storage locations of plants.For example, in one of my trading client, we used to import materials from abroad in big containers and then those containers were unloaded into one big branch (plant) as it was cost efficient to import materials in bulk to one location.
Stock Overview In Sap Date Wise Images
Next, other smaller branches (plans) raised SAP stock transport order (STO) to purchase stock from big branch for the quantity required. The big branch dispatched the quantity against the STO on the mentioned delivery dates. AdvertisementIn the below screenshot, you can see a diagram illustrating the stock transfer process.
Stock Overview In Sap Date Wise Texas
STO is raised by a receiving plant and sent to a supplying plant. The supplying plant then delivers the material, which in the SAP system will be shown as stock in transit.
When the receiving plant receives the material, goods receipt takes place at the receiving plant. There is no invoicing, as the stock is transferred between plant that are part of the same company. Stock Transfer with SAP Stock Transfer Order (Example) How to Create SAP Stock Transport Order?To create a stock transport order in SAP, please follow the steps described below.
First, either start the transaction ME21N or navigate to the following path in SAP menu: Logistics – Materials Management – Purchasing – Purchase Order – Create – ME21N – Vendor/Supplying Plant Known.Menu Path for ME21N TransactionStock transfer process uses the standard transaction ME21N for creating purchase orders (PO), where we trigger STO process by selecting document type = Stock Transport Order as shown on the screenshots below.ME21N – Create a Purchase Order Select Stock Transport Order as the Document TypeHere you need to provide your supplying plant. As mentioned above, the supplying plant in our example is the big branch which imported the stock and has stock available. You also have to provide your purchase organization, purchase group and company code as show on the screenshot below.