topic Re: fb01 transaction in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822749#M660308 <HTML><HEAD></HEAD><BODY><P>may be there is some problem in code...try to run it in A mode and see the fieild in which error is coming..</P><P></P><P>its better to use BAPI for this purpose.</P><P></P><P> MOVE sy-uname TO wa_export_header-username.</P><P> MOVE c_header_txt TO wa_export_header-header_txt.</P><P> MOVE wa_unbilled-company_code TO wa_export_header-comp_code.</P><P> "MOVE WA_UNBILLED-ACC_YEAR TO WA_EXPORT_HEADER-FISC_YEAR. "--Might be uncommented</P><P> MOVE wa_unbilled-document_date TO wa_export_header-doc_date.</P><P> MOVE wa_unbilled-posting_date TO wa_export_header-pstng_date.</P><P> MOVE wa_unbilled-period TO wa_export_header-fis_period.</P><P></P><P> </P><P> "MOVE wa_unbilled-document_type TO wa_export_header-doc_type.</P><P> MOVE c_doctype_value TO wa_export_header-doc_type.</P><P></P><UL><LI level="1" type="ul"><P> Filtering data (empty spaces into Zeros)</P></LI></UL><P> CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'</P><P> EXPORTING</P><P> input = wa_unbilled-account1</P><P> IMPORTING</P><P> output = wa_unbilled-account1.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> ACCOUNT GL - (DEBIT)</P></LI></UL><P> MOVE c_itemno_dr TO wa_bapi_accountgl-itemno_acc.</P><P> MOVE wa_unbilled-company_code TO wa_bapi_accountgl-comp_code.</P><P> MOVE wa_unbilled-posting_date TO wa_bapi_accountgl-pstng_date.</P><P> MOVE wa_unbilled-account1 TO wa_bapi_accountgl-gl_account.</P><P></P><P> </P><P> "MOVE wa_unbilled-document_type TO wa_bapi_accountgl-doc_type.</P><P> MOVE c_doctype_value TO wa_bapi_accountgl-doc_type.</P><P></P><P> MOVE wa_unbilled-text1 TO wa_bapi_accountgl-item_text.</P><P> " MOVE wa_unbilled-cost_center_1 TO wa_bapi_accountgl-costcenter. </P><P> APPEND wa_bapi_accountgl TO t_bapi_accountgl.</P><P></P><UL><LI level="1" type="ul"><P> Filtering data (empty spaces into Zeros)</P></LI></UL><P> CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'</P><P> EXPORTING</P><P> input = wa_unbilled-account2</P><P> IMPORTING</P><P> output = wa_unbilled-account2.</P><P></P><UL><LI level="1" type="ul"><P> ACCOUNT GL - (CREDIT)</P></LI></UL><P> MOVE c_itemno_cr TO wa_bapi_accountgl-itemno_acc.</P><P> MOVE wa_unbilled-company_code TO wa_bapi_accountgl-comp_code.</P><P> MOVE wa_unbilled-posting_date TO wa_bapi_accountgl-pstng_date.</P><P> MOVE wa_unbilled-account2 TO wa_bapi_accountgl-gl_account.</P><P> MOVE wa_unbilled-text2 TO wa_bapi_accountgl-item_text.</P><P></P><P> "MOVE wa_unbilled-cost_center_2 TO wa_bapi_accountgl-costcenter.</P><P></P><P> APPEND wa_bapi_accountgl TO t_bapi_accountgl.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> CURRENCY - (DEBIT)</P></LI></UL><P> MOVE c_itemno_dr TO wa_bapi_currency-itemno_acc.</P><P> MOVE wa_unbilled-curr_code TO wa_bapi_currency-currency.</P><P> MOVE wa_unbilled-amt_curr_doc1 TO wa_bapi_currency-amt_doccur. </P><P> APPEND wa_bapi_currency TO t_bapi_currency.</P><P></P><UL><LI level="1" type="ul"><P> CURRENCY - (CREDIT)</P></LI></UL><P> MOVE c_itemno_cr TO wa_bapi_currency-itemno_acc.</P><P> MOVE wa_unbilled-curr_code TO wa_bapi_currency-currency.</P><P> "Conversion from positive into negative for credit</P><P> wa_bapi_currency-amt_doccur = ( wa_unbilled-amt_curr_doc2 * -1 ). APPEND wa_bapi_currency TO t_bapi_currency.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> Calling function module bapi and passing data.</P></LI></UL><P> CALL FUNCTION 'BAPI_ACC_GL_POSTING_POST'</P><P> EXPORTING</P><P> documentheader = wa_export_header</P><P> TABLES</P><P> accountgl = t_bapi_accountgl</P><P> currencyamount = t_bapi_currency</P><P> return = t_bapi_return.</P><P></P><UL><LI level="1" type="ul"><P> Calling function module bapi for commit.</P></LI></UL><P> CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'</P><P> EXPORTING</P><P> wait = c_x.</P></BODY></HTML> Wed, 03 Oct 2007 06:02:19 GMT Former Member 2007-10-03T06:02:19Z fb01 transaction https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822747#M660306 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P> I want to write bdc program for fb01. to do recording , when i am entering vallues i am getting error as 'in company code 1000 the number 16 is missing in the year 2007' irrespective of the document type. what should i do?</P></BODY></HTML> Wed, 03 Oct 2007 04:06:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822747#M660306 Former Member 2007-10-03T04:06:27Z Re: fb01 transaction https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822748#M660307 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do not write a BDC on FB01. Instead use BAPI</P><P>'BAPI_ACC_GL_POSTING_POST' OR BAPI_ACC_DOCUMENT_POST'.</P><P></P><P>Regards,</P><P>Atish</P></BODY></HTML> Wed, 03 Oct 2007 04:12:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822748#M660307 Former Member 2007-10-03T04:12:47Z Re: fb01 transaction https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822749#M660308 <HTML><HEAD></HEAD><BODY><P>may be there is some problem in code...try to run it in A mode and see the fieild in which error is coming..</P><P></P><P>its better to use BAPI for this purpose.</P><P></P><P> MOVE sy-uname TO wa_export_header-username.</P><P> MOVE c_header_txt TO wa_export_header-header_txt.</P><P> MOVE wa_unbilled-company_code TO wa_export_header-comp_code.</P><P> "MOVE WA_UNBILLED-ACC_YEAR TO WA_EXPORT_HEADER-FISC_YEAR. "--Might be uncommented</P><P> MOVE wa_unbilled-document_date TO wa_export_header-doc_date.</P><P> MOVE wa_unbilled-posting_date TO wa_export_header-pstng_date.</P><P> MOVE wa_unbilled-period TO wa_export_header-fis_period.</P><P></P><P> </P><P> "MOVE wa_unbilled-document_type TO wa_export_header-doc_type.</P><P> MOVE c_doctype_value TO wa_export_header-doc_type.</P><P></P><UL><LI level="1" type="ul"><P> Filtering data (empty spaces into Zeros)</P></LI></UL><P> CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'</P><P> EXPORTING</P><P> input = wa_unbilled-account1</P><P> IMPORTING</P><P> output = wa_unbilled-account1.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> ACCOUNT GL - (DEBIT)</P></LI></UL><P> MOVE c_itemno_dr TO wa_bapi_accountgl-itemno_acc.</P><P> MOVE wa_unbilled-company_code TO wa_bapi_accountgl-comp_code.</P><P> MOVE wa_unbilled-posting_date TO wa_bapi_accountgl-pstng_date.</P><P> MOVE wa_unbilled-account1 TO wa_bapi_accountgl-gl_account.</P><P></P><P> </P><P> "MOVE wa_unbilled-document_type TO wa_bapi_accountgl-doc_type.</P><P> MOVE c_doctype_value TO wa_bapi_accountgl-doc_type.</P><P></P><P> MOVE wa_unbilled-text1 TO wa_bapi_accountgl-item_text.</P><P> " MOVE wa_unbilled-cost_center_1 TO wa_bapi_accountgl-costcenter. </P><P> APPEND wa_bapi_accountgl TO t_bapi_accountgl.</P><P></P><UL><LI level="1" type="ul"><P> Filtering data (empty spaces into Zeros)</P></LI></UL><P> CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'</P><P> EXPORTING</P><P> input = wa_unbilled-account2</P><P> IMPORTING</P><P> output = wa_unbilled-account2.</P><P></P><UL><LI level="1" type="ul"><P> ACCOUNT GL - (CREDIT)</P></LI></UL><P> MOVE c_itemno_cr TO wa_bapi_accountgl-itemno_acc.</P><P> MOVE wa_unbilled-company_code TO wa_bapi_accountgl-comp_code.</P><P> MOVE wa_unbilled-posting_date TO wa_bapi_accountgl-pstng_date.</P><P> MOVE wa_unbilled-account2 TO wa_bapi_accountgl-gl_account.</P><P> MOVE wa_unbilled-text2 TO wa_bapi_accountgl-item_text.</P><P></P><P> "MOVE wa_unbilled-cost_center_2 TO wa_bapi_accountgl-costcenter.</P><P></P><P> APPEND wa_bapi_accountgl TO t_bapi_accountgl.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> CURRENCY - (DEBIT)</P></LI></UL><P> MOVE c_itemno_dr TO wa_bapi_currency-itemno_acc.</P><P> MOVE wa_unbilled-curr_code TO wa_bapi_currency-currency.</P><P> MOVE wa_unbilled-amt_curr_doc1 TO wa_bapi_currency-amt_doccur. </P><P> APPEND wa_bapi_currency TO t_bapi_currency.</P><P></P><UL><LI level="1" type="ul"><P> CURRENCY - (CREDIT)</P></LI></UL><P> MOVE c_itemno_cr TO wa_bapi_currency-itemno_acc.</P><P> MOVE wa_unbilled-curr_code TO wa_bapi_currency-currency.</P><P> "Conversion from positive into negative for credit</P><P> wa_bapi_currency-amt_doccur = ( wa_unbilled-amt_curr_doc2 * -1 ). APPEND wa_bapi_currency TO t_bapi_currency.</P><UL><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> _____________________________________________________________________________</P></LI><LI level="1" type="ul"><P> Calling function module bapi and passing data.</P></LI></UL><P> CALL FUNCTION 'BAPI_ACC_GL_POSTING_POST'</P><P> EXPORTING</P><P> documentheader = wa_export_header</P><P> TABLES</P><P> accountgl = t_bapi_accountgl</P><P> currencyamount = t_bapi_currency</P><P> return = t_bapi_return.</P><P></P><UL><LI level="1" type="ul"><P> Calling function module bapi for commit.</P></LI></UL><P> CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'</P><P> EXPORTING</P><P> wait = c_x.</P></BODY></HTML> Wed, 03 Oct 2007 06:02:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822749#M660308 Former Member 2007-10-03T06:02:19Z Re: fb01 transaction https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822750#M660309 <HTML><HEAD></HEAD><BODY><P>Dear Maaka,</P><P></P><P>Kindly go through the code in the following link.</P><P></P><P><A href="http://www.erpgenie.com/abap/bdc_and_idoc_status.htm" target="test_blank">http://www.erpgenie.com/abap/bdc_and_idoc_status.htm</A></P><P></P><P>Regards,</P><P></P><P>Abir</P><P></P><P>***************************************</P><UL><LI level="1" type="ul"><P> Don't forget to Reward Points *</P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="39" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P></BODY></HTML> Wed, 03 Oct 2007 09:04:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/fb01-transaction/m-p/2822750#M660309 Former Member 2007-10-03T09:04:00Z