How to upload material data using batch input recording ?

[Former Member]

Hello ,

I want to upload material data using transaction mm01 .

When I execute my project first 3 details are filled correctly like matnr mbrsh and matkl

After this it select views which have selected during recording but when 3 screen appears that is with blank details (where system takes detialsnfor plant and storage location ) flollowing error message appeared.

No batch input data for screen saplmg0080 .

Have did lsmw for mm01 several times but not able to understand what is the problem ? Also have checked my notepad file but contains no error.

Also will you please help me to how to upload data for mm01 using direct input method .

Have checked on sap technical.com but not able to understand .

Please go through below link

<< Invalid url removed >>

Not able to understand from where they have mapped below fields like

Stype  tcode Group Mandy start keep

If you could please provide me the solution for both of them it will be great and also the difference between them.

And if some examples available please provide me  to understand direct input method and recording method deeply.

Thanks and regards ,

Prasad Naralkar .

Message was edited by: Kesavadas Thekkillath

[Former Member]

It is better to use the BAPI approach as a little config change, changes a lot in material views...

sample code : http://saptechnical.com/Tips/BAPI/Material/Create.htm

If you need further help let me know.

[former_member198834]

Hi Prasad,

Its better to use BAPI or BDC, based on the material types ,the screen sequence will be change . here is sample code for BAPI.

CLEAR WA_EQUIP.

LOOP AT IT_EQUIP INTO WA_EQUIP.

  CLEAR  : WA_MATHEAD,WA_MARC,WA_MARCX,WA_MVKE,WA_MVKEX,WA_MARA,WA_MARAX,WA_MBEW, WA_MBEWX.

  REFRESH : IT_MARM, IT_MLAN,IT_MAKT.

WA_MATHEAD-MATERIAL = WA_EQUIP-MATNR.

WA_MATHEAD-MATL_TYPE  = WA_EQUIP-MTART.

WA_MATHEAD-IND_SECTOR = WA_EQUIP-MBRSH.

CASE WA_EQUIP-MTART.

WHEN 'ZOED'.

  WA_MATHEAD-BASIC_VIEW = C_X.

  WA_MATHEAD-SALES_VIEW = C_X.

  WA_MATHEAD-ACCOUNT_VIEW  = C_X.

  WA_MATHEAD-PURCHASE_VIEW = C_X.

  WA_MATHEAD-COST_VIEW = C_X.

  WA_MATHEAD-STORAGE_VIEW = C_X.

" newely added

WHEN 'ZOEA'.

  WA_MATHEAD-BASIC_VIEW = C_X.

  WA_MATHEAD-SALES_VIEW = C_X.

  WA_MATHEAD-ACCOUNT_VIEW  = C_X.

  WA_MATHEAD-PURCHASE_VIEW = C_X.

  WA_MATHEAD-COST_VIEW = C_X.

" NEW MATERIAL TYPE ZRCE ON 3/08/2011

WHEN 'ZRCE'.

  WA_MATHEAD-BASIC_VIEW = C_X.

  WA_MATHEAD-SALES_VIEW = C_X.

  WA_MATHEAD-ACCOUNT_VIEW  = C_X.

  WA_MATHEAD-PURCHASE_VIEW = C_X.

  WA_MATHEAD-COST_VIEW = C_X.

WHEN 'ZVEP'.

  WA_MATHEAD-BASIC_VIEW = C_X.

WA_MATHEAD-SALES_VIEW = C_X.

WHEN 'ZOER'.

  WA_MATHEAD-BASIC_VIEW = C_X.

  WHEN 'ZOEN'.

  WA_MATHEAD-BASIC_VIEW = C_X.

WHEN OTHERS.

  EXIT.

ENDCASE.

* ORGANIZATION DATA.

*PLANT

WA_MARD-PLANT = WA_EQUIP-WERKS.

WA_MARDX-PLANT = WA_EQUIP-WERKS.

WA_MARC-PLANT = WA_EQUIP-WERKS.

WA_MARCX-PLANT = WA_EQUIP-WERKS.

*

* SALE ORGANIZATION.

WA_MVKE-SALES_ORG = WA_EQUIP-VKORG.

WA_MVKEX-SALES_ORG = WA_EQUIP-VKORG.

*

* DISTRIBUTION CHANNEL

WA_MVKE-DISTR_CHAN  = WA_EQUIP-VTWEG.

WA_MVKEX-DISTR_CHAN  = WA_EQUIP-VTWEG.

   WA_MARD-STGE_LOC = WA_EQUIP-LGORT.      " STORAGE LOCATION

   WA_MARDX-STGE_LOC = WA_EQUIP-LGORT.

* FOR BASIC DATA

*MATERIAL DISCRIPTION.

*   BASE UNIT OF MEASURE

WA_MARA-BASE_UOM  = WA_EQUIP-MEINS.

WA_MARAX-BASE_UOM  = C_X.

