Make the file in txt format having the fields that are defined in the Structure below -
REPORT ZABAA 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.
TABLES: RAIFP1, RAIFP2, ANLA.
"STRUCTURE
TYPES : BEGIN OF ST,
BUKRS(4),
ANLN1(12),
ANLN2(4),
BLDAT(10),
BUDAT(10),
PERID(2),
BWASL(3),
DMBTR(13),
BZDAT(13),
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 'SAPMA01B' '0100'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'ANBZ-ANLN1'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'/00'.
PERFORM BDC_FIELD USING 'ANBZ-BUKRS'
WA-BUKRS."'RCFL'.
PERFORM BDC_FIELD USING 'ANBZ-ANLN1'
WA-ANLN1."'80027979'.
PERFORM BDC_FIELD USING 'ANBZ-ANLN2'
WA-ANLN2."'0'.
PERFORM BDC_FIELD USING 'ANEK-BLDAT'
WA-BLDAT."'12.12.2014'.
PERFORM BDC_FIELD USING 'ANEK-BUDAT'
WA-BUDAT."'12.12.2014'.
PERFORM BDC_FIELD USING 'ANBZ-PERID'
WA-PERID."'9'.
PERFORM BDC_FIELD USING 'ANBZ-BWASL'
WA-BWASL."'640'.
PERFORM BDC_DYNPRO USING 'SAPMA01B' '0110'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'ANBZ-BZDAT'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=UPDA'.
PERFORM BDC_FIELD USING 'ANBZ-DMBTR'
WA-DMBTR."'7129.50'.
PERFORM BDC_FIELD USING 'ANBZ-BZDAT'
WA-BZDAT."'01.04.2014'.
PERFORM BDC_TRANSACTION USING 'ABAA'.
ENDLOOP.
PERFORM CLOSE_GROUP.
REPORT ZABAA 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.
TABLES: RAIFP1, RAIFP2, ANLA.
"STRUCTURE
TYPES : BEGIN OF ST,
BUKRS(4),
ANLN1(12),
ANLN2(4),
BLDAT(10),
BUDAT(10),
PERID(2),
BWASL(3),
DMBTR(13),
BZDAT(13),
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 'SAPMA01B' '0100'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'ANBZ-ANLN1'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'/00'.
PERFORM BDC_FIELD USING 'ANBZ-BUKRS'
WA-BUKRS."'RCFL'.
PERFORM BDC_FIELD USING 'ANBZ-ANLN1'
WA-ANLN1."'80027979'.
PERFORM BDC_FIELD USING 'ANBZ-ANLN2'
WA-ANLN2."'0'.
PERFORM BDC_FIELD USING 'ANEK-BLDAT'
WA-BLDAT."'12.12.2014'.
PERFORM BDC_FIELD USING 'ANEK-BUDAT'
WA-BUDAT."'12.12.2014'.
PERFORM BDC_FIELD USING 'ANBZ-PERID'
WA-PERID."'9'.
PERFORM BDC_FIELD USING 'ANBZ-BWASL'
WA-BWASL."'640'.
PERFORM BDC_DYNPRO USING 'SAPMA01B' '0110'.
PERFORM BDC_FIELD USING 'BDC_CURSOR'
'ANBZ-BZDAT'.
PERFORM BDC_FIELD USING 'BDC_OKCODE'
'=UPDA'.
PERFORM BDC_FIELD USING 'ANBZ-DMBTR'
WA-DMBTR."'7129.50'.
PERFORM BDC_FIELD USING 'ANBZ-BZDAT'
WA-BZDAT."'01.04.2014'.
PERFORM BDC_TRANSACTION USING 'ABAA'.
ENDLOOP.
PERFORM CLOSE_GROUP.
No comments:
Post a Comment