topic Re: Report-Logic in Application Development and Automation Discussions

Report-Logic

Former Member — Mon, 03 Nov 2008 07:05:53 GMT

Moderator message: please use a more meaningful subject in future.

Hi Experts,

My Requirement is That,i Should get all the Sales Orders which are not invoiced in my report.I am using Tables VBAP and VBFA,i am getting all the invoices which are raised,but i want the one which are not raised,Is there any other table which contains sales orders which are not invoiced..how to get these invoices in Select Statement.

Thanks in Advance.

With Regards,

Sharmishta.

Re: Report-Logic

Former Member — Mon, 03 Nov 2008 07:10:53 GMT

Hi,

check tables VBRP and VBRK.

if EXNUM field has value, it is raise. if no, not raised. There is a field to check status, it should be C if raised, else other.

Re: Report-Logic

Former Member — Mon, 03 Nov 2008 07:12:07 GMT

check VBUK-ABSTK.it will give rejection status of invoice.

Re: Report-Logic

Former Member — Mon, 03 Nov 2008 08:26:20 GMT

Hi,

I have checked VBRK and VBRP Tables.

Even checked the VBUK Table also.

But i has not solved my problem.

Re: Report-Logic

Former Member — Mon, 03 Nov 2008 08:33:09 GMT

Hi,

I found the following info related to Sales order:

SAP SD Relationship between sales order number, delivery number and billing number tables

VBELN is the field name in the tables of VBAK (sales order), LIKP (delivery) and VBRK (billing).
VBFA table provides links between preceeding (sales document) and subsequent (delivery) documents.
in VBFA table a delivery can be a preceeding document to an invoice(subsequent document) 

Document number can be found within the transaction table.
in the delivery : field VGBEL contain the sales order number.
in the invoice : field VGBEL contain the delivery number & field VBELV contain sales order number.

Hope this is useful.

Regards,

Saba