Skip to Content
Author's profile photo Naveen Vishal

BDC for FI Posting (F-02/F-43/F-65)

There has been requirement for uploading financial data(GL, Customer, Vendor) into SAP system during the initial phase in the system/implementation. In the BDC it is required to handle different set of screens for posting FI document depending upon the posting key read using the flat file.

Following BDC can be used to upload data into SAP using a flat file(excel format of which can be found below, just save the excel file as flat file and remove the header line).

Currently the program reads flat file, making the assumption that the data is entered in double entry format(Dr and Cr) in the consecutive line. It posts two consecutive line items per document, which is normally the case during initial data upload. The program can be modified as per requirement (like, there was requirement to post a single document instead of one FI document per two line items read from file, in this case you just have to comment certain section like header looping and exit statements to make the thing work).

Technical Details:

Posting Keys used:

01 Customer invoice

05 Outgoing payment

09 SPL G\L Debit

11 Customer credit memo

15 Incoming payment

19 SPL G\L Credit

21 Vendor credit memo

25 Vendor payment

29 Special G/L Debit

31 Vendor invoice

35 Incoming payment

39 Special G/L Credit

40 G/L account debit posting

50 G/L account credit posting

70 Debit Asset

75 Credit Asset

Screens used for line items: 0300, 0301, 0302, 0303, 0304, 0305, 0332.

BDC File Structure:

Document Date Posting date Doc Type Co Code Currency Exchange rate Reference Document Number Document Header Text Posting Key Account SPl GL Indicator Asset Transaction Type Amount cost centre P Centre Business Area Transaction Type Terms of Payment Key Baseline Date for Due Date Calculation Baseline Date for Due Date Calculation Assignment Text

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Naveen Vishal,

      BDC working just fine after tweaking. Thanks for sharing.



      Author's profile photo Martin O
      Martin O

      Hi!! How Can I Download the BDC programa ?


      Author's profile photo Bhavani Amara
      Bhavani Amara

      Hi, how can i see your bdc program

      Author's profile photo TCS SD Support
      TCS SD Support

      Hi, how can i see your bdc program