topic Re: vbap-kdmat in Application Development and Automation Discussions

vbap-kdmat

Former Member — Tue, 15 May 2007 23:27:00 GMT

i need to get this field. here is what i have written but i am not getting it.

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO corresponding fields of TABLE itab

where

vbrk_{vbeln in p_vbeln and vbrk}kunag in p_kunag and vbrp_{matnr in p_matnr and vbrp}augru_auft in p_augru and vbrk~fkdat in P_fkdat .

loop at itab.

select kdmat into itab1-kdmat

from vbap

where vbeln = itab-vbeln .

endselect.

endloop.

***************************************************

there is no value showing up in itab.

is there some special approach for this ?

Re: vbap-kdmat

Former Member — Tue, 15 May 2007 23:28:47 GMT

Hi,

Make sure there is data in the table VBRK, VBRP for the corresponding input..

Make sure you are testing this in the right client..

Thanks,

Naren

Re: vbap-kdmat

Former Member — Wed, 16 May 2007 01:45:27 GMT

Try this:

Data: Begin of it_kdmat occurs 0,

vbeln like vbap-vbeln,

kdmat like vbap-kdmat,

End of it_kdmat.

Data: lv_index like sy-tabix.

If not itab[] is initial.

select vbeln kdmat

into table it_kdmat

for all entries in itab

where vbeln = itab=vbeln.

Endif.

Loop at itab.

lv_index = sy=tabix.

clear it_kdmat.

read table it_kdmat with key vbeln = itab-vbeln.

If sy-subrc eq 0.

itab-kdmat = it_kdmat-kdmat.

Modify itab index lv_index.

Endif.

Endloop.

Thanks,

SKJ

Re: vbap-kdmat

Former Member — Wed, 16 May 2007 02:56:26 GMT

See the below code :

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO corresponding fields of TABLE itab

where

vbrk_{vbeln in p_vbeln and vbrk}kunag in p_kunag and vbrp_{matnr in p_matnr and vbrp}augru_auft in p_augru and vbrk~fkdat in P_fkdat .

loop at itab.

select kdmat into itab1-kdmat

from vbap

where vbeln = <b>itab-aubel</b> .

endselect.

endloop.

If you want to get KDMAT(Custoemr material # ) then you need validate on vbrp-aubel(This is sales order #) and Item number

Reward Points if it is useful

Thanks

Seshu

Re: vbap-kdmat

Former Member — Wed, 16 May 2007 03:56:01 GMT

good

debug the program and check the detail condition that you have written for join statement and what value all the fields are carrying after giving the join statement.

thanks

mrutyun^