Application Development and Automation 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: 
Read only

BSE_CLR table

Former Member
0 Likes
4,730

Can somebody shead some light onto table BSE_CLR.

Can I expect data that has been in BSAD to be in table BSE_CLR. Is it a reliable source to querry for cleared items?

Thanks.

JB.

Can somebody shead some light onto table BSE_CLR.

Can I expect data that has been in BSAD to be in table BSE_CLR. Is it a reliable source to querry for cleared items?

Thanks.

JB.

3 REPLIES 3
Read only

Former Member
0 Likes
2,159

Hi,

SE_CLR table keeps other cleared items too apart from Cleared items for customer (BSAD). so it has vendor clear items too.

Secondly it does not keep entries where document number and the cleared items have same number.

so I think its not a reliable source.

Please let me know .

Thanks

Amit

Read only

former_member181966
Active Contributor
0 Likes
2,159

I <u><b>'MUST'</b></u> recommend you to use table 'BSAD' for cleared item . You can also run the report in FI "Customer Overdue analysis’. To see the logic as it also read clear item.

This report also read data from BSAS, BSAK....

Thanks

Message was edited by: Saquib Khan

Read only

former_member270798
Discoverer
0 Likes
2,159

Hi,

Table BSE_CLR contains both document, the payment and the reversal of the payment .

If you reset a cleared document the entry will go from BSAD to BSID.

Whereas it remains in BSE_CLR even though it is reset.

Thus BSAD is better if you want to querry for cleared items.

Thanks,

Pavan