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

Table for RFQ

Hello Gurus,

What is the table that links Purchase requisition to RFQs..? I need to prepare a report on all the PRs and the RFQs that were creted for those PRs.If there is no such table then is there anyway that i can view a table that contacins some information on the quotations made..?

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Sep 29, 2011 at 07:13 AM

    Hi

    Hence segregate your RFQ list by Docuemnt Type absed on your usage, Std RFQ doc type: AN.or ZAN whihc is used at your end

    RFQ Date:

    here give docuement type AV OR ZAN

    Table: EKKO

    FIELD: BEDAT

    RFQ Qty:

    Table: EKPO

    FIELD: KTMNG

    PR table

    EBAN - Purchase Requisition

    EBKN - Purchase Requisition Account Assignment

    and check following link

    [http://www.sap-img.com/materials/all-the-tables-in-sap-mm-purchasing.htm]

    Regards

    Kailas Ugale

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 07:15 AM

    Hi

    It is also a one of the Purchasing document...so you can go to EKKO and select the Doc. Category as A then you can get all the RFQ's created based on other selection parameters.

    I hope this information helps you.

    Thanks,

    Satya.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 07:16 AM

    Hi,

    You can find the details of RFQ made in table EKKO with data field BSTYP as 'A'.

    Table for PR is EBAN & EBKN.

    Check if you can link these two tables for your requirement.

    Regards,

    Divya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 07:24 AM

    Hi,

    It is also one of the Purchasing document only.

    So u can use all tables related to Purchasing document .

    The tables are EKKO, EKPO, EKBE, EKAN, EKKN .

    The purchase document category must be "A".

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 29, 2011 at 07:12 AM

    Hi,

    Goto SE16 and check the below table

    RFQ Date:

    Table: EKKO

    FIELD: BEDAT

    RFQ Qty:

    Table: EKPO

    FIELD: KTMNG

    And also check in EKET for RFQ and PR relation.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 09:49 AM

    thanks all.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.