topic Re: Problem in fetching invoice data from VBRK table. in Application Development and Automation Discussions

Problem in fetching invoice data from VBRK table.

Former Member — Mon, 08 Dec 2008 05:42:25 GMT

Hi guys,

I am developing an ABAP program where I have to fetch the invoice data from VBRK and VBRP based on the PO data or SO data in table LIPS. But I am not been able to link the two tables. Can anyone please suggest what are the PO and SO fields in VBRK or how to get the invoice data from VBRK and VBRP based on the Sales Order or Purchase Order number from LIPS. Thanks in advance.

Re: Problem in fetching invoice data from VBRK table.

GauthamV — Mon, 08 Dec 2008 05:54:43 GMT

hi,

use this link between sales order and invoice.

VBRP-AUBEL = VBAK-VBELN

VBRP-AUPOS = VBAP-POSNR.

Re: Problem in fetching invoice data from VBRK table.

Former Member — Mon, 08 Dec 2008 05:58:26 GMT

HI,

You can relate the PO or SO to invoice from the table VBFA.

Regards,

Anand.

Re: Problem in fetching invoice data from VBRK table.

Former Member — Mon, 08 Dec 2008 06:06:38 GMT

example:-

VBRK & VBRP

select b~vbeln

b~posnr

a~fkdat

a~spart

a~kunag

a~vkorg

a~rfbsk

a~fkart

a~vtweg

a~bzirk

a~kurrf

a~waerk

a~knumv

b~fkimg

b~netwr

b~mwsbp

b~matnr

b~arktx

b~prodh

b~vkgrp

b~ktgrm

b~aubel

b~matnr

into corresponding fields of table itab

from vbrk as a inner join vbrp as b

on a_{vbeln = b}vbeln

where a~kunrg in p_cust and

a~fkdat in p_date and

a~spart in p_dev and

a~vkorg in p_vkorg and

a~vtweg in p_vtweg and

a~rfbsk in p_rfbsk and

a~regio in p_regio and

a~fkart in p_type and

b~werks in s_werks and

b~matnr in matnr.