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

[Former Member]

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.

[GauthamV]

try this.

VBAP-VSTEL = VEKP-VSTEL.

[shishupalreddy]

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]

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]

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