Ahmed,   Writing data back to r/3 is not the same as writing to a database because r/3 is an ERP system.  I recommend working with your SAP team to determine if the table you want to write to can be updated.  If the table can be updated do you have permission to write to that table?  Based on the table you will also have to find an appropriate BAPI that will allow you to write to the table you want to update.  Once you have this information you can create a job in SAS Data Integration Studio (part of SAS Data Surveyor for SAP) using the SAP Transformation to call the BAPI and pass the updated data to the desired table.  In the properties of the of the SAP Transformation you will name the appropriate BAPI.  The transformation can have inputs and outputs based on the BAPI named in the SAP Transformation.  For example, the BAPI "BAPI_PBSRVAPS_CHANGEKEYFIGVAL2 " can be used to update planning data in a planning book in SAP.   Using the SAP Tranformation uses the PROC CALLRFC in code.  Here are some details about PROC CALLRFC https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=accr3&docsetTarget=n0xlumuutlj19rn1vhrbxhhrnnig.htm&locale=en   I hope this helps you. Regards, Lou Galway ... View more

I wanted to add some clarification to your response.  SAS Data Preparation is a product and it is part of SAS Visual Analytics which both run on Viya.  SAS Data Integration Studio runs on SAS9 and jobs are created in SAS Data Integration Studio.  Plans are created in SAS Data Preparation and are similar to jobs in SAS Data Integration Studio.   I hope this helps.   Regards,   Lou ... View more

SAS Access to SAP R/3 is the underlying solution for access to both SAP R/3 and SAP BW. If you only want access to BW, then the required SAP transports and configuration need only be done on the BW instance.   Hopefully, you also have SAS Data Integration Studio working in your environment. While it may be technically possible to draw data from a BW object (Infocube, etc) without it, it is likely to be exceedingly challenging task.  Once the Access engine is properly installed, SAP BW instance properly configured, and BW metadata successfully accessed from SAS Management Console, extracting data from a BW cube is really straightforward and simple.   Additionally,  here is a link to the post install configuration instructions for SAS/ACCESS  for R/3.  SAS/ACCESS for R/3 Post install configuration instructions ... View more