10-08-2008 11:47 AM
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)*?
10-08-2008 11:50 AM
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
10-08-2008 11:50 AM
10-08-2008 11:50 AM
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
10-08-2008 11:50 AM
10-08-2008 11:54 AM
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'.