Skip to Content
avatar image
Former Member

tables for Po number and corresponding invoice number

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 17, 2009 at 03:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded