report Z_VA01_BDC.
types:
begin of ty_tab,
header_id type i,
po_num type BSTKD,
sold_to type KUNNR,
ship_to type KUNNR,
material type MATNR,
quantity type char10,
end of ty_tab.
data:
it_tab type standard table of ty_tab,
wa_tab type ty_tab,
it_bdc like bdcdata occurs 0 with header line.
*** End generated data section ***
start-of-selection.
perform upload_data.
perform batch_data.
*&---------------------------------------------------------------------*
*& Form UPLOAD_DATA
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
form UPLOAD_DATA .
field-symbols:<fs>.
data:
l_answer(1) type c,
it_exc type alsmex_tabline occurs 0 with header line.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = 'C:\Users\x.zheng\Desktop\练习\va01.XLSX'
i_begin_col = 1
i_begin_row = 2
i_end_col = 50
i_end_row = 5000
tables
intern = it_exc
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
else.
IF it_exc[] is initial.
CALL F
types:
begin of ty_tab,
header_id type i,
po_num type BSTKD,
sold_to type KUNNR,
ship_to type KUNNR,
material type MATNR,
quantity type char10,
end of ty_tab.
data:
it_tab type standard table of ty_tab,
wa_tab type ty_tab,
it_bdc like bdcdata occurs 0 with header line.
*** End generated data section ***
start-of-selection.
perform upload_data.
perform batch_data.
*&---------------------------------------------------------------------*
*& Form UPLOAD_DATA
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
form UPLOAD_DATA .
field-symbols:<fs>.
data:
l_answer(1) type c,
it_exc type alsmex_tabline occurs 0 with header line.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = 'C:\Users\x.zheng\Desktop\练习\va01.XLSX'
i_begin_col = 1
i_begin_row = 2
i_end_col = 50
i_end_row = 5000
tables
intern = it_exc
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
else.
IF it_exc[] is initial.
CALL F