We try to load data from AWS (S3) into BW4HANA. We need to apply some logic in transformations and therefore require a python operator and then using the SAP Application Producer to write the entries directly into an adso on BW4HANA.
This is all working 100% when using any INT value, the moment a STRING value is used a data type mismatch error occur on the sap application producer.
Apologies for the lengthy details.
Custom table created, to be able to map the fields in the structured operators.
A dynamic table option was tried, however as these tables are only “created” at runtime, the fields are not available for mapping for example in the Data Transform operator
SAP Application Producer
counter=0 def gen(): global counter tbl =  tbl = [[counter+i,str(counter+i*1000000011)] for i in range(1,11)] table = api.Table(tbl, "com.tbw.battery_part") api.outputs.myDynamicPort.publish(table) counter += 10 return 5 api.add_timer(gen)
Python Output Port
aDSO on BW4HANA
Error Message when executing
STEPS THAT are WORKING with only INT values
Data written into adso
Have anyone came across this, or have suggestions to try?