Skip to Content
avatar image
Former Member

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

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

scn2.PNG (14.8 kB)
for scn.PNG (38.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 29, 2015 at 06:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member HITESH GAVANDE

      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.

  • Oct 30, 2015 at 03:02 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded