topic Re: Loading bulk data into any infotypes in Application Development and Automation Discussions

topic Re: Loading bulk data into any infotypes in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303051#M1391423 <HTML><HEAD></HEAD><BODY><P>Is there any demo programs for this.............</P></BODY></HTML> Wed, 21 Oct 2009 05:23:33 GMT Former Member 2009-10-21T05:23:33Z Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303048#M1391420 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need a program that can load thousands of data into any infotypes reading from a text file or excel spreadsheet. </P><P></P><P>Here the infotypes is generic(ie., they haven't mentioned any specific infotypes). </P><P></P><P>Can anyone help me out in this, is there any demo program or any other examples based on this requirement.</P><P></P><P></P><P>Thanks in advance,</P><P>Vishnu</P></BODY></HTML> Wed, 21 Oct 2009 04:24:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303048#M1391420 Former Member 2009-10-21T04:24:53Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303049#M1391421 <HTML><HEAD></HEAD><BODY><P>Try to use the function module HR_MAINTAIN_MASTERDATA to upload data in infotypes.</P></BODY></HTML> Wed, 21 Oct 2009 04:49:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303049#M1391421 Former Member 2009-10-21T04:49:57Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303050#M1391422 <HTML><HEAD></HEAD><BODY><P>Use these FM.</P><P></P><P><STRONG>HR_INFOTYPE_OPERATION</STRONG></P><P></P><P><STRONG>HR_MAINTAIN_MASTERDATA</STRONG></P></BODY></HTML> Wed, 21 Oct 2009 05:08:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303050#M1391422 GauthamV 2009-10-21T05:08:04Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303051#M1391423 <HTML><HEAD></HEAD><BODY><P>Is there any demo programs for this.............</P></BODY></HTML> Wed, 21 Oct 2009 05:23:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303051#M1391423 Former Member 2009-10-21T05:23:33Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303052#M1391424 <HTML><HEAD></HEAD><BODY><P>Is there any demo programs for this.............</P></BODY></HTML> Wed, 21 Oct 2009 05:24:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303052#M1391424 Former Member 2009-10-21T05:24:05Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303053#M1391425 <HTML><HEAD></HEAD><BODY><P>Is there any demo programs for this.............</P></BODY></HTML> Wed, 21 Oct 2009 05:24:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303053#M1391425 Former Member 2009-10-21T05:24:17Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303054#M1391426 <HTML><HEAD></HEAD><BODY><P>Is there any demo programs for this.............</P></BODY></HTML> Wed, 21 Oct 2009 05:24:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303054#M1391426 Former Member 2009-10-21T05:24:31Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303055#M1391427 <HTML><HEAD></HEAD><BODY><P>Do a where used for the function module HR_MAINTAIN_MASTERDATA and you will get some standard programs which use this function module.</P><P>You can check out the program RPLAPL00.</P></BODY></HTML> Wed, 21 Oct 2009 05:27:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303055#M1391427 Former Member 2009-10-21T05:27:04Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303056#M1391428 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use the FM to upload the xcel.</P><P></P><UL><LI level="1" type="ul"><P> FM call to upload file</P></LI></UL><P> CALL FUNCTION 'GUI_UPLOAD'</P><P> EXPORTING</P><P> filename = gv_file</P><P> filetype = lv_filetype</P><P> has_field_separator = lv_field_sep</P><P> TABLES</P><P> data_tab = gi_datatab.</P><P></P><P>Then use BDC recording to update infotypes:</P><P></P><UL><LI level="1" type="ul"><P>Infotype 0000</P></LI></UL><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-program = 'SAPMP50A'.</P><P> wa_bdcdata-dynpro = '1300'.</P><P> wa_bdcdata-dynbegin = 'X'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'BDC_OKCODE'.</P><P> wa_bdcdata-fval = '=INS'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'RP50G-PERNR'.</P><P> wa_bdcdata-fval = gv_pernr.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'RP50G-TIMR6'.</P><P> wa_bdcdata-fval = 'X'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'BDC_CURSOR'.</P><P> wa_bdcdata-fval = 'RP50G-SUBTY'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'RP50G-CHOIC'.</P><P> wa_bdcdata-fval = '0'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'RP50G-SUBTY'.</P><P> wa_bdcdata-fval = wa_datatab-massn.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-program = 'MP000000'.</P><P> wa_bdcdata-dynpro = '2000'.</P><P> wa_bdcdata-dynbegin = 'X'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'BDC_CURSOR'.</P><P> wa_bdcdata-fval = 'P0000-MASSG'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'BDC_OKCODE'.</P><P> wa_bdcdata-fval = '=UPD'.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'P0000-BEGDA'.</P><P> wa_bdcdata-fval = gv_begda.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P> wa_bdcdata-fnam = 'P0000-MASSG'.</P><P> wa_bdcdata-fval = wa_datatab-massg.</P><P> APPEND wa_bdcdata TO gi_bdcdata.</P><P> CLEAR wa_bdcdata.</P><P></P><P>Hope it helps.</P><P></P><P>Regards,</P><P>Rajesh Kumar</P></BODY></HTML> Wed, 21 Oct 2009 05:31:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303056#M1391428 Former Member 2009-10-21T05:31:36Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303057#M1391429 <HTML><HEAD></HEAD><BODY><P>Hi rajesh thanks for your post it looks good......... but instead of BDC is there any other way like BAPI, LSMW....... bcos BDC will be dependent on screens right so once if they upgrade it will become problem and another problem is we dont know the infotypes and fields for that.</P><P></P><P>thanks.....</P><P></P><P>Edited by: Vishnu Ramanathan on Oct 21, 2009 11:31 AM</P></BODY></HTML> Wed, 21 Oct 2009 05:43:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303057#M1391429 Former Member 2009-10-21T05:43:19Z Re: Loading bulk data into any infotypes https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303058#M1391430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Then use FM HR_MAINTAIN_MASTERDATA.</P><P></P><P> CALL FUNCTION 'HR_MAINTAIN_MASTERDATA'</P><P> EXPORTING</P><P> pernr = lv_pernr</P><P> actio = 'MOD'</P><P> tclas = lc_tclas "'A'</P><P> begda = wa_p0105-begda</P><P> endda = wa_p0105-endda "'99991231'</P><P> dialog_mode = lc_mode "'0'</P><P> luw_mode = '0'</P><P> IMPORTING</P><P> return = rc</P><P> return1 = rc1</P><P> TABLES</P><P> proposed_values = proposed_values0105_2.</P><P></P><UL><LI level="1" type="ul"><P>Rollback work</P></LI></UL><P> IF ( rc-type EQ 'E' OR rc1-type EQ 'E').</P><P> gv_success = 'N' .</P><P> ROLLBACK WORK.</P><P> ENDIF.</P><P></P><UL><UL><UL><UL><LI level="4" type="ul"><P>Infotye 0105</P></LI></UL></UL></UL></UL><P> lv_fval = lc_0010 . "'0010' " subtype</P><P> wa_proposed_values-infty = lc_0105.</P><P> wa_proposed_values-fname = lc_0105subty.</P><P> wa_proposed_values-fval = lv_fval.</P><P> wa_proposed_values-seqnr = lc_seqnr.</P><P></P><P> APPEND wa_proposed_values TO proposed_values0105.</P><P> CLEAR lv_fval.</P><P> CLEAR wa_proposed_values.</P><P></P><P></P><P></P><P> lv_fval = wa_source_data-usrid.</P><P></P><P> wa_proposed_values-infty = lc_0105.</P><P> wa_proposed_values-fname = lc_0105mailid.</P><P> wa_proposed_values-fval = lv_fval.</P><P> wa_proposed_values-seqnr = lc_seqnr.</P><P></P><P> APPEND wa_proposed_values TO proposed_values0105.</P><P> CLEAR lv_fval.</P><P> CLEAR wa_proposed_values.</P><P></P><P></P><P></P><P>Regards,</P><P>Rajesh Kumar</P><P></P><P>Edited by: Rajesh Kumar on Oct 21, 2009 8:19 AM</P></BODY></HTML> Wed, 21 Oct 2009 06:19:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/loading-bulk-data-into-any-infotypes/m-p/6303058#M1391430 Former Member 2009-10-21T06:19:20Z