selecting activities from afvc table by network number

[Former Member]

hi friends'

i am trying to get a list of activities from afvc table but the network number is in a diferent table (afko)

the joint field is "AUFPL"

what is the easy way to get the list

thanks

best reguards

[Former Member]

hi Anjali

thank you my friend,

i sucseeded and gut the activities

BR

ronen

[Former Member]

Hi,

Good to know that your problem solved.

BR

[Former Member]

hi Anjali

i will try and tell you if i sucseeded

thank you

ronen

[Former Member]

dear friends

in AFKO table there is no field "order category"

may be someone knows how to make join between tables?

[Former Member]

Hi,

Why is Order category required ?

As you mentioned, your requirement is to get all the activities of a network.

Then you may just enter the Order - AUFNR in AFKO table and get AUFPL. Pass this AUFPL to AFVC and get all the activities (VORNR)

Let me know if this helped. or you have a different requirement.

BR

Anjali

[Former Member]

Hi,

That is the easiest and most used way.

Thanks

[former_member230675]

This message was moderated.