on 2023 Feb 04 9:31 PM
Hi guys,
Starting to a little crazy with this. Using ABAP need to upload a BPC Excel Distribution template, and then change master data dimension members in it, and save it back to UJFS.
I have tried debugging the downloading of an Excel distribution template from the Excel front end, and I think it uses SAP Transformations (Call Transformation), but I don't understand those.
Is there a way to upload the file to xstring, and then convert the part where the BPC Dimension members need to be updated, and then save the file back to UJFS ?
I have tried FM's SCMS_XSTRING_TO_BINARY, THEN SCMS_BINARY_TO_STRING etc. but I never get anything readable. SAP Class CL_ABAP_CONV_IN_CE etc.
I have tried class cl_fdt_xl_spreadsheet, and I get the itab containing the worksheet contents, and then I tried to have named cells, which I can read using Method IF_FDT_DOC_SPREADSHEET~GET_NAMED_CELL_VALUE, but I cannot seem to write a new value using method IF_FDT_DOC_SPREADSHEET~SET_NAMED_CELL_VALUE.
Any pointers please ?
Thanks
Mark
Request clarification before answering.
Thanks Vadim for getting back.
The business case is as follows:
We are loading a file set of 14 separate csv files from a remote Azure Blob to BPC in an automation process to BPC. These files cover Master, Transaction and Comments data for a specific Entity (Type 'E') which are country projects.
There are currently 5 Entities (country project members) that we have to load each file set above.
When the all the data above has been loaded to BPC, I next need to refresh Distribution templates with the latest active country project ID's and email addresses for the Project managers (who receive the Distribution templates). This is done using virtual machines, (which is not my area - I am just BPC & ABAP).
All of the BPC BAdI's, e.g. different Entity master data attributes coming from multiple csv files, i.e. UJD_ROUTINE having a driver file and picking up other master data attributes, and Transaction data where different Account (Type 'A') members receive data from different SIGNEDDATA columns in single csv files, again UJD_ROUTINE, and as you know as there are no standard BPC packages to load comments, UJ_CUSTOM_LOGIC to load the comments, and this is working fine. There is also error handling incorporating the inclusion of the BPC Send Email if any of the loads fail.
As I said above about the need to refresh the Distribution templates, with the latest Project Entity master data, is where is am stumped at the moment.
Of course I can bring in the latest master data, and import the distribution templates as xstring data from UJFS, but I cannot figure out how to parse this .XLTX (Excel template), change it to have the refreshed members and then put the changed template back on UJFS.
I have tried using cl_fdt_xl_spreadsheet, and get the template data to display in an itab, but cannot change cell values (can display them) using methods of this class (and then want to save the updated xltx worksheet back to UJFS).
I have tried various function modules, e.g. SCMS_XSTRING_TO_BINARY, followed by SCMS_BINARY_TO_STRING, Class CL_ABAP_CONV_IN_CE Create and Read methods etc.
I have just seen, a FM SMUM_XML_PARSE which I may investigate. I was assuming the UJFS .xltx file contained BIFF binary, but perhaps it contains XML.
Anyhow you only asked for the business case, and I am also providing the technical means I am try to implement in order to meet the business requirement.
Maybe it is just something simple, I can be doing, hence reaching out to you guys for some clarity.
Thanks
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
58 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.