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

Vendor name in fbl3n

hi,

Is it possible to get the vendor code in FBL3n report. Because in Bank outgoing payment GL report we need vendor name. Vendor name is available in screen layout of fbl3n, i have moved from hidden to display still it is not showing the vendor name.

govind.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 11:46 AM

    is not possisble for vendor name in Fbl3n.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 12:08 PM

    Hi. You'd to add own field to BKPF(for example ZZNAME1), than in transaction OBVU add this field for FBL3N. After that use OpenFI, Event 00001650. If you need, I can post code of Functional module.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2008 at 01:05 PM

    Hi Govind,

    FBL3N is the transaction for G/L Account line item display.

    For Goods Receipt documents, line items will populate with Vendor LIFNR, but for Invoice Receipts only the vendor line item would populate LIFNR, the G/L lines for IR documents do not populate LIFNR.

    You can see this yourself by looking in SE16 at table BSEG for the GR and IR accounting documents. For GR document, BSEG-LIFNR should be filled for all line items. For IR document, BSEG-LIFNR should be filled only for the vendor line item.

    The line item display can't display any value, because there is no value on the database.

    The relevant tables for the G/L Line Item Display is BSIS/BSAS and BSEG. In BSIS/BSAS you will not find the fields Vendor number (LIFNR) and Vendor name (NAME1), and in BSEG Vendor number is only stored in the Vendor Line Item and not in the G/L line item, and you will not find Vendor name in BSEG. Therefore, you are not able to add the fields to the Line Item Display as a standard field or as a special field in the normal way.

    Hence, this is SAP standard design and it is not possible to have vendor number in the G/L line item display.

    There is a workaround for this, which should work in both 46* and Enterprise versions :

    The fields LIFNR and NAME1 do not exist in the structures RFPOS and RFPOSX. If you need these fields to be shown in the Line Item Display then you need to add the fields to the structures RFPOS and RFPOSX.

    When the structure has been extended with the fields then you need to run the reports RFPOSXEXTEND and BALVBUFDEL (in the same way as seen in the solution part in note 215798).

    After that you need to use the Open FI Exit 1650 to fill the fields. You will find a function group FI_ITEMS from transaction SE80. In this function group you will find a function module FI_ITEMS_DISPLAY where the form ITEMS_DISPLAY_INIT includes the exits 1610 to 1650. The important one for your problem is 1650 (OPEN_FI_PERFORM_00001650_E).

    This exit is used if you want to display fields in e.g. FBL3N which do not exist in the tables BSIS/BSAS and also not in the G/L Line in BSEG.

    Through this user exit it should be possible to get the value from the relevant tables e.g. from the vendor items from BSEG or the value from BSIK into structure RFPOSXEXT if there is a relation between the relevant tables e.g. BSEG/BSIK to RFPOSX/BSIS.

    Please also have a look at the notes 112312 and 217189.

    Hope it helps.

    Regards,

    Emoke

    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.