I have not recieved error for the same code in Test env. but in production I am getting this error.
While validating the ABAP R/3 DF it shows no error , but while executing it is giving me this error
It sounds like your SAP datastore ‘ABAP execution option’ is set to ‘Generate and Execute’ in Dev and ‘Execute Preloaded’ in Prod. This is fairly standard configuration. If this is the case, you will need to get your SAP Basis team to transport the ABAP code from Dev to Prod.
Thanks for your reply. I have checked in production that the DATAstore is set as Preload and execute . So, I have asked my basis/abap team to promote the abap program which i generate through abap R/3 DF to move to prod env.
Now my question is , i have created the abap R/3 DF in prod by using query and datatransport and validated by abap code without any error.
If basis team will move the code from test to GPR then what will happen with the ABAP R/3 DF in prod whcich i created using query,data transport etc. Please help me to understand , bit confused .
Really? BASIS Team won’t allow any program to get generated on fly and run in PROD. So your mode should always be 'Execute Preloaded" for a PROD Configuration.
So, you write a DS Code in DEV and you push the same code to TEST & PROD. In a similar way, you write(Data Services generates) the ABAP Program and runs in the DEV. Now you will have to promote that ABAP Program to QA & PROD using the Transport Process. Now, how does it know that it has to use this specific program? Right-click on your R/3 DF and see the Properties. You will see the ABAP Program name, Job Name and the File Name. So when the Datastore config is in “Execute Preloaded”, DS sends a request to SAP System to run that Program in SAP and get the data.
Now, you need to remember one important thing here. Say you have an ABAP Program and a DS Job running in DEV/QA/PROD as of today. Then you get a change request for bringing in an additional column for that table. So you add it and run in DEV (generate and execute). Now the code is updated in DEV. Byou will again have to raise a Transport request to push the updated program. Otherwise you are going to end up with errors
And you need to watch this process carefully. I’ve had no end of trouble when basis tell me that the transport has been applied but the code doesn’t seem to have changed. Or they claim that a transport has been applied but I later find out that they mean it will be applied overnight or the next day or sometime next week.