Skip to Content
author's profile photo
Former Member

Purchasing Info records

How to know if for a given material / plant / Pur org / vendor a COntract or Schdulign agrremnt exists.

(we dont maintain source list some times).

Rgds,

Mano Sri

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Sep 30, 2005 at 04:07 PM

    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
    10|10000 characters needed characters exceeded