Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SIZE OF TABLE

Former Member
0 Kudos

I m having some 500000 records in my legacy system is it possible to load it in SAP system.

how to do it..

i splitted the text file & uploaded into an Internal table when i modify the database table i m able to find only 10,000 records.

how to upload all 500000 records..

Thanks in advance

14 REPLIES 14

Former Member
0 Kudos

YES YOU CAN UPLOAD WITH BDC NA

Former Member
0 Kudos

Hi,

You can write the BDC program for this, Goto SE31 then give the table name and press New entries button then enter the new entries, for this write the BDC

Regards

Sudheer

former_member194669
Active Contributor
0 Kudos

Hi,

Please provide more details about your query. possible paste the code here.

aRs

Former Member
0 Kudos

ya we can do it with bdc my problem is not tht even though i increase the size category of the table i m not able to store more than 12,000 records in the database table..

how to increase the size of table to accept 500000 records

Former Member
0 Kudos

hi Maya

you can very well upload it into your SAP system using BDC concept...

jus use the function module GUI_UPLOAD thro patterns and give the details like filename,filetype,filelength and data table...and definitely 500000 records will be updated.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME =

  • FILETYPE = 'ASC'

  • HAS_FIELD_SEPARATOR = ' '

  • HEADER_LENGTH = 0

  • READ_BY_LINE = 'X'

  • DAT_MODE = ' '

  • CODEPAGE = ' '

  • IGNORE_CERR = ABAP_TRUE

  • REPLACEMENT = '#'

  • CHECK_BOM = ' '

  • VIRUS_SCAN_PROFILE =

  • NO_AUTH_CHECK = ' '

  • IMPORTING

  • FILELENGTH =

  • HEADER =

TABLES

DATA_TAB =

  • EXCEPTIONS

  • FILE_OPEN_ERROR = 1

  • FILE_READ_ERROR = 2

  • NO_BATCH = 3

  • GUI_REFUSE_FILETRANSFER = 4

  • INVALID_TYPE = 5

  • NO_AUTHORITY = 6

  • UNKNOWN_ERROR = 7

  • BAD_DATA_FORMAT = 8

  • HEADER_NOT_ALLOWED = 9

  • SEPARATOR_NOT_ALLOWED = 10

  • HEADER_TOO_LONG = 11

  • UNKNOWN_DP_ERROR = 12

  • ACCESS_DENIED = 13

  • DP_OUT_OF_MEMORY = 14

  • DISK_FULL = 15

  • DP_TIMEOUT = 16

  • OTHERS = 17

.

IF SY-SUBRC <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

REWARD IF USEFUL....!!

0 Kudos

thanks asha,

for example my text file hase 65,323 records using the FM i m able to get all 65,323 records in my internal table.

Now how to insert those 65,323 records in my database table.

0 Kudos

Hi Maya,

If you are usign GUI_UPLOAD then only 65,323 records can be uploaded into SAP at time. So divide 500000 records into file of upto 65000 records in a file & the upload one by one.

Ashvender

0 Kudos

still u didnt get my problem.

even though i split as 65,000, i m able to upload only 12,915 records in my database table.

remaning 53,000 records r missing. how to load 65,000 records in the table first clear this then i will try for 5000000 records.

Thanks

0 Kudos

What is the size category of your table?

Here is the size categories and number of recors relation:

SzCat Number of data records of table expected

0 0 to 3,800

1 3,800 to 15,000

2 15,000 to 62,000

3 62,000 to 240,000

4 240,000 to 990,000

5 990,000 to 1,900,000

6 1,900,000 to 3,900,000

7 3,900,000 to 7,900,000

8 7,900,000 to 15,000,000

Regards,

Ravi

0 Kudos

i specified as 9.

Data records expected: 59,000,000 to 2.300000E+09.

eventhough showing the same 12,000 records.

Why?

0 Kudos

Hi,

Can you paste the code you have written.

Ashven

0 Kudos

loop at it into wa.

date1 = wa-cald.

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = date1

IMPORTING

DATE_EXTERNAL = dates

  • EXCEPTIONS

  • DATE_INTERNAL_IS_INVALID = 1

  • OTHERS = 2

.

IF SY-SUBRC <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

wa-cald = dates.

*break-point.

modify ztesttb from wa.

endloop.

in IT i m having 65,323 records.

0 Kudos

Hi Maya,

You can try the below code for uplaoding the file. Below mentioned code is uploading 65535 records in the internal table.


DATA: BEGIN OF struc OCCURS 0,
        f1(10) TYPE c,
        f2(10) TYPE c,
      END OF struc.

DATA: count(7) TYPE n.

DATA: v_file             TYPE string.

CONSTANTS: c_tab         TYPE  abap_char1
                         VALUE cl_abap_char_utilities=>horizontal_tab.



PARAMETERS: p_file      TYPE rlgrap-filename.


AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
  CALL FUNCTION 'F4_FILENAME'
    EXPORTING
      program_name  = syst-cprog
      dynpro_number = syst-dynnr
    IMPORTING
      file_name     = p_file.


START-OF-SELECTION.

  v_file = p_file.

  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = v_file
      has_field_separator     = c_tab
    TABLES
      data_tab                = struc
    EXCEPTIONS
      file_open_error         = 1
      file_read_error         = 2
      no_batch                = 3
      gui_refuse_filetransfer = 4
      invalid_type            = 5
      no_authority            = 6
      unknown_error           = 7
      bad_data_format         = 8
      header_not_allowed      = 9
      separator_not_allowed   = 10
      header_too_long         = 11
      unknown_dp_error        = 12
      access_denied           = 13
      dp_out_of_memory        = 14
      disk_full               = 15
      dp_timeout              = 16
      OTHERS                  = 17.

  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

  DESCRIBE TABLE struc LINES count.

Reward points for helpful answers.

Ashvender

former_member194669
Active Contributor
0 Kudos

Hi,

Try to copy the file to an application server, and upload using OPEN DATASET syntax.

aRs