bdc using mm01

[Former Member]

hi gurus,

i create a programm in bdc to extend storage location from one plant to another. but i am not want to give data for

MEINS

MAKTX

IPRKZ

FROM FLAT FILE IT JUST TAKE DATA FROM DATA BASE

for these three fields can i do this

i am give matnr plant and lgort from flat file

but want 3 field from data base plz provide me code for this transaction.

my recording is as this

PERFORM bdc_dynpro USING 'SAPLMGMM' '0060' 'X'.

PERFORM bdc_field USING 'BDC_CURSOR' 'RMMG1-MATNR'.

PERFORM bdc_field USING 'BDC_OKCODE' '=AUSW'.

PERFORM bdc_field USING 'RMMG1-MATNR' wa_output-matnr.

PERFORM bdc_dynpro USING 'SAPLMGMM' '0070' 'X'.

PERFORM bdc_field USING 'BDC_CURSOR' 'USRM1-SISEL'.

PERFORM bdc_field USING 'BDC_OKCODE' '=ENTR'.

PERFORM bdc_field USING 'USRM1-SISEL' 'X'.

PERFORM bdc_field USING 'MSICHTAUSW-KZSEL(15)' 'X'.

PERFORM bdc_field USING 'MSICHTAUSW-KZSEL(16)' 'X'.

PERFORM bdc_dynpro USING 'SAPLMGMM' '0080' 'X'.

PERFORM bdc_field USING 'BDC_CURSOR' 'RMMG1-LGORT'.

PERFORM bdc_field USING 'BDC_OKCODE' '=ENTR'.

PERFORM bdc_field USING 'RMMG1-WERKS' wa_output-werks.

PERFORM bdc_field USING 'RMMG1-LGORT' wa_output-lgort.

PERFORM bdc_dynpro USING 'SAPLMGMM' '4000' 'X'.

PERFORM bdc_field USING 'BDC_OKCODE' '=SP20'.

PERFORM bdc_field USING 'MAKT-MAKTX' 'test for change'.

PERFORM bdc_field USING 'BDC_CURSOR' 'MARA-MEINS'.

PERFORM bdc_field USING 'MARA-MEINS' 'EA'.

PERFORM bdc_field USING 'MARA-IPRKZ' 'D'.

PERFORM bdc_dynpro USING 'SAPLMGMM' '4000' 'X'.

PERFORM bdc_field USING 'BDC_OKCODE' '=BU'.

PERFORM bdc_field USING 'BDC_CURSOR' 'MAKT-MAKTX'.

PERFORM bdc_field USING 'MAKT-MAKTX' 'test for change'.

• Call transaction to update RECORD

CALL TRANSACTION 'MM01' USING bdc_tab

MODE 'N' UPDATE 'S'

MESSAGES INTO messtab.

plz provide solution for it

thanks in advance

jayant.

[Former Member]

Hi jayant ,

First upload the data from the flat file into internal table and then fetch the data for the fields :MEINS

MAKTX ,IPRKZ from the database using select query and move the final data in to internal table and then write ur performs for creating the bdcdata table .

Thanks