cancel
Showing results for 
Search instead for 
Did you mean: 

References between Tables: "VEKP" and "AFPO" ?

Former Member
0 Kudos

Hello Experts,

i must select the "External Handling Unit ID - EXIDV" from Table VEKP.

How can i select over the Table AFPO some Informations from Table VEKP???

Is there some reference between the Tables, that i can use?

I expected that the Table VEKP has a field "AUFNR", than i can join the Tables VEKP and AFPO together, but it is not like that.

Kind regards

Ersin

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Try this:

AFPO~AUFNR = LIKP~TERNR           (AFPO -> LIKP)

LIKP~VBELN = VEKO~VBELN          (AFPO -> LIKP -> VEKO)

VEKO~VENUM = VEKP~VENUM     (AFPO ->LIKP -> VEKO -> VEKP)

Make sure to check this solution. I'm an ABAPer, the processes are not so clear to me.

Also, check out this document which explains relations between some standard tables

http://www.recercat.cat/bitstream/handle/2072/5419/PFCLopezRuizAnnex3.pdf?sequence=4

Jelena
Active Contributor
0 Kudos

We don't use handling units, so I'm not sure if they're even related to the production orders. I ran 'where-used' on the data element (VENUM) for the key in VEKP table, but none of the tables where it's used rings a bell.

The easiest way to find out would be to set up a SQL trace (ST05). You'll need some help from an ABAPer for that. Or, if you're an ABAPer, you might need some help from a functional consultant to point out where this field is located in the production order.

former_member184065
Active Contributor
0 Kudos

Hi ,

I have executed  2 tables in my System .but  VEKP doest have AUFNR Field but AFPO had that field as order number.

I think ,there was no relation b/w AFPO table and VEKP table.

Side Comment : If you don't mind can you explain your business requirement .

Thanks,

Naren