selecting program number(kunnr) from vbpa table

[Former Member]

Hi,

I have a requirement where i have to select program number(kunnr) from vbpa table

based on vbeln and parvw fields.I can use 'FOR ALL ENTRIES IN vbak table for vbeln field.But parvw field is not present in vbak table .Where can i get parvw field to select the program number(kunnr) from vbpa table?

Regards,

Hema

[Former Member]

<b>I guess you want Bill to party address

KUNRE is field from VBPA table Where PARVW = ‘RE’

Rewards if Helpful....</b>

[harimanjesh_an]

hi hema,

PARVW is present in VBFA (Sales Document: Partner ).

So do like this,

SELECT a_{vbeln b}parvw FROM vbak as a JOIN vbfa as b ON a_{vbeln = b}vbeln INTO TABLE t_vbak WHERE b_{parvw IN s_parvw AND a}vbeln IN s_vbeln.

Then,

SELECT vbeln kunnr FROM vbap INTO TABLE t_vbap FOR ALL ENTRIES IN t_vbak where vbeln = t_vbak-vbeln.

<b>Note:

where s_parvw and s_vbeln are SELECT-OPTIONS</b>

Reward me if useful.........

Harimanjesh AN

Message was edited by:

Harimanjesh AN