Creating XML transformation using multiple internal tables

Former Member — Tue, 28 Jun 2011 15:47:19 GMT

Hi everyone,

I'm trying to transforme 3 internal tables (from customer master data) into a single XML document.

DATA: BEGIN OF wtab OCCURS 0 ,

kunnr LIKE kna1-kunnr, "Customer ID

ktokd LIKE kna1-ktokd,

land1 LIKE kna1-land1,

name1 LIKE kna1-name1,

ort01 LIKE kna1-ort01,

pstlz LIKE kna1-pstlz,

spras_iso LIKE kna1-spras,

smtp_addr LIKE adr6-smtp_addr,

stras LIKE kna1-stras,

END OF wtab.

DATA: BEGIN OF wtab_o OCCURS 0 ,

kunnr LIKE knvv-kunnr, "Customer ID

vkorg LIKE knvv-vkorg, "Sales organisation

waers LIKE knvv-waers,

END OF wtab_o.

DATA: BEGIN OF wtab_p OCCURS 0 ,

kunnr LIKE knvp-kunnr, "Customer ID

vkorg LIKE knvp-vkorg, "Sales organisation

parvw LIKE knvp-parvw,

kunn2 LIKE knvp-kunnr,

END OF wtab_p.

The internal tables are related to each other as follows:*

wtab-kunnr = wtab_o-kunnr

AND

wtab_o-vkorg = wtab_p-vkorg

wtab_o-kunnr = wtab_p-kunnr

I couldn't figure out how to declare this relationship when calling the transformation. Is it possible?

ABAP

*----

REFRESH : gt_source_itab.

CLEAR : g_rxml.

GET REFERENCE OF wtab INTO gs_source_wa-value.

gs_source_wa-name = 'DEBMAS04'.

APPEND gs_source_wa TO gt_source_itab.

GET REFERENCE OF wtab_o INTO gs_source_wa-value.

gs_source_wa-name = 'E1KNVVM'.

APPEND gs_source_wa TO gt_source_itab.

GET REFERENCE OF wtab_p INTO gs_source_wa-value.

gs_source_wa-name = 'E1KNVPM'.

APPEND gs_source_wa TO gt_source_itab.

TRY.

CALL TRANSFORMATION Z_XSLT_CLIENT

SOURCE (gt_source_itab)

RESULT XML g_rxml

OPTIONS xml_header = 'without_encoding'.

CATCH cx_root INTO gs_rif_ex.

gs_var_text = gs_rif_ex->get_text( ).

MESSAGE gs_var_text TYPE 'E'.

ENDTRY.

*----

Transformation Z_XSLT_CLIENT:

*----

<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:sap="http://www.sap.com/sapxsl">

<xsl:output indent="yes" encoding="UTF-16" method="xml" version="1.0"/>

<xsl:strip-space elements="*"/>

<xsl:template match="/">

<xsl:apply-templates select="//DEBMAS04/item"/>

</DEBMAS04>

</xsl:template>

<xsl:template match="DEBMAS04/item">

<IDOC>

<xsl:attribute name="BEGIN">1</xsl:attribute>

<xsl:attribute name="SEGMENT">1</xsl:attribute>

<KUNNR>

<xsl:value-of select="KUNNR"/>

</KUNNR>

<KTOKD>

<xsl:value-of select="KTOKD"/>

</KTOKD>

<LAND1>

<xsl:value-of select="LAND1"/>

</LAND1>

<NAME1>

<xsl:value-of select="NAME1"/>

</NAME1>

<ORT01>

<xsl:value-of select="ORT01"/>

</ORT01>

<PSTLZ>

<xsl:value-of select="PSTLZ"/>

</PSTLZ>

<SPRAS_ISO>

<xsl:value-of select="SPRAS_ISO"/>

</SPRAS_ISO>

<SMTP_ADDR>

<xsl:value-of select="SMTP_ADDR"/>

</SMTP_ADDR>

<STRAS>

<xsl:value-of select="STRAS"/>

</STRAS>

<xsl:apply-templates select="//E1KNVVM/item"/>

</E1KNA1M>

</IDOC>

</xsl:template>

<xsl:template match="E1KNVVM/item">

<xsl:attribute name="SEGMENT">1</xsl:attribute>

<VKORG>

<xsl:value-of select="VKORG"/>

</VKORG>

<WAERS>

<xsl:value-of select="WAERS"/>

</WAERS>

<xsl:apply-templates select="//E1KNVPM/item"/>

</E1KNVVM>

</xsl:template>

<xsl:template match="E1KNVPM/item">

<xsl:attribute name="SEGMENT">1</xsl:attribute>

<PARVW>

<xsl:value-of select="PARVW"/>

</PARVW>

<KUNN2>

<xsl:value-of select="KUNN2"/>

</KUNN2>

</E1KNVPM>

</xsl:template>

</xsl:transform>

*----

The way the call transformation is now, for each line in table wtab (DEBMAS04) I'm getting all the lines in table wtab_o (E1KNVVM) and table wtab_p (E1KNVPM)

Thank you for your help,

Giselle

Re: Creating XML transformation using multiple internal tables

Sandra_Rossi — Tue, 28 Jun 2011 20:10:22 GMT

Hi Giselle,

I think it's possible (using xsl:if for instance), but an easier way is to nest your internal tables declarations (wtab_o inside wtab, kunnr becomes useless, and wtab_p inside wtab_o), and use the SAP standard "ID" transformation (no need for a custom XSL transformation). You'll get a slightly different result, but I don't think you want something very sophisticated.

Sandra

topic Re: Creating XML transformation using multiple internal tables in Application Development and Automation Discussions

Creating XML transformation using multiple internal tables

Re: Creating XML transformation using multiple internal tables