F-58 BDC Recording

[former_member315232]

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.

[Former Member]

Are you using this BDC in custom program?

[former_member315232]

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.

[former_member513101]

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

[former_member315232]

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.

[former_member513101]

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

[former_member315232]

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.

[former_member513101]

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.