Skip to Content
avatar image
-1
Former Member

F-58 BDC Recording

Hi Experts,

I have a requirement to develop a BDC for F-58 transaction, and have developed also.but coming to issue is how i came to know which document is posted successfully and in FBL5N how it could be cleared.

Thanks,
santosh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 12, 2017 at 01:01 PM

    Are you using this BDC in custom program?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      yeah....

      In my program i have recorded the F-58 except the first screen.Cause you may know very well first time only the initial screen will be visible in f-58 transaction.But Coming to Document clearing how will achieve it.We don't know which document is going to clear on which document.

  • Dec 14, 2017 at 01:34 AM

    Hi Santosh,

    Here the steps

    1. During BDC recording, make sure you record the required fields during for a successful posted payment
    2. If you are using the excel file open items for payment. You store the excel data into internal table. Then you can put logic to validate the line items data against BSIK data
    3. For sure you will have multiple invoices for same vendor, write logic to get the Total amount per vendor and populate it to amount field as screenshot below.
    4. Mark Other field =X for the BDC program

    5. Populate the document no from excel internal table to the fields as screenshot below

    6. You will notice only the doc no from step 5 are selected an the balance is zero. If balance is not zero then you cannot clear it.

    7. Example above is for full payment, if you want to cater for partial payment or residual payment then you need to record those screen fields as well and populate the "remaining amount there" so that Not assigned is zero. Set an indicator there whether it is partial payment then only process the screen field for partial payment.

    8. Capture the commit work message into message internal table.

    9. Repeat the BDC program for second vendor in the excel internal table.

    10. Output the message internal table after program execute all the data.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Santosh,

      System will skip the input screen for the house bank and check information for the subsequent check payment. You need to press the back button (F3). Then system will display the screen for you in case you want to check house bank or check lot information.

      for the second issue process open item button. I did the recording in my system. BDC_OKCODE = PA is for the process open item button and RF05A-SEL01(01) = 1500000026 is the invoice document number.

      Thanks.

  • Dec 13, 2017 at 08:37 AM

    Hi Santosh,

    For Vendor line item, document in table BSIK can be cleared. Once it is cleared, system will move it to table BSAK

    For Customer line item, document in table BSID can be cleared. Once it is cleared, system will move it to table BSAD

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      That's true....

      but coming to BDC program will pass an excel with proper document numbers and amount.And in program level i have skip first screen also.

      But still documents are not cleared.

      so before getting excel am i need to write a select query for open items from BSIK table and check the amount from excel to table or what .Guide me

      Thanks,

      Santosh.