# Support for SAP Business Warehouse, HANA systems

This ABAP-Transport contains code in a standard variant without considering higher security policies. No further
configuration in SAP BW System is required (besides the set up of proper authorization objects for the user-account).  



## The transport archives for SAP-Systems are listed below:

- SAP Business Warehouse on HANA
- SAP Business Warehouse for HANA



## The installation transport:

- DHBK900344, contains all the ABAP-Coding required for Talend-SAP Components. 

Features included:

```
aDSO-Write, Insert or Updates in a Business Warehouse DataStore Object with configuration mode "direct updateable"
```



## Deletion-Transport (optional):

- S4HK902231, To remove all the objects installed by DHBK900344.
	


## Usage, Steps for Installation

Extract the contents of the archive and copy the file within the data-folder as well as the file within the cofiles-folder to the location for the 
transport files on the SAP system (usr/sap/trans/{SID}/cofiles|data). For the copy task use transaction cg3z or ask an administrator, who has file system access on the SAP server 
instance. 

Then use the SAP transport management system (t-code stms) to add the files to the transport queue and perform the transport order.



## SAP Authorization

To connect to SAP System a user with proper authorizations must be created. 

More details can be found at help.talend.com: "Integration between SAP and Talend"

 
Sample for tADSOOutput
- Auhorization Object: S_RFC
-- Field: RFC_TYPE 
-- Value: FUGR (=Function Group)
-- Field: RFC_NAME 
-- Value: /CMT/TLND_BI_ADSO (=Name of the Function Group)
-- Field: ACTVT (=Operation allowed)
-- Value: 16 (=Execute)

To be defined to restrict the access to the Advanced Datastore Objects where the processing of data is allowed

- Auhorization Object: S_RS_ADSO
-- Field: RSINFOAREA (InfoArea)
-- Value: * or specific
-- Field: RSOADSONM (Name of Advanced Datastore Object)
-- Value: * or specific
-- Field: RSOADSOPAR
-- Value: DATA
-- Field: ACTVT (=Operation allowed)
-- Value: 23 (=Maintain, Insert/Update)



## Additional Information

Via SAP GUI use following transactions:
- SM37: View background jobs of the RFC user
- AL11: View files of a specific directory e.g. /usr/sap/trans
- CG3Y: Download files by specifying the source file on the SAP application server and a local target 
        file - use BIN to ensure the file is not truncated!



