Optional Tag in XML using Simple Transformation

[Sandra_Rossi]

Dear Experts,

I am using simple transformation for multiple XML to update table type in abap.

sample code: <ID> <Othr> are optional tags in XML files:

• <Id> --> *need to make it optional.
• <OrgId> --> *need to make it optional.
• <Othr>
• <Id tt:value-ref="ID.ORGID.OTHR.ID"/>
• <tt:d-cond check="not-initial(Id.OrgId.Othr.AddtlInf)">
• <AddtlInf tt:value-ref="Id.OrgId.Othr.AddtlInf"/>
• </tt:d-cond>
• </Othr>
• </OrgId>
• </Id>

please advise how to make above attributes to optional ?

thanks,

sanjeev

[Sandra_Rossi]

If some people want to help, here are the data well formatted to help you:

First XML test case (with OrgId present):

<?xml version="1.0"?>
<root>
  <Id>
    <OrgId>
      <Othr>
        <Id>Id</Id>
        <AddtlInf>AddtlInf</AddtlInf>
      </Othr>
    </OrgId>
  </Id>
</root>

Second XML test case (with OrgId absent):

<?xml version="1.0"?>
<root>
  <Id/>
</root>

The XSLT, correctly formatted:

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
  <tt:root name="ID"/>
  <tt:template>
    <Id>
      <OrgId>
        <Othr>
          <Id tt:value-ref="ID.ORGID.OTHR.ID"/>
          <tt:d-cond check="not-initial(Id.OrgId.Othr.AddtlInf)">
            <AddtlInf tt:value-ref="Id.OrgId.Othr.AddtlInf"/>
          </tt:d-cond>
        </Othr>
      </OrgId>
    </Id>
  </tt:template>
</tt:transform>

ABAP code:

TYPES: BEGIN OF ty_id,
         BEGIN OF orgid,
           BEGIN OF othr,
             id       TYPE ...
             addtlinf TYPE ...
         END OF orgid,
       END OF ty_id.
DATA: id TYPE ty_id.
...
DATA(xmlstring) = `...`
CALL TRANSFORMATION zst
  SOURCE XML xmlstring
  RESULT id = id.

[former_member658995]

Hi All,

Please advise, how to handle optional tags in XML as mention below using simple transformation in a nap.

#xmltag #sapabap

[Ivaylo]

Hi all,

possible solution to this very question would be ST-transformation:

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
  <tt:root name="ID"/>
  <tt:template>
    <tt:group>
      <tt:cond frq="?">
        <Id>
          <OrgId>
            <Othr>
              <Id tt:value-ref="ID.ORGID.OTHR.ID"/>
              <tt:d-cond check="not-initial(Id.OrgId.Othr.AddtlInf)">
                <AddtlInf tt:value-ref="Id.OrgId.Othr.AddtlInf"/>
              </tt:d-cond>
            </Othr>
          </OrgId>
        </Id>
      </tt:cond>
    </tt:group>
  </tt:template>
</tt:transform>

thus you can conditionally pass single tag or group of tags from the source XML. This was usable for me when de-serializing partner address, for example.

In case you need to skip a (set of) tags - use

<tt:skip name="Id" count="*"/>

In my case it works when deserialize XML to ABAP deep structure - both when need to skip a set of tags, and when some tags exists (sometimes) in the XML.

It is well documented in the SAP help -> Abap and XML -> Simple transformation -> ST - Overview of statements.

Just mu two cents.

Ivaylo

[former_member658995]

Hi sandra.rossi.

Thanks for the quick reply. I am looking for Transformation logic to make optional tag for ex: Orgid * Othr tags and have created SE11 table type with deep structures to fill from XML data.

XML file format is like below:

In XML file2 there is no <Othr> TAG hence ST is giving error.

so want to make, those Tags are Optional in transformation logic. kindly advise.

Thanks and appreciate your time.

Regards,

sanjeev

[Sandra_Rossi]

Please use COMMENT to add details. The button ANSWER is only to propose solutions.

I thought I had understood what you initially meant, my complement was only there to propose data for helping people reproduce, but now I am not sure anymore.