Error: Need to delete the setup table for SD module , in LBWG, upon clicking the execute button , a confirmation window opens up asking "Data will be lost , Do u want to delete the restructure tables" , I click on YES and after that there is no further status message (that whether the delete was sucessfull or not). Now when i go to RSA3 and test the extraction( for 2LIS_11_VAITM) , it still shows some records . indicating that the setup table has not been deleted
Solution:
1. Call T/A SE14 --> Enter table name MC11VA0ITMSETUP -->Select radio button "tables" --> click on Edit -->Select processing type "Background" --> Click on "Activate and Adjust database".
2. Here before performing the Activate and Adjust database function -- first try to check the data base object (click on check button and select database object --ok) if every thing is ok then proceed with the above steps.
3. Next try to delete the setup tables and check.
Also check if the data source is active or not before deleting the setup tables.
Solution:
1. Call T/A SE14 --> Enter table name MC11VA0ITMSETUP -->Select radio button "tables" --> click on Edit -->Select processing type "Background" --> Click on "Activate and Adjust database".
2. Here before performing the Activate and Adjust database function -- first try to check the data base object (click on check button and select database object --ok) if every thing is ok then proceed with the above steps.
3. Next try to delete the setup tables and check.
Also check if the data source is active or not before deleting the setup tables.
No comments:
Post a Comment