*   MATERILA GROUP.

WA_MARA-MATL_GROUP  = WA_EQUIP-MATKL.

WA_MARAX-MATL_GROUP  = C_X.

*   OLD MATERIL NUMBER

WA_MARA-OLD_MAT_NO  = WA_EQUIP-BISMT.

WA_MARAX-OLD_MAT_NO  = C_X.

*   DIVISION

WA_MARA-DIVISION  = WA_EQUIP-SPART.

WA_MARAX-DIVISION  = C_X.

*     GENERAL ITEM CATAGEORY

WA_MARA-ITEM_CAT  = WA_EQUIP-MTPOS_MARA .

WA_MARAX-ITEM_CAT  = C_X .

*     NET WEIGHT

WA_MARA-NET_WEIGHT  = WA_EQUIP-NTGEW.

WA_MARAX-NET_WEIGHT  = C_X.

*     WEIGHT UNIT

WA_MARA-UNIT_OF_WT  = WA_EQUIP-GEWEI.

WA_MARAX-UNIT_OF_WT  = C_X.

* OEM

WA_MARA-BASIC_MATL  = WA_EQUIP-WRKST.

WA_MARAX-BASIC_MATL  = C_X.

* SALE ORGANIZATION

*     CASH DISC INDICATOR

*

WA_MVKE-CASH_DISC   = WA_EQUIP-SKTOF  .

WA_MVKEX-CASH_DISC   = C_X  .

* SALES ORGANIZATION 2

*     Account assignment grou

WA_MVKE-ACCT_ASSGT  = WA_EQUIP-KTGRM.

WA_MVKEX-ACCT_ASSGT  = C_X.

" Item category grou

WA_MVKE-ITEM_CAT  = WA_EQUIP-MTPOS.

WA_MVKEX-ITEM_CAT  = C_X.

   WA_MVKE-MAT_PR_GRP = WA_EQUIP-KONDM.     " MATERIAL PRICING GROUP

   WA_MVKEX-MAT_PR_GRP = C_X.

   WA_MVKE-MATL_STATS = WA_EQUIP-VERSG.     " MATERIAL STATICAL GROUP

   WA_MVKEX-MATL_STATS = C_X.

* SALES GENERAL DATA

*     Checking Group for Availability Check

*

WA_MARC-AVAILCHECK    =  WA_EQUIP-MTVFP.

WA_MARCX-AVAILCHECK    =  C_X.

*     Transportation Group

WA_MARA-TRANS_GRP   = WA_EQUIP-TRAGR .

WA_MARAX-TRANS_GRP   = C_X .

*     Loading Group

WA_MARC-LOADINGGRP  = WA_EQUIP-LADGR  .

WA_MARCX-LOADINGGRP  = C_X  .

*Base quantity for capacity planning in shipping

*WA_MARC-BASE_QTY_PLAN   = WA_EQUIP-VBAMG .

*WA_MARCX-BASE_QTY_PLAN   = C_X .

*Profit Center

WA_MARC-PROFIT_CTR  = WA_EQUIP-PRCTR.

WA_MARCX-PROFIT_CTR  = C_X.

*  Serial Number Profile

   WA_MARC-SERNO_PROF  = WA_EQUIP-SERNP.

   WA_MARCX-SERNO_PROF  = C_X .

* PURCHASING

*Purchasing Group

WA_MARC-PUR_GROUP  = WA_EQUIP-EKGRP.

WA_MARCX-PUR_GROUP  = C_X.

* FORIEGN TRADE IMPORT DATA

   WA_MARC-COUNTRYORI      = WA_EQUIP-HERKL.     "Country of origin

   WA_MARCX-COUNTRYORI     = C_X.

   WA_MARC-REGIONORIG      = WA_EQUIP-HERKR.     "Region of origin

   WA_MARCX-REGIONORIG     = C_X.

* GENERAL PLANT DATA

WA_MARD-STGE_BIN = WA_EQUIP-LGPBE.

WA_MARDX-STGE_BIN = C_X.

WA_MARA-STOR_CONDS = WA_EQUIP-RAUBE.

WA_MARAX-STOR_CONDS = C_X.

** ACCOUNTING

*Valuation Class

   WA_MBEW-VAL_AREA   = WA_EQUIP-WERKS.

   WA_MBEWX-VAL_AREA   = WA_EQUIP-WERKS.

WA_MBEW-VAL_CLASS   = WA_EQUIP-BKLAS .

WA_MBEWX-VAL_CLASS   = C_X .

WA_MBEW-PRICE_CTRL    = WA_EQUIP-VPRSV.

WA_MBEWX-PRICE_CTRL    = C_X.

*Price Unit

WA_MBEW-PRICE_UNIT  = WA_EQUIP-PEINH .

WA_MBEWX-PRICE_UNIT  = C_X .

***** POPULATE INTERNAL TABLE OF BAPI

