<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: BAPI_MATERIAL_SAVEDATA in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100775#M980578</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Prakash&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;can u tell me that for every tcode there is a bapi or is it that a single bapi serves more tcodes?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 01 Jul 2008 05:11:44 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2008-07-01T05:11:44Z</dc:date>
    <item>
      <title>BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100766#M980569</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;what are all the scenarios that we can use the bapi BAPI_MATERIAL_SAVEDATA.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;what are the transaction codes affected using this bapi?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 04:48:41 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100766#M980569</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T04:48:41Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100767#M980570</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;HI,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;        MM01.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 04:50:04 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100767#M980570</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T04:50:04Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100768#M980571</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;so, can i take it for granted that each tcode has a different bapi or is it that a single bapi can serve multiple Tcodes?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 04:51:10 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100768#M980571</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T04:51:10Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100769#M980572</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;It is in MM01.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For example of using BAPI_MATERIAL_SAVEDATA refer the following link. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="http://www.sap-img.com/abap/bapi-to-copy-materials-from-one-plant-to-another.htm" target="test_blank"&gt;http://www.sap-img.com/abap/bapi-to-copy-materials-from-one-plant-to-another.htm&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Jagadish.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 04:54:47 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100769#M980572</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T04:54:47Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100770#M980573</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;MM01 tcode.....&lt;/P&gt;&lt;P&gt;This function module updates the following tables.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;mara, makt, marc, mard, mpop, marm mpgd, mean , mlan,&lt;/P&gt;&lt;P&gt;mbew, mlgn, mlgt, mvke, mltx, mfhm&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can check the function module for further information&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;reward points if useful.&lt;/P&gt;&lt;P&gt;regards&lt;/P&gt;&lt;P&gt;padma&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Edited by: Padmavathi Palli on Jul 1, 2008 6:56 AM&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 04:56:16 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100770#M980573</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T04:56:16Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100771#M980574</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;this BAPI will effect MM01 ( create material)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;if u wamt to upload a material from a flat file or from already existing material use this BAPI. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am sending u one code for creating a new material from existing material( already created material).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;just copy on yuor system and run.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt; 
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp; Report  ZBAPI
*&amp;amp; prog to copy n create the existing material using bapi .
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;
*&amp;amp;
*&amp;amp;---------------------------------------------------------------------*

REPORT  ZBAPI.

tables : mara, makt , marc.

parameters : new_mat like mara-matnr,
             desc like makt-maktx,
             ref_mat like mara-matnr.
data : begin of it occurs 0,
       matnr like mara-matnr ,
       mbrsh like mara-mbrsh,
       mtart like mara-mtart,
       maktx like makt-maktx,
       meins like mara-meins,
       end of it.

data : ihead_data type BAPIMaTHEAD,
       iclient_data type bapi_mara,
       iclient_datax type bapi_marax,
       imakt like bapi_makt occurs 0 with header line ,
       bapiret like bapiret2.

select matnr mbrsh mtart meins from mara into corresponding fields of it where matnr = ref_mat.

append it.
endselect.

 it-matnr = new_mat.
 it-maktx = desc.
 ihead_data-material = it-matnr.
 ihead_data-ind_sector = it-mbrsh.
 ihead_data-matl_type = it-mtart.
 iclient_data-base_uom = it-meins.
 ihead_data-basic_view = 'X'.
 iclient_datax-base_uom = 'X'.
 imakt-matl_desc = it-maktx.
 imakt-langu = 'E'.
 append imakt.

 CALL FUNCTION 'BAPI_MATERIAL_SAVEDATA'
   EXPORTING
     HEADDATA                   = ihead_data
    CLIENTDATA                 = iclient_data
    CLIENTDATAX                = iclient_datax
*    PLANTDATA                  =
*    PLANTDATAX                 =
*    FORECASTPARAMETERS         =
*    FORECASTPARAMETERSX        =
*    PLANNINGDATA               =
*    PLANNINGDATAX              =
*    STORAGELOCATIONDATA        =
*    STORAGELOCATIONDATAX       =
*    VALUATIONDATA              =
*    VALUATIONDATAX             =
*    WAREHOUSENUMBERDATA        =
*    WAREHOUSENUMBERDATAX       =
*    SALESDATA                  =
*    SALESDATAX                 =
*    STORAGETYPEDATA            =
*    STORAGETYPEDATAX           =
*    FLAG_ONLINE                = ' '
*    FLAG_CAD_CALL              = ' '
*    NO_DEQUEUE                 = ' '
*    NO_ROLLBACK_WORK           = ' '
  IMPORTING
    RETURN                     = bapiret
  TABLES
    MATERIALDESCRIPTION        = imakt
