topic Re: code help in Application Development and Automation Discussions

code help

Former Member — Wed, 08 Mar 2006 10:40:06 GMT

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

Re: code help

Former Member — Wed, 08 Mar 2006 10:59:31 GMT

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.

Re: code help

Former Member — Wed, 08 Mar 2006 11:01:40 GMT

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

Re: code help

Former Member — Wed, 08 Mar 2006 11:15:27 GMT

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