topic Re: How to upload material data using batch input recording ? in Application Development and Automation Discussions

How to upload material data using batch input recording ?

Former Member — Thu, 16 May 2013 18:36:48 GMT

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

Re: How to upload material data using batch input recording ?

Former Member — Fri, 17 May 2013 05:16:21 GMT

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.

Re: How to upload material data using batch input recording ?

former_member198834 — Fri, 17 May 2013 05:21:33 GMT

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.

Suresj

Re: How to upload material data using batch input recording ?

former_member15255 — Fri, 17 May 2013 05:22:36 GMT

Hello Prasad,

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

Regards

Suresh Nair

Re: How to upload material data using batch input recording ?

Former Member — Fri, 17 May 2013 05:24:27 GMT

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

Re: How to upload material data using batch input recording ?

uppu_narayan — Fri, 17 May 2013 06:37:04 GMT

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-b74c4ddba3c7?QuickLink=index&overridelayout=true&10995116287984

regards,

narayan