Category Archives: SAP BW/4 HANA

Dependency analysis on HANA calculation views

Posted on July 13, 2023 by kidex2

Just a small tipp… in order to analyze dependencies of calculation views you can use the following table: SELECT * from OBJECT_DEPENDENCIES WHERE (dependent_object_name like ‘%IOLE%STATUS%’ or base_object_name like ‘%IOLE%STATUS%’ ) and dependent_schema_name = ‘_SYS_BIC’

Posted in HANA, SAP BW/4 HANA | Leave a comment

Starting AfO from ABAP

Posted on July 29, 2020 by kidex2

Just a small snipped: AfO can be started via transaction RAAOE. Directly triggered from ABAP works this way:

Posted in Analysis for Office, SAP BW, SAP BW/4 HANA | Tagged , , | Leave a comment

Filter out special characters through SQL/AMDP

Posted on June 6, 2019 by kidex2

With this example AMDP script special characters gets sorted out using regular expressions: outTab = SELECT “/BIC/A”, “/BIC/B”, REPLACE_REGEXPR(‘([^[:print:]|^[\x{00C0}-\x{017F}]|[#])’ IN “/BIC/C” WITH ” OCCURRENCE ALL ) AS “/BIC/C”, “/BIC/D”, “RECORD”, “SQL__PROCEDURE__SOURCE__RECORD” FROM :inTab; The expression filters everything non printable or … Continue reading →

Posted in SAP BW/4 HANA | Tagged , , | 1 Comment

Alpha conversion in HANA SQL

Posted on June 6, 2019 by kidex2

To do a alpha conversion directly in AMDP script the following expression can be used: SELECT …, CASE WHEN ( LENGTH(LTRIM(hanaview.”CHARACTERISTIC”,’ 0123456789′)) = 0 and LTRIM(hanaview.”CHARACTERISTIC”,’ ‘) <> ” ) THEN LPAD( hanaview.”CHARACTERISTIC”,5,’0’ ) ELSE hanaview.”CHARACTERISTIC” END as “/BIC/CHARACTERISTIC”, … … Continue reading →

Posted in SAP BW/4 HANA | Tagged , , | 1 Comment