topic Re: Regarding Material extension - Upload through excel in Application Development and Automation Discussions

Regarding Material extension - Upload through excel

Former Member — Mon, 27 Oct 2014 10:37:30 GMT

Dear Experts,

I'm new to abap .Request all your help in solving for material extension for different plant and different storage location by using Bapi 'BAPI_MATERIAL_SAVEDATA'.

Requirement : Upload program needs to be created for material extension by uploading excel file . Request to share the correct coding.

Coding i was trying to do is as below and while checking i got the errror : " Statement is not accessible"

REPORT ZPP_MAT_EXT.

tables : BAPIMATHEAD.

data : BEGIN OF itab occurs 0,
...

PARAMETERS: p_file type RLGRAP-filename.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
perform get_f4_help.

START-OF-SELECTION.
   perform upload_file.
   perform call_bapi.

FORM GET_F4_HELP .
...
ENDFORM.                    " GET_F4_HELP

data : v_file type string.
MOVE p_file TO v_file.

CALL FUNCTION 'GUI_UPLOAD'       -----> Error : " " Statement is not accessible"
   EXPORTING
     FILENAME                      = p_file
...

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
    WAIT          = 2.
* IMPORTING
*   RETURN        =

Message was edited by: Matthew Billingham - to make it pretty obvious what the error is

Re: Regarding Material extension - Upload through excel

FredericGirod — Mon, 27 Oct 2014 10:53:03 GMT

Hi,

your BAPI call is not inside a routine (FORM / ENDFORM)

regards

Fred

Re: Regarding Material extension - Upload through excel

Former Member — Mon, 27 Oct 2014 11:05:50 GMT

Dear Fred,

After calling bapi inside the routine also the same error is displaying.

Best rgds/thnks,

Srikanth.

Re: Regarding Material extension - Upload through excel

FredericGirod — Mon, 27 Oct 2014 11:09:19 GMT

do you have put your BAPI COMMIT also ?

Re: Regarding Material extension - Upload through excel

Former Member — Mon, 27 Oct 2014 11:21:52 GMT

yes i've put bapi commit also. Request to share the coding for the material master extension through BAPI , if any..

Best rgds/thnks,
Srikanth.

Re: Regarding Material extension - Upload through excel

pavanm592 — Mon, 27 Oct 2014 11:25:37 GMT

Hi Srikanth,

Please Check the attachment and execute the code .

Regards,

Pavan

Re: Regarding Material extension - Upload through excel

Former Member — Mon, 27 Oct 2014 11:38:47 GMT

Dear Pavan,

Thanks for sharing the code. Will try and revert.

Best rgds/thnks,
Srikanth.

Re: Regarding Material extension - Upload through excel

matt — Mon, 27 Oct 2014 11:52:16 GMT

I've edited your post to make it clear what the issue is. You have ABAP code after the FORM... ENDFORM. It will never be run.

Since this is so darned obvious, I've marked your question as a discussion.