Skip to Content
-1

F-58 BDC Recording

Dec 12, 2017 at 12:08 PM

89

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

Are you using this BDC in custom program?

Show 1 Share
10 |10000 characters needed characters left 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.

0
avatar image
Former Member Dec 14, 2017 at 01:34 AM
0

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


Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi KK,

Almost near by...i have followed all the steps but the thing is in BDC recording it's not capturing the process open item button,And that to before this we have one more screen that is visible only once per initial login,after onwards the second screen what you have attached that will be visible,the first screen will be in background.

I have tried for BAPI also.But no BAPI is available for this.

Thanks,

Santosh.

0
Former Member

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.

0
avatar image
Former Member Dec 13, 2017 at 08:37 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0