add row in report FBL1N

[Former Member]

Hi Gurus,

I have requirement to add rows in report FBL1N in order to display all item per document ( like in document overview ) in the same screen.

I applied note 112312 to display offset a/c (BTE with FM LINE_ITEMS_GET_GKONT) but partialy resolve my pb that is one item is displayed.

I would like to know how to do this, if i have to use BADIs (such BADI FI_ITEMS_MENUE01 ) and witch one or clone de STD or customazing.

Thanks in advance.

[Former Member · Accepted solution]

hello,

FBL1n is a SAP standard programme and you can display in ALV grid as many field/column as provided in the options.

Please go into the change layout and add fileds as required. You will be able to see all columns in one row itself.

If you want to add more fields which are not there in the options, then it is suggested to develop a SAP Query.

Hope this helps, if yes, please assign points.

Regards,

Harish

[Former Member · Accepted solution]

Hello Harish, thanks for your reply,

My requirement is to display as many rows as displayed items in the document overview, I know how to add columns (first item in document ) but not all items in the same document .

Excuse my for my english.

Thanks

[Former Member · Accepted solution]

Hi,

Can u pls give an example.

Regards,

Harish

[Former Member · Accepted solution]

Ok,

trx FB1N, after selection give me :

DocumentNo Type Doc..Date Offst.acct

5300029134 TL 22.05.2007 600819 => one account per document

5300034345 TL 07.06.2007 600819

5300038636 TL 21.06.2007 600819

5300038637 TL 21.06.2007 600819

4200014129 FA 28.02.2007 40811030

4200012196 FA 31.03.2007 40811030

4200013351 FA 31.03.2007 60640000

details of fisrt document (n° 5300029134) give 4 line items :

Itm PK Account Account short text Amount

1 25 600819 LYRECO 20,524.36

2 39 600819 LYRECO 20,524.36-

3 50 51110040 BN att FGX LCR n.D. 20,524.36-

4 40 51119800 En cours E à P 20,524.36

my requirement is to display 3 account ( 600819, 51110040 and 51119800) given in details of document in column Offst.acct when excute FBL1N in stead of one. like this :

DocumentNo Type Doc..Date Offst.acct

5300029134 TL 22.05.2007 600819

5300029134 TL 22.05.2007 51110040

5300029134 TL 22.05.2007 51119800

5300034345 TL 07.06.2007 600819

5300038636 TL 21.06.2007 600819

5300038637 TL 21.06.2007 600819

4200014129 FA 28.02.2007 40811030

4200012196 FA 31.03.2007 40811030

4200013351 FA 31.03.2007 60640000

I hope that is more clear,thanks fo your patience.

[Former Member · Accepted solution]

Hi,

For this, I think you need to develop a report with the help of ababpers or can create a query using SQVI. There is no standard report available for the same.

Hope this helps.

Regards,

Harish

[Former Member · Accepted solution]

Ok, thank you very match Harish, i will try qry.