Vendor code in FBL3N for GR/IR Clearing A/C

[Former Member]

Hi,

We have requirement to display Vendor code & Name in FBL3N for GR/IR Clearing A/C.
Currently Vendor is updating for RE doc types but same is not appearing for WE doc type i.e for MIGO document.

Then we have include vendor field as special field in FBL3N

Before Addition of Vendor (LIFNR) in FBL3N  as special field


After Addition of Vendor (LIFNR) as Special field.

In Table BSEG LIFNR is updated for WE doc and not for RE document on GR/IR clearing account.

Now how to bring Vendor code & Name for both document types (WE, RE) in same column in FBL3N report for GR/IR clearing account.

[RaymondGiuseppi]

For standard fields don't use the old BTE, but use BAdI FI_ITEMS_CH_DATA which can change the final internal table, structure RFPOSXEXT.

[Former Member · Accepted solution]

I have added the Vendor code in FBL3N using BET, pls check the below document.

http://scn.sap.com/docs/DOC-49772

Regards,

Rohidas Shinde

[Subbaka11 · Accepted solution]

Hi Did you get the solution; we have similar requirement.

We are currently working on a requirement to enhance the FBL3N report by populating values for fields such as LIFNR and EBELN.

During our analysis and after reviewing several SAP Community blogs, we found that BTE 00001650 is a viable solution for this enhancement. However, we have encountered the following issues:

1. The standard structure RFPOSXEXT already contains the fields U_LIFNR and U_EBELN. But upon debugging BTE 00001650, we observed that these fields are not present in the internal tables I_POSTAB and E_POSTAB.

2. To overcome this, we appended the required fields to the structures RFPOS and RFPOSX and then executed the report RFPOSXEXTEND. As a result, the structure RFPOSXEXT was updated correctly, and we were able to populate LIFNR and EBELN in the BTE logic, which were displayed as additional columns in the FBL3N output.

   

3. Our main requirement is to populate these values specifically for documents with type 'RE', where currently these fields appear blank.

4. We would like to confirm whether it is technically possible to populate values in the existing standard fields U_LIFNR and U_EBELN instead of creating and using new custom fields for this purpose.

5. We have these two fields in Setting->Special Fields.

We would appreciate your guidance or suggestions on how best to

handle this scenario.

[Subbaka11 · Accepted solution]

Thanks, Raymond Giuseppi. We have implemented the BAdI FI_ITEMS_CH_DATA, through which we were able to modify the RFPOSXEXT values. This resolved our issue — thank you for the helpful suggestion

[eduardo_hinojosa]

Hi

First, take in account Note 308008 - FAQ: Posting logic: GR/IR clearing account to avoid other mistakes.

You can manage some fields (avoid to change values for ZUONR) as SGTXT or XREF1 to XREF3 with the BTE 00001120.

I hope this helps you

Regards

Eduardo

[Former Member]

I have added the Vendor code in FBL3N using BET, pls check the below document.

http://scn.sap.com/docs/DOC-49772

Regards,

Rohidas Shinde

[athaus_zehrang]

hi

f.13 is a std t code which will help you to clear gr ir account based on po number. use the gr ir tick in the selection screen

[former_member183378]

Hello Rohidas,

Requestign you to pls chk the OBA7 settings to WE doc. type. Is Vendor A/c type is selected or not? If not, so pls select that field in Account types tab. Let us know do you still face any issues after that.

Thanks & Regards,

Lakshmi S

[Former Member]

Dear Rohindas,

In the FBL3N you can edit the Layout and insert Name 1 of the Vendor & Vendor Code. However I couldnt find the Name of Vendor. Better check with your ABAPers for the same.

Regards,

Sravan.

[Former Member]

Hi Rohidas,

I came across the following thread which might be useful to you; I personally haven't used the user exit mentioned so can't say that this will completely answer your query. 

https://scn.sap.com/thread/2062666

Hope it helps,

Jay

[Former Member]

Hi,

add Offseting a/c number and name  ,but you will get  vendor name and number only  for RE document types

regards

sampath

[Former Member]

Hi Rohidas,

This is standard SAP. Vendor (BSEG-LIFNR) is only shown on MM movements (usually WE) and not on invoices (usually RE).

If you need to have vendor nr on the RE items as well then you need to create an FI substitution (trans. OBBH), most likely on complete-document level (but if you only need it on GR/IR account then you may perhaps also do it on item level using the original logistics invoice table RBKP). In any case, vendor field is not available for substitutions in standard SAP, so you will first have to release it in table GB01. Check SAP note 42615 for details - and make sure you test it properly as SAP does not take responsibility for such changes. But I have good experience with this.

May I ask you two questions:

1. Where do the columns "Vendor code" and "Vendor name" on your FBL3N screen come from? Did you add custom fields to BSEG? If so, then it may be easier for you to fill them (with the copy of LIFNR) on the MM documents as well, wherever available. It may be easier and safer for you than creating an FI substitution on the LIFNR field.

2. Do you keep control over the GR/IR account? My experience has shown, that in some businesses (e.g., in Retail), it can be one of the fastest growing open item accounts that can cause significant effort to finance and the standard tools (FBL3N, MB5S, MR11) may not be sufficient to explain what is going on. If this is your case as well, then you may think about a custom report that tries to dig deeper (e.g., WE but no RE for any item in a given PO => vendor probably has not sent an invoice vs. WE = RE for most items but WE without RE for some on one PO => vendor maybe did not deliver a certain article but the warehouse clerk just confirmed the whole PO, etc.). There can be many such patterns that can help accountants regain control - if the account grows faster than it can be tracked in FBL3N. You may think about it - I have some good experience with it from the past, but in the end the "root causes" you will find from the patterns will be specific to your company.

Let me know if you need any further help. Good luck!

[Former Member]

I have added the Vendor code in FBL3N using BET, pls check the below document.

http://scn.sap.com/docs/DOC-49772

Regards,

Rohidas Shinde