download problem from 'Z' table

[Former Member]

Hi

I am facing very strange problem ,

I have created a 'Z' table and now it has 2800 records but when i download from data base it only get the 1627 records

What might me the problem ???

Technical Settings :

Data class APPL0 Master data, transparent tables

Size category 3 Data records expected: 7.700 to 31.000

then i tried other standard table to download from data base save as local file....which contains 5000 records so it get all the 5000 records

so in thisw case wat can be done ?

pls help me on this

regards

rajan

[Former Member]

Hi,

Please let me know as to how you are downloading this data ?

Using SE12 ? Or are you using a program and downloading it ?

In both the cases check that you have not done a filtering on the data.

Regards,

Pramod

[Former Member]

Hi promod

when i m using from se12 it downloads 2800 data

but from gui_download that i hv used it downloads 1627 data

i m downloading from program

and i have not put any filter on fetching it shows me 2650 during debugging....

Regards

rajan

[Former Member]

Hi Rajan,

How many records does the Internal table assigned to the "Tables parameter DATA_TAB" contain ? Does this contain 2650 records.

Regards

[Former Member]

yes it contains 2650 records ...

[Former Member]

Hi Rajan,

Check these steps if you have not already done so.

1. How may records the Internal table contain after the Select statement? As you said you are not using any selection criteria , it should be 2800 records.

2. You say the table passed to the GUI_DOWNLOAD function module contains only 2650 records. There must be some code in between which removes the rest of the records.

Can you pase your code here so that we can check it.

Regards

[Former Member]

DATA : IT_TAB TYPE STANDARD TABLE OF ZMM_OPENSEZ.

  SELECT * FROM ZMM_OPENSEZ INTO TABLE IT_TAB .

  DATA: LOC_FILENAME TYPE STRING.
  LOC_FILENAME = P_FILE.
*  CONCATENATE P_FILE '.XLS' INTO LOC_FILENAME.
  CLEAR IT_FIELDNAMES.
  REFRESH IT_FIELDNAMES.

  IT_FIELDNAMES-STRING = 'Client'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Start Date of Period'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Last Date of Period'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Plant'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Project Definition'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Material Number'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Valuation Type'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Valution Type Description'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'SerialNo'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'ITEM GROUP LONG TEXT'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'ANNEXURE NO'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'POST1'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Number of Material Document'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Posting Date in the Document'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Movement Type (Inventory Management)'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Material Description (Short Text)'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Account Number of Vendor or Creditor'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'NAME'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Unit of Entry'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Purchasing Document Number'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Unit Rate'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Opening Proj Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Opening Proj Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Opening CS01 Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Opening CS01 Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'RECEIPT QTY'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'RECEIPT AMT'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'ISSUE QTY'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'ISSUE AMT'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'TRANSFER QTY'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'TRANSFER AMT'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Consumed Return Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Consumed Return Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Contractor Return Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Contractor Return Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'CS01 Consump. Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'CS01 Consump. Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'CS01 Consump.  Ret Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'CS01 Consump. Ret Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Work in Progress Qty'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Work in Progress Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Closing Stock with APL'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Total Closing Stock'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Total Closing Stock Amt'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'FINALUPDATE'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Modified By'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.
  IT_FIELDNAMES-STRING = 'Modified on'.
  APPEND IT_FIELDNAMES.CLEAR IT_FIELDNAMES.

  FILE_NAME = P_FILE.
  CALL FUNCTION 'GUI_DOWNLOAD'
     EXPORTING
*     BIN_FILESIZE                    =
       FILENAME                       = FILE_NAME
       FILETYPE                       = 'ASC'
*     APPEND                          = ' '
     WRITE_FIELD_SEPARATOR            = 'X'
*     HEADER                          = '00'
*     TRUNC_TRAILING_BLANKS           = ' '
*     WRITE_LF                        = 'X'
*     COL_SELECT                      = ' '
*     COL_SELECT_MASK                 = ' '
*     DAT_MODE                         = 'X'
*     CONFIRM_OVERWRITE               = ' '
*     NO_AUTH_CHECK                   = ' '
*     CODEPAGE                        = ' '
*     IGNORE_CERR                     = ABAP_TRUE
*     REPLACEMENT                     = '#'
*     WRITE_BOM                       = ' '
*     TRUNC_TRAILING_BLANKS_EOL       = 'X'
*     WK1_N_FORMAT                    = ' '
*     WK1_N_SIZE                      = ' '
*     WK1_T_FORMAT                    = ' '
*     WK1_T_SIZE                      = ' '
*     WRITE_LF_AFTER_LAST_LINE        = ABAP_TRUE
*     SHOW_TRANSFER_STATUS            = ABAP_TRUE
*   IMPORTING
*     FILELENGTH                      =
     TABLES
       DATA_TAB                        = IT_TAB
       FIELDNAMES                      = IT_FIELDNAMES
*   EXCEPTIONS
*     FILE_WRITE_ERROR                = 1
*     NO_BATCH                        = 2
*     GUI_REFUSE_FILETRANSFER         = 3
*     INVALID_TYPE                    = 4
*     NO_AUTHORITY                    = 5
*     UNKNOWN_ERROR                   = 6
*     HEADER_NOT_ALLOWED              = 7
*     SEPARATOR_NOT_ALLOWED           = 8
*     FILESIZE_NOT_ALLOWED            = 9
*     HEADER_TOO_LONG                 = 10
*     DP_ERROR_CREATE                 = 11
*     DP_ERROR_SEND                   = 12
*     DP_ERROR_WRITE                  = 13
*     UNKNOWN_DP_ERROR                = 14
*     ACCESS_DENIED                   = 15
*     DP_OUT_OF_MEMORY                = 16
*     DISK_FULL                       = 17
*     DP_TIMEOUT                      = 18
*     FILE_NOT_FOUND                  = 19
*     DATAPROVIDER_EXCEPTION          = 20
*     CONTROL_FLUSH_ERROR             = 21
*     OTHERS                          = 22
             .

  IF SY-SUBRC = 0.
    MESSAGE S229(ZMM).
  ELSE.
    MESSAGE S230(ZMM).
  ENDIF.

it_tab contains 2800 records ..

Regards

[Former Member]

hi ravi

i got the solution the data contains description and it has double quote (") so it combines 2 rows in one in such sort of data so when i replaced such data it isworking properly

but thanxs for your help

regards

rajan

[Former Member]

Hi Rajan,

Try this

In SE11 Click on Contents. Put the field "Maximum No. of Hits" as 2800.

Choose System --> List -->Save --> Local file.

The no of records downloaded depends on the no of hits displayed. May be this is the problem

Regards

[Former Member]

Hi ravi

now i m doin this with a program and i have used gui_download so during debugging it shows 2800 records

but after downloading it remains 1627 records

regards

rajan

[Former Member]

Hi,

Just try by specifying the maximum no of hits as 2800.And download.

You can view this field when you execute the database table is the last field.

Thanks,

Anil.D