cancel
Showing results for 
Search instead for 
Did you mean: 

Add field in FBL3N Tcode Layout

Former Member
0 Kudos

Hello All,

I wish to add the field LGTXT (Wage Type Long Text) to be displayed in FBL3N. How to add this field in the layout in FBL3N?

Can we add this field? My idea is to view the Wage type text field when i hit the G/L Account and company code in FBL3N.

Please guide me. Thanks in advance.

Regards,

Santosh

Accepted Solutions (0)

Answers (3)

Answers (3)

eduardo_hinojosa
Active Contributor
0 Kudos

Hi Santosh,

See this [article|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40d6c489-aa3a-2e10-db88-deb9114b6854] by Swapnoneel Mukherjee.

Regards

Eduardo

Former Member
0 Kudos

Thanks for the article but it does not help much because it contains information which i have already dealt with. Am looking at fields to be added from HR table to FBL3N report so.

Regards,

Santosh

Former Member
0 Kudos

HI Madhu,

Can you please elaborate on this BTE? If you know the steps on how to achieve it then it would be great. Thanks.

Regards,

Santosh

madhu_vadlamani
Active Contributor
0 Kudos

Hi Santhosh,

Go to fibf , settings products of a customer,create a product name ,ps modules ,of a customer,go to the event 0001650,product name,one zfunction module name.Append custom fields RFPOS structure and RFPOSX structure..Then go to the report RFPOSXEXTEND and extedn it .Write the code in the function module before the name given in the fibf tcode.Check this and post if there is any issue.

Regards,

Madhu.

Former Member
0 Kudos

Hello Madhu,

I did activate the BTE in FIBF and also assigned the ZSAMPLE_INTERFACE_00001650 Function Module to it.

I carried out following steps:

1) Activated FIBF and assigned function module 00001650.

2) Appended structure to RFPOS and RFPOSX with ZZLGTXT and executed RFPOSXEXTEND.

3) In coding inside FM 00001650, following is my code:

FUNCTION

E_POSTAB = I_POSTAB.

TABLES: bseg, ska1, skat, t512t, t52el.

Data: lc_account like SKA1-SAKNR.

Data: lc_symbolic_account like T52EL-SYMKO.

Data: lc_type like T52EL-LGART.

Data: lc_text like T512T-LGTXT.

select single SAKNR into lc_account from ska1 where SAKNR = e_postab-konto.

select single SYMKO into lc_symbolic_account from T52EL where SYMKO = e_postab-konto.

IF lc_symbolic_account = lc_account.

select single LGART into lc_type from T52EL.

ENDIF.

IF lc_type = T512T-LGART.

select single LGTXT into lc_text from T512T.

IF sy-subrc = 0.

e_postab-ZZLGTXT = lc_text.

ENDIF.

ENDIF.

ENDFUNCTION

Am not getting the Wage type text data in my Wage Type Text Field in FBL3N. Please guide me on my coding.

Thanks,

Santosh

Former Member
0 Kudos

Hi

But you can see the new field in FBL3N?

Max

Former Member
0 Kudos

Hello Max,

Yes, the field Wage Type Long Text is visible in FBL3N but if i execute it with G/L account and company code it does not show any values where as i want to display the Wage type text linked to the G/L Account as i can see it in PCP0 Tcode.

Thanks,

Santosh

Former Member
0 Kudos

Hi

Strange....

Try to debug it, because I think you have done all need

Max

madhu_vadlamani
Active Contributor
0 Kudos

Hi Santosh,

It is looking every thing is right.Try to debug the structure and see.Please check all the things are active.If still there is any issue please post.

Regards,

Madhu.

Former Member
0 Kudos

Yes, it does not enter the last IF statement. Can you let me know which are the common fields in PCP0 and FBL3N?

madhu_vadlamani
Active Contributor
0 Kudos

Hi Santhosh,

Please go to the report and see in that structure and compare both.

Regards,

Madhu.

Former Member
0 Kudos

Hi

I don't know very well HR module, but T52EL-SYMKO is long 4 char, that means it can't fatch with KONTO (long 10 char).

They are 2 different things: T52EL-SYMKO is a symbolic account, so I can suppose it should be a table where it can be assigned to a real account

Max

Former Member
0 Kudos

Hi Santosh,

Max is right, you cannot find symbolic account against G/L account from table T52EL.

From G/L account, look at table T030 to get Symbolic Account (T030-BWMOD). Then, go to T52EL for wage type.

Please note that, one G/L account can be mapped to many wage types. Therefore, we cannot determine which wage type will be used to display its text on FBL3N in this case.

You can run tcode PC00_M99_DKON to see assignment Wage Type - Symbolic Account - G/L account

Thanks,

madhu_vadlamani
Active Contributor
0 Kudos

Hi Santosh,

You can check with BTE 00001650 ,fm copy of SAMPLE_INTERFACE_00001650.You can check with this bte.

Regards,

Madhu.