Access to the BW Netweaver BW Application server date and time system fields in the SYST table is useful. Especially when automating data processing in Process Chains and Transformations.
The SY-DATUM field is the current application server date.
For Example: 19991231, 20080631, 20140317 and 20190723.
The SY-UZEIT field is the current application server time.
For Example: 020000, 083000, 115959, and 200000.
The list of available system fields in the Formula Builder should look like this:
You should have access to all four SYST date and time fields: DATUM, UZEIT, DATLO and TIMLO.
“unfortunately the SYST-UZEIT system field is
usually missing from the list of system fields”
Add the “Application Server Time (SYST-UZEIT)” system field into the BW Formula Builder in 3 easy steps:
- Save the SYST-UZEIT Code Snippet.
- Create an ABAP Class for the IF_EX_RSAR_CONNECTOR interface.
Further Reading: BAdI for Customer-Defined Functions in the Formula Builder
- Create Business Add-In (BAdI) to call the new class interface.
Further Reading: Transformation Library and Formula Builder
How did it go for you?