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

[former_member183402]

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.

[kothandaraman_nagarajan · Accepted solution]

Hi,

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

Thanks

[Former Member · Accepted solution]

I think its ok as long as its a UDF/UDT using post transaction notification..

Can you confirm?

I'm not sure..

Thanks,

Joseph

[julie_jamieson2 · Accepted solution]

If you are using Formatted search, just use a SELECT statement to add the value to the field.

To get current datetime stamp would be SELECT GETDATE(). Trigger this on the same field you are using to trigger your other Formatted search.

To update your UDF you should use SAP tools such as DTW not an update query

[former_member183402 · Accepted solution]

Hi Julie,

Let me ask you one more question please,

As it seems it's not allowed to update UDF/UDT by using query. So if yes, how can I use a SELECT statement to add the value to the field without the query?

Lets take an example to PDN1 Table and UDF (U_datetime).

I think DTW updates SAP DB but when you have a template file of data.

Please anyone can help us to solve this question.

[julie_jamieson2 · Accepted solution]

Hi Rurangwa,

You would use a select query and a formatted search on the field.

Create and save the query, then under Tools>Customisation Tools> User defined Values you assign the query to a field, and select a trigger field.

You would need to check the SAP help files for this.

UDF's at line level cannot be updated after add, even DTW will not allow this

[former_member183402 · Accepted solution]

Hi Julie,

Thank you for helping me, but as it seems that the way can be used to one by one Goods Receipt PO document. it cannot help in multiple Goods Receipt PO documents.

Thank you for your good Idea.