select -join

[Former Member]

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]

Use VF05(Further selection criteria)/VF05N transaction.

[Former Member]

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]

MATNR is in VBRP as well: VBRP -> MARA

[Former Member]

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'.