Invoice reference

[Former Member]

Hi all!

In FBL5N, Invoice reference is updating for each payment as well as bill transaction. When I press F1 on this field and navigate, it's showing BSID,BSAD and BSEG tables. But it's not getting updated in these tables. Are there any other tables for invoice reference? If not, how is this FBL5N report able to show the invoice reference?

[Former Member]

closing thread

[Former Member]

Dear Jayasri,

Can you please what is the answer for this, and also what is reason it is not updating in data base table.

[Former Member]

Hi,

You can change the layout of FBL5N. As default this field is hidden, but you can hit the change lay out icon near the sort key or shortcut CTRL+F8.

Thanks,

Rod

[Former Member]

Hi !

I don't have any problem with layout, what I am saying is , this invoice reference is showing in FBL5N but I didn't get in which database table this data is updated.

[Former Member]

Check BKPF table..

[Former Member]

Hi!

It's not in BKPF. There is some more field named reference.But it's not showing invoice reference,instead it's showing billing document doc. as reference.

[Former Member]

Hi

I think you are referring to field BSEG-REBZG.

Regards

[Former Member]

Actually I am working with BSID and BSAD tables.Here data is not updated in REBZG. Even in BSEG,it's not updated. But how is this FBL5N report able to show invoice reference? Is there any other table?

[Former Member]

pls check BKPF-XBLNR Field

regards

nitin

[Former Member]

Hi Nithin!

It's not updating invoice reference.

[Former Member]

Hi

Actually at the table level, this field (REBZG) is blank whereas while executing FBL5N, the same field is getting updated by a standard function module.

For details, refer the following coding in Function module ITEM_DERIVE_FIELDS

*... invoice reference:

if s_item-rebzg is initial

and s_item-rebzt is initial.

s_item-rebzg = s_item-belnr.

endif.

Hope this helps.

Regards