FBL3N - ALV Function Call

[Former Member]

I need to add Material Desc. & Vendor Desc. in the standard report FBL3N. I am not able to find the where the ALV Function Module is called in the standard program for this report so that i can add the fields to the internal table passed to this ALV Function module.

[Former Member]

Hi Senthil,

This report is call LDB(Logical Data base ) - SDF ,look at SE36 Transaction

Look at below FM ,this FM calls ALV Display

call function 'FI_ITEMS_DISPLAY'

EXPORTING

caller_repid = c_repid_gl

acctype = c_koart_gl

x_opvw = x_gl_opvw

x_change = x_change

i_u_save = gd_alvsave

is_u_variant = gs_variant

it_u_fieldcat = gt_fieldcat[]

it_kontab = it_accts[]

it_slbtab = it_comps[]

it_t001 = it_h_t001[]

it_skat = it_h_skat[]

it_skb1 = it_h_skb1[]

x_grid = x_grid

x_inet = pa_inet

TABLES

it_items = it_pos.

Thanks

Seshu

[Former Member]

Adding vendor description. & Material Description I need to change the table structure of it_pos to include the fields in the standard Zprogram 'RFITEMGL' and write a query before ALV call to populate values or is there any other method to do in SE36 - LDB since I am not familiar with LDB.

[Former Member]

Program uses 'rfposxext' - automatically generated structure for creating table it_pos. How could i include the fields material Desc. and Vendor Desc. to it. Kindly help me.

[Former Member]

Nothing to worry,

Just Copy the program into zprogram and while creating mention LDB Name in attributes. Here no need to look at LDB ( Just i saw the program ).

Program using Internal table -

it_pos like rfposxext occurs 1 with header line.

include ur fields here :

data : begin of it_pos occurs 0.

include rfposxext

and also add vendor and so on .

data : end of it_pos .

before FM ,get the data on this field

Thanks

Seshu

[Former Member]

Hi Seshu,

I did what u said but i am getting error 'The row type of the table "IT_POS" is not compatible with the field symbol type "<LFS_POS>" in the program ZRFITEM_INC

[Former Member]

I got it solved seshu.

Thanks

[Former Member]

I did everything but I am not able to add these fields to Field Catalog for the function Module ‘FI_ITEMS_DISPLAY’. Even after appending the fields to gt_fieldcat[] using the following code before FM I am not able to see these fields in the report layout

gt_fieldcat-TABNAME = 'IT_POS1'.

gt_fieldcat-FIELDNAME = 'NAME1'.

gt_fieldcat-OUTPUTLEN = '20'.

gt_fieldcat-SELTEXT_L = 'Vendor Name'.

APPEND GT_FIELDCAT.

gt_fieldcat-TABNAME = 'IT_POS1'.

gt_fieldcat-FIELDNAME = 'MAKTX'.

gt_fieldcat-OUTPUTLEN = '20'.

gt_fieldcat-SELTEXT_L = 'Material Desc.'.

APPEND GT_FIELDCAT.

[former_member189629]

Hello Seshu garu,

I have a similar requirement - to add spl fields to fbl3n and the field is matnr, which is now not available in the layout. Is there no other way but to copy the program into "Z"...

Awaiting your reply,

Karthik