Convert date to different formatConvert timestamp
DATA: v_time_stamp TYPE timestamp,
v_DATE TYPE sy-datum,
v_TIME TYPE sy-uzeit,
v_TIMEZONE TYPE ttzz-tzone.
CONVERT TIME STAMP v_time_stamp TIME ZONE v_TIMEZONE
INTO DATE v_DATE TIME v_TIME.
Convert to MM/DD/YYYY

Data: A type D, B type D.
define date_conversion.
write &1 to &2 MM/DD/YYYY.
end-of-definition.
date_conversion A B.
Date calculation - a date several days ago
DATA: v_date TYPE sy-datum.
 v_date = sy-datum – 5.

BW ABAP, SAP BW | 2 Comments »

From RSA1 — Top menu — Tools — Apply Hierarchy and attribute change (Ctrl + F9), you should be able to either execute “attribute change run” on all infoObjs or selected ones.
However, the “Execute” button was grayed out on one server.
Solution:
Check if there’s any change-run jobs released/running/stuck. Make sure they are not useful, then cancel and delete [...]

BW Admin, SAP BW | No Comments »

In Bex Analyzer, first, you don’t see the technical name of a workbook, you also can’t delete them.
In our system, several workbooks are created from a common workbook template, and save in a folder of an user workbook role.
To save the new workbook, the old workbook need to be deleted from the Role. Then, those unused workbooks should be deleted from [...]

BW Reporting, SAP BW | No Comments »