Skip to Content

This document is used for consultant or developers at customer side who would like to know technical detail about how a word template is merged with xml data stream. Before you touch the related ABAP code about document merging, it is good to get some basic understandong about how ABAP manipulates word document in this document Manipulate Docx document with ABAP .

In the document Create Webservice enabled word document in attachment assignment block, it is described how to create a word template and feed its content with web service generated via web service tool in CRM Webclient UI. Besides that you could also use your own web service, for example you can expose your function module in ABAP backend via SOAMANAGER. The detailed step could be found in this document.

In consulting note 2048272, an ABAP report is provided to allow you to merge the word template with given xml data without Webclient UI:

/wp-content/uploads/2014/08/clipboard1_521175.png

If you meet with issue that the merged word document does not work as you expected, for example some fields are empty however the corresponding node in xml do have data filled, then you can use this ABAP report to do trouble shooting. You could get the word template and  xml data file for web service response by following consulting note 2047259.

In this document, I will show you how the element “Partner” in word template is merged with the value from xml node SOLD_TO.PARTNER in the runtime. You could find the template “zpartner.docx” and xml data file “response.xml” used in this example from document attachment.

/wp-content/uploads/2014/08/clipboard2_521176.png

Explore the word template to identify binding information

From the above screenshot, we click on Partner field and the tooltip shows this element is bound to field PARTNER. How is this mapping relationship maintained within word template?

Rename zparetner.docx to zpartner.zip, double click on the zip file, double click subfolder “word”, then double click on “document.xml”:

You should find a w:t node with PARTNER, and a w:tag node with attribute “w:val”, whose value is 0050569457471ED488F2038D1D8360BE.

The w:t node contains the text which end user sees in the word template, and w:val maintains the mapping relationship to xml schema.

/wp-content/uploads/2014/08/clipboard3_521210.png

Now go back to zpartner.zip, click on customXml folder and double click “item1.xml”. Search xml file by value “0050569457471ED488F2038D1D8360BE”. One result found, and we could know the complete binding path is Z_JENS_GET_MORE_COMPLEXResponse.ES_C5064266.SOLD_TO.PARTNER.

/wp-content/uploads/2014/08/clipboard4_521211.png

Merge step1 cl_crm_oi_docx_helper=>replace_vars_uuid_with_path

In this step, the original uuid in document.xml is replaced by the complete path of bound xml node:

/wp-content/uploads/2014/08/clipboard5_521212.png

Merge step2 add necessary namespace to every node in xml

It is done via transformation call:

CALL TRANSFORMATION crm_office_int_rt_add_ns
        SOURCE XML lv_response
        RESULT XML lv_response_ns.

Notice the no namespace added for each node after transformation call:

/wp-content/uploads/2014/08/clipboard6_521213.png

Merge step3 cl_crm_oi_docx_transform_rt=>transform

the formatted template source( uuid replaced with complete path ) and formatted xml data source( n0 namespace added ) are passed into this method.

step3.1 cl_crm_oi_docx_transform_rt=>indicate_tree

The xml node is further enriched with attribute Loopcount and Path, which are especially used for render data with table structure. ( template merged with table data will be discussed in another document )

/wp-content/uploads/2014/08/clipboard7_521214.png

step3.2 cl_crm_oi_docx_transform_rt=>update_payload_from_addinsch

This method will create a new attribute sapvartype with value “T” for those node in xml source with table structure, not relevant for current example.

/wp-content/uploads/2014/08/clipboard8_521215.png

step3.3 recursively call cl_crm_oi_docx_transform_rt=>process_node_cc

node: dom element of root node “Z_JENS_GET_MORE_COMPLEXResponse” in xml.

/wp-content/uploads/2014/08/clipboard9_521216.png

/wp-content/uploads/2014/08/clipboard10_521217.png

Now we have reached the first leaf node in xml, “CLIENT”. Pay attention to the recursive callstack.

/wp-content/uploads/2014/08/clipboard11_521218.png

since we don’t bind CLIENT node in xml to our template, after method get_contentcontrol_node_bypath, lt_node_ref_word will remain empty so we quit from the current traverse and try with next node.

/wp-content/uploads/2014/08/clipboard12_521219.png

Soon we reach the method get_contentcontrol_node_bypath again, and since our template consumes the node PARTNER, it is ready to feed the template with the value contained in this xml node.

/wp-content/uploads/2014/08/clipboard13_521220.png

The sold to partner id “0000419333” will be set to the corresponding dom element node “lr_node_word” by the method below.

/wp-content/uploads/2014/08/clipboard14_521221.png

in the beginning of this document we know it is the content of w:t node which will be displayed to end user so first we have to locate those w:t nodes via filtering ( w:t node found and stored in variable node_text ) and finally fill value to them by method fill_text_node, and that’s all.

/wp-content/uploads/2014/08/clipboard15_521222.png

final merged document:

/wp-content/uploads/2014/08/clipboard16_521223.png

And you could find the w:t node contains the correct value from document source code:

/wp-content/uploads/2014/08/clipboard17_521224.png

Next reading

Understand how the word template is merged with xml data stream – part 2 – table structure

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Roy Willems

    Hi Jerry,

    we recently upgraded our CRM to EHP3 and now I also need to recreate our Word templates with the new SAP Data Panel solution. I followed all the steps and used an already existing webservice for this. I’m able to attach the new Word Template to my opportunity but when I open this attachment the Data Panel fields are not populated.

    I followed the different steps from consulting notes to debug this. During creation of the attachment I can see that the correct data is gathered and written to the Data Panel structure. In note 2047259 it says that I need to put a breakpoint in method  CL_OI_HANDLER~FILL_TEMPLATE_WITH_DATA. When I open the attachment this code is not called at all so it seems that here something goes wrong and causes the issue I’m facing. Do you have any idea what could be wrong here?

    Best regards,

    Roy Willems

    Newitera

    (0) 

Leave a Reply