一种内表转XML的方法step by ste

业务背景：

       在与其他外部系统的对接过程中，主要推荐的是JSON的数据格式，但是有的系统因为历史原因或管理要求上的原因，会要求使用XML的格式进行数据交换。本文档将介绍一种XML与SAP内表转换的方法。

1，内表转XML

1.首先需要定义要转换为内表的结构

在企业服务中新建Data Type

选择Data Type，点击继续按钮

<img class="alignnone size-full wp-image-6565" src="http://www.baidusap.com/wp-content/uploads/2019-06-24_10-39-31.jpg" alt="" width="737" height="510" />

选择Backend，点击继续按钮

<img class="alignnone size-medium wp-image-6567" src="http://www.baidusap.com/wp-content/uploads/2019-06-24_10-42-12-740x509.jpg" alt="" width="740" height="509" srcset="http://www.baidusap.com/wp-content/uploads/2019-06-24_10-42-12-740x509.jpg 740w, http://www.baidusap.com/wp-content/uploads/2019-06-24_10-42-12-768x528.jpg 768w, http://www.baidusap.com/wp-content/uploads/2019-06-24_10-42-12.jpg 790w" sizes="(max-width: 740px) 100vw, 740px" />

 

输入名称和名称空间

没有可选择的命名空间时,输入事务代码SPXNGENAPPL创建命名空间，点击修改按钮，这是一张跨客户端的表，弹出警告直接点击确认即可

<img class="alignnone size-full wp-image-6566" src="http://www.baidusap.com/wp-content/uploads/2019-06-24_10-41-03.jpg" alt="" width="697" height="382" />

点击新条目，创建新的命名空间

<img class="alignnone size-full wp-image-6571" src="http://www.baidusap.com/wp-content/uploads/1-6.png" alt="" width="690" height="165" />

选择一个可用的命名空间即可，但是一般来说WebService的命名空间是

urn:sap-com:document:sap:soap:functions:mc-style，一般我们选择这个即可

Generation Source选择BACKENDMDR Backend Metadata Repository

<img class="alignnone size-full wp-image-6572" src="http://www.baidusap.com/wp-content/uploads/2-6.png" alt="" width="697" height="171" />

然后返回，选择我们刚刚创建的命名空间，点击继续

<img class="alignnone size-medium wp-image-6573" src="http://www.baidusap.com/wp-content/uploads/3-6-740x510.png" alt="" width="740" height="510" srcset="http://www.baidusap.com/wp-content/uploads/3-6-740x510.png 740w, http://www.baidusap.com/wp-content/uploads/3-6-768x529.png 768w, http://www.baidusap.com/wp-content/uploads/3-6.png 790w" sizes="(max-width: 740px) 100vw, 740px" />

选择包和请求，注意不要输入前缀，不然你的名称会变得很难看，很长，很奇怪，但是你在前面输入名称那里已经考虑到这边要输入前缀了，那当我没说，点击完成即可

<img class="alignnone size-medium wp-image-6574" src="http://www.baidusap.com/wp-content/uploads/4-5-740x510.png" alt="" width="740" height="510" srcset="http://www.baidusap.com/wp-content/uploads/4-5-740x510.png 740w, http://www.baidusap.com/wp-content/uploads/4-5-768x529.png 768w, http://www.baidusap.com/wp-content/uploads/4-5.png 790w" sizes="(max-width: 740px) 100vw, 740px" />

我们将会看到如此界面

<img class="alignnone size-medium wp-image-6575" src="http://www.baidusap.com/wp-content/uploads/5-5-740x341.png" alt="" width="740" height="341" srcset="http://www.baidusap.com/wp-content/uploads/5-5-740x341.png 740w, http://www.baidusap.com/wp-content/uploads/5-5-768x353.png 768w, http://www.baidusap.com/wp-content/uploads/5-5-1024x471.png 1024w, http://www.baidusap.com/wp-content/uploads/5-5.png 1069w" sizes="(max-width: 740px) 100vw, 740px" />

选择External View来定义XML的结构

<img class="alignnone size-medium wp-image-6576" src="http://www.baidusap.com/wp-content/uploads/6-4-740x324.png" alt="" width="740" height="324" srcset="http://www.baidusap.com/wp-content/uploads/6-4-740x324.png 740w, http://www.baidusap.com/wp-content/uploads/6-4-768x336.png 768w, http://www.baidusap.com/wp-content/uploads/6-4-1024x448.png 1024w, http://www.baidusap.com/wp-content/uploads/6-4.png 1340w" sizes="(max-width: 740px) 100vw, 740px" />

2.以一个较为全面的头行结构为例子

右键单击字段，将简单结构转为复杂结构

<img class="alignnone size-full wp-image-6577" src="http://www.baidusap.com/wp-content/uploads/7-3.png" alt="" width="505" height="182" />

然后添加元素HEAD和ITEMS，注意字段是区分大小写的

<img class="alignnone size-full wp-image-6578" src="http://www.baidusap.com/wp-content/uploads/8-3.png" alt="" width="499" height="140" />

右键新建全局类型

<img class="alignnone size-full wp-image-6579" src="http://www.baidusap.com/wp-content/uploads/9-3.png" alt="" width="570" height="167" />

继续新建类型，建议中间结构在后面跟上_1或者自己能区分的字符

<img class="alignnone size-medium wp-image-6580" src="http://www.baidusap.com/wp-content/uploads/10-2-740x510.png" alt="" width="740" height="510" srcset="http://www.baidusap.com/wp-content/uploads/10-2-740x510.png 740w, http://www.baidusap.com/wp-content/uploads/10-2-768x529.png 768w, http://www.baidusap.com/wp-content/uploads/10-2.png 790w" sizes="(max-width: 740px) 100vw, 740px" />

