SAP ABAP - Uploading Excel Sheet Data & Saving It To FB01 Transaction Using BDC Session Or Call Transaction Method.
This is a sample program on uploading FI documents into SAP system . Also this program shows how to upload multiple line items through BDC sessions . Upload the financial documents from a legacy system (excel file) into SAP using transaction code FB01 . The file to be uploaded is specified on the selection screen by the user. The same file is displayed on the output screen in ALV Format (grid display) along with status details (success/failure).Also, the successful transaction is uploaded into the SAP system. ALSO this program download all the error message and success messages in excel sheets. SAMPLE PROGRAM: REPORT ztest_fi_bdc_fb01_upload MESSAGE-ID zfimessages. TYPE-POOLS: truxs,slis. * STRUCTURE FOR INTERNAL TABLE TYPES:BEGIN OF x_file, documentreferencenumber TYPE augbl, "Variable name for document reference number. documentdate(10) TYPE c, "Variable name for document date. documenttype TYPE blart, "Variable name for document type. ...