*    UNITSOFMEASURE             =
*    UNITSOFMEASUREX            =
*    INTERNATIONALARTNOS        =
*    MATERIALLONGTEXT           =
*    TAXCLASSIFICATIONS         =
*    RETURNMESSAGES             =
*    PRTDATA                    =
*    PRTDATAX                   =
*    EXTENSIONIN                =
*    EXTENSIONINX               =
           .
message bapiret-message type 'S'.&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:02:44 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100771#M980574</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:02:44Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100772#M980575</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;is this bapi used only to upload the material or any other scenario that  it is useful for?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:05:06 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100772#M980575</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:05:06Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100773#M980576</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;It will effect the Material Create(MM01) transaction through this BAPI.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Reward points if it is helpful.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:05:07 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100773#M980576</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:05:07Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100774#M980577</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;if u want to copy a material from existing material then it can be usefull also if you want to change only the few things in that case this ll also usefull&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;rewards if useful.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;prakash varun&lt;/STRONG&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:08:17 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100774#M980577</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:08:17Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100775#M980578</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Prakash&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;can u tell me that for every tcode there is a bapi or is it that a single bapi serves more tcodes?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:11:44 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100775#M980578</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:11:44Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100776#M980579</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A tcode may have several bapis,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;but one bapi serves for one tcode only.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Jagadish&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:17:31 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100776#M980579</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:17:31Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100777#M980580</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;SAP provides BAPI for almost every thing so when there is a need u just have to find those BAPI in t-code BAPI.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and one more thinf BAPI is nothing but FUNCTION MODULE, so you display BAPI in SE37 and you ll be able to know where &lt;/P&gt;&lt;P&gt;that BAPI can be used&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:19:07 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100777#M980580</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:19:07Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_MATERIAL_SAVEDATA</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100778#M980581</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;by using this bapi tcode mm01 gets affected as well as which view to update like in the below example im updating basic ,sales ,purchase, storage views&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;*&amp;amp;---------------------------------------------------------------------*
*&amp;amp; Report  ZBAPI_MATERIAL_SAVEDATA
*&amp;amp;
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;
*&amp;amp;----------------------------------------------------------------------
*&amp;amp; PURPOSE : THIS REPORT USES BAPI MATERIAL SAVE DATA TO UPDATE AND CREATE
*&amp;amp;           THE MATERIAL
*&amp;amp;
*&amp;amp;
*&amp;amp;
*&amp;amp;
*&amp;amp;---------------------------------------------------------------------*

REPORT  ZBAPI_MATERIAL_SAVEDATA NO STANDARD PAGE HEADING MESSAGE-ID (ZHNC).

TYPES:BEGIN OF TY_MAT,
       MATERIAL(4),
       IND_SECTOR(1),
       MATL_TYPE(4),

       MATL_GROUP(9),
       BASE_UOM(3),
       BASE_UOM_ISO(3),
       PLANT(4),
       DEL_FLAG(1),
       PUR_GROUP(3),
       BASE_QTY(13),
       STGE_LOC(4),
       MRP_IND(1),
       SALES_ORG(4),
       DISTR_CHAN(2),
       DEL_FLAG1(1),
       MIN_ORDER(13),
       LANGU(2),
      MATL_DESC(40),

   END OF TY_MAT.


DATA: IT_DATA TYPE TABLE OF TY_MAT,
      WA_DATA LIKE LINE  OF IT_DATA.

*decalraing flag

data: v_flag value ''.


*DECLARING WORK AREAs  TO BE PASSED TO THE FUNCTION MODULE.

DATA: BAPI_HEAD LIKE BAPIMATHEAD,
      BAPI_CLIENTDATA LIKE BAPI_MARA,
      BAPI_CLIENTDATAX LIKE BAPI_MARAX,
      BAPI_PLANTDATA LIKE BAPI_MARC,
      BAPI_PLANTDATAX LIKE  BAPI_MARCX,
      BAPI_STORAGELOCATIONDATA LIKE BAPI_MARD,
      BAPI_STORAGELOCATIONDATAX LIKE BAPI_MARDX,
      BAPI_SALESDATA LIKE BAPI_MVKE,
      BAPI_SALESDATAX LIKE BAPI_MVKEX,
      BAPI_MAKT LIKE BAPI_MAKT,
      BAPI_RETURN LIKE BAPIRET2.

*INTERNAL TABLE TO HOLD THE MATERIAL DESCRIPTION

DATA: BEGIN OF IT_MAKT OCCURS 0.
INCLUDE STRUCTURE BAPI_MAKT.
DATA END OF IT_MAKT.

DATA:BEGIN OF IT_RET OCCURS 0.
INCLUDE STRUCTURE BAPIRET2.
DATA END OF IT_RET.

*INTERNAL TABLE TO HOLD HEADER DATA

