cancel
Showing results for 
Search instead for 
Did you mean: 

Stock balances by Profit centre-New GL

Former Member
0 Kudos

Hi,

Is there any standard FI report by which I can get the stock/material/inventory balances by profit centre and segment. We are in ECC 6.0 with new GL activated.

If there is no standard report, can this be acheived by using a ABAP query by table join.If yes, please let me know the tables to consider.

Thanks

Aravind

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Got a Z report done.

Former Member
0 Kudos

Hi Aravind,

May be you can try an ABAP query using the tables MARA, MARC and MBEW

Regards,

Mike

Former Member
0 Kudos

Hi,

I have developed a query using the above tables. The problem is the query outputs all the entries from MBEW table. I want only the current value.Any inputs on this.

Thanks

Aravind

0 Kudos

Try the report S_E38_98000088 - Profit Center Group: Plan/Actual/Variance for your inventory accounts. This will give you stock values by profit center. Leave the profit center value blank in the selection criterial. Run MB5L for stock values by inventory account and then double click the account to get the stock values by material.

FAGL_FLEXT, MBEW and MARC can be joined to get the values.

Former Member
0 Kudos

Hi,

Please let me know if any further inputs. There is no PC to plant relation in our case.

Aravind

Former Member
0 Kudos

Hi,

As you would have defined each Plant as a profit center, you can see the inventory list through MMBE or through MB5L

Best Regards,

Sadashivan