Make the file txt file.
Format in the form of structure defined below in ST.
REPORT ZMB1A NO STANDARD PAGE HEADING LINE-SIZE 255.
"DECLARATION TYPES
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.
"STRUCTURE
TYPES : BEGIN OF ST,
BLDAT(10),
BUDAT(10),
BWARTWA(3),
WERKS(4),
LGORT(4),
MATNR(18),
ERFMG(13),
KONTO(10),
SGTXT(50),
KOSTL(10),
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.
** 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 'SAPMM07M' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'RM07M-BWARTWA'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=NPE'.
PERFORM BDC_FIELD USING 'MKPF-BLDAT'
WA-BLDAT."'01.04.2016'.
PERFORM BDC_FIELD USING 'MKPF-BUDAT'
WA-BUDAT."'20.07.2016'.
PERFORM BDC_FIELD USING 'RM07M-BWARTWA'
WA-BWARTWA."'201'.
PERFORM BDC_FIELD USING 'RM07M-WERKS'
WA-WERKS."'2000'.
PERFORM BDC_FIELD USING 'RM07M-LGORT'
WA-LGORT."'2009'.
PERFORM BDC_FIELD USING 'XFULL'
'X'.
PERFORM BDC_FIELD USING 'RM07M-WVERS2'
'X'.
PERFORM BDC_DYNPRO USING 'SAPMM07M' '0410'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'MSEG-SGTXT'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=BU'.
PERFORM BDC_FIELD USING 'MSEG-MATNR'
WA-MATNR."'300000011'.
PERFORM BDC_FIELD USING 'MSEG-ERFMG'
WA-ERFMG."'250'.
PERFORM BDC_FIELD USING 'MSEG-WERKS'
WA-WERKS."'2000'.
PERFORM BDC_FIELD USING 'MSEG-LGORT'
WA-LGORT."'2009'.
PERFORM BDC_FIELD USING 'DM07M-KONTO'
WA-KONTO."'650999'.
PERFORM BDC_FIELD USING 'MSEG-SGTXT'
WA-SGTXT."'TEST'.
PERFORM BDC_FIELD USING 'DKACB-FMORE'
'X'.
PERFORM BDC_DYNPRO USING 'SAPLKACB' '0002'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'COBL-AUFNR'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=ENTE'.
PERFORM BDC_FIELD USING 'COBL-KOSTL'
WA-KOSTL."'20000'.
PERFORM BDC_TRANSACTION USING 'MB1A'.
ENDLOOP.
PERFORM CLOSE_GROUP.
Format in the form of structure defined below in ST.
REPORT ZMB1A NO STANDARD PAGE HEADING LINE-SIZE 255.
"DECLARATION TYPES
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.
"STRUCTURE
TYPES : BEGIN OF ST,
BLDAT(10),
BUDAT(10),
BWARTWA(3),
WERKS(4),
LGORT(4),
MATNR(18),
ERFMG(13),
KONTO(10),
SGTXT(50),
KOSTL(10),
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.
** 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 'SAPMM07M' '0400'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'RM07M-BWARTWA'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=NPE'.
PERFORM BDC_FIELD USING 'MKPF-BLDAT'
WA-BLDAT."'01.04.2016'.
PERFORM BDC_FIELD USING 'MKPF-BUDAT'
WA-BUDAT."'20.07.2016'.
PERFORM BDC_FIELD USING 'RM07M-BWARTWA'
WA-BWARTWA."'201'.
PERFORM BDC_FIELD USING 'RM07M-WERKS'
WA-WERKS."'2000'.
PERFORM BDC_FIELD USING 'RM07M-LGORT'
WA-LGORT."'2009'.
PERFORM BDC_FIELD USING 'XFULL'
'X'.
PERFORM BDC_FIELD USING 'RM07M-WVERS2'
'X'.
PERFORM BDC_DYNPRO USING 'SAPMM07M' '0410'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'MSEG-SGTXT'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=BU'.
PERFORM BDC_FIELD USING 'MSEG-MATNR'
WA-MATNR."'300000011'.
PERFORM BDC_FIELD USING 'MSEG-ERFMG'
WA-ERFMG."'250'.
PERFORM BDC_FIELD USING 'MSEG-WERKS'
WA-WERKS."'2000'.
PERFORM BDC_FIELD USING 'MSEG-LGORT'
WA-LGORT."'2009'.
PERFORM BDC_FIELD USING 'DM07M-KONTO'
WA-KONTO."'650999'.
PERFORM BDC_FIELD USING 'MSEG-SGTXT'
WA-SGTXT."'TEST'.
PERFORM BDC_FIELD USING 'DKACB-FMORE'
'X'.
PERFORM BDC_DYNPRO USING 'SAPLKACB' '0002'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'COBL-AUFNR'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=ENTE'.
PERFORM BDC_FIELD USING 'COBL-KOSTL'
WA-KOSTL."'20000'.
PERFORM BDC_TRANSACTION USING 'MB1A'.
ENDLOOP.
PERFORM CLOSE_GROUP.
No comments:
Post a Comment