topic Re: select -join in Application Development and Automation Discussions

select -join

Former Member — Wed, 08 Oct 2008 10:47:12 GMT

Hi all,

I wont to display list of Billing Document ( VBRP tab) which contain

materials with HAWA status ( MTAR -field)

Not sure but ( VBRP-EKPO-MARA tables)*?

Former Member — Wed, 08 Oct 2008 10:50:11 GMT

Use VF05(Further selection criteria)/VF05N transaction.

Former Member — Wed, 08 Oct 2008 10:50:38 GMT

Hi,

Just VBRP & MARA should do it, something like....

select vbp~vbeln vbrp~matnr into table gt_itab
  from vbrp
    inner join mara on mara~matnr = vbrp~matnr
  where mara~mtart = 'HAWA'.

Darren

Former Member — Wed, 08 Oct 2008 10:50:44 GMT

MATNR is in VBRP as well: VBRP -> MARA

Former Member — Wed, 08 Oct 2008 10:54:32 GMT

You mean material type?? MTART ??

If I'm right use this...



SELECT a~vbeln a~matnr b~mtart
INTO TABLE it_vbrp
FROM vbrp AS a
INNER JOIN mara AS b
ON a~matnr EQ b~matnr
WHERE <cond>
AND  b~mtart EQ 'HAWA'.