SAP report with sales (invoices) and cost of goods sold

[stevejohnson]

Is there standard SAP report that would show list of invoices, the materials sold, and the cost of goods sold (for how much they were bought)?

[former_member209761]

Dear sapfan22222222

If it is a one time activity, the please do the following.

SE11 , put the table VBRK and execute (you may use selection criteria like DATE o BILLING DATE if there is any specific data which you are trying to extract.)

VBRK-VBELN will give you the list of invoices.

You can download the same into spreadsheet.

Now copy the VBELN entries from the spreadsheet and put it in SE11 of VBRP as VBELN.

VBRP-MATNR will give you the material sold.

Download the same into 2nd spreadsheet

your cost of goods sold will be coming in the pricing procedure against any condition type.

So in VBRK which you have extracted earlier, you will find VBRK-KNUMV

Put that KNUMV in KONV table (put KSCHL= your condition type which shows the cost of goods sold).

Download that also as a spreadsheet.

Now you may combine these 3 spreadsheet with the help of someone who is an expert in excel and get the required data.

(BILLING NO FROM FIRST EXCEL , MATERIAL FROM 2ND EXCEL AND COST OF GOODS SOLD FROM 3RD EXCEL)

Check and revert back.

Thanks & Regards,

Hegal K Charles

[eduardo_hinojosa]

Hi

You can enhance the tcode VF05. Please, see these notes:

SAP Note 350068 - Additionl fields in VA05:Customer material number as example

SAP Note 398575 - List of billing docs: Accounting document number is missing

You can populate the cost in one of the KZWIx field (x is 1 to 6) or in an additional KZWIx field (see SAP Note 155012 - Further subtotal fields in pricing).

I hope this helps you

Regards

Eduardo

[former_member209761]

Dear sapfan22222222 ,

For your requirement, please develop a QUERY with table VBRK & VBRP .

Also if your cost price is reflecting in any condition type, you may link it to KONV table to get the value by giving the appropriate condition type as KSCHL.

Thanks & Regards,

Hegal K Charles

[stevejohnson]

But where I would see cost of goods sold in these tables? It should come from the MM invoice for the same material. And we don't have Batch Management for inventory, so is it even possible?

[former_member217082]

Hi

Since the Cost of Goods Sold value has to come from SAP MM records, so instead of developing a query it is advised to develop a Z report using LIS.

Regards

Srinath

[stevejohnson]

Is it possible to extract the data from tables, rather than creating Z report (as it is one time need). From which table I can get the cost of goods sold for corresponding sales invoices?

[former_member217082]

Hi

It is possible to extract the data from the tables but rather than extracting the data from tables it will be easy to create a

Z report.even though it is a one time need.While creating a Z report you can use VBAP and KONV tables

Regards

Srinath

[former_member217082]

Hi

There is no standard SAP Report which shows list of invoices,materials sold and the Cost of Goods Sold.So it is advised to create a Z report.There are some standard reports of t.code MC+Q which shows Cost of goods sold.

Regards

Srinath