Skip to Content
author's profile photo Former Member
Former Member

Purchasing Info records

Posted on Sep 30, 2005 at 03:37 PM 6 Views

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

ABAP Development
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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