Revenue for a material for a period

[sathishkumar_arugakeerthi]

How can we find the revenue for a material for a particular period? Is there a standard report that shows the billing data for material with the list of customers

Edited by: SATHISH KUMAR ARUGA KEERTHI on Sep 25, 2009 9:08 AM

[Former Member · Accepted solution]

Hi,

Go to below Menu path in Easy Access Menu and see whether you can use any of those reports provided.

Information Systems -> Logistics -> Sales and distribution -> Material

Under "Information Systems -> Logistics -> Sales and distribution" node you can see lot of analysis,

Check each and see.

Best regards,

Anupa

[Former Member]

There are various sales reports go in initial screen not in spro under sales information system u will find various sales reports based on material and period

Ahmed

[sathishkumar_arugakeerthi]

Hello Gurus,

Thanks for your response. Sorry for not replying back.

I still do not able to find the exact report matching my requirements.

Ahmed,

Could you pls tell me the Tcode. I do not find the revenue (Billing) report for List of materials/ Period under Sales information system.

Thanks

Sathish

[Former Member]

Hi Satish

Please try MC2 and MCQ.

This might help you.

[Former Member]

Hi Satish

Exactly based on material is not possible. For this you require FI consultants help to do some configuration.

Else you can check sales based on Plant, profit center. You can check revenues for the plant assigned to your material.

For this goto FBL3N t code.Click on "Dynamic selection" button (SHIFT + F4).

Select Plant there and enter plant number. Press F8.

try and revert

[Former Member]

use the report VF05N.

[claudia_neudeck]

Dear Customer,

you can check the following tables:

VBREVK: Control lines

Each sales document item (type A, B) has 2 control lines (per G/L account)

Each invoice item (type D) has 1 control line (per G/L account)

Her it hows total accrual value, account balance, revenue amount, processing status

VBREVE: detail lines

Each sales document item has revenue detail lines for different periods (per revenue account) representing the revenue forecast

Revenue account, posting period, amount, processing status

VBREVR: reference document lines

Each document line item of the subsequent Invoice or Cancellation

Accounts, amounts

I hope that the information are helpful.

With best regards

Claudia Neudeck