Skip to Content

EDIT BP NAME

Hello,

If I edit the BP name in the master data and choose "NO" to update the open documents, SAP updates the journal entry anyway with the new BP name.

Is there a way to keep the original BP name in the journal entry?

Thank you in advance for your collaboration.

Best Regards.

Simona Malavolti

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 12, 2017 at 02:56 PM

    Hello Simona -

    I have never done this, but maybe an idea. All theory here...and do this in a TEST system first, not your Production to see what happens.

    Before updating BPs:

    A. Run an SQL to select the original BP Codes and Names. Save to Excel.

    After updating BPs:

    1. Run an SQL to select all Journal Entry Lines which have a BP Code in them.

    2. Save to Excel and format the SQL results into a DTW Speadsheet for Journal Entries.

    3. Use the Excel spreadsheet from "Before updating BPs", step A.

    4. Do a VLOOKUP in DTW Excel to change the new names to the original names using the spreadsheets from 2 and 3 above.

    5. Perform a DTW on Journal Entries in your Test system (pretty certain you will need both a "header" and a "line" files to do the DTW).

    6. Review the results in Test and see if you want to do it in Production.

    Again, just off the top of my head, but you might want to try this - might work???

    Please let us all know if this works - be interesting to see if it does.

    Regards, Zal

    Add comment
    10|10000 characters needed characters exceeded

    • Geez Simona - I thought AccountCode was for the GL / BP Numbers. But I just looked at JDT1 DTW and you are correct.

      I also looked at some SQL I use to find detail and it is not pulling the Customer / Vendor Name from JDT1, but from actual documents like AP Invoice, AP Credit Memo, etc.

      So that means the original BP Name cannot be done that way...

      Maybe you can add a UDF on the Journal Entry Line and do the same thing??? And then situate it right after the Description Field on the Journal Entry Window.

      Sorry - I am not being much help here - Zal

  • Oct 12, 2017 at 03:25 PM

    Hi,

    As per SAP note 1728295, if you change BP name in business partner data, system only will update open documents not posted document.

    Please check again your transactions. If not, submit ticket to SAP.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded