Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Report-Logic

Former Member

‎2008 Nov 03 7:05 AM

0 Likes
782

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.

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.

Reply
4 REPLIES 4
Read only

Former Member

‎2008 Nov 03 7:10 AM

0 Likes
711

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.

Read only

Former Member
In response to Former Member

‎2008 Nov 03 8:26 AM

0 Likes
711

Hi,

I have checked VBRK and VBRP Tables.

Even checked the VBUK Table also.

But i has not solved my problem.

Read only

Former Member

‎2008 Nov 03 7:12 AM

0 Likes
711

hi

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

Read only

Former Member

‎2008 Nov 03 8:33 AM

0 Likes
711

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