Skip to Content

Adding Vendor number/name to KSB1?

I am trying to find a way to be able to report Vendor number/Vendor name and Document Header text in the same output.  I have found KSB1 and it contains everything I need for reporting except the Vendor number/name.

Is anyone aware of another transaction code that will provide the additional information?  Or, is there a way I can add the vendor name/number to the layout or output of KSB1?

Thank you,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 16, 2014 at 12:13 PM

    Hi Richelle,

    To Bring Vendor name and Vendor number to a desired report u may need to contact a ABAP Consultant, as i hope there is no such a t.code for vendors that will give you  vendor name in report,

    Please inform vendor master general data table LFA1, and vendor master company code data table LFB1, to ABAPER,and fields name that need to fetch into the report, based on such data ABAPER can developed new report as per requirement.

    Regards

    Gouse

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 15, 2014 at 05:21 PM

    Hi Richelle,

    You can take a look at offseting account fields (GKOAR, GKONT, GKONT_KTXT) in KSB1. If those fields do not meet your requirement, you can see the following notes:

    • 325546 - CO line item reports: Creating a user-defined field
    • 354529 - Customer Exit for Offset Account Determination

    Best Regards!

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 16, 2014 at 05:17 AM

    Hi,

    You can use the fields offsetting account no & offsetting account name in KSB1 report instead of vendor no/name.

    Regards,

    Mukthar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2014 at 09:59 AM

    Hi,

    When your offset account type is K the offset A/C gives you the vendor number and Name of the offsetting A/c gives you the vendor name.

    Please check if not you can go with the Note: 325546 - CO line item reports: Creating a user-defined field

    Regards

    Divya S

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 16, 2014 at 12:42 PM

    Have you tried Offsetting Account No. and Name in your layout in KSB1?

    Add comment
    10|10000 characters needed characters exceeded