Skip to Content

SAP B1 sales order doubt

Hi, Can anyone help me on how to get update about who has last changed/modified or updated a sales order in SAP B1

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 01, 2017 at 11:39 AM

    Hi Datta Phulse,

    You can use SAP B1 standard changelog option to view the changes.Check Under Tools-ChangeLog

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01, 2017 at 10:55 AM

    Hi Datta,

    Please try below steps.

    1. In the CDHDR - pass the below values

    Object:VERKBELEG

    Object value - ASales order number.

    T.code - VA02.

    2. here you will have the Name, Date time - on which you can get the lsast changed date

    3. This CDHDR / CDPOS are the tables that will have the values for all the changes.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2017 at 01:11 PM

    Hi,

    You can view those updated changes under Sales Order-->Tools-->Change log.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      The subquery in the following query works fine in SAPB1 and SQL without parameters but when parameters are added the subquery in the query does not work in SAP B! but still works in SQL

      SELECT T0.[DocEntry], T0.[DocNum] 'SO NO',

      T0.[DocDate] 'Doc Date', T0.[CardCode] 'Customer Code',

      T0.[CardName] 'Customer Name',

      T1.[SlpName] 'Account Manager',

      T0.[DocTotal] 'Total'

      ,T2.u_name 'Created By',

      (SELECT top 1 o.U_NAME

      from adoc A inner join OUSR O on a.UserSign2 = o.Userid

      where a.DocEntry = t0.DocEntry and a.objtype = 17

      order by a.UpdateDate desc)'Last Updated by'

      FROM ORDR T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

      Left Join OUSR T2 on T2.userid = T0.Usersign

      WHERE T0.[DocDate] BETWEEN '2016-03-06' AND '2017-03-06' AND T0.[DocStatus]='O'

      Can you tell me the reason to make it working in both cases

  • avatar image
    Former Member
    Mar 07, 2017 at 03:56 PM

    Hi Datta Phulse,

    You can seen the changes made in SAP B1 in the change log.

    You can access it from TOOLS >>>> CHANGE LOG

    Thanks and regards

    Tony

    Add comment
    10|10000 characters needed characters exceeded