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,971

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,807

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,807

See

Read only

0 Likes
2,807

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,807

Did you delete data from all clients?

Read only

0 Likes
2,807

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,808

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,807

Hi Alexander,

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

Rgds,

Diana

Read only

0 Likes
2,807

Hi Diana

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

Thanks