cancel
Showing results for 
Search instead for 
Did you mean: 

ofsetting account in faglb03

Former Member
0 Kudos

Hiii Experts.... i am trying to get offsetting account in faglb03... i did badi implementation in se19 and in classic badi wrote FAGL_ITEMS_CH_DATA and copied to Z_FAGL_ITEMS_CH_DATA and in interface tab.. did change items--> abap code and activated the badi... i got the ofsetting account in the report but its coming blank... guide me to get the data

Regards,

Abhay

Accepted Solutions (1)

Accepted Solutions (1)

ajaycwa1981
Active Contributor
0 Kudos

Hi Abhi

I have used note 112312 (BTE in FIBF) to get the Offsetting accounts

Ofcourse, The note given by Eli is a better one.. But see if the BTE also can suffice

Br. Ajay M

Former Member
0 Kudos

hey ajay sir... i did the bte for offsetting setting in FBL reports.. in which i was successful... but now i dont know which functional module and which event i should give as i assigned LINE_ITEMS_GET_GKONT for offsetting in fbl reports

ajaycwa1981
Active Contributor
0 Kudos

Hi

The note explains in detail in my opinion

The event is 1650

Br. Ajay M

Former Member
0 Kudos

hii sir... i have done the steps given in the note... but still facing the problem.. and the note explains for fbl reports moreover...

Former Member
Former Member
0 Kudos

hiii Kavita Mam... i did my implementation with this document only.... i will give u the screenshots of that.. please guide where am i wrong

Former Member
0 Kudos

Hi Abhay,

What are you trying to do? BTE or BADI?

As per your response above, I u/s that you are trying to implement BTE, for that go to t-code FIBF and follow the steps.

Paste screen shot of FIBF if you are not getting offsetting items in FBL reports

Regards,

Kavita

Former Member
0 Kudos

Hiii Mam,

I did BTE for FBL reports which was successful  but now they want Offsetting account in FAGLB03... for which i did BADI...i did BADI but the offsetting account is coming blank

iklovski
Active Contributor
0 Kudos

FAGLB03? But it's a totals report. I doubt if you can add offset account there.

Former Member
0 Kudos

hey eli... offsetting account is added but coming blank...

iklovski
Active Contributor
0 Kudos

This is not FAGLB03. This is drill-down to FAGLL03 (or FBL3N). Please, implement the BADI as instructed in the note I provided.

Former Member
0 Kudos

hey eli... i implemented as u gave the notes... but the fields are not providing any values they coming blank... idk why.. i provided screenshot the badi implemented aslo

iklovski
Active Contributor
0 Kudos

Since I cannot see the code in the BADI, I'd suggest you speaking with your ABAPer and checking why the fields are not filled. I was using this function in several projects and it always worked.

iklovski
Active Contributor
0 Kudos

Just one additional tip: maybe, the documents, for which offset account is shown as blank are archived? In this case, you have to implement note 1425118. Otherwise, check with your ABAPer.

Former Member
0 Kudos

Hi,

Please find herewith the code which needs to be written in BADI to bring the Offset account.

Logic for getting Offset Account Information in FAGLL03 report.

method IF_EX_FAGL_ITEMS_CH_DATA~CHANGE_ITEMS.
* Added Additional fields Offset A/C, Offset A/C type to Transaction
* FAGLL03
DATA: wa_items TYPE faglposx. LOOP AT ct_items INTO wa_items.
CALL FUNCTION 'GET_GKONT' EXPORTING
belnr = wa_items-belnr
bukrs = wa_items-bukrs
buzei = wa_items-buzei
gjahr = wa_items-gjahr
gknkz = '3'
IMPORTING
gkont = wa_items-gkont
koart = wa_items-gkart EXCEPTIONS
belnr_not_found = 1
buzei_not_found = 2
gknkz_not_found = 3
OTHERS = 4.
IF sy-subrc = 0.

* Get Offset Account Description Based on Account Type
* In case of G/L Account
Data: w_txt50 type txt50, w_name1 type name1.
Clear: wa_items-zzgkont_ltxt, w_txt50,

w_name1.
if wa_items-gkart = 'S'. select single txt50
from skat into w_txt50
where spras = sy-langu and saknr = wa_items-gkont.
if sy-subrc = 0.
wa_items-zzgkont_ltxt = w_TXT50. endif.
* In case of Customer
elseif wa_items-gkart = 'D'. select single name1
from kna1 into w_name1
where kunnr = wa_items-gkont. if sy-subrc = 0.
wa_items-zzgkont_ltxt = w_name1.
endif.
* In case vendor
elseif wa_items-gkart = 'K'. select single name1
from lfa1 into w_name1
where lifnr = wa_items-gkont. if sy-subrc = 0.
wa_items-zzgkont_ltxt = w_name1. endif.
endif.
MODIFY ct_items FROM wa_items. ENDIF.
ENDLOOP.
endmethod.

Regards,

Ramana

Former Member
0 Kudos

hey Eli thankss for the reply.. and the documents are not archived... i checked that

Former Member
0 Kudos

hey Kuppachi Rumanan thanks for the reply... i will try and revert back to you

Answers (1)

Answers (1)

iklovski
Active Contributor
0 Kudos

Hi,

I guess, you mean to have offset account in the line items report. Please, check if this note is duly applied:

1504612 - Line items: Offsetting account info (BAdI FI_ITEMS_CH_DATA)

Regards,

Eli

Former Member
0 Kudos

hey Eli.. thanks for the reply.yes i have applied the same note