Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

purchase info record

Former Member

‎2006 Oct 09 2:46 PM

0 Likes
1,018

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

4 REPLIES 4
Read only

Former Member

‎2006 Oct 09 3:18 PM

0 Likes
726

plz help

Read only

Former Member
In response to Former Member

‎2006 Oct 10 12:25 AM

0 Likes
726

check in the EKKO table

Read only

Former Member

‎2006 Oct 10 12:33 AM

0 Likes
726

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

Read only

Former Member

‎2006 Oct 10 3:10 AM

0 Likes
726

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