DATA: IT_EXCEL TYPE ALSMEX_TABLINE OCCURS 0 WITH HEADER LINE.

*SELECTION-SCREEN ELEMENTS

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETER: FNAME TYPE RLGRAP-FILENAME OBLIGATORY DEFAULT 'C:\Documents and Settings\Administrator\Desktop\MATMAS.XLS' .
PARAMETERS: P_BEGCOL TYPE I DEFAULT 1 NO-DISPLAY,
            P_BEGROW TYPE I DEFAULT 1 NO-DISPLAY,
            P_ENDCOL TYPE I DEFAULT 100 NO-DISPLAY,
            P_ENDROW TYPE I DEFAULT 32000 NO-DISPLAY.


SELECTION-SCREEN END OF BLOCK B1.

*DECLARATION OF EXCELAL TABLE

AT SELECTION-SCREEN ON VALUE-REQUEST FOR FNAME.

PERFORM F_GET_FILE USING FNAME.


START-OF-SELECTION.

PERFORM F_XLS_ITAB USING FNAME
                   CHANGING IT_EXCEL.

PERFORM F_MOVE_DATA.

perform F_GET_DATA.






*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_GET_FILE
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      --&amp;gt;P_FNAME  text
*      &amp;lt;--P_SY_SUBRC  text
*----------------------------------------------------------------------*
FORM F_GET_FILE  USING    P_FNAME LIKE FNAME.


CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
 EXPORTING
   PROGRAM_NAME        = SYST-REPID
   DYNPRO_NUMBER       = SYST-DYNNR
*   FIELD_NAME          = ' '
*   STATIC              = ' '
*   MASK                = ' '
  CHANGING
    FILE_NAME           = P_FNAME
* EXCEPTIONS
*   MASK_TOO_LONG       = 1
*   OTHERS              = 2
          .
IF SY-SUBRC &amp;lt;&amp;gt; 0.
MESSAGE E006(ZHNC).
ENDIF.

ENDFORM.                    " F_GET_FILE
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_XLS_ITAB
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      --&amp;gt;P_FNAME  text
*      &amp;lt;--P_IT_EXCEL  text
*----------------------------------------------------------------------*
FORM F_XLS_ITAB  USING    P_FNAME
                 CHANGING P_IT_EXCEL.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
  EXPORTING
    FILENAME                      = FNAME
    I_BEGIN_COL                   = P_BEGCOL
    I_BEGIN_ROW                   = P_BEGROW
    I_END_COL                     = P_ENDCOL
    I_END_ROW                     = P_ENDROW
  TABLES
    INTERN                        = IT_EXCEL
 EXCEPTIONS
   INCONSISTENT_PARAMETERS       = 1
   UPLOAD_OLE                    = 2
   OTHERS                        = 3
          .
IF SY-SUBRC &amp;lt;&amp;gt; 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

ENDFORM.                    " F_XLS_ITAB
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_MOVE_DATA
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  --&amp;gt;  p1        text
*  &amp;lt;--  p2        text
*----------------------------------------------------------------------*
FORM F_MOVE_DATA .

DATA : LV_INDEX TYPE I.

FIELD-SYMBOLS &amp;lt;FS&amp;gt;.

*--- Sorting the internal table

SORT IT_EXCEL BY ROW COL.

CLEAR IT_EXCEL.

LOOP AT IT_EXCEL.

MOVE IT_EXCEL-COL TO LV_INDEX.

*--- Assigning the each record to an internal table row

ASSIGN COMPONENT LV_INDEX OF STRUCTURE WA_DATA TO &amp;lt;FS&amp;gt;.

*--- Asigning the field value to a field symbol

MOVE IT_EXCEL-VALUE TO &amp;lt;FS&amp;gt;.

AT END OF ROW.

APPEND WA_DATA TO IT_DATA.

CLEAR WA_DATA.

ENDAT.

ENDLOOP.

*
ENDFORM.                    " F_MOVE_DATA
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_GET_DATA
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  --&amp;gt;  p1        text
*  &amp;lt;--  p2        text
*----------------------------------------------------------------------*
FORM F_GET_DATA .
LOOP AT IT_DATA INTO WA_DATA.

MOVE-CORRESPONDING WA_DATA  TO  BAPI_HEAD.

BAPI_HEAD-BASIC_VIEW ='X'.

BAPI_HEAD-SALES_VIEW ='X'.

BAPI_HEAD-PURCHASE_VIEW ='X'.

BAPI_HEAD-STORAGE_VIEW ='X'.

MOVE-CORRESPONDING WA_DATA TO BAPI_CLIENTDATA.

BAPI_CLIENTDATAX-MATL_GROUP = 'X'.

BAPI_CLIENTDATAX-BASE_UOM = 'X'.

