Code Snippets für die Verwendung mit SQL Script AMDP (z.B. in Transformationen). Nützliche Snippets für ABAP Routinen finden Sie hier.

Durchschnitt berechnen

outTab =
SELECT calyear, calmonth, d_nw_prid__d_nw_prcat AS d_nw_prcat, d_nw_pcurr,
' ' AS recordmode, AVG (d_nw_gamt) AS "/BIC/ZBW_AVERG", ' ' AS record, ' ' AS SQL__PROCEDURE__SOURCE__RECORD
FROM :inTab
GROUP BY calyear, calmonth, d_nw_prid__d_nw_prcat, d_nw_pcurr;

Attribute ableiten

SELECT d_nw_prid__d_nw_prcat AS d_nw_prcat ...

Error Tab DUMMY

errorTab =
SELECT '' AS ERROR_TEXT,
'' AS SQL__PROCEDURE__SOURCE__RECORD
FROM DUMMY
WHERE DUMMY <> 'X';

Kalenderjahr aus Kalendermonat

SELECT SUBSTRING(calmonth, 1, 4) AS calyear

Kalendermonat aus Fiskalmonat

outTab =
SELECT company, fiscper, fiscvarnt,
CASE
    WHEN SUBSTRING(fiscper,5,3) = 001 then  CONCAT(SUBSTRING(fiscper,1,4) - 1, SUBSTRING(fiscper,5,3) - 3 + 12)
    WHEN SUBSTRING(fiscper,5,3) = 002 then  CONCAT(SUBSTRING(fiscper,1,4) - 1, SUBSTRING(fiscper,5,3) - 3 + 12)
    WHEN SUBSTRING(fiscper,5,3) = 003 then  CONCAT(SUBSTRING(fiscper,1,4) - 1, SUBSTRING(fiscper,5,3) - 3 + 12)
    ELSE CONCAT(SUBSTRING(fiscper,1,5), SUBSTRING(fiscper,5,3) - 3)
END AS calmonth,
currency, recordmode, amount, record, SQL__PROCEDURE__SOURCE__RECORD
FROM :inTab;