Skip to Content

Is there any date function in query which can be used to insert date and time in SAP B1 automatically?.

Hi all,

I have a question, some times I have an idea of to insert datetime in SAP B1 query automatically. So is that possible in SAP B1?

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 06, 2016 at 10:43 PM

    Hi,

    Please note that, direct UPDATE/INSERT/DELETE sap tables leads to DB inconsistency and may loose SAP support too.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2016 at 07:57 AM

    Hi Rurangwa,

    Could you be a little more specific and give us an example? It is of course not allowed to insert or alter data directly in the database, but you could use other tools like Formatted Search, ex: to fill the duedate with the Postingdate + 30 days in an invoice you could use:

    SELECT CONVERT(DATETIME,$[OINV.DocDate],5)+30

    or

    SELECT DATEADD(dd, 30, Docdate) from OINV

    Let me know what it is you are looking for.

    Kind regards,

    Andy Grootens

    Asecom

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andy,

      I want to updated user defined field (U_exported) of PDN1 where I will update N to Y, but again I want to update another user defined field of U_datetime in order to know the date or if it's possible datetime of when each Item updated to.

      This is the query

      .

      datetime.png (36.1 kB)
  • Apr 09, 2016 at 07:20 AM

    Hi

    By default SAP save the date and time in the table, what is the use of your date and time...

    Rgds

    Kennedy

    Add comment
    10|10000 characters needed characters exceeded