Skip to Content
0
Former Member
Nov 20, 2008 at 06:42 AM

Opening Stock Comapny - Plant - Material - Batch - Storage location Wise

26 Views

Dear Friends,

I want to do the following report. I will explain the details to you. Pleaes suggest on how to go about it.

1. Since you know that SAP stores stock in a summary form (Plant / Material wise). Our management wants the report on the following hierarchy. (Company - Plant - Material - Batch - Storage). Our management has suggested the following:

a. Create a ZTABLE with the above columns including Quantity (which will contain closing stock quantity).

b. In this calculate and store Closing stock for each month.

c. an insert / update program has to be created for uploading data in the ZTABLE (selection will contain date).

for ex:

When running the program for 31st March 2008. system will take the closing stock stored in the ZTABLE for previous months + March Receipt - March issues. the result will be the closing stock for March 2008.

d. Then a report will be prepared using the ZTABLE and other calculated fields.

Can anyone give me the guideline as to how to go about it. Tables to be used and logic to be followed? Or if any other way the result can be achieved then nothing like it.

The Managements final goal is to have any given date closing stock in the above hierarchy (minimizing the Performance issue... that is why the suggestion of ZTABLE)...

Awaiting for your expert opinions.....

Regards,

Jitesh M Nair