Skip to Content
avatar image
Former Member

Change log of document address for Ship to party in sales order

hi experts,

There is a case where Ship to party address is diffferent at sales order level and custome rmaster level.Can anyone help to find the log of data inserted /updated in the customer address at sales document level. We tried CDHDR and CDPOS tables with object Adresse.But this is not giving correct information.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jul 04, 2011 at 02:37 PM

    Hi,

    In your case,I hope the Customer number is same at both levels.i.e. at Sales Order level and Customer master level but the address is different.

    Goto the T.Code "SE16".Enter the table Name as "KNA1".Enter the Custoemr Number and get the value from the field "Adress".

    Now Enter the table name as "VBPA".

    Enter the Address numebr you have noted from table "KNA1" and enter the select option as "Not Equla to".Pass the Ship-To-Party number under the field "Customer" and select the partner function as "WE/SH".

    Execute.

    You will receive all the list of sales orders where teh address is differed from master data.

    Regards,

    Krishna.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 04, 2011 at 03:13 PM

    Use this report S_ALR_87101238 with 'VERKBELEG' as object class to select changes of SD documents. Then filter the report to restrist display by specific transaction codes and fields.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05, 2011 at 03:30 AM

    May be after creating that sale order, some changes would have been made in customer master. Check in XD05. Alternatively, you can also compare the field ADRNR from table KNA1 with VBPA.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2011 at 06:12 AM

    If you change Ship to party address at Sales order item level then item partners indicator gets activated in Sales order item details Partner tab.

    Also it will get updated in VBPA table with Sales order and item number.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2011 at 06:58 AM

    Dear Aparna,

    In the table VBPA, check for the field ADRDA.

    Thanks & Regards,

    Hegal K Charles

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Hegal,

      Thanks you for your reply.Thats is very helpful answer.

      Is there any way to find on which field the change has happened.

      Regards,

      Aparna.G