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: 

Connection between EBAN & EKPO

0 Kudos

Hi,

I am selecting PO details from EKPO based on EBAN -BANFN & EBAN -BNFPO fields ie where EKPO-BANFN = EBAN -BANFN and EKPO-BNFPO = EBAN -BNFPO . It is taking lot of time to retrieve data as there are no index based on these fields. I tried to retreive data from EKPO using EBAN-EBELN ie where EKPO-EBELN = EBAN-EBELN. But the output is inconcistent. Is there any other way to select PO details for every PR passing through EKPO Index.

Regards,

Vipin.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

You have to use the link

EKPO-BANFN = EBAN -BANFN and EKPO-BNFPO = EBAN -BNFPO only

Try to create a Secondary Index on these fields and use

try to link other Material fields like plant, stor location, material group also

MATNR

WERKS

LGORT

MATKL

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

Regards

Anji

3 REPLIES 3

Former Member
0 Kudos

Hi

You have to use the link

EKPO-BANFN = EBAN -BANFN and EKPO-BNFPO = EBAN -BNFPO only

Try to create a Secondary Index on these fields and use

try to link other Material fields like plant, stor location, material group also

MATNR

WERKS

LGORT

MATKL

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

Regards

Anji

Former Member
0 Kudos

HI vipin,

Instead of using EKPO-EBELN = EBAN-EBELN , you have to use EKKO-EBELN = EBAN-EBELN. Then based on ekko details you have to select po details from ekpo.

Wth Regards,

Neptune.M

Former Member
0 Kudos

Hi,

Check the field <b>BANFN</b> in EKAN & EKPO.

Regards