topic Re: Link Between VBRK and VBFA in Application Development and Automation Discussions

Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 12:30:09 GMT

Dear Gurus,

Here I got some Requirement where I am getting all the Deliveries but the User wants only Invoiced Deliveries. For achieving the same what should I do?

Suggest Me if I am analyzing correct r wrong.

Get the INVOICE DETAILS from VBRK, for the corresponding Values get the PRECEDING DOC NO from VBFA Table with VBTYP_N = "m".

Am I doing correct????

Ur Inputs are Valued....

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 12:41:19 GMT

No, read SAP Note 185530 for correct document index table to read for invoice documents (these include VRKPA, VRPMA...read the Note!). Once you have the list of invoices, get the preceding document from VBRP, probably in AUBEL....Look at content of VBRP fields:

VBELV

POSNV

VGBEL

VGPOS

VGTYP

AUBEL

AUPOS

AUREF

Nobody should write reporting for SD/LE without first reading the referenced SAP Note. And, we never read VBFA backward, only forward. The preceding document(s) are stored in VBRP, LIPS and VBAP.

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 12:44:26 GMT

Break Point,

Thanks for Quick Reply....

can i make a View for the above scenario, as itz going to be input for SAP BI.

Plz help Me.

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 12:52:39 GMT

View? We can make views are needed....my installation doesn't run SD, so not sure what is there but look at where VBRP / VBRK is used...you may find an existing view. And, one could join to VRKPA or VRPMA but note the differences in documents....one has only billing docs, other refers to billing doc and item, as I recall....

Do you where used on your tables, selecting only Views....you'll find several views already existing, and I'd check those to see if there's something already created that I could use, if I were writing SD/LE reporting/extracts, etc.

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 14:30:59 GMT

If you simply do a where used in views for both tables, you'll have your answer.

Rob

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 16:39:42 GMT

Hi Harsha,

Since per your requirements you only need to show the invoiced deliveries, you can also check table VBUK using the delivery number and check the billing status field (FKSTK) to find out if an invoice was created for the delivery or not.

KInd regards,

Robert

Re: Link Between VBRK and VBFA

Former Member — Fri, 04 Feb 2011 21:23:55 GMT

Why you dont use the fm RV_ORDER_FLOW_INFORMATION to get that information

Re: Link Between VBRK and VBFA

Former Member — Sat, 05 Feb 2011 06:08:06 GMT

This message was moderated.

Re: Link Between VBRK and VBFA

Former Member — Sat, 05 Feb 2011 06:29:02 GMT

Hi Harsha,

As per your requirement and my as per my understanding you do not need the details from VBFA.

As you are getting all the deliveries, check the status of the delivery in VBUK whether it has been invoiced.

If Invoiced, then display the Delivery,

For a better understanding you can view the delivery in VL03n Transaction and see the status of the delivery at the header level.

You will need the VBFA details only if you need the corresponding Invoice for a delivery which I think is not part of your requirement.

Thanks,

Rohan

Re: Link Between VBRK and VBFA

Former Member — Sat, 05 Feb 2011 08:13:39 GMT

For BI you can create database view

Re: Link Between VBRK and VBFA

uwe_schieferstein — Sat, 05 Feb 2011 10:19:24 GMT

Hello

As Juan mentioned already the fm which delivers this information is RV_ORDER_FLOW_INFORMATION.

Since this fm allows to read the document flow backwards and forwards I do not think that the statement


  And, we never read VBFA backward, only forward.  ...

is correct. However, if you start with an invoice and read forwards the fm still returns the corresponding delivery.

Regards

Uwe

Re: Link Between VBRK and VBFA

Former Member — Sat, 05 Feb 2011 12:00:23 GMT

Hi Harsha,

As Rohan mentioned use VBUK table for invoice status.

First get all sales order from seelction crietaria as per user requirements from VBAK then get all deleiveries for the sales orders from LIKP and then check in VBUK for invloce status .I think that is best way to improve performace.

If you get the invoices first , query will get all invoices which are unneccesary and need to elimate based on your sales orders or deliveries.

Hope it is usful.

Thanks,

Srikanth.A

Re: Link Between VBRK and VBFA

Former Member — Mon, 07 Feb 2011 16:36:24 GMT

Hi Srikanth,

Please read all the replies and then decide if your reply is adding any new information.

Thanks,

Robert