Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Generating XML from internal table

former_member188001
Active Participant

‎2011 Dec 28 4:21 PM

0 Likes
374

All,

I have a requirement where we need to generate XML file from an internal table. I have been successful to generate that but now they want the xml in a different format. I am having difficulty to do so.

I am also able to generate similar format but am not able to close ZMAM_RUN_TYPE at the top. I am able to do it at the end.

Requirement

- <sap:ZMAM_BCC_PUBDATE_GETLIST xmlns:sap="urn:sap-com:document:sap:rfc:functions.response">
  <NO_UPSELL_MARK /> 
  <ZMAM_RUN_TYPE>jobs</ZMAM_RUN_TYPE> 
- <ZMAM_BCC_LIST>
- <item>
  <AVM_NR>0010249901</AVM_NR> 
  <POS_NR>030</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>PAJUP</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>2010012045</GPAG> 
  <INSERENT>2010012045</INSERENT> 
  <REGULIERER>2010012045</REGULIERER> 
  <GPNR_RECH>2010012045</GPNR_RECH> 
  <S_TERMIN>2011-11-06</S_TERMIN> 
  <E_TERMIN>2011-12-05</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220557</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010249944</AVM_NR> 
  <POS_NR>020</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>PAJUP</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>2010012056</GPAG> 
  <INSERENT>2010012056</INSERENT> 
  <REGULIERER>2010012056</REGULIERER> 
  <GPNR_RECH>2010012056</GPNR_RECH> 
  <S_TERMIN>2011-12-04</S_TERMIN> 
  <E_TERMIN>2012-01-02</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220594</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010250017</AVM_NR> 
  <POS_NR>020</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>PAJUP</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1010143394</GPAG> 
  <INSERENT>1010143394</INSERENT> 
  <REGULIERER>1010143394</REGULIERER> 
  <GPNR_RECH>1010143394</GPNR_RECH> 
  <S_TERMIN>2011-11-27</S_TERMIN> 
  <E_TERMIN>2011-12-26</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220711</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010250053</AVM_NR> 
  <POS_NR>020</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>PAJUP</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>2010012064</GPAG> 
  <INSERENT>2010012064</INSERENT> 
  <REGULIERER>2010012064</REGULIERER> 
  <GPNR_RECH>2010012064</GPNR_RECH> 
  <S_TERMIN>2011-11-27</S_TERMIN> 
  <E_TERMIN>2011-12-26</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220733</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010250511</AVM_NR> 
  <POS_NR>020</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>PAJUP</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>2010011719</GPAG> 
  <INSERENT>2010011719</INSERENT> 
  <REGULIERER>2010011719</REGULIERER> 
  <GPNR_RECH>2010011719</GPNR_RECH> 
  <S_TERMIN>2011-12-04</S_TERMIN> 
  <E_TERMIN>2012-01-02</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220922</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010250512</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000001</EIN_NR> 
  <INHK_KFM>00004899</INHK_KFM> 
  <BELEGEINH>PAJFRZ</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>2010011719</GPAG> 
  <INSERENT>2010011719</INSERENT> 
  <REGULIERER>2010011719</REGULIERER> 
  <GPNR_RECH>2010011719</GPNR_RECH> 
  <S_TERMIN>2011-12-04</S_TERMIN> 
  <E_TERMIN>2012-01-02</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000220923</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>0000-00-00</AENDATE> 
  <AENTIME>00:00:00</AENTIME> 
  </item>
  </ZMAM_BCC_LIST>
  </sap:ZMAM_BCC_PUBDATE_GETLIST>

2 REPLIES 2
Read only

former_member188001
Active Participant

‎2011 Dec 28 4:22 PM

0 Likes
324

I am getting out put in the following format.

<?xml version="1.0" ?> 
- <ZMAM_BCC_PUBDATE_GETLIST>
- <ZMAM_RUN_TYPE>
  REAL_ESTATE 
- <ZMAM_BCC_LIST>
- <item>
  <AVM_NR>0010262705</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000012</EIN_NR> 
  <INHK_KFM>1142GTWN</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1000004824</GPAG> 
  <INSERENT>1000004824</INSERENT> 
  <REGULIERER>1000004824</REGULIERER> 
  <GPNR_RECH>1000004824</GPNR_RECH> 
  <S_TERMIN>20110129</S_TERMIN> 
  <E_TERMIN>20110204</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000377005</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010262706</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000002</EIN_NR> 
  <INHK_KFM>1142AUPK</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1000004824</GPAG> 
  <INSERENT>1000004824</INSERENT> 
  <REGULIERER>1000004824</REGULIERER> 
  <GPNR_RECH>1000004824</GPNR_RECH> 
  <S_TERMIN>20110129</S_TERMIN> 
  <E_TERMIN>20110204</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000377012</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010262707</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000002</EIN_NR> 
  <INHK_KFM>00001117</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1000004824</GPAG> 
  <INSERENT>1000004824</INSERENT> 
  <REGULIERER>1000004824</REGULIERER> 
  <GPNR_RECH>1000004824</GPNR_RECH> 
  <S_TERMIN>20110130</S_TERMIN> 
  <E_TERMIN>20110205</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000377013</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010262726</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000013</EIN_NR> 
  <INHK_KFM>1157BETH</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1000000810</GPAG> 
  <INSERENT>1000000810</INSERENT> 
  <REGULIERER>1000000810</REGULIERER> 
  <GPNR_RECH>1000000810</GPNR_RECH> 
  <S_TERMIN>20110129</S_TERMIN> 
  <E_TERMIN>20110204</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000377208</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010262730</AVM_NR> 
  <POS_NR>020</POS_NR> 
  <EIN_NR>000012</EIN_NR> 
  <INHK_KFM>1142DUP</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZMKD</PSTYV> 
  <GPAG>1000000810</GPAG> 
  <INSERENT>1000000810</INSERENT> 
  <REGULIERER>1000000810</REGULIERER> 
  <GPNR_RECH>1000000810</GPNR_RECH> 
  <S_TERMIN>20110129</S_TERMIN> 
  <E_TERMIN>20110204</E_TERMIN> 
  <MOTIV>000002</MOTIV> 
  <MOTIVID>100000377212</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
+ <item>
  <AVM_NR>0010264436</AVM_NR> 
  <POS_NR>010</POS_NR> 
  <EIN_NR>000010</EIN_NR> 
  <INHK_KFM>1157MONT</INHK_KFM> 
  <BELEGEINH>OL7CLSRE</BELEGEINH> 
  <PSTYV>ZSTD</PSTYV> 
  <GPAG>1000002073</GPAG> 
  <INSERENT>1000002073</INSERENT> 
  <REGULIERER>1000002073</REGULIERER> 
  <GPNR_RECH>1000002073</GPNR_RECH> 
  <S_TERMIN>20110716</S_TERMIN> 
  <E_TERMIN>20110722</E_TERMIN> 
  <MOTIV>000001</MOTIV> 
  <MOTIVID>100000380160</MOTIVID> 
  <AZART_GEST>0003</AZART_GEST> 
  <CHIFFRE_NR /> 
  <ZZPICCNT>00</ZZPICCNT> 
  <AENDATE>00000000</AENDATE> 
  <AENTIME>000000</AENTIME> 
  </item>
  </ZMAM_BCC_LIST>
  </ZMAM_RUN_TYPE>
  </ZMAM_BCC_PUBDATE_GETLIST>

Read only

Former Member
In response to former_member188001

‎2011 Dec 28 5:35 PM

0 Likes
324

Hi ,

Please check the below link

it may use full to you

Regards

Siva