SAP R/3 форум ABAP консультантов
Russian ABAP Developer's Club

Home - FAQ - Search - Memberlist - Usergroups - Profile - Log in to check your private messages - Register - Log in - English
Blogs - Weblogs News

КАК МОЖНО СОЕДИНЯТЬ СТРОКИ



 
Post new topic   Reply to topic    Russian ABAP Developer's Club Forum Index -> ABAP
View previous topic :: View next topic  
Author Message
araz.umbayev
Участник
Участник


Age: 39
Joined: 21 Oct 2011
Posts: 9

PostPosted: Tue Oct 25, 2011 10:01 am    Post subject: КАК МОЖНО СОЕДИНЯТЬ СТРОКИ Reply with quote

Если данные стобцов одинаковые(TABNR), как сделать так, чтобы они выходили в одной строке


1.png
 Description:
 Filesize:  61.57 KB
 Viewed:  8142 Time(s)

1.png


Back to top
View user's profile Send private message
Удав
Гуру
Гуру


Age: 48
Joined: 25 Jan 2008
Posts: 580
Location: Москва

PostPosted: Tue Oct 25, 2011 11:12 am    Post subject: Reply with quote

С помощью оператора CONCATENATE.
Code:
REPORT  ztext LINE-SIZE 255.
DATA: lt_hrt1002 TYPE STANDARD TABLE OF hrt1002,
      ls_hrt1002 TYPE hrt1002.
DATA: BEGIN OF ls_result,
        tabnr TYPE hrt1002-tabnr,
        text TYPE string,
      END OF ls_result,
      lt_result LIKE STANDARD TABLE OF ls_result.

SELECT-OPTIONS: so_tabnr FOR ls_hrt1002-tabnr.

START-OF-SELECTION.
  SELECT *
  INTO TABLE lt_hrt1002
  FROM hrt1002
  WHERE tabnr IN so_tabnr.

  SORT lt_hrt1002 BY tabnr tabseqnr.
  LOOP AT lt_hrt1002 INTO ls_hrt1002.
    CONCATENATE ls_result-text ls_hrt1002-tline INTO ls_result-text
      SEPARATED BY space.
    AT END OF tabnr.
      ls_result-tabnr = ls_hrt1002-tabnr.
      CONDENSE ls_result-text.
      INSERT ls_result INTO TABLE lt_result.
      CLEAR ls_result.
    ENDAT.
  ENDLOOP.

  LOOP AT lt_result INTO ls_result.
    WRITE: / ls_result-tabnr, ls_result-text.
  ENDLOOP.

_________________
С уважением,
Удав.
Back to top
View user's profile Send private message
araz.umbayev
Участник
Участник


Age: 39
Joined: 21 Oct 2011
Posts: 9

PostPosted: Tue Oct 25, 2011 11:29 am    Post subject: Reply with quote

Большое спосибо за ответ
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Russian ABAP Developer's Club Forum Index -> ABAP All times are GMT + 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG.
SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG.
Every effort is made to ensure content integrity. Use information on this site at your own risk.