cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory report creation for Current month, Previous month,Previous quarter,previous year

joice_samuel
Explorer
0 Kudos

Hi Guru,

I am working on Inventory report.

I've some queries.

1. In my query output, I'm not getting Quantity total Stock(0TOTALSTCK).

2. If I'm executing my query I want to show current month, previous month, previous quarter & last year stock data

Please help.

Regards,

Joice

Accepted Solutions (1)

Accepted Solutions (1)

former_member183519
Contributor
0 Kudos

Hi Joice,

1) what is exception aggreation and ref. char. for 0TOTALSTCK ?

2) For CC 'SADAF' is there any material movement happend during period of may 10-aug 11, baecuse i think if there is no material movement then 0total stock for that period will be zero (pls validate)

3) check oss note 360249 (in your case is it required to mantain validity table ??)

4) have u run prog program SAP_REPOINT_COMPLETE after taking opening balance (BX ) ??

refer link:

Regards,

Hitesh

joice_samuel
Explorer
0 Kudos

Hi Hitesh,

Thanks for the reply.

For 0TOTALSTCK,

Then how to check,material movement happened or not? because I'm using dev. system.

Regards,

Joice

former_member183519
Contributor
0 Kudos

Hello Joice,

In BF, there is a field BWART, which is for Movement type.

In ecc there is a table T156 which stores movemnt type info.

pls check with mm functional for more details.

have u run program mentioned in 4th point after taking opening  bal. ?

also, is there any filter in bex ?

Regards,

Hitesh

joice_samuel
Explorer
0 Kudos

Hello Hitesh,

I didn't run that programme. I've tried to run that programme in bw se38. but its showing no programme exist. this step is right or not? and  In bex query there is no filter.

Answers (1)

Answers (1)

former_member976
Active Contributor
0 Kudos

HI,

1 .can you show me the cube output for the Quantity total Stock(0TOTALSTCK).

if it is cube level is coming it should come in report.

ex-  take 1 material, movement type ,plant, PO check the (0TOTALSTCK).for cube output.

with same slection run the report.

Thanks,

Phani.