Stock report for Depots

[Former Member]

Hi

We got a requirement to develop a report for depot , for a particular given period of time say suppose jan to march 2009 the depot want to see the stock details with value like

if they run the report for jan to march , system should show the opening stock of january 1st and the receipts happened in the 3 months and the issues happened in the 3 months and the cllosing balence of march 31st . system should show stock as wel as value (inclusive of excise duties)

we actually checked MB5B tcode in which all the details we get from the report , but system is giving dump because we have huge data and materials . So we cannot use MB5B for this data . and we created one Z programme calling MB5B in the background to extract the Opening stock for a material . Even that report also not working because of MB5B.

Is there any workaround to get the opening stock or can we develop this through LIS . If any workaround is possible or if it can be done through LIS please suggest . Important Note : in the value excise to be included and come

[Former Member · Accepted solution]

Assuming that RG23D register gets updated correctly, you could use the TCode J1IDEPOTSTOCK1 for getting the values.

You can check table J_1IRG23D.

Regards,

Aroop

[Former Member]

Hi Pradeep,

You use the TCode J1IDEPOTSTOCK1, here you can get the stock based on period, plants, excise group, series group and based on excise invoice no/bill of entry no.

Thanks,

Swamy H P