Purchase order related data.

[Former Member]

HI all,

Can anyone guide me which tables would fetch me these data?

Below PO information needed based on date ranges and payment terms:

Vendor Name

Address

Fed ID #

Remit to Vendor #

Contracting Vendor #

Ordering Vendor #

Payment Terms

"Payment Terms Translation"

Date Last Changed

"Contract Expiration"

"Vendor Group or Type"

"Buyer Name"

"Contact Name - who maintains this record"

The columns in quotes are really giving trouble.

[Former Member]

Hithere,

Pls check

EKKO, EKPO, EKAN, LFM2.

Go the field that you require & press F1. In the performance assistance press the tools button (screw drivers). It will give the table & field name where the data is stored.

Regards,

Sivanand

[Former Member]

What i have found till now is below. I dont know about some of the fields. EKKO,EKPO,LFA1 or EKAN are the only table i am using keeping in mind that i wil pull out all PO in a date range and then pull the coressponding data.

Vendor Name--EKKO-vendor no->LFA1 vendor name.

Address-LFA1 or EKAN

Fed ID #-- ???

Remit to Vendor #--EKKO-LBLIF(supplying vendor)

Contracting Vendor # --EKKO-LLIEF(contracting vendor)

Ordering Vendor # -- EKKO-LFINR(vendor)

Payment Terms -- EKKO-ZTERM

Payment Terms Translation -- ???

Date Last Changed -- EKPO-AEDAT

Contract Expiration --???

Vendor Group or Type --??/?

Buyer Name --???

Contact Name - who maintains this record--???

can anyone pls suggest about the rest?

[Shiva_Ram]

HI,

You can try with the following tables;

EKKO - Purchasing document header data

EKPO - PO item data

EKAN - Vendor address -purchasing document

LFM2 - Vendor purchasing data.

CDHDR and CDPOS - Date last changed.

Regards,

[Former Member]

Hi,

Try tbale EINE, LFA1

Rgds

SAN