Regarding FBL1N transaction report

[Former Member]

Hi,

I want to know the functionality of transaction code FBL1N as i want to make a report on it. plzz provide me guidelines which tables are used for it and what is the purpose of this transction code.

plzz everyone it is very urgent to me as help will be definatelty rewarded....

Edited by: ric .s on May 17, 2008 6:13 AM

[GauthamV]

hi,

FBL1N transaction is used to display all vendor line items.

the tables related to this transaction BSIK and BSAK.also u can use BKPF and BSEG related to accounting documents.

[Former Member]

hi,

is it having a relationship with the tcode F110? if it is then plzz tell me ?

moreover what is the procedure to perform this tcode so that i can update the tables REGUP , REGUH..........

[Former Member]

Hi Ricky Singh,

FBL1N transaction is to display the OPEN and CLEAR line items of the vendor.

F110 transaction is to do automatic payments. if u want to do the payment for all the vendor at a time. then we go for the automatic payment .

REGUH ---> Settlement data from payment program and

REGUP ---> Processed items from payment program will be automatically filled with F110 transaction.

After the Payment program the OPEN line items will be displayed in the CLEARED item Tab.

Best regards,

raam

[Former Member]

Hi,

It means i pick the vendor from FBL3N(DISPLAY MODE) and take it to

the F110 tcode and put it into the vendor field of it and process it for it,

as the data will be updated in to the REGUH and REGUP tables as cleared items in it.

but 2 things i wanna know more in which tables these vendor items or vendors are stored whether their payements are made or not?

plzz reply it is really urgent to me as help will be deifinately rewarded.

It is really urgent. plzz its a humble request to all of you.

Edited by: ric .s on May 17, 2008 7:20 AM

[Former Member]

Hi,

We give the vendors for whom we want to run the payment program.

it gets the vendor from the table, not from the transaction.

In F110, in Parameter tab we give the range of Vendors and customer to whom we want to run the program.

Vendor cleared items are stored in

BSAK Accounting: Secondary Index for Vendors(Cleared Items)

open items are stored in

BSIK Accounting: Secondary Index for Vendors

Best regards,

raam

[Former Member]

hi,

ok but by which trasnaction code u get know that these are the vendors u have to run tcode F110. I think there might be some criteria to run it?

[Former Member]

Hi,

Actual Table for vendors is LFA1-->Vendor Master (General Section)

In table BSIK u have field LIFNR --> Account Number of Vendor or Creditor.

we run the transaction to the vendor for whom the paymentis not done.

table BSIK contains open line items. That means the vendor accounts for whom the payment is not done.

Once the payment is done then they will appear in BSAK table ( Cleared line Items).

Best regards,

raam

[Former Member]

bsak,bsik,bseg, lfa1

[Former Member]

Hi Ric,

functionality of FBL1N is that it tells you the details of open and close items of vendor transactions as on the date.

tables u can used is BSIK BSAK.

I HAD PREPARED REPORT ON THE SAME FOR SEEING VENDOR LEDGER , IF U WANT A SAMPLE CODE DO TELL ME.

REWARD IF HELPFUL.

PRIYA

[Former Member]

Hi Priya,

Yeah sure i might help me out .plzz give me the code .

[Vijaykmm]

Hi, Priya, we have a similar requirement as above could you please provide the code which you have.

Thanks 

vijay