08-20-2011 10:33 PM
Dear All,
I am developing an ALV report, wherein the requirement is i have many columns but out of which i have 3 major columns, 1 column is for Invoice Amount(wherein i am able to pick the wrbtr data of bseg) and 2nd colums in pmt made by customer(editable column) and 3rd is pending payment(1st col-2nd column).
This report is basically for collection recevied from customer, when end user enters the data in pmt recvd then automatically my 3rd colm is getting updated and if the complete pmt is recvd then the record will be deleted from BSID table.( i am able to acheive till here).
But at the same time a new record should be automatically created in the BSAD and it will automatically create a new row in BSEG table.
Please let me know, how to acheive this, do i need to used bapi BAPI_ACC_Document_Post to update the BSAD and BSEG table.
<<Text removed>>
Thanks,
A Sustainer.
Edited by: Matt on Aug 22, 2011 7:59 AM
08-20-2011 10:48 PM
Hi
It's not really clear what you need, but it seems you need to post a payment: the item will automatically move from BSID to BSAD as soon as it'll cleared.
It don't know how you "delete" the item of BSID, but i believe the BAPI BAPI_ACC_DOCUMENT_POST is not good for your requirement.
It's not possibile to add a new record in BSEG: an accounting document can't be changed (excluded the values of some fields).
Max
08-20-2011 10:48 PM
Hi
It's not really clear what you need, but it seems you need to post a payment: the item will automatically move from BSID to BSAD as soon as it'll cleared.
It don't know how you "delete" the item of BSID, but i believe the BAPI BAPI_ACC_DOCUMENT_POST is not good for your requirement.
It's not possibile to add a new record in BSEG: an accounting document can't be changed (excluded the values of some fields).
Max
08-20-2011 11:00 PM
Yes, MAX you are right instead of using f-28 for clearing the payment customer would like to have this report.
If complete payment is done through f-28 then the particular record of that billing document will be automatically deleted from the BSID table and a new record will be appened to the BSAD table and BSEG too automatically.
If the part payment is done, the the record will not be deleted from BSID instead the field WRBTR is modified with the updated value from the report and there will not record appened in the BSAD table(as complete pmt not received).
Now to put the same thing in report, i am deleting the record from BSID table using delete statement.
But unable to append a new record to the BSAD table and BSEG(as it is cluster table, direct updation is not possbile).
So, i am facing difficulty in appending a new record in both BSID and BSEG tables, when the complete payment is done and in part payments.
Thanks,
A Sustainer
08-20-2011 11:12 PM
Now to put the same thing in report, i am deleting the record from BSID table using delete statement.
But unable to append a new record to the BSAD table and BSEG(as it is cluster table, direct updation is not possbile).
Please: Don't touch those tables
You have to simulate the clearing by a batchinput, not to update the tables directly.
You can try to use the fm POSTING_INTERFACE_CLEARING, I don't remember if it can do a partial payment
Max
Edited by: max bianchi on Aug 21, 2011 12:19 AM
08-22-2011 7:00 AM
Please note - do not ask for or offer points in these forums
You original post has been edited.
08-22-2011 2:31 PM
Dear All,
As said the record from the BSID will be automatically deleted and a new record will be created in the BSAD and BSEG when complete payment is made through F-28, therefore, when doing a same thing i am doing through a batch input and trying to make a complete payment, then the record is getting deleted from BSID but a new record is not getting created in the BSAD and BSEG. Please do the needful and let me know a way to achieve this and if possible pls post the required batch input.
08-22-2011 2:39 PM
Hi
But which new record you expect?
FI document can't be changed, No new item can be add
When you clear a document the system can create a new document (clearing document) but not to add a new item in the old one
Max
08-22-2011 2:53 PM
Yeah Max,
I am telling the same thing, when i clearing the complete amount from f-28, the corresponding entry in the BSID is getting deleted automatically and till that time for the that billing document number there will no record present in BSAD table.
But when made the complete payment in F-28 then record from BSID get automatically disappear and a new records in BSAD will be created with new reference document number and also in BSEG.
Record is getting deleted from batch input, but no new record is getting created in BSAD and BSEG through batch input.
Is there anything wrong in my batch input, can u let me know the correct batch in put as here SIMULATION Is also happening in f-28.
08-22-2011 2:57 PM
Ok
just as I said try to use the fm POSTING_INTERFACE_CLEARING, it'll create the right batchinout for you
Max
08-22-2011 5:09 PM
This Function Module 'POSTING_INTERFACE_CLEARING' is for creating batch input from FB05.
I need to batchinput F-28.
08-22-2011 5:20 PM
Hi
All transactions for clearing (just like F-28) are based on FB05, so you can use it.
You need to set the clearing operation (field I_AUGLV), in your case EINGZAHL
Max
09-05-2011 10:48 PM
Hi Max,
I have done a batch input of f-28.
My report is an editable report, wherein rows are selected and same is submited to batch input.
I am not clear on 1 thing.
When i do a select row on my alv report and click on save button, same record will be submitted to batch input, but in batch input 2nd screen i can see multiple document number, how shall i compare my document number with the correct document number in the 2nd screen of f-28.
A Sustainer
09-07-2011 4:50 AM
09-09-2011 8:05 PM
Thanks Max. I am using POSTING_INTERFACE_CLEARING.
Your reply was very useful to me.