tables for Po number and corresponding invoice number

[Former Member]

Hi

can Any buddy help me to find the PO number and its corresponding Invoice document number from table LFB1.

LFB1->PO->Invoice num.

thanks

imran

[Former Member]

Hi,

In LFB1 table you cant get all the details, this is related to vendor master at company code level.

Can try with the below logic:

1st Get all the PO of particular vendor from EKKO table ( Po field EBELN, vendor field LIFNR)

2nd take all the PO's and pass to EKBE table ( PO field EBELN) and also give the below values in the EKBE table

field BEWTP = Q

Now you can see the invoice number in feild BELNR material document number.

Regards

VK