REPORT ZJ1IUN NO STANDARD PAGE HEADING LINE-SIZE 255.
*TYPES DECLARATION
DATA: W_FILENAME TYPE STRING.
SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-500.
PARAMETERS: P_FILENM LIKE RLGRAP-FILENAME.
SELECTION-SCREEN END OF BLOCK B1.
TYPES : BEGIN OF ST,
J_1IDOCNUM(10),
J_1ISECREF(10),
J_1IFRMTYP(3),
J_1IFRMYER(4),
J_1IVENCUS(10),
J_1IFRMNUM(10),
J_1IISSDAT(10),
J_1IFRMSND(1),
J_1IDUEDAT(10),
J_1IACTDAT(10),
J_1IFRMAMT(13),
J_1IAMTUNT(5),
J_1ISTATUS(1),
J_1IREMARK(40),
END OF ST.
*INTERNAL TABLE AND WORKAREA DECLARATION
DATA : IT TYPE TABLE OF ST.
DATA : WA TYPE ST.
INCLUDE BDCRECX1.
START-OF-SELECTION.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILENM.
CALL FUNCTION 'WS_FILENAME_GET'
EXPORTING
MASK = ',*.*,*.*.'
MODE = '0'
TITLE = 'GET FILE NAME'
IMPORTING
FILENAME = P_FILENM
EXCEPTIONS
INV_WINSYS = 1
NO_BATCH = 2
SELECTION_CANCEL = 3
SELECTION_ERROR = 4
OTHERS = 5.
** END OF CHANGE DCS05052003
** START OF CHANGE DCS05052003
START-OF-SELECTION.
W_FILENAME = P_FILENM.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
** FILENAME = 'C:\BDC_XLS_ASSIGN.TXT'
FILENAME = W_FILENAME
FILETYPE = 'ASC'
HAS_FIELD_SEPARATOR = 'X'
TABLES
DATA_TAB = IT
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.
PERFORM OPEN_GROUP.
LOOP AT IT INTO WA.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0200'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=OTHE'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'V_J_1IDOCNUM'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=CREA'.
PERFORM BDC_FIELD USING 'V_J_1IDOCNUM'
WA-J_1IDOCNUM."'5105640684'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'V_J_1IDOCNUM'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=IROW'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'T_FRDTOT-J_1IREMARK(01)'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=SAVE'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1ISECREF(01)'
WA-J_1ISECREF."'686'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMTYP(01)'
WA-J_1IFRMTYP."'C'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMYER(01)'
WA-J_1IFRMYER."'2013'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IVENCUS(01)'
WA-J_1IVENCUS."'100675'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMNUM(01)'
WA-J_1IFRMNUM."'1418186200'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IISSDAT(01)'
WA-J_1IISSDAT."'21.08.2014'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMSND(01)'
WA-J_1IFRMSND."'X'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IDUEDAT(01)'
WA-J_1IDUEDAT."''.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IACTDAT(01)'
WA-J_1IACTDAT."'21.08.2014'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMAMT(01)'
WA-J_1IFRMAMT."'137872'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IAMTUNT(01)'
WA-J_1IAMTUNT."'INR'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1ISTATUS(01)'
WA-J_1ISTATUS."'S'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IREMARK(01)'
WA-J_1IREMARK."'SENT THRU SPEED POST'.
PERFORM BDC_TRANSACTION USING 'J1IUN'.
ENDLOOP.
PERFORM CLOSE_GROUP.
*TYPES DECLARATION
DATA: W_FILENAME TYPE STRING.
SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-500.
PARAMETERS: P_FILENM LIKE RLGRAP-FILENAME.
SELECTION-SCREEN END OF BLOCK B1.
TYPES : BEGIN OF ST,
J_1IDOCNUM(10),
J_1ISECREF(10),
J_1IFRMTYP(3),
J_1IFRMYER(4),
J_1IVENCUS(10),
J_1IFRMNUM(10),
J_1IISSDAT(10),
J_1IFRMSND(1),
J_1IDUEDAT(10),
J_1IACTDAT(10),
J_1IFRMAMT(13),
J_1IAMTUNT(5),
J_1ISTATUS(1),
J_1IREMARK(40),
END OF ST.
*INTERNAL TABLE AND WORKAREA DECLARATION
DATA : IT TYPE TABLE OF ST.
DATA : WA TYPE ST.
INCLUDE BDCRECX1.
START-OF-SELECTION.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILENM.
CALL FUNCTION 'WS_FILENAME_GET'
EXPORTING
MASK = ',*.*,*.*.'
MODE = '0'
TITLE = 'GET FILE NAME'
IMPORTING
FILENAME = P_FILENM
EXCEPTIONS
INV_WINSYS = 1
NO_BATCH = 2
SELECTION_CANCEL = 3
SELECTION_ERROR = 4
OTHERS = 5.
** END OF CHANGE DCS05052003
** START OF CHANGE DCS05052003
START-OF-SELECTION.
W_FILENAME = P_FILENM.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
** FILENAME = 'C:\BDC_XLS_ASSIGN.TXT'
FILENAME = W_FILENAME
FILETYPE = 'ASC'
HAS_FIELD_SEPARATOR = 'X'
TABLES
DATA_TAB = IT
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.
PERFORM OPEN_GROUP.
LOOP AT IT INTO WA.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0200'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=OTHE'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'V_J_1IDOCNUM'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=CREA'.
PERFORM BDC_FIELD USING 'V_J_1IDOCNUM'
WA-J_1IDOCNUM."'5105640684'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'V_J_1IDOCNUM'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=IROW'.
PERFORM BDC_DYNPRO USING 'SAPMJ1IUN' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'T_FRDTOT-J_1IREMARK(01)'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=SAVE'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1ISECREF(01)'
WA-J_1ISECREF."'686'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMTYP(01)'
WA-J_1IFRMTYP."'C'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMYER(01)'
WA-J_1IFRMYER."'2013'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IVENCUS(01)'
WA-J_1IVENCUS."'100675'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMNUM(01)'
WA-J_1IFRMNUM."'1418186200'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IISSDAT(01)'
WA-J_1IISSDAT."'21.08.2014'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMSND(01)'
WA-J_1IFRMSND."'X'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IDUEDAT(01)'
WA-J_1IDUEDAT."''.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IACTDAT(01)'
WA-J_1IACTDAT."'21.08.2014'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IFRMAMT(01)'
WA-J_1IFRMAMT."'137872'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IAMTUNT(01)'
WA-J_1IAMTUNT."'INR'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1ISTATUS(01)'
WA-J_1ISTATUS."'S'.
PERFORM BDC_FIELD USING 'T_FRDTOT-J_1IREMARK(01)'
WA-J_1IREMARK."'SENT THRU SPEED POST'.
PERFORM BDC_TRANSACTION USING 'J1IUN'.
ENDLOOP.
PERFORM CLOSE_GROUP.
No comments:
Post a Comment