Table & Field Name

[Former Member]

Helo SAP Experts,

My client is required Consumption report. In that I need to give inputs ABAPers, total quantity consumed and total value consumed table name and field name to get different output in SAP Screen.

Thanks and regards,

babu

[Former Member · Accepted solution]

Hi,

Material consumption for special stocks (Project stock,sale order stock,network)can be seen in CJI3.In MB5B can get material wise GRs , GIs and remaining stock. Use MB51 give Mvt type and reversal movement type, you will get the report. But there is no direct report for consumption. I hope it will help you. Thanking you.

[former_member564225]

Helo SAP Experts,
> 
> My client is required Consumption report. In that I need to give inputs ABAPers, total quantity consumed and total value consumed table name and field name to get different output in SAP Screen.
> 
> 
> Thanks and regards,
> babu

Hi Babu,

You can build a query to get this report with an ifoset containing LDB I3L to pull data from MSEG and required fields.

Hope it helps

Shiva

[former_member329706]

You can fetch the requried data from MSEG table using movement type 201 and 261.

[Former Member]

Can you tell exact table name and field name.

[Former Member]

Can you tell exact table name and field name.

[former_member564225]

Hi,

Use MSEG-MBLNR, MSEG-BWART, MSEG-DMBTR

(Or any other additional fields as you require)

Shiva

[former_member329706]

Goto SE16N and enter the table MSEG there you can check the fields based on your material number,plant,Movement type,total qty and value.Go can add the logic for in report like based on number of days of consumption but add the date limitation in selection screen for two to three months as the report performance will be down.