Industry in FBL1n report

[Former Member]

All,

We have industries for vendors to sort the vendor line items based on industry type. Industry is master data. I can run the report by the industry through dynamic slection. But, industry field is not available in the layout to add to the line item as a separate column.

What should I do to bring to the report?

Thanks,

Sri

[Former Member]

Sri

Try this out...

Please see the thread below. In this I had mentioned the procedure. Let me know if it worked.

Try this

1.Execute Transaction code SE36. Click F4. Enter the table name wherein you think the field could be found. In this case it should be BSIK/BSAK

2. From the initial screen of SE36, Choose from the path EXTRAS>> Selection Views

3. Copy Selection View "SAP" to "CUS"

4. Change the selection views "CUS"

5. In the right corner, double click your table BSIK/BSAK.l

6. In the right corner, check whether what functional groups does your field belong. If it is 01 then input it beside your field name.

7. Then Save it afterwards

Hope this works. Let me know if it does.

Karthik

[Former Member]

Thanks Karthik,

In this case the table is LFA1. This table is not available in SE36

[Former Member]

how did your issue get resolved?

Karthik

[Former Member]

We have a ZFI_FBL1n report and I requested abaper to add the column to this report instead of changing the standard SAP report