SAP HANA SQLScript · SQLScript in SAP BW (AMDP Routines)

You set the sort field like this. Records come out ordered 1, 10, 11, 2, 3… Why? ``` RANK() OVER (ORDER BY d) AS "RECORD" ```

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in SQLScript in SAP BW (AMDP Routines)

A transformation already has one AMDP (SQLScript) end routine. You now add a start routine — can you write it in ABAP?

With an InfoSource between two transformations, which mixed ABAP/HANA arrangement is allowed?

How many AMDP classes get generated for a transformation's routines — BW on HANA vs BW/4HANA?

A BW transformation contains an ABAP start routine. Your team wants it to run in the SAP HANA runtime for speed. Can it?

How does a DTP running in the SAP HANA runtime move data differently from one running in the ABAP runtime?

Default DTP package size: ABAP runtime vs SAP HANA runtime?

Start learning today

Free to start — download the app or use it in your browser.