on 10-21-2008 9:23 PM
Hi Everyone,
I've been looking around to see if there is a way to add "Name1" to FBL1N through Special Fields but have had no luck. It almost doesn't sound possible that SAP would not allow the addition of this crucial piece of info to that report. Can anyone tell me if there is a way to add the field to the standard report.
Thanks,
Pete
Hi Pete,
as you probably already know you can display the Vendor name in the header but not in the line items, this is standard functionality.
The Vendor Name may be displayed in the Header Data via the following Menu path in FBL1N :
Settings -> Display Variant -> Current Header Rows. The note 181592 explains how to set up the headers. Also reveiw note 181697.
Further it is not possible to include NAME1 in the line item display of 'normal' Vendors. This should only be possible for one-time vendors through table BSEC. The only area this can be included is in the header
data.
Regards,
Emoke
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Emoke. Thanks for the reply. Yes, I did know about the header section for the name. Points awarded for the helpful advice. I was looking for the name within the line item detail (each row of data). I did find a few items actually just last night that might be worth looking into.
Not sure if the link worked but essentially, it states the following for adding vendor name to the report:
"You have to activate Business Transaction Event 1650 and implement a simple code so that depending on the account type (D = customer, K = vendor), you get the business partners name from table KNA1 / LFA1 and put it into field Name1."
Hi Pete,
I found a workaround for your query:
The field NAME1 or LIFNR does also 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. FBLN which does not exist in the tables BSI/BSA* 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.
Regards,
Emoke
Hi.
At first you should to add user field to BKPF.
then in SM30 this field add to V_T021S(or throw FBL1N - see post of Emoke Suto).
after that use SE18 and BADI FAGL_ITEMS_CH_DATA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I saw a couple of suggestions in the following post.
https://forums.sdn.sap.com/click.jspa?searchID=17750298&messageID=6234930
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srikanth,
I actually found that one as well and followed this:
take menu path(after line items disply) settings-> special fields. then you will go to change view "line layout vaiant special fields" then click on new entries
enter table name : BSEG field name: LIFNR
save your entry.
Later Go to SA38 or SE38 and execute program BALVBUFDEL .
Unfortunately, BSEG-LIFNR only provided me with the vendor number which FBL1N already provides.
Any other suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.