FBL1N - vendor ledger

[Former Member]

HI EXPERTS !

The transaction code for the report we r using is FBL1N - vendor ledger.

we require the vendor's bank detail in this report at the header i.e. vendor bank name , account no..( basically change layout of report for output )

this detail can be seen by transaction code FK03 - view vendor data base.

can anybody help me to solve this .

thanks

[Former Member]

Use tables BSIK for vendor Open items,

BSAK for vendor cleared Items,

LFBK for Vendor Master (Bank Details)

Reward points if useful, get back in case of query...

Cheers!!!

In FBL1n if you press (Cntrl+F10) you are taken to the Master-FK03

Message was edited by:

Tripat Pal Singh

[Former Member]

HI T.P SINGH.

THANKS .

The transaction code for the report I M using is FBL1N - vendor ledger.

we require the vendor's bank detail in this report at the header i.e. vendor bank name , account no..( basically change layout of report for output )

this detail can be seen by transaction code FK03 - view vendor data base.

can anybody help me to solve this .

initially after pressing F8 i goto settings---- layout----current header rows.

then click on gen.variable and insert/ change text variable window come, from where i can select variable type but its not showing vendor bank name , account no. how i can add these details under variable type and variable name sothat i can select them.

CAN U HELP ME IN THIS QUERY

thanks

RANJNA

[Former Member]

instead of clicking on 'general variable', click on 'features', u'll find house bank there

regards,

Tripat!!!

[JozsefSzikszai]

hi ranjna,

FBL1N is a stanradr transaction and has accesses only transaction data, no master data of the vendor.

What you can do is:

either copy the program behind the transaction and modify accordingly

or create a complete new report with the data you want

hope this helps

ec

[Former Member]

HI EC!

HOW R U.

I HAV POSTED ONE PROBLEM CALLED 'LINE ITEM PROBLEM'

PLZ FIND TIME TO HELP ME IN THIS .

THANKS.

[Former Member]

HI E.C

The transaction code for the report we r using is FBL1N - vendor ledger.

we require the vendor's bank detail in this report at the header i.e. vendor bank name , account no..( basically change layout of report for output )

this detail can be seen by transaction code FK03 - view vendor data base.

can anybody help me to solve this .

initially after pressing F8 i goto settings---- layout----current header rows.

then click on gen.variable and insert/ change text variable window come, from where i can select variable type but its not showing vendor bank name , account no. how i can add these details under variable type and variable name sothat i can select them.

PLZ HELP ME IN THIS

thanks

[Former Member]

I think u cant introduce addtitional fields at header level in the output.

If you found any alternative method ...lets us know