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: 

Searching for a join between AFRU and COEP

Former Member
0 Kudos

Hi,

I'm looking for a possibilty to find entries in COEP witch are created with

IW42. I find entries in COEP and AFRU, but i can't see the link between them.

Is there any other table which gives me the join of them?

Thanks for help.

Regards, Dieter

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Please see view

<b>V_TXW_AFRU</b> Join COEP/COBK/AFRU

You can easily check this yourself. Do a 'where used list' on both tables in views. You want any view that contains both tables. I found only the one in 4.7.

Rob

Message was edited by:

Rob Burbank

3 REPLIES 3

Former Member
0 Kudos

Please see view

<b>V_TXW_AFRU</b> Join COEP/COBK/AFRU

You can easily check this yourself. Do a 'where used list' on both tables in views. You want any view that contains both tables. I found only the one in 4.7.

Rob

Message was edited by:

Rob Burbank

ferry_lianto
Active Contributor

Hi,

You can join tables AFRU and COEP thru table COBK.

AFRU-RUECK = COBK-REFBN

AFRU-RMZHL = COBK-AWORG

COBK-KOKRS = COEP-KOKRS

COBK-BELNR = COEP-BELNR

Regards,

Ferry Lianto

Former Member
0 Kudos

Hi Rob,

that's it, thanks. Thanks too to Ferry.

It solved my Problem.

But i have a problem with this thread, i cannot set the buttons to

give reward points. Sorry, i try it later.

Regards, Dieter