Application Development 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
Showing results for 
Search instead for 
Did you mean: 

relationship between ekko&konp

Former Member
0 Kudos
468

i want to fetch the condition types& their condition values which are in me22n---->invoice---->taxes tab.these condition types are present in KONP table but not in KONV table.KNUMV field in EKKO table and KNUMH field in KONP table are not same ,please help in retreiving the above data by telling the table links.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
185

Hi,

1. Extract KNUMV from EKKO.

2. Using EKKO-KNUMV - Extract conditions from KONV where KONV-KNUMV = EKKO-KNUMV.

3. We can find item prices where KONV-KPOSN = EKPO-EBELP.

<b>Reward points</b>

Regards

3 REPLIES 3

Former Member
0 Kudos
186

Hi,

1. Extract KNUMV from EKKO.

2. Using EKKO-KNUMV - Extract conditions from KONV where KONV-KNUMV = EKKO-KNUMV.

3. We can find item prices where KONV-KPOSN = EKPO-EBELP.

<b>Reward points</b>

Regards

gopi_narendra
Active Contributor
0 Kudos
185

It seems you are looking for the contract conditions.

It can be achieved as below.

extract PACKNO from EKPO

use the PACKNO SUB_PACKNO from ESLL to validate againt the EKPO-PACKNO.

now relate the kont_pack kont_zeile of A081 with pln_packno pln_introw from ESLL.

Regards

Gopi

Former Member
0 Kudos
185

Hi

You need to first find out the Access sequence related Condition tables(some A* like A003, A012 or A353 etc) related to these taxes.

Take the condition type for the taxes in KONP and search in these A* tables

so after finding this A series table take the KNUMH from that and pass that to KONP-KNUMH table and take the KBETR and KWERT fields and use

<b>Reward points for useful Answers</b>

Regards

Anji