Vendor Details mentioned in the agreement

[former_member184595]

Hi All,

We need to generate a report (excel) that lists all the vendors ( vendors of outline agreements) records in SAP which shows. SAP ID number, vendor name, address, 'blocked' status and 'marked for deletion' status and purchase orgs created in.

Can anyone suggest me from which tables i can generate this report for the vendors mentioned in the Outline agreements.

Thanks.

[Former Member · Accepted solution]

hi

you can find these fields in ekko and ekpo

[Former Member · Accepted solution]

Hi,

Check the table EKET,

[Former Member · Accepted solution]

LFA1 - vendor master general

LFB1 - vendor master company code

for vendor address: Get the address number ADRNR from LFA1 table and pass it to ADRC table to get the complete contact details