topic BDC Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bdc-query/m-p/1806048#M345957 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am having a problem when i execute the foll code:</P><P></P><P>DATA : l_trfar TYPE HRP1005-TRFAR,</P><P> l_trfgb TYPE HRP1005-TRFGB.</P><P></P><P></P><P> SELECT SINGLE trfar trfgb INTO (l_trfar,l_trfgb)</P><P> FROM hrp1005 WHERE otype = 'S' AND</P><P> objid = second_per-plans AND</P><P> begda LE second_per-begda AND</P><P> endda GE second_per-begda.</P><P></P><P> REFRESH: bdc_table.</P><P></P><P> PERFORM build_dynpro USING 'X' 'SAPMP50A' '1000'.</P><P> PERFORM build_dynpro USING ' ' 'RP50G-PERNR' second_per-pernr.</P><P> PERFORM build_dynpro USING ' ' 'RP50G-CHOIC' '0008'.</P><P></P><UL><LI level="1" type="ul"><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '=COP'. "dvhk910657</P></LI></UL><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '=INS'.</P><P></P><P> PERFORM build_dynpro USING 'X' 'MP000800' '2010'.</P><P> PERFORM build_dynpro USING ' ' 'P0008-BEGDA' second_per-begda.</P><P> PERFORM build_dynpro USING ' ' 'P0008-PREAS' second_per-preas.</P><P></P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFAR' l_trfar.</P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFGB' l_trfgb.</P><P></P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFGR' second_per-trfgr.</P><P> IF second_per-ansal = ' '. "CHG20599</P><UL><LI level="1" type="ul"><P> bypass sending the field in the BDC</P></LI></UL><P> ELSE. "CHG20599</P><P> PERFORM build_dynpro USING ' ' 'Q0008-ANSAL' second_per-ansal.</P><P> ENDIF. "CHG20599</P><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '/11'.</P><P></P><P> PERFORM build_dynpro USING 'X' 'MP000800' '2010'.</P><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '/11'.</P><P></P><P> CALL TRANSACTION 'PA30' USING bdc_table</P><P> MODE s_view</P><P> UPDATE 'S' " Synchronous</P><P> MESSAGES INTO tran_itab.</P><P></P><P> retcode = sy-subrc.</P><P> CLEAR bdc_table.</P><P> REFRESH bdc_table.</P><P></P><P> IF retcode &lt;&gt; 0.</P><P> WRITE:/ 'Could not Modify IT0008 for personnel # : ',</P><P> second_per-pernr.</P><P> end_session = 1.</P><P> ENDIF.</P><P></P><P></P><P></P><P>In this code i am making changes in infotype 0008, its givin error</P><P>wat cud b posss cause of error.</P><P></P><P>Answers will be rewarded.</P></BODY></HTML> Thu, 04 Jan 2007 08:40:04 GMT Former Member 2007-01-04T08:40:04Z BDC Query https://community.sap.com/t5/application-development-and-automation-discussions/bdc-query/m-p/1806048#M345957 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am having a problem when i execute the foll code:</P><P></P><P>DATA : l_trfar TYPE HRP1005-TRFAR,</P><P> l_trfgb TYPE HRP1005-TRFGB.</P><P></P><P></P><P> SELECT SINGLE trfar trfgb INTO (l_trfar,l_trfgb)</P><P> FROM hrp1005 WHERE otype = 'S' AND</P><P> objid = second_per-plans AND</P><P> begda LE second_per-begda AND</P><P> endda GE second_per-begda.</P><P></P><P> REFRESH: bdc_table.</P><P></P><P> PERFORM build_dynpro USING 'X' 'SAPMP50A' '1000'.</P><P> PERFORM build_dynpro USING ' ' 'RP50G-PERNR' second_per-pernr.</P><P> PERFORM build_dynpro USING ' ' 'RP50G-CHOIC' '0008'.</P><P></P><UL><LI level="1" type="ul"><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '=COP'. "dvhk910657</P></LI></UL><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '=INS'.</P><P></P><P> PERFORM build_dynpro USING 'X' 'MP000800' '2010'.</P><P> PERFORM build_dynpro USING ' ' 'P0008-BEGDA' second_per-begda.</P><P> PERFORM build_dynpro USING ' ' 'P0008-PREAS' second_per-preas.</P><P></P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFAR' l_trfar.</P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFGB' l_trfgb.</P><P></P><P> PERFORM build_dynpro USING ' ' 'P0008-TRFGR' second_per-trfgr.</P><P> IF second_per-ansal = ' '. "CHG20599</P><UL><LI level="1" type="ul"><P> bypass sending the field in the BDC</P></LI></UL><P> ELSE. "CHG20599</P><P> PERFORM build_dynpro USING ' ' 'Q0008-ANSAL' second_per-ansal.</P><P> ENDIF. "CHG20599</P><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '/11'.</P><P></P><P> PERFORM build_dynpro USING 'X' 'MP000800' '2010'.</P><P> PERFORM build_dynpro USING ' ' 'BDC_OKCODE' '/11'.</P><P></P><P> CALL TRANSACTION 'PA30' USING bdc_table</P><P> MODE s_view</P><P> UPDATE 'S' " Synchronous</P><P> MESSAGES INTO tran_itab.</P><P></P><P> retcode = sy-subrc.</P><P> CLEAR bdc_table.</P><P> REFRESH bdc_table.</P><P></P><P> IF retcode &lt;&gt; 0.</P><P> WRITE:/ 'Could not Modify IT0008 for personnel # : ',</P><P> second_per-pernr.</P><P> end_session = 1.</P><P> ENDIF.</P><P></P><P></P><P></P><P>In this code i am making changes in infotype 0008, its givin error</P><P>wat cud b posss cause of error.</P><P></P><P>Answers will be rewarded.</P></BODY></HTML> Thu, 04 Jan 2007 08:40:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc-query/m-p/1806048#M345957 Former Member 2007-01-04T08:40:04Z Re: BDC Query https://community.sap.com/t5/application-development-and-automation-discussions/bdc-query/m-p/1806049#M345958 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What is the Error you are getting...u can see the contents of the tran_itab. in debugging to see what are the problems....</P><P></P><P>santhosh</P></BODY></HTML> Thu, 04 Jan 2007 08:46:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc-query/m-p/1806049#M345958 Former Member 2007-01-04T08:46:43Z