About former_member183519

former_member183519 · 07-29-2019

Dear Readers, This blog can be use to optimize Performance of SELECT....FOR ALL ENTRIES statements which are taking more time to execute.(Implementation of Note 1662726) Pre-requisite: SAP DB should be HANA DB. With the use of this optimization ...

former_member183519 · 10-26-2017

Hello All, Now i have data like below in bex output: Instead of multiple rows i want data into a single row for last 3 chars in screenshot.. Could anyone pls tell any possibility for this Thanks.

former_member183519 · 02-07-2016

Dear All,Many times there are sdn threads on issues while adding records to SOURCE_PACKAGE or ERSULT_PACKAGE.This issue causes because while adding new records to SOURCE or RESULT Package, we need to add "Record Number" field in addition to other fie...

former_member183519 · 01-06-2016

Dear All,Recently i have a faced one issue where i required to change TR status from released to unreleased.I have assumption that once we released TR(task) then we can not revert TR to modiable, but that was wrong.SAP have provided program using whi...

former_member183519 · 12-03-2015

Hello i m executing one pc... in one of EXOR step it is stuck..when i checked table rspcprocesslog then i have found its state field is F.. so i manually run program rspc_process_finsh(as well as FM RSPC_PROCESS_FINISH) and set its status to green 'G...

former_member183519 · 07-29-2019

Hello, Thanks for comment! yes,right!!! This should be only used with time consuming and expensive SELECT….FOR ALL ENTRIES statements.

former_member183519 · 10-29-2018

Hi,Lets say your soruce and target variables are :lv_src type C length 60.lv_tgt type C length 20.as you wanted to assign soruce to target..lv_tgt = lv_src+0(20). <-- offset

Re: Problem with User Exit in BEX HANA · 10-26-2018

Hi Hector,Seems your code is correct... could you pls do little one modification to code..DATA: ZVARLY_I TYPE /BI0/OICALYEAR , ZVARLY_S TYPE /BI0/OICALMONTH. ** change code for variable 'ZVAR_TIME_UE_01' .. remove '.' from beow statemen...

former_member183519 · 10-26-2018

Hi Robbie,can u give one try.. as u said in one of the your earlier comment, you tried hard code constant value in transformation..Instead of passing some hardcode value, can u pls give a try with BLANK value..as below.. if this not work.. give one o...

former_member183519 · 10-25-2018

Hello Robert,After activating request, in active table i could see you are getting fields SID DATAPAKID RECORD ? on activation, in active table we are not getting this 3 fields..

User Statistics

User Activity

SAP ABAP/BI : 'SELECT...FOR ALL ENTRIES' Optimization

Bex query Issue

Addition of new records to START or END routine

Change released task to unreleased/ modifiable

rspcprocesslog table is not updated for fields event_end & eventp_end

Re: SAP ABAP/BI : 'SELECT...FOR ALL ENTRIES' Optimization

Re: Data is not trimmed during data load

Re: Problem with User Exit in BEX HANA

Re: Transformation logic is not applied in the Active DSO

Re: Transformation logic is not applied in the Active DSO