Hi,
I have written the Field based HANA Routine , data load is failed due to some error and could no able to find the exact issue. We are in BW4HANA 2021 .please help. Below is the Code and Error message.
METHOD S0001_G01_R59 BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY USING /BIC/TZCOBJ_ID.
-- target field: M_WC_TXTM
-- *** Begin of routine - insert your code only below this line ***
-- Note the _M class are not considered for DTP execution.
-- AMDP Breakpoints must be set in the _A class instead.
outTab =
SELECT a.txtmd as "M_WC_TXTM" , InTab.record , Intab.sql__procedure__source__record from "/BIC/TZCOBJ_ID" as a inner join :InTab as InTab on inTab.mainwcobjectid = a."/BIC/ZCOBJ_ID";
-- Allow Error Handling for HANA Routines is enabled
errorTab =
SELECT '' AS ERROR_TEXT,
'' AS SQL__PROCEDURE__SOURCE__RECORD
FROM DUMMY
WHERE DUMMY <> 'X';
-- *** End of routine - insert your code only before this line ***
ENDMETHOD.
