Table or view for BKPF and BSEG data

[Former Member]

Dear ladies and gentlemen,

i'm searching for a view or table which contains the receipt-numbers for a supplier. the fields belnr and lifnr should be keys. Does anbody know sth. about this?

Thank you,

Marcel

[Former Member]

i think there is no such table or view wherein Belnr & Lifnr are keys....Using the document number u can find the vendor number...

[Former Member]

Or they should be one of the first fields. This is necessary, because i have to select a huge number of records from BKPF and BSEG. (performance).

Thanks for fast answer,

Marcel

[former_member181962]

HI Marcel,

I think querying the tables BSAK(Cleared Items) or BSIK(OPen Items) would be a better option.

Regards,

Ravi

[Former Member]

Hi Ebert,

for every vendor number (ie lifnr) there will be multiple document numbers(BLENR). i dont think these 2 will have key fields in one table.

but try with BSEG table .In this u will have BELNR as a key field

Thanks

Vikranth Khimavath