BADI_RSPLS_LOGGING_ON_SAVE

[arsiasmi]

Trying to implement 'BADI_RSPLS_LOGGING_ON_SAVE' however an error is generated, saying "SQL Syntax Error - 257 - Error near """ col1355". there is a call to method 'LOGGING_TAB_FILL_STORE' class of class 'CL_RSPLS_LOGGING_SRVS' which generates a dynamic sql which is further based on some buffer/runtime tables. i have cross checked the sql and did not find any specific mistake.

any help will be appreciated

[sheldon_piao · Accepted solution]

Hi Arsalan,

The issue should be related to INDPERCENT and its source. We can see that the first select is "", which is abnormal.

---

...SELECT "" , "$BIC$TPBASLNCS"...

---

What's the Netweaver version and SP level? Maybe you can implement note 2389559 and 2631609.

Best Regards,

Sheldon

[arsiasmi · Accepted solution]

Thank you & lots of appreciations Sheldon, though i corrected it by removing the corresponding field, i will still try implementing the SNote and check.

[sheldon_piao]

Hi Arsalan,

What DB does the system use? Can you paste the SQL statement here?

Best Regards,

Sheldon

[arsiasmi]

it is using HANA DB, the issue is in the first field of select statement, i removed the field while debugging in both insert & select, the process works fine. The mapping is done in BADI Initialization method _INITIALIZE_BADI of class CL_RSPLS_BUFFER_B. it skips this field.

Thank you for response.

INSERT INTO "_IP_LOG_20181224__ABIFNLYTNAPOTAPN4HUM4PI7M4" ( "INDPERCENT" , "/BIC/TPBASLNCS" , "/BIC/TPBASLNLB" , "/BIC/TPFXCUSTE" , "/BIC/TPFXFDSHO" , "/BIC/TPFXMGPO" , "/BIC/TPFXMISCS" , "/BIC/TPFXPYSVS" , "/BIC/TPFXSPOUT" , "/BIC/TPGRMARGN" , "/BIC/TPGRSLVOL" , "/BIC/TPINGRMRG" , "/BIC/TPLAMBAMT" , "/BIC/TPLAMBRAM" , "/BIC/TPLAMEXVL" , "/BIC/TPLAMXREV" , "/BIC/TPLTBPAMT" , "/BIC/TPLTBRAMT" , "/BIC/TPLTG1AMT" , "/BIC/TPLTG2AMT" , "/BIC/TPLTPDAMT" , "/BIC/TPLTSTRTN" , "/BIC/TPNTSLVOL" , "/BIC/TPPYCUSTE" , "/BIC/TPPYFDSHO" , "/BIC/TPPYFXSPT" , "/BIC/TPPYMISCS" , "/BIC/TPPYNTVOL" , "/BIC/TPPYPRSVS" , "/BIC/TPPYSLVLB" , "/BIC/TPPYSLVSU" , "/BIC/TPPYTOTSD" , "/BIC/TPQSHPVCS" , "/BIC/TPQSHPVOL" , "/BIC/TPSBBPAMT" , "/BIC/TPSBBRAMT" , "/BIC/TPSTBBLSM" , "/BIC/TPSTOLVOL" , "/BIC/TPSTOPAMT" , "/BIC/TPSTORAMT" , "/BIC/TPTOTCOGS" , "/BIC/TPTOTLREV" , "/BIC/TPTOTLSPD" , "/BIC/TPUPLTVCS" , "/BIC/TPUPLTVOL" , "BPARTNER" , "BP_GRP_A01" , "BP_GRP_A02" , "BP_GRP_A03" , "BP_GRP" , "CALMONTH" , "CALWEEK" , "CRMVERSION" , "CRM_MKTELM" , "CRM_PROD" , "CRM_SALORG" , "CRM_TACTIC" , "CURRENCY" , "CUSTOMER" , "CUST_SALES" , "DISTR_CHAN" , "DIVISION" , "FISCPER3" , "FISCPER" , "FISCVARNT" , "FISCYEAR" , "PERIOD_TYP" , "PR_CAT_SAL" , "SALESORG" , "SALES_UNIT" , "SOURSYSTEM" , "BUY_PAT" , "DISTRATIO" , "KYF_IND" , "DATE0" , "/BIC/TPSAVEID" , "TIME" ) SELECT "" , "$BIC$TPBASLNCS" , "$BIC$TPBASLNLB" , "$BIC$TPFXCUSTE" , "$BIC$TPFXFDSHO" , "$BIC$TPFXMGPO" , "$BIC$TPFXMISCS" , "$BIC$TPFXPYSVS" , "$BIC$TPFXSPOUT" , "$BIC$TPGRMARGN" , "$BIC$TPGRSLVOL" , "$BIC$TPINGRMRG" , "$BIC$TPLAMBAMT" , "$BIC$TPLAMBRAM" , "$BIC$TPLAMEXVL" , "$BIC$TPLAMXREV" , "$BIC$TPLTBPAMT" , "$BIC$TPLTBRAMT" , "$BIC$TPLTG1AMT" , "$BIC$TPLTG2AMT" , "$BIC$TPLTPDAMT" , "$BIC$TPLTSTRTN" , "$BIC$TPNTSLVOL" , "$BIC$TPPYCUSTE" , "$BIC$TPPYFDSHO" , "$BIC$TPPYFXSPT" , "$BIC$TPPYMISCS" , "$BIC$TPPYNTVOL" , "$BIC$TPPYPRSVS" , "$BIC$TPPYSLVLB" , "$BIC$TPPYSLVSU" , "$BIC$TPPYTOTSD" , "$BIC$TPQSHPVCS" , "$BIC$TPQSHPVOL" , "$BIC$TPSBBPAMT" , "$BIC$TPSBBRAMT" , "$BIC$TPSTBBLSM" , "$BIC$TPSTOLVOL" , "$BIC$TPSTOPAMT" , "$BIC$TPSTORAMT" , "$BIC$TPTOTCOGS" , "$BIC$TPTOTLREV" , "$BIC$TPTOTLSPD" , "$BIC$TPUPLTVCS" , "$BIC$TPUPLTVOL" , "0BPARTNER_KEY" , "0BP_GRP_A01_KEY" , "0BP_GRP_A02_KEY" , "0BP_GRP_A03_KEY" , "0BP_GRP_KEY" , "0CALMONTH_KEY" , "0CALWEEK_KEY" , "0CRMVERSION_KEY" , "0CRM_MKTELM_KEY" , "0CRM_PROD_KEY" , "0CRM_SALORG_KEY" , "0CRM_TACTIC_KEY" , "0CURRENCY_KEY" , "0CUSTOMER_KEY" , "0CUST_SALES_KEY" , "0DISTR_CHAN_KEY" , "0DIVISION_KEY" , "0FISCPER3_KEY" , "0FISCPER_KEY" , "0FISCVARNT_KEY" , "0FISCYEAR_KEY" , "0PERIOD_TYP_KEY" , "0PR_CAT_SAL_KEY" , "0SALESORG_KEY" , "0SALES_UNIT_KEY" , "0SOURSYSTEM_KEY" , "BUY_PAT" , "DISTRATIO" , "KYF_IND" , '20181224' , '005056AF13681EE981EDE1E8CE3CFF67' , '122817' FROM "_SYS_PLE:20181224112818_5456460:DATA"