code help

[Former Member]

Hi all!

Can any body give me simple code help for the following requirement.

I have to retrieve KNMT from KDMAT based on following calculations:

This is customer part number where KNMT-MATNR=VEPO-MATNR

(Note VEPO-VNUM=VEKP-VENUM) for VEKP-EXIDV.

regards

Pavan

[Former Member]

Hi ,

Assuming that you have VEKP-exidv in a internal table tb_vekp

data : begin of tb_kdmat occurs 0,

kdmat like knmt-kdmat,

end of tb_kdmat.

select a~kdmat

from KNMT as a

inner join vepo as b

on a_{matnr = b}matnr

inner join vekp as c

on b_{vnum = c}venum

into table tb_kdmat

for all entries in tb_vekp

where

c~exidv = tb_vekp-exidv.

If your VEKp-exidv is in select-options s_exidv..

then

select a~kdmat

from KNMT as a

inner join vepo as b

on a_{matnr = b}matnr

inner join vekp as c

on b_{vnum = c}venum

into table tb_kdmat

where

c~exidv in s_exidv.

Thanks and Regrads,

Sriranjani Chimakurthy.

[Former Member]

HI kumar

select knmt_{vkorg knmt}vtweg knmt_{kunnr knmt}matnr vepo_{venum vepo}vepos into corresponding fields of table itab from knmt innner join vepo on knmt_{matnr = vepo}matnr.

select vepo_{vbeln vepo}posnr vekp_{exidv vekp}vstel vekp_{lstel into corresponding fields of table itab2 from vepo inner join vekp on vepo}venum = vekp_{venum for all entries in itab where vepo}venum = itab-venum and vepo~vepos = itab-vepos.

now itab2 contains the data.

regards

kishore

[Former Member]

Hi Pavan,

Following code will help you:

DATA: v_kdmat TYPE matnr_ku.

PARAMETERS: p_venum TYPE venum.

SELECT SINGLE knmt~kdmat INTO v_kdmat FROM

( knmt INNER JOIN vepo

ON knmt_{matnr = vepo}matnr )

INNER JOIN vekp

ON vekp_{venum = vepo}venum

WHERE vekp~exidv = p_venum.

Hope it helps.

Regards,

Neeraj Gupta