******Material Descriptions

WA_MAKT-LANGU = SY-LANGU.

WA_MAKT-LANGU_ISO = SY-LANGU.

WA_MAKT-MATL_DESC = WA_EQUIP-MAKTX.

APPEND WA_MAKT TO IT_MAKT.

************* UNIT OF MEASURE

  WA_MARM-ALT_UNIT = WA_EQUIP-MEINS.

WA_MARM-NUMERATOR = 1.

WA_MARM-DENOMINATR  = 1.

WA_MARM-VOLUME  = WA_EQUIP-VOLUM.

WA_MARM-VOLUMEUNIT  = WA_EQUIP-VOLEH.

WA_MARM-GROSS_WT  =   WA_EQUIP-BRGEW.

WA_MARM-UNIT_OF_WT  = WA_EQUIP-GEWEI .

APPEND WA_MARM TO IT_MARM.

WA_MLAN-DEPCOUNTRY  = 'IN'.

WA_MLAN-DEPCOUNTRY_ISO = 'IN'.

   WA_MLAN-TAX_TYPE_1 = 'ZMWS'.

    WA_MLAN-TAXCLASS_1  = WA_EQUIP-TAXKM.

APPEND WA_MLAN TO IT_MLAN.

      WA_MARMX-ALT_UNIT = WA_EQUIP-MEINS.

     WA_MARMX-DENOMINATR = C_X.     "Denominator for Conversion Factor

     WA_MARMX-NUMERATOR  = C_X.     "Numerator for Conversion Factor

     WA_MARMX-VOLUME     = C_X. "Volume

     WA_MARMX-VOLUMEUNIT = C_X.  "Volume unit

     WA_MARMX-GROSS_WT   = C_X.  "Gross weight

     WA_MARMX-UNIT_OF_WT = C_X.  "Weight Unit

     APPEND WA_MARMX TO IT_MARMX.

  CALL FUNCTION 'BAPI_MATERIAL_SAVEDATA'

    EXPORTING

      HEADDATA                    =  WA_MATHEAD

     CLIENTDATA                  = WA_MARA

     CLIENTDATAX                 = WA_MARAX

     PLANTDATA                   = WA_MARC

     PLANTDATAX                  = WA_MARCX

*    FORECASTPARAMETERS          =

*    FORECASTPARAMETERSX         =

*    PLANNINGDATA                =

*    PLANNINGDATAX               =

     STORAGELOCATIONDATA         = WA_MARD

     STORAGELOCATIONDATAX        = WA_MARDX

     VALUATIONDATA               = WA_MBEW

     VALUATIONDATAX              = WA_MBEWX

     WAREHOUSENUMBERDATA         = WA_MLGN

     WAREHOUSENUMBERDATAX        = WA_MLGNX

     SALESDATA                   = WA_MVKE

     SALESDATAX                  = WA_MVKEX

*    STORAGETYPEDATA             =

*    STORAGETYPEDATAX            =

*    FLAG_ONLINE                 = ' '

*    FLAG_CAD_CALL               = ' '

*    NO_DEQUEUE                  = ' '

*    NO_ROLLBACK_WORK            = ' '

*  IMPORTING

*    RETURN                      =

   TABLES

     MATERIALDESCRIPTION         = IT_MAKT

     UNITSOFMEASURE              = IT_MARM

     UNITSOFMEASUREX             = IT_MARMX

*    INTERNATIONALARTNOS         =

*    MATERIALLONGTEXT            =

     TAXCLASSIFICATIONS          = IT_MLAN

     RETURNMESSAGES              = IT_RETURN

*    PRTDATA                     =

*    PRTDATAX                    =

*    EXTENSIONIN                 =

*    EXTENSIONINX                =

*    NFMCHARGEWEIGHTS            =

*    NFMCHARGEWEIGHTSX           =

*    NFMSTRUCTURALWEIGHTS        =

*    NFMSTRUCTURALWEIGHTSX       =

            .

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

* EXPORTING

*   WAIT          =

* IMPORTING

*   RETURN        =

           .

* Display message return

     LOOP AT IT_RETURN INTO WA_RETURN

       WHERE TYPE = 'E' OR TYPE = 'S'.

*      Display the message in screen

       WRITE: / WA_RETURN-MESSAGE.

     ENDLOOP.

ENDLOOP.

Suresj

[former_member15255]

Hello Prasad,

Please make use of BAPI : BAPI_MATERIAL_SAVEDATA, instead of using BDC. Its very easy.

Regards

Suresh Nair

[Former Member]

Hello Prasad,

            is your requirement very particular that you have to use BDC only? The best solution could be to use Direct input program using LSMW. that is hassle free and take care of the config changes also.

Regards

Animesh Sundriyal

[uppu_narayan]

Hi Prasad,

      Go through the below link for easy understanding.....

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/309cb157-738d-2910-7691-b74c4ddba...

regards,

narayan