Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

What to do to move changes from alv rep editable columns to bsad and bseg

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

13 REPLIES 13

Former Member
0 Kudos

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

0 Kudos

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

0 Kudos
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

matt
Active Contributor
0 Kudos

Please note - do not ask for or offer points in these forums

You original post has been edited.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Ok

just as I said try to use the fm POSTING_INTERFACE_CLEARING, it'll create the right batchinout for you

Max

Former Member
0 Kudos

This Function Module 'POSTING_INTERFACE_CLEARING' is for creating batch input from FB05.

I need to batchinput F-28.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Max,

You have not yet replied to the question.

Former Member
0 Kudos

Thanks Max. I am using POSTING_INTERFACE_CLEARING.

Your reply was very useful to me.