topic selecting program number(kunnr) from vbpa table in Application Development and Automation Discussions

selecting program number(kunnr) from vbpa table

Former Member — Fri, 26 Oct 2007 06:42:45 GMT

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

Re: selecting program number(kunnr) from vbpa table

Former Member — Fri, 26 Oct 2007 06:53:27 GMT

<b>I guess you want Bill to party address

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

Rewards if Helpful....</b>

Re: selecting program number(kunnr) from vbpa table

harimanjesh_an — Fri, 26 Oct 2007 06:55:28 GMT

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