billing report

[Former Member]

Dear Experts,

please we need to generate which contains below details

payer name

destination

billing document number

outbound delivery nuber

item code

selling price

quantity

total selling price

[suman_sardar2 · Accepted solution]

Hi,

There is no standard report to meet your requirement.

I would suggest for simple SQVI and if it gradually require more info then try for SAP Query (SQ01/02/03).Also you can go for Zdevelopment.

You can use of following tables;

1. VBRK
2. VBRP
3. LIKP
4. LIPS
5. KONV

Thanks,

Suman$

[Former Member · Accepted solution]

Hi Suman,

Can you send me the screen shots to develop above table.

Regards,

jamsheer

[suman_sardar2 · Accepted solution]

Hello,

Are you asking to make a report in SQVI?

Please find the below link to prepare the SQVI report.

http://scn.sap.com/thread/733030

http://www.sap-press.de/download/dateien/2423/sappress_sap_query_reporting.pdf

http://help.sap.com/saphelp_nw04/helpdata/en/d1/44f2b5c7f411d296080000e82de14a/frameset.htm

http://www.sappoint.com/abap/ab4query.pdf

Please try to create your own query in SQVI, also note that SQVI you have to create it in the Production server and after executing the report click on the System >>> Status and note the Program name and try to create a Tcode in the DEV server and transport the same to the PRD server.

Try a hands on its not very difficult.You will enjoy it doing

Thanks,

Suman$

[Former Member · Accepted solution]

Hi Suman

the 4th link i cannot open. please upload it again.

Regards,

jamsheer

[balaji_parsewar · Accepted solution]

Hello Suman,

Use of SQVI query will hamper system performance.

Hence use of SQVI query for multi-column reports is not advisable.

After creating query, just check the results. If he results are desirable then just carry same logic & hand over to ABAP consultant for creation of Z report. Its a better idea.

Regards,

Balaji

[Former Member]

hi mohamed Jamsheer,

for this u have to make z report with the help of apaper , n u can make functional specification with help of table n field names

sales order header/item    : vbrk/ vbrp

dly doc header/item          : likp/lips

n billing header/item         : vbrk / vbrp

[balaji_parsewar]

Hi Vicky,

Sales order header/item - vbak/vbap

Regards,

Balaji

[Former Member]

Hi Vicky

please attach screan shots.

Regards,

Jamsheer

[Former Member]

Hi,

you can achieve this with the zdevelopment with the table VBFA by passing the customerr number and date as inputs.

Regards

Ratnamsree

[eduardo_hinojosa]

Hi

You can try to do it with transaction VF05. You can enhance it with the help of notes SAP Note 350068 - Additionl fields in VA05:Customer material number as example and SAP Note 398575 - List of billing docs: Accounting document number is missing, if you don't find the fields in the standard VF05.

I hope this helps you

Regards

Eduardo