选择到新建的ZSTEST_1，右键添加如图三个抬头结构的字段

<img class="alignnone size-full wp-image-6581" src="http://www.baidusap.com/wp-content/uploads/11-2.png" alt="" width="272" height="145" />

激活该结构，返回ZSTEST结构，可以看到抬头结构已经建好

<img class="alignnone size-full wp-image-6582" src="http://www.baidusap.com/wp-content/uploads/12-1.png" alt="" width="504" height="204" />

接下来是创建多行结构，右键ITEMS，选择新建全局结构

<img class="alignnone size-full wp-image-6583" src="http://www.baidusap.com/wp-content/uploads/13-1.png" alt="" width="550" height="199" />

同样输入接口名称ZSTEST_2

<img class="alignnone size-medium wp-image-6584" src="http://www.baidusap.com/wp-content/uploads/14-740x510.png" alt="" width="740" height="510" srcset="http://www.baidusap.com/wp-content/uploads/14-740x510.png 740w, http://www.baidusap.com/wp-content/uploads/14-768x529.png 768w, http://www.baidusap.com/wp-content/uploads/14.png 790w" sizes="(max-width: 740px) 100vw, 740px" />

新建一行ITEM，作为ITEMS的子标签

<img class="alignnone size-full wp-image-6585" src="http://www.baidusap.com/wp-content/uploads/15.png" alt="" width="277" height="105" />

然后再给ITEM行创建新的全局类型

<img class="alignnone size-full wp-image-6586" src="http://www.baidusap.com/wp-content/uploads/16.png" alt="" width="666" height="185" />

新建如下类型，选择激活后返回ZSTEST_2类型

<img class="alignnone size-full wp-image-6587" src="http://www.baidusap.com/wp-content/uploads/17.png" alt="" width="294" height="152" />

点击ITEM选择红框中的选项

<img class="alignnone size-medium wp-image-6588" src="http://www.baidusap.com/wp-content/uploads/18-740x161.png" alt="" width="740" height="161" srcset="http://www.baidusap.com/wp-content/uploads/18-740x161.png 740w, http://www.baidusap.com/wp-content/uploads/18-768x167.png 768w, http://www.baidusap.com/wp-content/uploads/18.png 999w" sizes="(max-width: 740px) 100vw, 740px" />

可以看到ITEM已经变成了表格类型了，激活该类型，返回到ZSTEST类型

<img class="alignnone size-full wp-image-6589" src="http://www.baidusap.com/wp-content/uploads/19.png" alt="" width="329" height="168" />

返回ZSTEST界面，激活ZSTEST结构。

<img class="alignnone size-full wp-image-6590" src="http://www.baidusap.com/wp-content/uploads/20.png" alt="" width="303" height="171" />

接下来做一个内表转XML的测试。

REPORT ztest012.
DATA: ls_data   TYPE zstest,
ls_item   LIKE LINE OF ls_data-items-item,
lv_xmlstr TYPE string.ls_data-head-zhead1 = '抬头一'.
ls_data-head-zhead2 = '抬头二'.ls_item-zitem1 = '行一列一'.
ls_item-zitem2 = '行一列二'.APPEND ls_item TO ls_data-items-item.ls_item-zitem1 = '行二列一'.
ls_item-zitem2 = '行二列二'.
ls_item-zitem3 = '行二列三'.APPEND ls_item TO ls_data-items-item.DATA(lv_xml) = cl_proxy_xml_transform=>abap_to_xml_xstring(
EXPORTING abap_data = ls_data
ddic_type = 'ZSTEST' ).    "这里就是我们定义的类型CALL FUNCTION 'ECATT_CONV_XSTRING_TO_STRING'
EXPORTING
im_xstring = lv_xml
*   IM_ENCODING       = 'UTF-8'
IMPORTING
ex_string  = lv_xmlstr.cl_demo_output=>display_xml( lv_xmlstr ).

 

 

<img class="alignnone size-full wp-image-6591" src="http://www.baidusap.com/wp-content/uploads/21.png" alt="" width="677" height="355" />

可以看出，当参数列没有值的时候，是直接以简写的<ZHEAD3/>收尾，这一点要和外部系统讲清楚，同时提醒一句，当整个列表都没有值的时候，整个列表都不显示。

2，XML转内表

 

REPORT ztest012.
DATA: ls_data   TYPE zstest,
ls_item   LIKE LINE OF ls_data-items-item,
lv_xmlstr TYPE string.ls_data-head-zhead1 = '抬头一'.
ls_data-head-zhead2 = '抬头二'.ls_item-zitem1 = '行一列一'.
ls_item-zitem2 = '行一列二'.APPEND ls_item TO ls_data-items-item.ls_item-zitem1 = '行二列一'.
ls_item-zitem2 = '行二列二'.
ls_item-zitem3 = '行二列三'.APPEND ls_item TO ls_data-items-item.DATA(lv_xml) = cl_proxy_xml_transform=>abap_to_xml_xstring(
EXPORTING abap_data = ls_data
ddic_type = 'ZSTEST' ).    "这里就是我们定义的类型CALL FUNCTION 'ECATT_CONV_XSTRING_TO_STRING'
EXPORTING
im_xstring = lv_xml
*   IM_ENCODING       = 'UTF-8'
IMPORTING
ex_string  = lv_xmlstr.cl_demo_output=>display_xml( lv_xmlstr ).

 

&amp;amp;lt;img class="alignnone size-full wp-image-6592" src="http://www.baidusap.com/wp-content/uploads/22.png" alt="" width="460" height="303" /&amp;amp;gt;

可以看到，已经解析到了数据。

以上。