vbap-kdmat

[Former Member]

hi

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 ?

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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^