Enhancing SAP standard transactions FBL3NFBL1NFBL5N with extra fields in the output list via BTE
August 30, 2012 4 minute read
Enhancing SAP standard transactions FBL3N/FBL1N/FBL5N with extra fields in the output list via BTE
31777,372
This blog talks about how to add some extra fields like Vendor Number, Customer Number, separate fields for credit & debit indicators and opening balance , closing balance per posting date wise in the output screen of SAP standard transactions FBL3N/FBL1N/FBL5N.
Solution: We can use openFI 1650 (BTE) to add any fields to ALV output list in FBL3N/FBL1N/FBL5N at the same time.
SAP has already provided the place for Open FI BTE (1650) in the standard program that will trigger the custom function module assigned to the event 1650 in FIBF T-code.
FBL3N: G/L Account Line Item Display
FBL1N: Vendor Line Item Display
FBL5N: Customer Line Item Display
Step 1: Create all required fields using append structure in structures RFPOS, RFPOSX
Step 2: Create a custom function module by copying the same interface parameters of FM SAMPLE_INTERFACE_00001650.
Step 3: Write the logic to populate the extra fields inside this custom function module as per your requirement.
FUNCTION zfi_fm_fbl3n.*”———————————————————————-
*”*”Local Interface
*” IMPORTING
*” VALUE(I_POSTAB) LIKE RFPOS STRUCTURE RFPOS
*” EXPORTING
*” VALUE(E_POSTAB) LIKE RFPOS STRUCTURE RFPOS
*”———————————————————————-
*& Function Module Name : ZFI_FM_FBL3N
*& Module : FI
*& Functional Consultant
*& Author Name : Manoj Kumar Pradhan
*& Date Of Creation : 24/07/2012
*& Description : This fm populates values for additional fields
* like vendor,customer, separate fields for debit & credit
* indicator which will be displayed in FBL3N/FBL1N/FBL5N
* output list.
*
* It triggers from T-codes FBL3N/FBL1N/FBL5N
* for BTE event 00001650 & configured
* in FIBF T-code for customer products Z1650 for the event 00001650.
*& Transport Request
*& Tcode : NA
***** Data Declaration***************
DATA : e_fiscal_yr TYPE bapi0002_4-fiscal_year,
e_period TYPE bapi0002_4-fiscal_period,
e_prev_period TYPE bapi0002_4-fiscal_period,
e_ret TYPE bapireturn1,
e_first_day_of_period TYPE bapi0002_4-posting_date,
lf_prev_day_of_post_date TYPE budat,
e_ret2 TYPE bapireturn1,
e_ret3 TYPE bapireturn,
e_ret4 TYPE bapireturn,
lf_sum_dmbtr TYPE dmbtr,
lf_sum_dmbtr_k TYPE dmbtr,
lf_sum_dmbtr_d TYPE dmbtr.
e_postab = i_postab.
SELECT SINGLE lifnr kunnrFROM bseg
INTO (e_postab-zzlifnr, e_postab-zzkunnr)
WHERE bukrs = i_postab-bukrs
AND gjahr = i_postab-gjahr
AND belnr = i_postab-belnr
AND ( kunnr <> ” OR lifnr <> ” ).
IF i_postab-shkzg = ‘S’.e_postab-zzdeb_ind = ‘S’.
ELSEIF i_postab-shkzg = ‘H’.
e_postab-zzcr_ind = ‘H’.
ENDIF.Step 4: Activate Open FI: t-CODE – FIBF & Create product of a customer by inputting product name, text & activate the same.
Step 5: Create P/S MODULES of a customer in FIBF and assign custom function module to event 1650 & product.
Step 6: Finally run standard program RFPOSXEXTEND to regenerate structure & run program BALVBUFDEL to clear ALV.
Note: These two programs can only be run by user who has admin authority. Contact Basis user or IT administrator for assistance
After the completion of the above steps, we will be able to view these extra fields on execution of T-codes FBL3N/FBL1N/FBL5N.
FollowLikeRSS Feed
Alert Moderator
Assigned Tags
ABAP Development
abap
Similar Blog Posts
Changing Fields Financial Accounting
By Rafael SáJun 22, 2015
How to Change and Add more Information in Header Row in the Output of FBL1N FBL5N FBL3N FAGLL03H in SAP?
By arghadip karAug 19, 2020
How to Enable Net Due Date and put a Count on Number of Items in FBL1N and FBL5N Transaction Code?
By arghadip karDec 21, 2020
Related Questions
extra fields in FBL3N tcode
By Former MemberApr 23, 2014
Hotspot field in ALV of FBL1N FBL3N FBL5N?
By Markus SpringerJun 20, 2017
adding new column to fbl3n fbl5n fbl1n
By Siya WaMay 26, 2008
3 Comments
Bhakti joshi
October 12, 2012 at 7:20 am
hello Manoj
thank you very much for your blog
kindly provide some help/comments for my issue
1 - i followed sapnote 112312, but i cudnt see the new field in change layot section of fbl5n
2 - i read yr blog and did 3 extra things - enhance RFPOSX, run the two std reports
3 - i can now see the field in change layout and i can include it in the fbl5n , but its not getting populated. by BTE is getting called and i have directly hardcoded 'X' value to myfield
i checked in debug
could you please let me know what could be the reason ?
thank you in advance
Bhakti Joshi
Like 0
Reply
Alert Moderator
Share
Madhu Vadlamani
October 13, 2012 at 6:01 am
Hi Manoj,
Good one.
Hi Bhakti,
i have directly hardcoded 'X' value to myfield.You just raise a new thread if possible.
Can you explain this.
Regards,
Madhu.
Like 0
Reply
Alert Moderator
Share
Bhakti joshi
October 15, 2012 at 6:09 am
I have hardcoded the new field = X in the BTE
this BTE is called in debug when I run FBL5N
I have raised new thrd http://scn.sap.com/message/13589273#13589273
thanks
Like 0
Reply
Alert Moderator
Share
