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

SBAL_DELETE program

Former Member
0 Likes
4,966

Hi experts,

Does the std pgm SBAL_DELETE delete logs from both BALHDR & BALDAT? Anyhow in the code i find only BALHDR.

Can someone give me some more idea on this pls?

I need to purge data from BALDAT too. In case SBAL_DELETE does not do this, then how can we go about this?

Thanks in advance.

Diana

1 ACCEPTED SOLUTION
Read only

AlexanderOv
Product and Topic Expert
Product and Topic Expert
0 Likes
2,802

Anyhow in the code i find only BALHDR.

You can run this report in debug mode. There is form "delete_logs" which calls function "BAL_DB_DELETE". This function then calls "BAL_DB_INTERNAL_NO_UPDATE_TASK" where deleting is performed.

DELETE baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_d.

7 REPLIES 7
Read only

AlexanderOv
Product and Topic Expert
Product and Topic Expert
0 Likes
2,802

See

Read only

0 Likes
2,802

Hi Alexander,

I went through this already. But it didnt help.

Rgds,

Diana

Read only

AlexanderOv
Product and Topic Expert
Product and Topic Expert
0 Likes
2,802

Did you delete data from all clients?

Read only

0 Likes
2,802

Hi Alexander,

I dont think so. This is currently running in Production. And only Production logs should have been deleted.

Rgds,

Diana

Read only

AlexanderOv
Product and Topic Expert
Product and Topic Expert
0 Likes
2,803

Anyhow in the code i find only BALHDR.

You can run this report in debug mode. There is form "delete_logs" which calls function "BAL_DB_DELETE". This function then calls "BAL_DB_INTERNAL_NO_UPDATE_TASK" where deleting is performed.

DELETE baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_d.

Read only

0 Likes
2,802

Hi Alexander,

I will check this in debug. Thank you for your help.

Rgds,

Diana

Read only

0 Likes
2,802

Hi Diana

Did you get the solution on deleting the entries from  BALDAT?

Thanks