Saturday, September 20, 2014

BDC for J1IUN Transaction MM Module

REPORT ZJ1IUN NO STANDARD PAGE HEADING LINE-SIZE 255.

*TYPES DECLARATION
DATAW_FILENAME TYPE STRING.
SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-500.
PARAMETERSP_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