cancel
Showing results for 
Search instead for 
Did you mean: 

Error while running APD with 0CH_ON as a filter

former_member226000
Participant
0 Kudos

Hi folks ,

I have created an APD for extracting data of customer out of 0BPARTNER. My requirement is to give daily data of those customers whose profiles have been changed. I have used 0CH_ON as a filter.But APD throws below error on execution.

Error analysis
    Short text of error message:
    Program error in a program in package RSAN_RT

    Long text of error message:
     Diagnosis
         An inconsistent program status has occurred in a program belonging
         to package RSAN_RT.
         o   SY-MSGV1: "RT2_MAP_CONVERT_SELTAB_NOT_POSSIBLE"
         o   SY-MSGV2: "0CH_ON"
         o   SY-MSGV3: "20130514"
         o   SY-MSGV4: "20130514"

Can anybody please help me out of this error ?

Best Regards,

Mandar.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182470
Active Contributor
0 Kudos

What did you put under Filter Condition tab for Selection from and To? There is an error here actually. Please correct it and run again.

former_member226000
Participant
0 Kudos

Hi Suman ,

Below is the filter selection.

Am I doing anything wrong here ?

-Mandar.

former_member182470
Active Contributor
0 Kudos

Hi,

Please change the dates and try to run again.

former_member226000
Participant
0 Kudos

Yes... I have already checked for different ranges from 14th April to till date . For any date APD doesn't get executed.

former_member182470
Active Contributor
0 Kudos

Try this FM:  APPL_LOG_READ_DB_WITH_LOGNO to know the error message exactly.

Follow this:--

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/11/06/how-to--get-apd-record-co...

As a last chance, you can debug your APD execution by entering /h in t-code command prompt-->Press Enter. Then debugging will be switched on..

Select your APD and press execute...

Regards,

Suman

former_member226000
Participant
0 Kudos

I did tried with the FM you suggested and below is the output of it.When I open the header of FM output I hardly see anything useful there . Below is the output.

I am still trying to debug APD with whatever small knowledge I have about ABAP.

-Mandar.

former_member182470
Active Contributor
0 Kudos

Hi,

Another work around. Get into change mode of this APD and check/save/activate it freshly. execute it to see any improvement is there. Try to use any other date field instead of Changed on. Check whether the data is available properly for the filter value at source before execution.

Regards,

Suman

former_member226000
Participant
0 Kudos

Hi Suman ,

The same APD is working for other filters e.g. customer ID. The issue started occuring when we changed filter to "Changed On".

Former Member
0 Kudos

Please try to give date in format: YYYYMMDD.

former_member182470
Active Contributor
0 Kudos

Please change the date format as Dipti said. What is the format of Changed On field in your source? Keep it identical

former_member226000
Participant
0 Kudos

Hi All ,

The issue was resolved as per the suggestions made in SAP note # 1507700 ( APD: Termination RT2_MAP_CONVERT_SELTAB_NOT_POSSIBLE ) . The error I am facing now is when I replace hard coded values with variable.The error is "Cannot find variable for 0CH_ON characteristic in selection".The variable created is of type DATS.

-Mandar.

former_member182470
Active Contributor
0 Kudos

Thats good to hear. I feel pity about myself that i could not help you..