Direct database table entry deletion: What are the problems

Former Member — Thu, 29 Dec 2011 11:57:13 GMT

Hi.

I need to develop a ZRFC to delete the Material-specification association with MICs in the transaction code QS61. Actually, I have checked with SAP & got confirmation that there are no BAPIs or RFC existing to delete it. Even, BDC approach too failed for QS61 since the NEXT-PAGE & SCROLLING are not supported in BDC (the QS61 transaction is not meant from BDC (Confirmed by SAP) & so there is no find/focus a line button). So, i will have to develop the ZRFC using the direct database table deletion approach.

I am developing the ZRFC which deletes the QMSP (Master table for Material specifictaions) entries with the statement DELETE FROM QMSP where MIC is ....

Now the question is,

1) What are the consequences of dierct database entry deletion from a ZRFC in SAP?

2) I heard that it will create problem at the time of SAP auditing, Is it true? Will it really create a problem during audting??

So, Please help me with your valuable inputs. I will APPRECIATE IF I GET A SAP NOTE/DOCUMENT for the answers.

Thanks in advance,

~ Guru

Re: Direct database table entry deletion: What are the problems

kesavadas_thekkillath — Thu, 29 Dec 2011 12:19:32 GMT

Please have a look into function QMS1_MATERIAL_SPECIFICATION where the operations happen. Make sure you maintain the change documents & Locks as done in this function. Its better to debug the standard transaction clearly and see what is happening. Please wait for experts opinion.

Kesav

topic Re: Direct database table entry deletion: What are the problems in Application Development and Automation Discussions

Direct database table entry deletion: What are the problems

Re: Direct database table entry deletion: What are the problems