11-15-2006 1:00 PM
Hi,
Can any tell me how to link invoice and Po number. Tables also.
thank you.
11-15-2006 2:02 PM
hi sarath ,,
invoice is in vbrk ---
VBRK-VBELN = VBRP-VBELN.
Now fetch
VBRP-VGBEL ,
VBRP-VGPOS . from VBRP
now
VBRP-VGBEL = LIPS-VBELN .
VBRP-VGPOS = LIPS-POSNR.
LIPS-VGBEL = VBAP-VBELN
LIPS-VGPOS = VBAP-POSNR.
VBAP-VBELN = VBAK-VBELN.
INVOICE TO SALES ..
NOW FROM SALES TO PO
VBAK-VBELN
<b>VBAK-BSTNK</b> -
> THIS IS UR FIELD
<b>VBAK-BSTNK = EKKO-EBELN</b> CROSS CHECK THIS ..
take an invoice number and explore from table VBRK --to VBAK
this is the link..
regards,
Vijay
11-15-2006 1:03 PM
check EKBE table .
EKBE-VGABE = 1 FOR GR
EKBE-VGABE = 2 FOR IR.
regards
Prabhu
null
11-15-2006 1:05 PM
SELECT EBELN
EBELP
BELNR
FROM EKBE
WHERE EBELN = EKPO-EBELN
AND EBELP = EKPO-EBELP
AND VGABE = '2'.
ekbe-belnr would be the IR.
Regards,
ravi
11-15-2006 1:05 PM
Hi ,
Tables for invoice ,
VBRK - invoice header
VBRP - invoice line items.
Customer Purchase order field -VBRK-BSTNK_VF.
Tables for Purchase order,
EKKO - Header table
EKPO - Line items
Regards,
Raghavendra
11-15-2006 2:02 PM
hi sarath ,,
invoice is in vbrk ---
VBRK-VBELN = VBRP-VBELN.
Now fetch
VBRP-VGBEL ,
VBRP-VGPOS . from VBRP
now
VBRP-VGBEL = LIPS-VBELN .
VBRP-VGPOS = LIPS-POSNR.
LIPS-VGBEL = VBAP-VBELN
LIPS-VGPOS = VBAP-POSNR.
VBAP-VBELN = VBAK-VBELN.
INVOICE TO SALES ..
NOW FROM SALES TO PO
VBAK-VBELN
<b>VBAK-BSTNK</b> -
> THIS IS UR FIELD
<b>VBAK-BSTNK = EKKO-EBELN</b> CROSS CHECK THIS ..
take an invoice number and explore from table VBRK --to VBAK
this is the link..
regards,
Vijay