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: 

How to link sales order number (VBELN) and Handling unit number (EXIDV)

Former Member
0 Kudos
1,463

Hi !! Please tell me is there any way to link the sales order number VBELN of VBAK and Handling unit number EXIDV of VEKP? Suggest me any method to link those two fields.

1 ACCEPTED SOLUTION

GauthamV
Active Contributor
0 Kudos
250

try this.

VBAP-VSTEL = VEKP-VSTEL.

4 REPLIES 4

GauthamV
Active Contributor
0 Kudos
251

try this.

VBAP-VSTEL = VEKP-VSTEL.

0 Kudos
250

Hello ,

Check this , Hope it will solve u r problem .

SELECT SINGLE * FROM vekp

INTO l_vekp

WHERE exidv = l_hunr. -->Handling Unit number

SELECT SINGLE * FROM vepo WHERE venum = l_vekp-venum.

then

SELECT SINGLE * FROM likp WHERE vbeln = v_vbeln.

Regards,

naveen_inuganti2
Active Contributor
0 Kudos
250

Hi,

In addition to Goutham's help..,

Check this table:

VBELN field in VEPO -- Is Delivery where is has links with LIKP, It also contains VENUM

VENUM -- Internal Number , You can have this in VEKP(Handling unit table Also)

(Ask for your Functional guy once)

--Naveen Inuganti.

Former Member
0 Kudos
250

You can find the linking at handling unit item level VEPO (VBELN/POSNR) - these link the handling unit to the delivery item.

VEKP is handling unit header and is linked to VEPO via VENUM