topic Re: Limited rows in table in Application Development and Automation Discussions

Limited rows in table

former_member2492 — Tue, 07 May 2019 09:32:41 GMT

Hello,

I am trying to send the table content through email,however the table has 926 rows, not all rows and columns are displayed.I am trying to convert it to xstring and all the columns are displaying now but not all the rows only half .

Can anyone help me with this?

 LOOP AT lt_contents_bin.
 CALL FUNCTION 'SCMS_STRING_TO_XSTRING'
 EXPORTING
 text = lt_contents_bin
 IMPORTING
 buffer = lt_contents
 EXCEPTIONS
 failed = 1
 OTHERS = 2.
*Converting the table contents from xstring to binary
 CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'
 EXPORTING
 buffer = lt_contents
 APPEND_TO_TABLE = 'X'
 TABLES
 binary_tab = lt_contents_hex.

  LOOP AT lt_contents_hex.
      APPEND lt_contents_hex TO gt_contents_hex.
    ENDLOOP.
  ENDLOOP.

  gt_contents_text = lt_contents_text.

Re: Limited rows in table

r010101010 — Tue, 07 May 2019 09:53:03 GMT

Hi,

You can try to use the OO option for to generate the attachement in Binary instead of the function modules. The classes to be used CL_DOCUMENT_BCS and CL_BCS. have a look at the below post on the attachement section: https://wiki.scn.sap.com/wiki/display/ABAP/Send+Emails+with+Attachments+of+any+Format

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 10:13:52 GMT

from the description : have kept 100 documents in a Folder on my desktop,this dude uploads files from desktop I want it from my table

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 11:48:18 GMT

Your question misses lots of information.

SCMS_STRING_TO_XSTRING converts a STRING into UTF-8 (by default).

SCMS_XSTRING_TO_BINARY splits a XSTRING into a table of X lines.

But what types are your variables?

And what number of bytes do you pass to the parameter I_ATTACHMENT_SIZE of method ADD_ATTACHMENT?

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 12:14:31 GMT

lt_contents TYPE STANDARD TABLE OF xstring WITH HEADER LINE,
lt_contents_bin TYPE STANDARD TABLE OF string WITH HEADER LINE,
lt_contents_hex TYPE STANDARD TABLE OF solix WITH HEADER LINE, 

lt_objpack-body_num = lv_tab_lines.
 lt_objpack-obj_descr = 'BoW'.
 lt_objpack-doc_type = 'TXT'.
 lt_objpack-doc_size = lv_tab_lines * 255.

I do not use method ADD_ATTACHMENT,In the end I simply use 
FM: NEW_DOCUMENT_ATT_SEND_API1

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 12:38:48 GMT

Johnu Blatvasky

1) What is "lv_tab_lines" ?

2) Do you pass:

LT_OBJPACK-TRANSF_BIN = 'X'.

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 12:39:59 GMT

DATA: lv_tab_lines LIKE sy-tabix.

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 12:42:55 GMT

about 1), I mean, how do you fill "lv_tab_lines"?

+ see the question 2 I have added in my previous comment

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 12:45:31 GMT

yes exatcly like that,


DESCRIBE TABLE lt_objtxt LINES lv_tab_lines.READ TABLE lt_objtxt INDEX lv_tab_lines.
t_objpack-transf_bin = 'X'.
 lt_objpack-head_start = 1.
 lt_objpack-head_num = 0.
 lt_objpack-body_start = 1.
 lt_objpack-body_num = lv_tab_lines.
 lt_objpack-obj_descr = 'BoW'.
 lt_objpack-doc_type = 'TXT'.
 lt_objpack-doc_size = lv_tab_lines * 255.
 APPEND lt_objpack.

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 12:49:11 GMT

What is lt_objtxt, how do you fill it?

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 12:55:00 GMT

DATA: lt_objtxt LIKE solisti1 OCCURS 10 WITH HEADER LINE.

the rest regarding lt_objtxt is above

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 13:03:02 GMT

sorry, I don't find lt_objtxt "above"

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 13:15:08 GMT

DESCRIBETABLE lt_objtxt LINES lv_tab_lines.READTABLE lt_objtxt INDEX lv_tab_lines.

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 13:19:08 GMT

how do you fill it?

I'm trying to help you. Please attach the whole program in txt.ZIP format.

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 13:27:50 GMT

email.txt

Please do so.Let me know

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 13:40:12 GMT

Is it really the right version?

Form Send_mail.
  DATA: lt_objtxt    LIKE solisti1 OCCURS 10 WITH HEADER LINE.
  DESCRIBE TABLE lt_objtxt LINES lv_tab_lines.

lv_tab_lines will always be zero.

Re: Limited rows in table

Tomas_Buryanek — Tue, 07 May 2019 13:43:07 GMT

As Sandra wrote:

SCMS_STRING_TO_XSTRING is returning XSTRING type (you have it wrong).
lt_objpack-doc_size definitely will not have size of x * 255. But xstrlen of xstring.

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 13:49:18 GMT

Tomas Buryanek Beware the header line! 😉

Re: Limited rows in table

Sandra_Rossi — Tue, 07 May 2019 13:51:14 GMT

I feel (but difficult to be sure) that your code is more or less fine.

1) But I wonder if it's normal to have this combination, can you try RAW instead of TXT ? (because your text is UTF-8, made of bytes):

  lt_objpack-transf_bin = 'X'.
  lt_objpack-doc_type = 'TXT'.

2) Are you sure that LT_CONTENTS_BIN is correct at the very start of your code?

Re: Limited rows in table

former_member2492 — Tue, 07 May 2019 13:52:50 GMT

yes I know ,the prb is that I dont see all the rows,only some and I dont know why...