-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Generating XML from internal table
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.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Success! Subscription added.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
This group has been set to read-only. Please go to our new Developer forums to publish your content instead.
Read only
Generating XML from internal table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Dec 28 4:21 PM
447
- SAP Managed Tags
- ABAP Development
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>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>
Bluesky
2 REPLIES 2
Read only
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Dec 28 4:22 PM
397
- SAP Managed Tags
- ABAP Development
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Dec 28 5:35 PM
Top Liked Authors
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
