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
5,099

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

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

See

Read only

0 Likes
2,935

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

Did you delete data from all clients?

Read only

0 Likes
2,935

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

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

Hi Alexander,

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

Rgds,

Diana

Read only

0 Likes
2,935

Hi Diana

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

Thanks