BAPI_CLIENTDATAX-BASE_UOM_ISO = 'X'.

MOVE-CORRESPONDING WA_DATA TO BAPI_PLANTDATA.

BAPI_PLANTDATAX-PLANT = BAPI_PLANTDATA-PLANT.

BAPI_PLANTDATAX-DEL_FLAG = 'X'.

BAPI_PLANTDATAX-PUR_GROUP = 'X'.

BAPI_PLANTDATAX-BASE_QTY = 'X'.

MOVE-CORRESPONDING WA_DATA TO BAPI_STORAGELOCATIONDATA.

BAPI_STORAGELOCATIONDATA-PLANT = BAPI_PLANTDATA-PLANT.

BAPI_STORAGELOCATIONDATAX-PLANT = BAPI_STORAGELOCATIONDATA-PLANT.

BAPI_STORAGELOCATIONDATAX-STGE_LOC = BAPI_STORAGELOCATIONDATA-STGE_LOC.

BAPI_STORAGELOCATIONDATAX-MRP_IND = 'X'.

MOVE-CORRESPONDING WA_DATA TO BAPI_SALESDATA.

BAPI_SALESDATAX-SALES_ORG = BAPI_SALESDATA-SALES_ORG.

BAPI_SALESDATAX-DISTR_CHAN = BAPI_SALESDATA-DISTR_CHAN.

BAPI_SALESDATAX-DEL_FLAG = BAPI_SALESDATA-DEL_FLAG.

BAPI_SALESDATAX-MIN_ORDER = 'X'.

REFRESH IT_MAKT.

IT_MAKT-LANGU = WA_DATA-LANGU.

IT_MAKT-MATL_DESC = WA_DATA-MATL_DESC.

APPEND IT_MAKT.

CLEAR IT_RET.

REFRESH IT_RET.

PERFORM F_CALL_BAPI.


READ TABLE IT_RET WITH KEY TYPE = 'S'.



IF SY-SUBRC EQ 0.

PERFORM F_BAPI_COMMIT.

WRITE:/ 'MATERIAL CREATED OR UPDATED SUCESSFULLY WITH MATERIAL NO',WA_DATA-MATERIAL.

ELSE.


MESSAGE E000(ZHNC) WITH 'ERROR IN CREATING THE MATERIAL'.

*WRITE: / 'ERROR IN CREATIN MATERIAL',IT_RET-MESSAGE.

*PERFORM F_DOWNLOAD.

ENDIF.

*ENDIF.

ENDLOOP.

ENDFORM.                    " F_GET_DATA
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_CALL_BAPI
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  --&amp;gt;  p1        text
*  &amp;lt;--  p2        text
*----------------------------------------------------------------------*
FORM F_CALL_BAPI .
CALL FUNCTION 'BAPI_MATERIAL_SAVEDATA'
  EXPORTING
    HEADDATA                   = BAPI_HEAD
   CLIENTDATA                 =  BAPI_CLIENTDATA
   CLIENTDATAX                =  BAPI_CLIENTDATAX
   PLANTDATA                  =  BAPI_PLANTDATA
   PLANTDATAX                 =  BAPI_PLANTDATAX
   STORAGELOCATIONDATA        =  BAPI_STORAGELOCATIONDATA
   STORAGELOCATIONDATAX       =  BAPI_STORAGELOCATIONDATAX
   SALESDATA                  =  BAPI_SALESDATA
   SALESDATAX                 =  BAPI_SALESDATAX
 IMPORTING
   RETURN                     =  IT_RET
 TABLES
   MATERIALDESCRIPTION        = IT_MAKT
*   UNITSOFMEASURE             =
*   UNITSOFMEASUREX            =
*   INTERNATIONALARTNOS        =
*   MATERIALLONGTEXT           =
*   TAXCLASSIFICATIONS         =
*   RETURNMESSAGES             =
*   PRTDATA                    =
*   PRTDATAX                   =
*   EXTENSIONIN                =
*   EXTENSIONINX               =
          .

APPEND IT_RET.

ENDFORM.                    " F_CALL_BAPI
*&amp;amp;---------------------------------------------------------------------*
*&amp;amp;      Form  F_BAPI_COMMIT
*&amp;amp;---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  --&amp;gt;  p1        text
*  &amp;lt;--  p2        text
*----------------------------------------------------------------------*
FORM F_BAPI_COMMIT .

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
* EXPORTING
*   WAIT         =
* IMPORTING
*   RETURN        =
          .







ENDFORM.                    " F_BAPI_COMMIT&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 01 Jul 2008 05:23:59 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-material-savedata/m-p/4100778#M980581</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-07-01T05:23:59Z</dc:date>
    </item>
  </channel>
</rss>

