Hi,
You can actually read EKKO and EKPO for this.
An inner join on EKKO and EKPO should tell you.
For example,
SELECT a~ebeln FROM ekko AS a INNER JOIN ekpo AS b
ON ( aebeln = bebeln )
WHERE a~bstyp IN ('K', 'L') "K - Contract, L - Sch. Agr
AND a~lifnr EQ <your vendor>
AND a~ekorg EQ <your purchasing org.>
AND b~matnr EQ <your matnr>
AND b~werks EQ <your plant>.
Sri
Add comment