BODS scripts for ABAP flow, how to get 2 fiscal year of data

[Former Member]

Dear Experts,

Seeking for your help, on how can my BODS Abap flow retrieved only 2 fiscal years of data.

Example: data for FY 2016 and FY 2017.

Here is the background:

Before I have a normal data flow retrieving data form BSAD table of ECC that one day did not work any more.

BSAD source table reached 4.7 M of rows.

I read from here and other blogs that , I can replace the normal data flow to ABAP data flow and so I did.

But the ABAP data flow I created is still not working due to large vol of data.

I test it in Dev and it works, (dev has 100 of rows only) , when I move it on Qual environment, The ABAP flow didn't work any more, in Q envi, we have 4.7 M of data.

I check the generated abap program and its working but the ADF_flow is not retrieving any data with this error message:

(14.2) 05-11-17 14:12:32 (6280:12920)     ABAP: Begin executing ABAP program <ZBODSBSAD>.
 (14.2) 05-11-17 14:42:36 (6280:12920) DATAFLOW: Data flow <DF_DEMS_A4_BSAD> is terminated due to error <150412>.
 (14.2) 05-11-17 14:42:36 (6280:12920) DATAFLOW: Process to execute data flow <DF_DEMS_A4_BSAD> is completed.
 (14.2) 05-11-17 14:42:36 (2652:11448) WORKFLOW: Work flow <WF_DEMS_ABAP_4> is terminated due to an error <150412>.
 (14.2) 05-11-17 14:43:03 (2652:11448)  PRINTFN: Mailing Execution and error log.  If following character is 0, sending was successfull -->0<--
 (14.2) 05-11-17 14:43:29 (2652:11448)  PRINTFN: Mailing Execution and error log.  If following character is 0, sending was successfull -->0<--

Upon checking the details of error, it says that:

bsad-error.png

Please advise what are the ways on how I can retrieved only 2 fiscal year of data or all data.

Many Thanks in advance,

Lissa

[kalyani_kolli]

Hi Lissa,

If issue resolved, please explain how to fix this issue.