Updation of Assignment number in FBL3n

[Former Member]

Hi,

While posting user has entered assignment number which is there in voucher but when i open fbl3n, in report Assignment field is showing as "00000".

Actual in FS00, control data earlier sort key was Personnel number which i have change to Allocation number. And now the Assignment field is showing the data.

Please let me know what can be done for those previous entry  which is still showing as "00000". There are many entries.

[former_member222241 · Accepted solution]

Hi,

It will not display for already posted documents.

It will start displaying only for newly created documents.

Please note that mass changes can be done only for documents having common Personnel number.

In this case you need to develop BDC for transaction code FB02 with the help of ABAPer.

Regards,

Tejas

[Former Member · Accepted solution]

Hi Tejas,

Yes, it is displaying for new entries, and not for old one.

Apart from writting a program can we also upload it via LSMW.

But why it is happening so, any idea?

[former_member222241 · Accepted solution]

Hi,

Yes, you can do LSMW for FB02 transaction.

This is standard SAP behavior of updating the values for the new ones instead of old ones.

Regards,

Tejas

[Former Member · Accepted solution]

Hi Tejas,

I have tried but it is not happening, via manual change also.

I have taken one old entry and made done modification via FB02.

It is appearing still "00000" in FBL3N display, but when i go inside the document i am able to see.

[former_member222241 · Accepted solution]

Hi,

Please refresh FBL1N.

You can do so by :

1. Execute FBL1N.

In the output screen

2. List - Refresh or

3. Come out of transaction code FBL1N.

4. Again execute FBL1N transaction

Tejas

[Former Member · Accepted solution]

Hi Tejas,

Done but it is not reflecting. Even i have talk to my senior he has told LSMW will not work because we dont have proper data to upload.

Can you let me know what logic to be given to Abaper to write a Program.

[former_member222241 · Accepted solution]

Hi,

Do the following steps :

1. Download all the documents for which you want to change the assignment field.

2. Go to transaction code SHDB3.

3. Click on New recording.

4. Enter recording name for e.g. ZFB02.

5. Enter transaction code FB02.

6. Click on start recording.

7. Enter document number

8. Enter Company Code

9. Fiscal Year

10. Press Enter

11. Double click on line item wherein you want to enter assignment field.

12. Enter assignment field.

13.Save

14 Save

15 Give this recording to ABAPer wherein he will develop BDC for you.

16. Once the BDC is developed ask ABAPer that you will be entering only Document number, Company code and fiscal year.

Please update assignment field against vendor only than only you can see through FBL1N.

Regards,

Tejas

Message was edited by: Tejas Gupte

[vinod_vemuru2]

Hello,

After you updated the data in documents, did you check table BSIS field ZUONR to see if the data is correctly updated? Just tried in my system and it works fine both in FBL3N and BSIS table. FBL3N picks up data from BSIS/BSAS. If you are updating cleared items, check table BSAS.

Thanks,

V V

[Former Member]

Hi Durga

Additionally, can you check the below link and SAP notes mentioned therein.

Assignment field in FAGLL03/FBL3N different fro... | SCN

Before you implement LSMW, do it manually for few line items ot check the system behaviour

In my opinion, I think this is a sap error as you said assignment already maintaned and visible in FB03 and but not in FBL3N. Check with SAP by raising OSS message

Hope it helps

Regards

Mustafa

[Former Member]

Hi Durga,

Go to FBL1N---> Make the Selection of the items to be changed--->Edit--->Select All---->Click on Mass Change--> Fill the field & then click execute changes.

[Former Member]

No Kavita,

Actual data is already there in Posted invoice, the only thing is it is not reflected in FBL3N display.

[Former Member]

But when we go to document and open it , we can see the data.

Why it is not reflecting in FBL3N- Line item display?

[Former Member]

Hi Durga,

You can use mass change functionality in FBL3n to update the already posted invoices with the correct assignment .

Regards,

kavita