Creating XML transformation using multiple interna...

Former Member · ‎2011 Jun 28

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

Sandra_Rossi · ‎2011 Jun 28

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

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My Account

My Account

Creating XML transformation using multiple internal tables