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

Approved Vendors List

1.We need a list of Approved Vendors from List of Vendors Master Data. Is there any provision to have a report. Can any body Guide me.

2. At time of Entering Vendors ( Business Partner)Master Data in <b>Accounting tab</b> if I Select Tax Sub tab There is a provision Vendor Type----


Drop Down box .

In this can we define this vendor as <b>Approved.</b>

If so how can we generate Report.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Dec 01, 2007 at 09:50 AM

    Paidipelli...one client went through several iterations to keep track of approved vendors and I can go through each way...they "grew" into the final solution over time...

    1st Iteration. Used the "on hold" check box on the "General Tab" on the BP Master Data to indicate whethere a vendor was approved or not...

    Report was created using the following SQL:

    SELECT *

    FROM OCRD T1

    WHERE T1.FrozenFor = 'N'

    AND T1.CardType = 'V'

    Of course you would need to list those fields you want on the report instead of using "*" behind the SELECT statement

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2007 at 10:02 AM

    2nd Iteration...client was not using the "Priority" field on the "Payment Terms" tab in the BP Master Data...so they dropped the usage of the "On Hold" and had me change the label of the "Priority" field to "Approval Stage". They had started using several "stages" to approve a vendor. They defined the approval levels as: QA Approved [with code of QA Appr], Engineer Dept Approved [with code of Engr Appr], Governmental Reporting Approved [Govern Appr], Final Approval [Final Appr].

    1. To change the label of the fleld name: position the cursor over the field name, and double-click the field name as you hold the "Ctrl" key down. Remember to make the new field name bold and use all caps for the new name (easy way to ID which field names have changed).

    2. Wrote SQL on each stage of the approval process for each department as follows:

    SELECT *

    FROM OCRD T1

    WHERE T1.Priority = 'QA Appr'

    AND T1.CardType = 'V'

    Just substituted 'QA Appr' with 'Engr Appr', etc...

    3. Of course after seeing the various reports, someone in management came along and wanted to have a report that showed ALL Vendors in each and every stage so we changed the SQL to check:

    WHERE T1. Priority IS NOT NULL

    AND T1.CardType = 'V'

    ORDER BY T1.Priority, T1.CardName

    The government required them to do even more "stages" and so they had a third iteration...which was my original suggestion...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2007 at 10:12 AM

    3rd and final iteration...they dropped the usage of the "Priority" field and had me create a User-Defined Field with security restrictions on it. I changed the name back to its original name. They removed all of the codes from the "Priority' field, assigned one person to be responsible for changing the UDF, and they ended up with TEN approval stages after the government stepped in!

    The UDF was what I had mentioned at the very beginning and is what they are using now. Then we wrote the same type of simple SQL:

    SELECT *

    naaaa - you get the idea!!!

    hahaha - Good Luck with whichever route you take!

    Zal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2007 at 10:20 AM

    oh PS - I do not have a "Vendor Type" on my "Tax" tab of the BP Master. I only have "Tax Status" - maybe due to localization variances?

    There might be other ways to do this also - maybe "Properties"? Well something should get you there!

    Zal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 04:23 PM

    Narender,

    The SAP Help files says the following:

    Country-Specific for India

    Vendor Type: Appears only when the BP is Vendor.

    &#9679; Value in this combo-box is optional.

    &#9679; Possible to change the description, but not delete the default vendor type once it has been used in transactions.

    &#9679; To add a vendor type, choose Define New, and enter the requested information in the Define Vendor Type window.

    I there might be any Out of the Box Reports they would be under Business Partner Reports. Otherwise I would suggest you the following.

    Enable viewing System Information from the Top View Menu (CTRLShiftD), when you mouse over this field you will see the Table it is coming from and the field name.

    You could create a SQL Query Report based on this.

    Regards

    Suda

    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.