topic Re: purchase info record in Application Development and Automation Discussions

purchase info record

Former Member — Mon, 09 Oct 2006 13:46:41 GMT

hi,

How to select data from KONV table corresponding to a Purchase info record or Purchase requistion.

I have Purchase requiston data , and Purchase info record associated with that.

Now i culd nt find field KNUMV in tables

EINA Purchase info record (main data)

EINE

EBAN Purchase requisition

EBKN

so how to select data from KONV table

Re: purchase info record

Former Member — Mon, 09 Oct 2006 14:18:37 GMT

plz help

Re: purchase info record

Former Member — Mon, 09 Oct 2006 23:25:35 GMT

check in the EKKO table

Re: purchase info record

Former Member — Mon, 09 Oct 2006 23:33:36 GMT

Hi,

For purchase info record

Check the table A017 for the combination of vendor, material and etc..

Get the condition number from A017 and go to the table KONP for the condition rate...

Thanks

Naren

Re: purchase info record

Former Member — Tue, 10 Oct 2006 02:10:12 GMT

Hi Rajesh

KNUMV Number of the document condition

can be found in all the follwoing tables

EKBE History per Purchasing Document

EKBEH Removed PO History Records

EKKI Purchasing Condition Index

EKKO Purchasing Document Header

ESLH Service Package Header Data

ESLL Lines of Service Package

LIKP SD Document: Delivery Header Data

MKPF Header: Material Document

then match the KNUMV field woth the table of KONV then if there is a particular condition, else get value from the follwing conditions table and join them A017 .

Cheers