Code: Alles auswählen.
SELECT COUNT( DISTINCT matnr )
FROM marc
INTO gs_stklivw-matverw5
WHERE ynfg = gv_matnr AND
werks = '0150'.
Code: Alles auswählen.
SELECT COUNT( matnr )
FROM mara
INTO gs_stklivw-matverw5
WHERE EXISTS (
SELECT matnr
FROM marc
WHERE ynfg = gv_matnr AND
werks = '0150' ).
Code: Alles auswählen.
MANDT
YNFG
etc.
Code: Alles auswählen.
SELECT COUNT( DISTINCT matnr )
FROM mara
INTO gs_stklivw-matverw5
WHERE EXISTS (
SELECT matnr
FROM marc
WHERE matnr = mara~matnr "weitere Bedingung
AND ynfg = gv_matnr
AND werks = '0150' ).