topic Re: appending specific rows to specific columns in Application Development and Automation Discussions

appending specific rows to specific columns

Former Member — Thu, 28 Jun 2018 13:42:23 GMT

Hi Experts,

I am trying to separate the column 1 to two column number 2 and 3 .

my criteria is simple and depending on current date, e.g if the lo_date (wt_exdt) => sy-datum select wt_date into 2 ..... ....

else ,

select wt_date into 3

unfortunately it is not working , can you please guide me to achieve this.

many thanks in advance.

Jenie

Re: appending specific rows to specific columns

retired_member — Thu, 28 Jun 2018 13:55:00 GMT

Use CASE in the SELECT list.

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abensql_case.htm

Re: appending specific rows to specific columns

Former Member — Thu, 28 Jun 2018 14:01:23 GMT

can you clear this more i think CASE is sql statement,

do you have please a doc or a short example for this for select and case together .

Re: appending specific rows to specific columns

Former Member — Thu, 28 Jun 2018 14:14:53 GMT

i have tried it and it is not working the after WHEN after the case when need to put a 'XXXX' and this will not suit my criteria.

Re: appending specific rows to specific columns

ArthurParisius — Thu, 28 Jun 2018 14:39:01 GMT

Maybe share a bit of your coding so we can maybe see what can be corrected.

Re: appending specific rows to specific columns

retired_member — Thu, 28 Jun 2018 14:54:32 GMT

Yes, follow the link I gave above.

Re: appending specific rows to specific columns

retired_member — Thu, 28 Jun 2018 15:11:27 GMT

Sorry, I do not understand.

Re: appending specific rows to specific columns

DoanManhQuynh — Fri, 29 Jun 2018 01:42:52 GMT

I think what Jennifer want is something like this (just an image, not working code):

SELECT wt_date FROM dbtab WHERE CASE wt_exdt WHEN => sy-datum THEN INTO wt_date1
 							      ELSE INTO wt_date2.

with CASE in SQL you have to put a value after WHEN but she want to put variable ( sy-datum ) as condition. i think there is no way to archive it direct in the SQL, you can get the data and loop the itab to assign value only.

Re: appending specific rows to specific columns

retired_member — Fri, 29 Jun 2018 04:15:10 GMT

This is possible with CASE in Open SQL. See the link above.

7.40, SP08